rcdporraz 6 Posted January 22, 2020 Share Posted January 22, 2020 (edited) I need help with this error, please if anyone knows can you help me? thanks. https://metin2.download/picture/aj97Q5YSJav67xT3xTljk5I3SnMcjD4I/.gifv Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal 1 Link to comment Share on other sites More sharing options...
rcdporraz 6 Posted January 22, 2020 Author Share Posted January 22, 2020 up Link to comment Share on other sites More sharing options...
Sherer 481 Posted January 22, 2020 Share Posted January 22, 2020 It's impossible to help you without getting even a leap of code. Link to comment Share on other sites More sharing options...
rcdporraz 6 Posted January 22, 2020 Author Share Posted January 22, 2020 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 More sharing options...
Forum Moderator Raylee 656 Posted January 22, 2020 Forum Moderator Share Posted January 22, 2020 1 hour ago, rcdporraz said: up Rules §2 Topics (2.2) Bumping Allowed bumping times: Services area - 24 hours Q&A - 48 hours Any other bumping will result in an infraction! Regards Raylee Link to comment Share on other sites More sharing options...
Sherer 481 Posted January 22, 2020 Share Posted January 22, 2020 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 More sharing options...
rcdporraz 6 Posted January 23, 2020 Author Share Posted January 23, 2020 hace 8 horas, Sherer dijo: Debes investigar tu estructura offline_shop_item. Well, I don't know much about source but could you help me out? please Link to comment Share on other sites More sharing options...
Sherer 481 Posted January 23, 2020 Share Posted January 23, 2020 10 hours ago, rcdporraz said: Well, I don't know much about source but could you help me out? please Open database (assuming you use navicat), click on offline_shop_item table and edit its structure. Link to comment Share on other sites More sharing options...
rcdporraz 6 Posted January 23, 2020 Author Share Posted January 23, 2020 (edited) 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 September 4, 2022 by Metin2 Dev Core X - External 2 Internal 1 Link to comment Share on other sites More sharing options...
rcdporraz 6 Posted January 24, 2020 Author Share Posted January 24, 2020 up Link to comment Share on other sites More sharing options...
Flourine 106 Posted April 22, 2020 Share Posted April 22, 2020 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4587 Posted April 22, 2020 Premium Share Posted April 22, 2020 (edited) 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 September 4, 2022 by Metin2 Dev Core X - External 2 Internal 1 Link to comment Share on other sites More sharing options...
Flourine 106 Posted April 24, 2020 Share Posted April 24, 2020 (edited) 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 April 24, 2020 by Flourine Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now