Database Error Desc Limit

KenDude · November 25th, 2011, 09:11 AM

Chuck,
I had a member create a category and put some pictures in it, but now when I try to view his category I get a database error which seems to indicate the title of an image was too long?

The error in my browser says:

Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 ' images.imageid DESC LIMIT' at line 5 in [path]/includes/class_core.php on line 1173

Inside the database box in the browser error report is the following:

Code:

Content visible to verified customers only.

The category in question is here:
LED Spars with Radiator Guards Installation - Photo Gallery

Can you help?

KenDude · November 25th, 2011, 09:13 AM

Chuck,
Weird but upon refresh the category and photos show up now. No idea what happened or why...

Chuck S · November 25th, 2011, 09:36 AM

well actually what script you are on? it looks to me like that error means your missing a sort meaning that there is a sort that is empty. see those two commas with nothing in between

KenDude · November 25th, 2011, 09:40 AM

Here's what I did. I navigated to the category where that user had their photos and was met with a request to enter a password, for some reason the member put a password on the category and shouldn't have. So in another browser I opened up admincp and went in and editted the category and removed the password. I then went back to the other tab and backed up a page and clicked on the category again and it still asked me for a password, well I remembered what the password was so I filled it in and after pressing submit is when I get this error. Possibly the page had been served up from my browser cache as opposed to the server because the password should have been gone, but yet it was still asking me for it, seemed to accept it but then went to the database error page.

Hope that helps... I thought something was wrong with some photo in his category or something that was throwing the error but then after reporting here I went back and tried to access the category again and it was just fine.

Chuck S · November 25th, 2011, 09:47 AM

yeah I was just asking so I can try and track anything down