Register FAQ Search Today's Posts Mark Forums Read
Go Back   JazzJackrabbit Community Forums » Maintenance & Feedback » Site and Forum Rules, Questions & Feedback

Error after trying to post a review

LittleFreak

JCF Member

Joined: May 2004

Posts: 4,190

LittleFreak is doing well so far

Mar 10, 2005, 05:16 AM
LittleFreak is offline
Reply With Quote
Error after trying to post a review

http://www.jazz2online.com/J2Ov2/dow...p?levelID=3624

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

Quote:
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.
__________________
Sober again. Still love it.
FQuist

JCF Member

Joined: Sep 2001

Posts: 3,251

FQuist is an asset to this forumFQuist is an asset to this forum

Mar 12, 2005, 10:19 AM
FQuist is offline
Reply With Quote
Quote:
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..
__________________
“The truth is that everything that can be accomplished by showing a person when he's wrong, ten times as much can be accomplished by showing him where he is right.” - Robert T. Allen

Interesting Jazz-related links:
Thread: Gameplay Theories - Thread: Make Up Your Own Gametype

Spotify.fm

LittleFreak

JCF Member

Joined: May 2004

Posts: 4,190

LittleFreak is doing well so far

Mar 12, 2005, 10:22 AM
LittleFreak is offline
Reply With Quote
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 )
__________________
Sober again. Still love it.
Olsen

JCF Member

Joined: May 2004

Posts: 1,370

Olsen is doing well so far

Mar 12, 2005, 10:23 AM
Olsen is offline
Reply With Quote
Quote:
Below is a copy of the E-Mail not sent to the Technical Staff:
Ahahahahahahaha
__________________
some kind of nature
FQuist

JCF Member

Joined: Sep 2001

Posts: 3,251

FQuist is an asset to this forumFQuist is an asset to this forum

Mar 12, 2005, 11:27 AM
FQuist is offline
Reply With Quote
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.
__________________
“The truth is that everything that can be accomplished by showing a person when he's wrong, ten times as much can be accomplished by showing him where he is right.” - Robert T. Allen

Interesting Jazz-related links:
Thread: Gameplay Theories - Thread: Make Up Your Own Gametype

Spotify.fm

LittleFreak

JCF Member

Joined: May 2004

Posts: 4,190

LittleFreak is doing well so far

Mar 12, 2005, 12:00 PM
LittleFreak is offline
Reply With Quote
Quote:
Originally Posted by Fquist
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.
__________________
Sober again. Still love it.
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

All times are GMT -8. The time now is 10:12 AM.