Log in

View Full Version : Mysql error after source update from today.


epilz
02-17-2015, 10:11 PM
Has anyone seen this error when updating to the latest source today. It gives the error to every account that logs in.

[MySQL Error] 1064: 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 'FROM
character_data WHERE `account_id` = 68226' at
line 1
SELECT `id`, name,
`level`, last_login, FROM
character_data WHERE `account_id` = 68226 ORDER BY `name` LIMIT 1
2

epilz
02-17-2015, 10:12 PM
everything worked fine until today's update

epilz
02-17-2015, 11:08 PM
Suppose this is due to the change in the changelog.

SoF thru RoF2 have had their max characters raised to 12 from 10
- Changing the number of characters per account is accomplished by:
1) Setting consts::CHARACTER_CREATION_LIMIT to the desired count in the client's constants file in ../common/patches/
2) Ensuring that eq_dictionary's EmuConstants::CHARACTER_CREATION_LIMIT is equal-greater than the client's new value..referencing is good
3) Recompiling the server code
- A rules-based qualifier may be added at some point

Are we getting this error due to no rule, or is there something else that needs to be changed? Or do I need to change it back to 10 and recompile to fix error? Any assistance would be great!

Uleat
02-18-2015, 01:19 AM
Sorry about that..didn't want to push a perfect product!

[Comma removed]

epilz
02-18-2015, 02:37 AM
No worries. Just making everyone aware. Thanks!