SQL Error

digitalpoint · July 23rd, 2005, 01:29 PM

Anyone else seen this? It seems when cutoffdate is "lastvisit", it's not being converted to anything usable for the SQL query...

Quote:

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:

SELECT images.imageid, images.userid, images.thumbname, extension
FROM adv_gallery_images AS images

WHERE valid = 1 AND images.posts != 0 AND images.lastpostdateline > AND images.catid NOT IN(3)
ORDER BY images.lastpostdateline DESC, images.imageid DESC;

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 'AND images.catid NOT IN(3)
ORDER BY images.lastpostdateline D
Error Number : 1064
Date : Saturday, July 23rd 2005 @ 11:20:00 AM
Script : http://forums.digitalpoint.com/galle...date=lastvisit
Referrer : http://forums.digitalpoint.com/galle...date=lastvisit
IP Address : 82.43.213.74
Username : T0PS3O
Classname : vb_database

digitalpoint · July 23rd, 2005, 01:47 PM

Figured it out...

In showimage.php, this line:

Code:

Content visible to verified customers only.

should be:

Code:

Content visible to verified customers only.

(notice double $ in first line).

July 24th, 2005, 09:21 PM

Thanks for pointing this out.