PhotoPost Community - Invalid SQL

PhotoPost Community (http://www.photopost.com/forum/)

- Bugs From 1.0.0 (http://www.photopost.com/forum/bugs-1-0-0/)

- - Invalid SQL (http://www.photopost.com/forum/bugs-1-0-0/117704-invalid-sql.html)

I got this error emailed to me twice last night. It must not happen very often since this is the first time I received it.

Quote:

Invalid SQL:
SELECT images.imageid, filename, originalname, thumbname, extension, images.title, images.catid, sticky, open ,images.userid, images.title ,images.username, images.description, images.dateline ,width, height, originalwidth, originalheight, images.views, images.posts, votenum, votetotal, categories.title AS cattitle
FROM adv_gallery_images AS images
LEFT JOIN adv_gallery_categories AS categories USING (catid)
WHERE images.imageid IN(762,763,765)
ORDER BY lastpostdateline , imageid DESC

mysql error: Column: 'lastpostdateline' in order clause is ambiguous

mysql error number: 1052

Can you post the entire error, inlcuding the script and referrer?

Yes, I will post it when I get home after work.

Here is the full error message minus the users IP:

Quote:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT images.imageid, filename, originalname, thumbname, extension, images.title, images.catid, sticky, open ,images.userid, images.title ,images.username, images.description, images.dateline ,width, height, originalwidth, originalheight, images.views, images.posts, votenum, votetotal, categories.title AS cattitle
FROM adv_gallery_images AS images
LEFT JOIN adv_gallery_categories AS categories USING (catid)
WHERE images.imageid IN(762,763,765)
ORDER BY lastpostdateline , imageid DESC

mysql error: Column: 'lastpostdateline' in order clause is ambiguous

mysql error number: 1052

Date: Thursday 24th of February 2005 12:36:34 AM
Script: http://www.dragonslist.com/gallery/b...&cutoffdate=-1
Referer: http://www.dragonslist.com/gallery/b...p?do=favorites
Username: EMEI KUNG FU

Strange that this doesn't give an error on here, though it should. If you'll look in your forum/includes/functions_gallery.php file for this code:

Code:

Content visible to verified customers only.

And replace it with this:

Code:

Content visible to verified customers only.

Then that should take care of the problem.

I'm guessing its MySQL 4.1.x

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT images.imageid, filename, originalname, thumbname, extension, images.title, images.catid, sticky, open ,images.userid, images.title ,images.username, images.dateline ,filesize, originalfilesize ,width, height, originalwidth, originalheight, images.views, images.posts, votenum, votetotal, categories.title AS cattitle
FROM adv_gallery_images AS images
LEFT JOIN adv_gallery_categories AS categories USING (catid)
WHERE images.imageid IN(27122,17609,13090)
ORDER BY lastpostdateline DESC, imageid DESC

mysql error: Column: 'lastpostdateline' in order clause is ambiguous

mysql error number: 1052

Date: Friday 11th of March 2005 12:12:17 PM
Script: http://www.royouth.com/gallery/brows...&imageuser=497
Referer: http://www.royouth.com/gallery/browseimages.php?c=521
Username: ymeaga1n

I'm having same problem and I've made edit that you said Brian. It's the same no matter where I am coming from.

PHP Version 4.3.10
MySQL 4.0.22-standard

For the record, this just happened in last hour. Only things I changed was:

fixing the vb footer on moderate new option (http://www.vbadvanced.com/forum/show...ghlight=footer)

fixing the sort options(http://www.vbadvanced.com/forum/showthread.php?t=6253)

Brian, I figured out why I was getting the error message. I had also changed the "Default Order" under Browse Category Options in the admincp to Last Post and that's when I started getting that message. I changed it back to date added and it worked fine. You probably already knew that though :) hope it helps.

I can't seem to reproduce the problem. Would you mind submitting a support ticket so I can have a look?