• 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!

Lua Flammingsvets

Simonk

Simonk

Banned User
Joined
Apr 20, 2011
Messages
41
Reaction score
2
[23/08/2012 11:15:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[23/08/2012 11:15:30] Error during getDataInt(vipdays).
[23/08/2012 11:15:30] Error during getDataInt(vipdays).
[23/08/2012 11:15:30] Error during getDataInt(vipdays).
[23/08/2012 11:15:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[23/08/2012 11:15:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[23/08/2012 11:15:36] Error during getDataInt(vipdays).
[23/08/2012 11:15:36] Error during getDataInt(vipdays).
[23/08/2012 11:15:36] Error during getDataInt(vipdays).
[23/08/2012 11:15:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[23/08/2012 11:15:42] Error during getDataInt(vipdays).
[23/08/2012 11:15:42] Error during getDataInt(vipdays).


Ill get this bugs when i run my flammingsvets,,,, Can someone send me the lua´s and the scripts /config for this ???+ Ill give rep+++++++++++++++
 
Sort by date Sort by votes
SQL: 
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
 
Upvote 0 Downvote
I suggest you people don't even bother since you obviously do not know what an SQL code is, I suggest you stop here. Read a bit about SQL and how to execute queries then come back and hopefully you'll have a better understanding of what Ninja posted.
 
Upvote 0 Downvote
Go to phpmyadmin, and add what ninja wrote into your database.

Go to your database and press sql at the menu bar. then paste it in there and then press go.

It will create the missing table as the error says.

- - - Updated - - -

Korrex said:
I suggest you people don't even bother since you obviously do not know what an SQL code is, I suggest you stop here. Read a bit about SQL and how to execute queries then come back and hopefully you'll have a better understanding of what Ninja posted.
Click to expand...

That's also a solution, because if you can't fix this simple programe, then you do really need to learn more about tibia before you start a server by yourself, and btw the problem exist if you use the search function. Since lots of players have had the same problem.
 
Upvote 0 Downvote
8408323 said:
Go to phpmyadmin, and add what ninja wrote into your database.

Go to your database and press sql at the menu bar. then paste it in there and then press go.

It will create the missing table as the error says.

- - - Updated - - -



That's also a solution, because if you can't fix this simple programe, then you do really need to learn more about tibia before you start a server by yourself, and btw the problem exist if you use the search function. Since lots of players have had the same problem.
Click to expand...

Exactly.

Simonk said:
Yeah i asked where couse i cant come in to my "http://localhost/phpmyadmin/
Click to expand...

Well gee have you thought of the fact that you're using SQLite? herpderp
 
Upvote 0 Downvote
my server is running and i got a router so i cant use mysql

- - - Updated - - -

my server is running and i got a router so i cant use mysql

- - - Updated - - -

my server is running and i got a router so i cant use mysql
 
Upvote 0 Downvote
Back
Top