Jump to content

Recommended Posts

HI,

i have problem when open safe box or mall they do not open @@ when click in they i have this error in db sysser 

Spoiler

SYSERR: May  6 02:42:27 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May  6 02:42:29 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May  6 02:44:22 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE owner_id=1 AND window='SAFEBOX'' at line 1 (query: SELECT id, window+0, pos, count, vnum, socket0, socket1, socket2, socket3, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0,applytype1, applyvalue1,applytype2, applyvalue2,applytype3, applyvalue3,applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7FROM item WHERE owner_id=1 AND window='SAFEBOX' errno: 1064)
SYSERR: May  6 02:44:22 :: RESULT_SAFEBOX_LOAD: null safebox result
SYSERR: May  6 02:44:26 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE owner_id=1 AND window='MALL'' at line 1 (query: SELECT id, window+0, pos, count, vnum, socket0, socket1, socket2, socket3, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0,applytype1, applyvalue1,applytype2, applyvalue2,applytype3, applyvalue3,applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7FROM item WHERE owner_id=1 AND window='MALL' errno: 1064)
SYSERR: May  6 02:44:26 :: RESULT_SAFEBOX_LOAD: null safebox result

Any hel please ?

Link to comment
https://metin2.dev/topic/11664-porblem-in-mall-and-safeobx-not-open/
Share on other sites

At RESULT_SAFEBOX_LOAD in ClientManager.cpp

Change applyvalue7FROM  to applyvalue7 FROM.

 

But now srsly, before posting here check the query because it clearly tells you that this is a syntax error. It isn't that much hard to fix it.

  • Love 1
6 hours ago, Denis said:

At RESULT_SAFEBOX_LOAD in ClientManager.cpp

Change applyvalue7FROM  to applyvalue7 FROM.

 

But now srsly, before posting here check the query because it clearly tells you that this is a syntax error. It isn't that much hard to fix it.

thnx for you fixed 

Don't use any images from : imgur, turkmmop, freakgamers, inforge, hizliresim... Or your content will be deleted without notice...
Use : https://metin2.download/media/add/

Please use https://metin2.download/ when uploading files smaller than 100MB, otherwise the approval will take longer due to manual upload.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • 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.