Second problem!

[Mr. Anas]

Hello guys!
I just opened my own server, but players cannot login, I just opened ports, and did fully things, and when my friend try to login,
It says on Server LOG:

[19/03/2012 23:15:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

Please try to help me.
Rep+++++

 

[Mr. Anas]

Help!

 

[Rizzla]

i think you have to add table z_ots_comunication in database

 

[Mr. Anas]

i think you have to add table z_ots_comunication in database

How?
Also my friend told me, because website, I just bought this ot, So I didn't edit it.. Just my friend told me its the website problem, How can I disable website? Like I make no website ? Also how to add Z_OTS_Comm~

 

[Rizzla]

i think you must have website,

CREATE TABLE `z_ots_comunication`;

 

[Mr. Anas]

i think you must have website,

CREATE TABLE `z_ots_comunication`;

But I dont need website, and also where do I paste this CREATE TABLE `z_ots_comunication

 

[Rizzla]

phpmyadmin. Just follow this tutorial. http://otland.net/f479/complete-tutorial-how-setup-server-42048/

 

[Rizzla]

Press on sql and put CREATE TABLE `z_ots_comunication

 

[Ninja]

[FONT=Tahoma, Calibri, Verdana, Geneva, sans-serif]

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;

[/FONT]

 

[Mr. Anas]

[FONT=Tahoma, Calibri, Verdana, Geneva, sans-serif]

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;

[/FONT]

Rep+++

 

[Mr. Anas]

Someone can tell me about cap?
When player starts (First stay) the first items he get, gets dropped in the floor!
How to fix?

 

[Mjmackan]

Which version of distro are you using?