• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows z_ots_communication crash

Wezc

Wezc

Banned User
Joined
Feb 9, 2009
Messages
467
Reaction score
14
Location
Svenneland
Hey, once i start my server and try to join it, the server spams
SQL: 
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'theforgottenserver.z_ots_comunication' doesn't exist (1146)

and once i try to login the server stops responding..

Help? :]
 
Sort by date Sort by votes
so many peole have this problem :P

Code: 
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=1993 ;
 
Upvote 0 Downvote
well he removed the z_ots_communities issue.. but now this annoying shit appear, Error (200002)

I connect via 8.54 and the server stops responding and gives me Error: (200002)
 
Upvote 0 Downvote
Taken From Otfans.net..

Code: 
you don't always have to port forward heres an example

THIS CAN SKIP THE PORT FORWARDING STAGE FOR YOU..THIS DOESNT COVER DATABASES, THIS JUST ASSISTS IN BROADCASTING YOUR IP


lets take a step back this is how i used to do it back in the day

hold the windows key and press r to open up the run box// type cmd to bring up the command prompt// type ipconfig to show ur default gateway etc..// look for your ip address (not the static one) so copy your IP ADDRESS to a piece of paper, for example mines 192.168.0.2 using a netgear modem// next keep command prompt open and look at your default gateway type that number into your web browser...example... internet explorer, firefox, opera, safari etc etc...// next your prompted with a username and password box// the try these default values in the respected boxes...

user: admin
pass: admin

user: admin
pass: leave blank

user: admin
pass: password

if they fail look up your modems model number on the internet through google to find the default values (unless you changed it)

now once your in your modems page.. remember that ip address you wrote down? mine was 190.168.0.2 we will need it now....// on my netgear its in WAN setup under DMZ (note:refer to your modems user manual or goto google to find out how to change your DMZ if you cannot locate it)

the DMZ allows me to broadcast my static ip out for others to connect to, my DMZ at the moment is 192.168.0.6 <--- well no wonder people cant connect, its allocated another ip so what we need to do is change that to my ip all i need to do is change the 6 into a 2 then click apply...// your modem may reboot to change settings

NOTE: the good thing about my netgear modem is i dont have to port forward or change firewall settings, once i change the DMZ to my ip from the command prompt it automatically makes the required changes for hosting

hopefully this has helped
 
Upvote 0 Downvote
Back
Top