How do i fix this error

[7amo]

How do i fix this error

 

[Czupryn1994]

Add to database sql to your server this:

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;

 

[Limos]

Depense what is causing it (the not valid packet size warnings), if it's from someone on your server who uses a bot like elfbot, you can set autoBanishUnknownBytes to true in config.lua.

autoBanishUnknownBytes = true

 

[7amo]

I can't login into my ot This Picture Of Error Please Help

 

[Limos]

Add your global ip in config.lua and open port 7171 and 7172.
Use your IPv4 address in your IP Changer (other people (who login from a computer that doesn't host the server) should use your global ip).

 

[7amo]

This Ot Not On My Pc Its On A Vps How Can i know ipv4 address?

 

[Czupryn1994]

What adress do you use? 127.0.0.1 or 149.210.138.215?

In the screen is your local adress...

 

[Limos]

Add your global ip (www.whatismyip.com) in config.lua.
If you don't login from the computer that hosts the server, it means port 7171 is already open. If you still get this error when you added your global ip in config.lua, make sure the gameport 7172 is open aswell.

 

[7amo]

@Limos And @Czupryn1994 Thanks Alot But There is An Error On Record Files In Global Events
This Is The script
function onRecord(current, old, cid)
db.executeQuery("INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (" .. current .. ", " .. getConfigValue('worldId') .. ", " .. os.time() .. ");")
addEvent(doBroadcastMessage, 150, "New record: " .. current .. " players are logged in.", MESSAGE_STATUS_DEFAULT)
end
But it Gives Me Error
And Another In Start
function onStartup()
db.executeQuery('UPDATE players SET online=0')
db.executeQuery('DELETE FROM player_storage WHERE `key` IN(126,127,128)')
doCreateNpc('Xodet', {x=569, y=2181, z=8})
doSetStorage(50290, 0)
doSetStorage(50320, 0)
end

 

[Limos]

Add this in data/lib/100-compat.lua

db.executeQuery = db.query

 

[7amo]

After What i Can Add db.executeQuery = db.query In 100-compat.lua?

 

[Limos]

That doesn't matter, just add it under something else.

 

[Czupryn1994]

For example on the end of file