July 23rd, 2005, 02:29 PM
|
#1 (permalink)
|
| Junior Member Verified Customer
Join Date: Jul 2005 Location: San Diego, Californi
Posts: 15
| SQL Error
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
| |
| |