mysql_query error: Table 'account.player_index' doesn't exist

[мσнαмє∂ 0]

Hello guys , 

 

Spoiler

SYSERR: Apr 25 20:00:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.player_index' doesn't exist
query: SELECT id, pid1, pid2, pid3, pid4 FROM player_index WHERE pid1=2826 OR pid2=2826 OR pid3=2826 OR pid4=2826 AND empire=3
SYSERR: Apr 25 19:59:50 :: ChildLoop: AsyncSQL: query failed: Table 'account.safebox' doesn't exist (query: SELECT size FROM safebox WHERE account_id = 14 errno: 1146)
SYSERR: Apr 25 19:59:52 :: ChildLoop: AsyncSQL: query failed: Table 'account.messenger_list' doesn't exist (query: SELECT account, companion FROM messenger_list WHERE account='Test1' errno: 1146)
SYSERR: Apr 25 02:06:14 :: RunState: LUA_ERROR: locale/italy/quest/questlib.lua:2680: attempt to call a nil value
SYSERR: Apr 25 02:06:14 :: WriteRunningStateToSyserr: LUA_ERROR: quest reload_itemshop.start click

anyone know how can me solve it .

[tierrilopes 407]

If they dont exist at db:

DB--> Player --> query

DROP TABLE IF EXISTS `safebox`;
CREATE TABLE `safebox` (
  `account_id` int(20) unsigned NOT NULL DEFAULT '0',
  `size` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `password` varchar(6) NOT NULL DEFAULT '',
  `gold` int(30) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `messenger_list`;
CREATE TABLE `messenger_list` (
  `account` varchar(20) NOT NULL DEFAULT '',
  `companion` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`account`,`companion`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `player_index`;
CREATE TABLE `player_index` (
  `id` int(11) NOT NULL DEFAULT '0',
  `pid1` int(11) NOT NULL DEFAULT '0',
  `pid2` int(11) NOT NULL DEFAULT '0',
  `pid3` int(11) NOT NULL DEFAULT '0',
  `pid4` int(11) NOT NULL DEFAULT '0',
  `empire` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pid1_key` (`pid1`),
  KEY `pid2_key` (`pid2`),
  KEY `pid3_key` (`pid3`),
  KEY `pid4_key` (`pid4`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[metin2team 623]

Table 'account.player_index' doesn't exist

Table 'account.safebox' doesn't exist

Table 'account.messenger_list' doesn't exist

you have to change account table in game cores CONFIG file  NOT AUTH to player.

1 minute ago, tierrilopes said:

DROP TABLE IF EXISTS `safebox`;
CREATE TABLE `safebox` (
  `account_id` int(10) unsigned NOT NULL DEFAULT '0',
  `size` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `password` varchar(6) NOT NULL DEFAULT '',
  `gold` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `messenger_list`;
CREATE TABLE `messenger_list` (
  `account` varchar(12) NOT NULL DEFAULT '',
  `companion` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`account`,`companion`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

wtf?

[мσнαмє∂ 0]

Just now, metin2team said:

Table 'account.player_index' doesn't exist

Table 'account.safebox' doesn't exist

Table 'account.messenger_list' doesn't exist

you have to change account table in cores NOT AUTH to player.

I Did it , but core dont work .

8 minutes ago, metin2team said:

Table 'account.player_index' doesn't exist

Table 'account.safebox' doesn't exist

Table 'account.messenger_list' doesn't exist

you have to change account table in cores NOT AUTH to player.

Solve , thanks bro

 

Please close