SQL Bug with semicolon

Hello,

 

whem user make an Nick or username with simicolon like

Helmut'sKneipe

 

the become a Database error. Here is my report.

Database error in **.de - ---

Query:

UPDATE tht_sessions SET userid='****', username = 'Helmut'sKneipe', time=1312017780, guest ='0' where session_id =****************'

Mysql error: 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 'sKneipe', time=1312017780, guest ='0' where session_id =***************' at line 1

--Germany-- Sorry for my bad english :P
Quote · 30 Jul 2011
' is an apostrophe. ; is a semicolon. Your English is better than my German. ;-)
Quote · 30 Jul 2011
  1. That's an apostrophe ('), not a semicolon (;)
  2. Neither of those characters are allowed by default, and probably for a good reason
  3. I don't recall "tht_sessions" being a default database table. Problems with custom modules or extensions should be taken up with the developer.

 

Cheers.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 30 Jul 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.