Solved help with error.

[nystrom]

hello i wounder how i could solve this error:

[29/04/2013 18:14:58] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)

i dont want to add this table i just want to remove it from the server so it does not spam my serverlog.

 

[hodleo]

must be gesior's shop globalevent, erase the line from globalevents.xml that has the script:
data/globalevents/scripts/shop.lua

 

[Mokerhamer]

go to your phpadmin and add this to your database.

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;

 

[nystrom]

go to your phpadmin and add this to your database.

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;

thanks dude that solved all my problems, ur awsome!
rep+ for you

- - - Updated - - -

ive just found out an other old problem i do have:

[29/04/2013 21:05:58] [Error - MoveEvents Interface] 
[29/04/2013 21:05:58] data/movements/scripts/viptile.lua:onStepIn
[29/04/2013 21:05:58] Description: 
[29/04/2013 21:05:58] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[29/04/2013 21:05:58] stack traceback:
[29/04/2013 21:05:58] 	[C]: in function 'error'
[29/04/2013 21:05:58] 	data/lib/004-database.lua:60: in function 'getDataInt'
[29/04/2013 21:05:58] 	data/lib/050-function.lua:4: in function 'getPlayerVipDays'
[29/04/2013 21:05:58] 	data/movements/scripts/viptile.lua:3: in function <data/movements/scripts/viptile.lua:2>

this problems has now showed up becuse i use an old server that i found in my old computer, and i do not have to old database saved so i need to add some stuff that i had in the old database, does someone know what i shoud add in the database to make this work?

 

[Mokerhamer]

ALTER TABLE `accounts` ADD
`vipdays` INT(11) NOT NULL DEFAULT 0;

 

[nystrom]

ALTER TABLE `accounts` ADD
`vipdays` INT(11) NOT NULL DEFAULT 0;

awsome now it works to add vip days with my vip medal, and to pass vip doors / sqms

but when i add this in my globalevent.lua:

<event type="login" name="VipCheck" event="script" value="vipcheck.lua"/>

this connects to this script:

--- Script by Kekox
function onLogin(cid)
         if getPlayerVipDays(cid) >= 1 then
            doPlayerSendTextMessage(cid, 19, "You have ".. getPlayerVipDays(cid) .." vip days left.")
         end
         return true
end

and now the server just crashes, without any errors in the log...

 

[Limos]

It should be in creaturescripts.

 

[nystrom]

It should be in creaturescripts.

oh yes it is, sry my bad i wrote wrong.

btw i just installed a new webpage:
http://otland.net/f118/gesior-2012-version-1-0-1-0-2-x-0-3-6-all-0-4-a-176677/
* version for TFS 0.3.6 and 0.4 up to rev. 3703 [in that rev. developers added 'salt' in table 'accounts']

the installation went smooth but now when i try to start my server so does it just load to Running Database Manager, and then it crashes... there is no errors showen, im just getting a sign that says that the program has stopped to work :/

(the webpage is working great, but i cant load the server....)

im using (TFS 0.3.6 Edited by Cyko V8)

does anyone know how i might could solve this problem? its really hard to get to the point when it dosent show any error messages.... anyone might have been having the same problem?

- - - Updated - - -

bump....

- - - Updated - - -

anyone knows how i could fix this?...