• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[8.54-8.57] Pure Frag V.2

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
i add in schemas/mysql

CREATE TABLE `z_ots_comunication` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DON'T WORK !! HELP!!
 
Este archivo sólo puede descargarse con SpeedyShare Premium. Ahora puede conseguir Premium.


SpeedyShare only premiums users :(
 
when i use sqlite
i get dis Error

SQL query:

CREATETABLE"server_config"(

"config"VARCHAR( 35)NOTNULL DEFAULT'',
"value"INTEGER NOTNULL ,
UNIQUE (
"config"
));

and new i use mysql but i got many erors please helppp !



MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER ' at line 1
 
Really nice ! i will use it !

ht1.jpg
jh88.jpg
test.jpg
huang10
 
[29/05/2012 08:44:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

[29/05/2012 08:44:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)


HELP.
 
you're still using sqlite, not mysql :p
you have mysql running but it's not used by the server because of bad configuration
 
bro in not using sqlite im using mysql.. but still givs a lot errors.. can help on TeamViewer
see you on chat. :D :p :D
 
Can anyone reupload it on mediafire or any other website cuz i cant download from speedyshare :(
 
Back
Top