Jump to content
×
×
  • Create New...
  • 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 comment
Share on other sites

  • Answers 1
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

1 answer to this question

Recommended Posts

  • 0
  • Web Developer

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

Metin2 Icon Database

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.


  • Activity

    1. 36

      Destroy Item System

    2. 1

      Brillances

    3. 0

      Fusion.org is Looking for Staff Members

    4. 1

      Brillances

    5. 3

      ELONIA2 | PVM-MEDIUM | 11 LANGUAGES | INTERNATIONAL | A NEW STORY

    6. 4

      Spider Queen not spawining in spider dungeon v1

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.