Jump to content

Bug in shop offline


Recommended Posts

Sysser of the database is empty, this throws it to me in chanel 1

DestroyItem: WTH! Invalid item owner. owner pointer : 0x476b6e00

DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Out of range value for column 'applytype0' at row 1

query: INSERT INTO offline_shop_item (id,owner_id,pos,count,price,price_cheque,vnum,transmutation,evolution,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, applyvalue7) VALUES (330000002,1,17,1,123,0,1049,0,0,1,1,0,0,18,10,0,0,0,0,0,0,0,0,0,0,0,0,153,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

 

Link to comment
Share on other sites

  • Bronze
3 hours ago, rcdporraz said:

Sysser of the database is empty, this throws it to me in chanel 1

DestroyItem: WTH! Invalid item owner. owner pointer : 0x476b6e00

DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Out of range value for column 'applytype0' at row 1

query: INSERT INTO offline_shop_item (id,owner_id,pos,count,price,price_cheque,vnum,transmutation,evolution,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, applyvalue7) VALUES (330000002,1,17,1,123,0,1049,0,0,1,1,0,0,18,10,0,0,0,0,0,0,0,0,0,0,0,0,153,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

 

You should investigate your offline_shop_item structure.

Link to comment
Share on other sites

6 hours ago, Sherer said:

Open database (assuming you use navicat), click on offline_shop_item table and edit its structure.

This is my structure  https://metin2.download/picture/bhZ33f6V9XH3mKRiqq566G4XOo8Zitk4/.png you can give me you skype? please

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1
Link to comment
Share on other sites

  • 2 months later...
  • Premium
On 1/24/2020 at 12:59 AM, rcdporraz said:

This is my structure  https://metin2.download/picture/bhZ33f6V9XH3mKRiqq566G4XOo8Zitk4/.png you can give me you skype? please

 

Mark the checkbox that says Unsigned there while having applytype0 highlighted as in your picture and Save.

 

1 hour ago, Flourine said:

sysrc mysql_optfile="/var/db/mysql/my.cnf"

ee /var/db/mysql/my.cnf

[mysqld]

sql_mode=

esc-> a - > a 

service mysql-server restart

fixed

 

The original game won't even run (without crashing) in a modern version of MySQL if that wasn't done already. Besides, that's not the standard location of my.cnf in FreeBSD.

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1
Link to comment
Share on other sites

On 4/23/2020 at 12:10 AM, Shogun said:

 

Mark the checkbox that says Unsigned there while having applytype0 highlighted as in your picture and Save.

 

 

The original game won't even run (without crashing) in a modern version of MySQL if that wasn't done already. Besides, that's not the standard location of my.cnf in FreeBSD.

Thats why i used that sysrc here to tell where is my.cnf

log.cpp need to be edited in original game but it won't cause the core crash.It will only cause troubles with saving of logs 

 

If u are talking about mysql above 5.7 then you are right.It won't run but below and equal 5.7 it will

Edited by Flourine
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • 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.