Rokco 12 Posted July 15, 2021 Share Posted July 15, 2021 Hi, i was just install sash with scale, All done no bugs or problem, Only thing what i can't solve it's this, Has anyone an idea about this error. (The error its aparar when i try to combine sash of different grades) Iven if is show this error no bug / problems in game. SYSERR: Jul 15 21:23:08 :: 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 '' at line 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 519, 968863, 278983, 11895041, 'COMBINE (REFINE SUCCESS)', 'Esarfa Roiala (Antica) 1 ', errno: 1064) Thank you in advence. Link to comment Share on other sites More sharing options...
Rokco 12 Posted July 15, 2021 Author Share Posted July 15, 2021 OK, I found the solution for this, but I don't understand why he does this when his name is too long in DB. The solution is this, I got in * DB * PLAYER = Item_proto (name and Locale_name) to the object that displayed my error, It was called [Esarfa Suveran (Ancient)] if you cut 4 or 5 characters from the object name, Example: [Esarfa Suv (Ancient)] (error disappears). I think because the name is too long, but I still don't see the connection. If anyone has an explanation for this, I would be happy to hear it! Thank you. Link to comment Share on other sites More sharing options...
Premium FlorinMarian 122 Posted July 16, 2021 Premium Share Posted July 16, 2021 Hi! Maybe log table has less characters available than your item name. Open your log database with Navicat, then click on log table and press CTRL+D, you should figure out if this is the case or not. Best regards, Florin. Shared Hosting | Domain names | Dedicated Servers | VPS HAZI.ro 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