EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Mysql error after source update from today. (https://www.eqemulator.org/forums/showthread.php?t=39382)

epilz 02-17-2015 10:11 PM

Mysql error after source update from today.
 
Has anyone seen this error when updating to the latest source today. It gives the error to every account that logs in.

Code:

[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!


All times are GMT -4. The time now is 02:28 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.