[Help] My Server Wont Let me log in!!

[jacksponge]

I've being getting this error and the ot wont let me log in. Help me please?

mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)

 

[wesoly136]

Did you changed version? You have to update database. Create new database and import there mysql

 

[jacksponge]

yea i did, look!

> Updating database to version: 1...
> Database has been updated to version: 1.
> Updating database to version: 2...
> Database has been updated to version: 2.
> Updating database to version: 3...
> Database has been updated to version: 3.
> Updating database to version: 4...
> Database has been updated to version: 4.
> Updating database to version: 5...
> Database has been updated to version: 5.
> Updating database to version: 6...
> Database has been updated to version: 6.
> Updating database to version: 7...
> Database has been updated to version: 7.
> Updating database version to: 8...
> Database has been updated to version: 8.
> Updating database to version: 9...
> Database has been updated to version: 9.
> Updating database to version: 10...
> Database has been updated to version: 10.
> Updating database to version: 11...
> Database has been updated to version: 11.
> Updating database to version: 12...
> Database has been updated to version: 12.
> Updating database to version: 13...
mysql_real_query(): ALTER TABLE `accounts` DROP K
rror on rename of '.\forgottenserver\#sql-68c_5c'
' (errno: 150) (1025)
mysql_real_query(): ALTER TABLE `players` DROP KE
ror on rename of '.\forgottenserver\#sql-68c_5c'
(errno: 150) (1025)
mysql_real_query(): DROP TABLE `groups`; - MYSQL
a parent row: a foreign key constraint fails (121
> Database has been updated to version: 13.
> Updating database to version: 14...
> Database has been updated to version: 14.
> Updating database to version: 15...
> Database has been updated to version: 15.
> Updating database to version: 16...
> Database has been updated to version: 16.
> Updating database to version: 17...
> Database has been updated to version: 17.

But Still Don't Work :/ this is the messege i get when i try to log in with account manager. "1/1"

mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'forgottenserver.z_ots_comunication' doesn't exist (1146)

Get me? jejeje thanks tho

 

[wesoly136]

But you only downloaded a new TFS and turn on it, Try to create new DB and import from schemas mysql file...

 

[Cykotitan]

SQL query:

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`)
);