Solved SQL Error Help plz :)

[Fyruz]

Hello community of otland, I have a error or debug on my server when i run it, and i hope anyone can help me if is not much work
here is the screenshot when i run it


Uploaded with ImageShack.us
the error says mysql_real_query<>Select * From z_ots_comunication WHERE 'type' = login' = MySQL ERROR: table: tfs.z_ots_communication' does not exist <1146>

AND IF YOU SAW I CANT ENTER TO MY OTSERVER WITH LOCALHOST OR SOMETIMES IT TOOK LONG TIME thanks for your patience to reading this
atte,
fyruz

 

[Fragdonut]

try closing it down. maybe it dont loop anymore, maybe or not maybe i dont know, just try

 

[Fyruz]

try closing it down. maybe it dont loop anymore, maybe or not maybe i dont know, just try

First: Thanks for your answer
Second: my server stills like this since 2 weeks
Third: hope you canhelp me

 

[Fragdonut]

âf man, mnaybe u can download new ot? it maybe works then? maybe and u can imporut ur old map to new distro ?

 

[Fyruz]

âf man, mnaybe u can download new ot? it maybe works then? maybe and u can imporut ur old map to new distro ?

I did it, i download other map other OT is an error on SQL but i need help because i cant login

 

[Fallen]

you dont have the table "z_ots_etc" in ur database...

 

[Fragdonut]

now, u can put new tables in ur databse rep+++++

 

[president vankk]

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;

 

[Fyruz]

you dont have the table "z_ots_etc" in ur database...

and how i put that

 

[Fyruz]

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;

hey bro and how i create the table if is not to much work can u put step by step i am a beginner

 

[Fragdonut]

u must go to phpmyadmin!

 

[Fyruz]

u must go to phpmyadmin!

i am here bro, but i dont know what to do, i dont know how to add new tables

 

[Fragdonut]

press sql

 

[Fyruz]

what i put in number of fields

 

[Fyruz]

ohh i see now thanks alot to you all guys

 

[snipermike13]

and how i put that

Go to phpmyadmin and go to your database and than at the top go to SQL and copy past what he posted above into that and hit Go.
Than it is in your database

REP+++


/\/\1K3

 

[Debian]

compile to debian lenny or debian etch