• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

SQL Error

L

liqeen

Active Member
Joined
Nov 26, 2014
Messages
150
Solutions
1
Reaction score
30
Location
Poland
After compiling a server and log in into the game then loging out this error appearing in console
Code: 
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560866209,`lastip` = 16777343,`conditions` = '',`skulltime` = 0' at line 1
How do I fix this? Because of it any character can't save their statistics.
 
Sort by date Sort by votes
liqeen said:
After compiling a server and log in into the game then loging out this error appearing in console
Code: 
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560866209,`lastip` = 16777343,`conditions` = '',`skulltime` = 0' at line 1
How do I fix this? Because of it any character can't save their statistics.
Click to expand...
My friend that error doesn't give enough info, like we can understand what problem you have but we can't know exactly where is your problem, or with better words giving a solution..

looks like a .cpp error by generating an invalid sql sentence but sql also have triggers... which engine are you trying to setup?

for the client, which client are you using? latest update?
 
Upvote 0 Downvote
kuhi said:
My friend that error doesn't give enough info, like we can understand what problem you have but we can't know exactly where is your problem, or with better words giving a solution..

looks like a .cpp error by generating an invalid sql sentence but sql also have triggers... which engine are you trying to setup?

for the client, which client are you using? latest update?
Click to expand...
Client does have anything to this, I have a compiled version of TFS when it were working few months ago and now I wanted to change something but I can't compile anything becuase of thousands of errors.
now MVS does not compile and sends a error
Code: 
cannot open input file 'lua51.lib'
duude it is like tilt at windmills
 
Upvote 0 Downvote
liqeen said:
Client does have anything to this, I have a compiled version of TFS when it were working few months ago and now I wanted to change something but I can't compile anything becuase of thousands of errors.
now MVS does not compile and sends a error
Code: 
cannot open input file 'lua51.lib'
duude it is like tilt at windmills
Click to expand...
yeah now with that error msg client doesn't play here but if you didn't give all details we can't know it with black magic, client is dealing with logout signal too that's why I said...

it's easy you didn't link the libs correctly, just read this manual and just understand the idea so you can apply to your engine:

Google Code Archive - Long-term storage for Google Code Project Hosting.

code.google.com code.google.com
 
Upvote 0 Downvote
kuhi said:
yeah now with that error msg client doesn't play here but if you didn't give all details we can't know it with black magic, client is dealing with logout signal too that's why I said...

it's easy you didn't link the libs correctly, just read this manual and just understand the idea so you can apply to your engine:

Google Code Archive - Long-term storage for Google Code Project Hosting.

code.google.com code.google.com
Click to expand...
Just linked every sdk folder also the boost folders and lua51 lib fixed.

But the SQL error is still killing me.
Code: 
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 1005,`group_id` = 1,`vocation` = 2,`health` = 5270,`healthmax` = 5270,`experience` = 16854438038,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 430,`lookaddons` = 3,`maglevel` = 56,`mana` = 6846
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560871933,`lastip` = 16777343,`conditions` = '\0\0\0    ' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 1005,`group_id` = 1,`vocation` = 2,`health` = 5270,`healthmax` = 5270,`experience` = 16854438038,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 430,`lookaddons` = 3,`maglevel` = 56,`mana` = 6846
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560871933,`lastip` = 16777343,`conditions` = '\0\0\0    ' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 1005,`group_id` = 1,`vocation` = 2,`health` = 5270,`healthmax` = 5270,`experience` = 16854438038,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 430,`lookaddons` = 3,`maglevel` = 56,`mana` = 6846
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560871933,`lastip` = 16777343,`conditions` = '\0\0\0    ' at line 1
Error while saving player: Helper
Whole error message since login till logout
About the client what you mean? Tibia client? If yes it is just normal 10.95 version
 
Upvote 0 Downvote
liqeen said:
Just linked every sdk folder also the boost folders and lua51 lib fixed.

But the SQL error is still killing me.
Code: 
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 1005,`group_id` = 1,`vocation` = 2,`health` = 5270,`healthmax` = 5270,`experience` = 16854438038,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 430,`lookaddons` = 3,`maglevel` = 56,`mana` = 6846
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560871933,`lastip` = 16777343,`conditions` = '\0\0\0    ' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 1005,`group_id` = 1,`vocation` = 2,`health` = 5270,`healthmax` = 5270,`experience` = 16854438038,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 430,`lookaddons` = 3,`maglevel` = 56,`mana` = 6846
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560871933,`lastip` = 16777343,`conditions` = '\0\0\0    ' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 1005,`group_id` = 1,`vocation` = 2,`health` = 5270,`healthmax` = 5270,`experience` = 16854438038,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 430,`lookaddons` = 3,`maglevel` = 56,`mana` = 6846
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',`lastlogin` = 1560871933,`lastip` = 16777343,`conditions` = '\0\0\0    ' at line 1
Error while saving player: Helper
Whole error message since login till logout
About the client what you mean? Tibia client? If yes it is just normal 10.95 version
Click to expand...
I have no idea bro, if I could look at the code that is generating that query I could help but I'm sorry can't do anything here
 
Upvote 0 Downvote
liqeen said:
Client does have anything to this, I have a compiled version of TFS when it were working few months ago and now I wanted to change something but I can't compile anything becuase of thousands of errors.
now MVS does not compile and sends a error
Code: 
cannot open input file 'lua51.lib'
duude it is like tilt at windmills
Click to expand...
go into your /MSVC/lib folder look for lua5.1.lib and change name to lua51.lib
 
Upvote 0 Downvote

Similar threads

D
  • Question
console error
Replies
9
Views
672
dfs1
dfs1
D
  • Solved
mysql problem with new skill
Replies
2
Views
288
Dran Ryszard
D
A
  • Question
Syntax erro boosted_monsters
Replies
0
Views
236
Azerty
A
F
  • Question
TFS 1.X+ IOLoginData::loginserverAuthentication
Replies
10
Views
793
ForgottenNot
F
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
2
Views
247
ShadowProwl
ShadowProwl
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
589
lursky
L
M
  • Question
Error MySQL
Replies
0
Views
129
Mokk
M
Back
Top