sysser auth mysql_query error: Table 'account.banned_ip' doesn't exist

[mohanad1111 12]

SYSERR: Feb 20 16:31:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.secure_ip' doesn't exist
query: SELECT ip FROM account.secure_ip WHERE login = 'root'
SYSERR: Feb 20 16:31:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.banned_ip' doesn't exist
query: SELECT ip FROM account.banned_ip WHERE ip = '206.62.139.25'
SYSERR: Feb 20 16:31:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.banned_hwid_list' doesn't exist
query: SELECT hwid FROM account.banned_hwid_list WHERE hwid = '00::FF::2A::7A::04::04'
SYSERR: Feb 20 16:31:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.banned_hdd_list' doesn't exist
query: SELECT hdd_serial FROM account.banned_hdd_list WHERE hdd_serial = 'ACE4_2E00_0A08_D6BE_2EE4_AC00_0000_0001.'
SYSERR: Feb 20 16:31:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.secure_pc_list' doesn't exist
query: SELECT hwid FROM account.secure_pc_list WHERE login = 'root' and status='1'
 

[Karbust 4717]

The errors are pretty explicit, you don't have those tables on database account, you need to create them.

 

We don't know what structure they need to have, but you can see at least 1 field per error message.

 

secure_ip we can see it has, at least, the field ip

banned_hwid_list we can see it has, at least, the fields hwid and hdd_serial

secure_pc_list we can see it has, at least, the fields hwid, login and status, which I imagine it probably has the foreign key login to login column on table account (which isn't the correct way, it should have the PK from account as FK)