Jump to content
  • 0

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


mohanad1111

Question

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'
 

Link to post

1 answer to this question

Recommended Posts

  • 0
  • VIP

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)

QJ0orbR.png

Logo M2IconDB

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



Shoutbox

Shoutbox

Chatroom Rules

 

Join our Discord

A request for help = Shoutbox Ban

Be respectful & Respect the rules

 

×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.