Windows Just a small error....need help :)

[snipermike13]

[04/06/2010 16:05:02] >> Starting SQL connection
[04/06/2010 16:05:02] >> Running Database Manager
[04/06/2010 16:05:04] > No tables were optimized.

Whats this mean? Did I just forget to change something in config.lua or did I do something wrong on phpmyadmin?

I also get this...

[04/06/2010 16:08:48] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'realtibiamap.z_ots_comunication' doesn't exist (1146)


and than server shuts down shortly after...It doesn't seem like anything big but I am not as up to date as some other people


+rep for all who help!

 

[Djivar]

[04/06/2010 16:05:02] >> Starting SQL connection
[04/06/2010 16:05:02] >> Running Database Manager
[04/06/2010 16:05:04] > No tables were optimized.

this part is fine,

and this:

[04/06/2010 16:08:48] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'realtibiamap.z_ots_comunication' doesn't exist (1146)

the table z_ots_comunication dose not exist in your database

 

[snipermike13]

and this:

[04/06/2010 16:08:48] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'realtibiamap.z_ots_comunication' doesn't exist (1146)

the table z_ots_comunication dose not exist in your database[/QUOTE]


and how would I go about getting that into my database? Cause it keeps shutting my server down....

 

[Djivar]

readd the mysql.sql from your server path

 

[snipermike13]

readd the mysql.sql from your server path

I read this mysql and it wasn't anywhere in their, how would I go about adding,

"[05/06/2010 06:18:56] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'realtibiamap.z_ots_comunication' doesn't exist (1146)" To mysql?

Thanks. Rep+

 

[VirrageS]

To your database paste this:

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=17 ;

 

[snipermike13]

To your database paste this:

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=17 ;

I did that. Got this....still....

[05/06/2010 14:37:38] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'realtibiamap.z_ots_comunication' doesn't exist (1146)

 

[Fyruz]

CREATE TABLE `z_ots_comunication` (
`id` int(11) NOT NULL auto_increment, PRIMARY
`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',
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
THIS MAY HELP

 

[Fyruz]

This help me alot, just create new table put 12 fields and add in order

 

[snipermike13]

YAHOO! I got it... THANKS ALL IM REP+ right now.

Now just to get my god damn temple position right....
I CANT FIGURE IT OUT. Im Metarded.....

Peace.

ps- ex. I see it says:

Name/id
Rookgaard 15

temple position
32097 32219 7


Now I type this in the config.lua in the newplayer

-- Account manager
accountManager = true
namelockManager = false
newPlayerChooseVoc = false
newPlayerSpawnPosX = 32097
newPlayerSpawnPosY = 32219
newPlayerSpawnPosZ = 7
newPlayerTownId = 15
newPlayerLevel = 1
newPlayerMagicLevel = 0

and says its wrong

 

[Fyruz]

Post your ACCount databse is an error there

 

[snipermike13]

Post your ACCount databse is an error there

SELECT * FROM `accounts` WHERE 1


...that is what i find under the acc database SQL....or is their more?

 

[Fyruz]

is an error on your GROup id check is in (1)

 

[snipermike13]

id - name - password - premdays - lastday - key - blocked - warnings - group_id

1 - 1 - 1 - 65535 - 1275764360 - 0 - 0 - 0 - 1

 

[Fyruz]

It's ok, i think that you need to configurate your acc manager because its ok, for example if you put on Players change your name Example Fyruz and put group id 6 you create a gm, try it and if its function PM me if not i find the error

 

[snipermike13]

Temple position is still wrong....

 

[Fyruz]

then open your RMe and see map>edit towns> and see thais/id
and put her coordinates because rookgard posibly has wrong

 

[snipermike13]

I SOLVED IT DUDE!! YEYEYE IM SOOOO SMART LOL


Thanks everyones help. LOVE OTLAND.NET

Rep+

Peace.




ps- 1 more problem i just realized. the server still shuts down ima post pic with reason why, idk how to solve this now.....