Log in

View Full Version : Error after trying to post a review


LittleFreak
Mar 10, 2005, 05:16 AM
http://www.jazz2online.com/J2Ov2/downloads/info.php?levelID=3624

As I reviewed the above upload and clicked on 'Submit', I got the following message:

There seems to be a slight problem with the database.

Please press the refresh button in your browser window once.
If you still see this error message, and you have already refreshed your browser, then there is something wrong.

Please worry. An E-Mail has not been sent to the Technical Staff.
If you feel that you would like to tell the Technical Staff more about this incidient, please click the link.

We are sorry for any inconvienience this may have caused you.

Below is a copy of the E-Mail not sent to the Technical Staff:
mySQL Database Error!

Script That Crashed: J2Ov2
Script Returned: Bad SQL Syntax: insert into J2Ov2_latestAdditions set objectType = 'downloadReview', objectID = '22734', objectName = 'Review for Lightgazer's Relic (rating: 6.5)', userID = '2288', timestamp = '1110463877'
mySQL Said: 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 's Relic (rating: 6.5)', userID = '2288', timestamp = '111046387 (Error Number 1064)
Date of Error: March 10th, 2005 at 9:11 AM
URL of Script: /J2Ov2/downloads/submitReview.php
Referring Page:

After I clicked refresh, I got a message I may not review this upload twice. As I clicked my review was existant, which means the error message is false.

I guess it's best if one of the J2O admins could check what it is, because it's somewhat annoying to write a detailed review for nothing.

FQuist
Mar 12, 2005, 10:19 AM
I guess it's best if one of the J2O admins could check what it is, because it's somewhat annoying to write a detailed review for nothing.

I'll look into it. I don't get the part of your message quoted above. You didn't write it for nothing right? It posted..

LittleFreak
Mar 12, 2005, 10:22 AM
Yes, it's there. That means, that the message telling me there was an error while trying to post my review is false, because it worked fine.

Before a review 'really' gets deleted though, it'd be better if the error could be fixed. ;) (sorry, I know my grammar sux sometimes. ;D )

Olsen
Mar 12, 2005, 10:23 AM
Below is a copy of the E-Mail not sent to the Technical Staff:

Ahahahahahahaha

FQuist
Mar 12, 2005, 11:27 AM
The error isn't fake, since it's about the review link being posted to the latest additions page (which we never finished), not the review itself not being posted.

Fixed it now. It looks like somehow it wasn't adding the necesarry slashes for the database. Weird..

Thanks for the report.

LittleFreak
Mar 12, 2005, 12:00 PM
The error isn't fake, since it's about the review link being posted to the latest additions page (which we never finished), not the review itself not being posted.

Fixed it now. It looks like somehow it wasn't adding the necesarry slashes for the database. Weird..

Thanks for the report.

Thanks for fixing it. ;)