No announcement yet.

New Register's with an ' in their name

  • Filter
  • Time
  • Show
Clear All
new posts

  • New Register's with an ' in their name

    People are getting an error when they try to register to my forums using a name with an apostrophe in it. Here is what is said when they try and create one.

    There seems to have been a slight problem with the Game Generation Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    here is the error sent to me in email.

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT username FROM user WHERE username='DA PPL'S CHAMP' mysql error: You have an error in your SQL syntax near 'S CHAMP'' at line 1

    mysql error number: 1064

    any ideas on how to fix this?

    Thanks for any help

  • #2
    This is likely from a hack. I'd recommend reuploading all the unmodified files (or just register.php). Alternatively you'll have to contact the hack author.


    • #3
      thanks Ed, that did in fact fix it, now im just hoping to clean up the previous code


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.