[Moreliator]

Today at 08:04 PM Bitsys said this in Post #1515

Can you send me a copy of the e-mail that was sent to Tech Support when the user got the database error?

Hmm, well I'm getting so many emails now, that I';m not sure which one it was. But all of them are basically the same:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO battle_posts VALUES (NULL,'326','s'mores','8447','The 1337 Beast used his Scratch to deal 12 points of damage. Mediator tried to dodge, but was not successful. Mediator has died!!')
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 'mores','8447','[I]The 1337 Beast used his Scratch to dea

mysql error number: 1064

Date: Tuesday 22nd of April 2003 08:00:03 PM
Script: http://smashboards.com///battleupdat...26&username=s\'mores&userid=8447&battlekey=Smashboards
Referer: http://smashboards.com//battlefight....ey=Smashboards

s'mores is the guy who has the really messed up battle record. I checked all the email errors I've been getting, and ever since the first guy got his record screwd up they have all been this '1064' error with similar messages:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO battle_posts VALUES (NULL,'333','s'mores','8447','The 1337 Beast was awarded $0 for winning the battle.')
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 'mores','8447','[I]The 1337 Beast was awarded $0 for winn

mysql error number: 1064

Date: Tuesday 22nd of April 2003 08:05:57 PM
Script: http://smashboards.com///battleupdat...33&username=s\'mores&userid=8447&battlekey=smores
Referer: http://smashboards.com//battlefight....33&username=s\'mores&userid=8447&battlekey=smores

The only other email error message I receive is:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT field5 FROM userfield WHERE userid=
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 '' at line 1

mysql error number: 1064

Date: Tuesday 22nd of April 2003 05:15:51 PM
Script: http://smashboards.com//itemshop.php
Referer: http://smashboards.com/itemshop.php?action=donate&user=

But that doesn't seem to be too big of a problem.


EDIT: Okay, I did more research, and it appears these problems are coming from the fact that people with a ' in their name are screwing up syntax. I reset battle standings and told the people with ' and & in their name not to play, and so far no problem.

Any ideas on that donation error? It appears members only have success donating through the profile.