I entered an apostrophe as one of the allowed characters in Admin for login names. As soon as someone used an apostrophe, the whole room went down and this message now appears instead of the login page:
Database error: Invalid SQL: UPDATE c_messages SET message = 'stripslashes(sprintf(L_ENTER_ROM_NOSOUND, "n'eNow770"))' WHERE message = 'stripslashes(sprintf(L_ENTER_ROM, "n'eNow770"))' AND m_time<1156308123 ORDER BY m_time DESC LIMIT 1
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 'eNow770"))' WHERE message = 'stripslashes(sprintf(L_ENTER_ROM, "n'eNow770"))' AN' at line 1)
Session halted.
How do I correct this? Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The default list of allowed characters is the one you first found in Admin Panel... No other characters should be used...
This is the list of chars which will not cause any problems:
a-zA-Z0-9_.-@#$%^&*()=<>?~|`:
Of course, I haven't checked all of them, so if someone finds out that one of these cause errors, please let us know!
Thanks,
Ciprian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I entered an apostrophe as one of the allowed characters in Admin for login names. As soon as someone used an apostrophe, the whole room went down and this message now appears instead of the login page:
Database error: Invalid SQL: UPDATE c_messages SET message = 'stripslashes(sprintf(L_ENTER_ROM_NOSOUND, "n'eNow770"))' WHERE message = 'stripslashes(sprintf(L_ENTER_ROM, "n'eNow770"))' AND m_time<1156308123 ORDER BY m_time DESC LIMIT 1
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 'eNow770"))' WHERE message = 'stripslashes(sprintf(L_ENTER_ROM, "n'eNow770"))' AN' at line 1)
Session halted.
How do I correct this? Thanks.
The default list of allowed characters is the one you first found in Admin Panel... No other characters should be used...
This is the list of chars which will not cause any problems:
a-zA-Z0-9_.-@#$%^&*()=<>?~|`:
Of course, I haven't checked all of them, so if someone finds out that one of these cause errors, please let us know!
Thanks,
Ciprian
Don't you ever use the ' character in the username field. As well as \ " or space.