[cosmin]

I get the following error message when I set the default sort order to Last Post in the admincp. How do I go about fixing this? Because Dated Added is making a lot of our members unhappy.

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

PHP Version 4.3.10
MySQL 4.0.22-standard