PDA

View Full Version : Article Comments Are Bugged Slightly


Love & Thunder
Mar 22, 2012, 06:24 AM
If you try to comment on an Article, it'll come up with this:
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 don't worry. An E-Mail has 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 sent to the Technical Staff:mySQL Database Error!

Script That Crashed: J2Ov2
Script Returned: Bad SQL Syntax: insert into J2Ov2_ipLog (ipAddress,userID,action, timestamp, specifics) VALUES ('','18978','Post article comment','1332429655','articleID: 356; reviewID: 2229')
mySQL Said: Duplicate entry '65535' for key 'PRIMARY' (Error Number 1062)
Date of Error: March 22nd, 2012 at 4:20 PM
URL of Script: /articles/postReview.php
Referring Page:But, if you go back a page and refresh, the Comment is right there as if there was no error at all.

Jgke
Mar 22, 2012, 06:32 AM
mySQL Said: Duplicate entry '65535' for key 'PRIMARY' (Error Number 1062)

So, using a smallint?

Stijn
Mar 22, 2012, 08:27 AM
Apparently. Fixed.