andy2295
06-10-2009, 06:48 PM
I have a problem:
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT user.*, entries.entryid, entries.title, entries.catid, entries.userid, entries.username, entries.views, open, entries.valid, entries.dateline, hasattach, votenum, votetotal, entries.iconid, caticon, icon.title as icontitle, icon.iconpath, IF(user.options & 512, 1, 0) AS invisible, entries.posts AS posts, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, customfields.* , NOT ISNULL(subscribeentry.entryid) AS issubscribed, entries.lastpostid, entries.lastpostdateline, entries.lastpostuserid, entries.lastpostusername, NOT ISNULL(favorites.entryid) AS isfavorite, pagetext, pagetext_parsed, hasimages, attachment.attachmentid, attachment.hasthumb, attachment.filename, attachment.dateline AS attachdateline, extension, attachment.userid AS attachuserid
FROM adv_dyna_entries AS entries
LEFT JOIN adv_dyna_categories AS categories ON (entries.catid = categories.catid)
LEFT JOIN icon AS icon ON (entries.iconid = icon.iconid)
LEFT JOIN user AS user ON (entries.userid = user.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN adv_dyna_cfields_entries AS customfields ON (entries.entryid = customfields.eid)
LEFT JOIN adv_dyna_subscribeentry AS subscribeentry ON (entries.entryid = subscribeentry.entryid AND 1 = subscribeentry.userid) LEFT JOIN adv_dyna_favorites AS favorites ON (favorites.entryid = entries.entryid AND favorites.userid = 1) LEFT JOIN adv_dyna_entries_pages AS entries_pages ON (entries.entryid = entries_pages.entryid AND entries_pages.pagenumber = 1) LEFT JOIN adv_dyna_entryparsed AS entryparsed ON (entries.entryid = entryparsed.entryid AND entryparsed.languageid = 0 AND entryparsed.styleid = 2 AND entryparsed.pagenumber = 1)LEFT JOIN adv_dyna_attachments AS attachment ON (entries.attachid = attachment.attachmentid)
WHERE entries.entryid IN(1)
ORDER BY dateline DESC
LIMIT 5;
MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Wednesday, June 10th 2009 @ 06:14:09 PM
Error Date : Wednesday, June 10th 2009 @ 06:14:09 PM
Script : http://www.xxxxxxxxx.com/forum/dynamics/index.php
Referrer : http://www.xxxxxxxxx..com/forum/index.php
IP Address : xxxxxxxxxxxx
Username : admin
Classname : vB_Database
MySQL Version : 5.0.77-community
Any ideas?
Thanks
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT user.*, entries.entryid, entries.title, entries.catid, entries.userid, entries.username, entries.views, open, entries.valid, entries.dateline, hasattach, votenum, votetotal, entries.iconid, caticon, icon.title as icontitle, icon.iconpath, IF(user.options & 512, 1, 0) AS invisible, entries.posts AS posts, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, customfields.* , NOT ISNULL(subscribeentry.entryid) AS issubscribed, entries.lastpostid, entries.lastpostdateline, entries.lastpostuserid, entries.lastpostusername, NOT ISNULL(favorites.entryid) AS isfavorite, pagetext, pagetext_parsed, hasimages, attachment.attachmentid, attachment.hasthumb, attachment.filename, attachment.dateline AS attachdateline, extension, attachment.userid AS attachuserid
FROM adv_dyna_entries AS entries
LEFT JOIN adv_dyna_categories AS categories ON (entries.catid = categories.catid)
LEFT JOIN icon AS icon ON (entries.iconid = icon.iconid)
LEFT JOIN user AS user ON (entries.userid = user.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN adv_dyna_cfields_entries AS customfields ON (entries.entryid = customfields.eid)
LEFT JOIN adv_dyna_subscribeentry AS subscribeentry ON (entries.entryid = subscribeentry.entryid AND 1 = subscribeentry.userid) LEFT JOIN adv_dyna_favorites AS favorites ON (favorites.entryid = entries.entryid AND favorites.userid = 1) LEFT JOIN adv_dyna_entries_pages AS entries_pages ON (entries.entryid = entries_pages.entryid AND entries_pages.pagenumber = 1) LEFT JOIN adv_dyna_entryparsed AS entryparsed ON (entries.entryid = entryparsed.entryid AND entryparsed.languageid = 0 AND entryparsed.styleid = 2 AND entryparsed.pagenumber = 1)LEFT JOIN adv_dyna_attachments AS attachment ON (entries.attachid = attachment.attachmentid)
WHERE entries.entryid IN(1)
ORDER BY dateline DESC
LIMIT 5;
MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Wednesday, June 10th 2009 @ 06:14:09 PM
Error Date : Wednesday, June 10th 2009 @ 06:14:09 PM
Script : http://www.xxxxxxxxx.com/forum/dynamics/index.php
Referrer : http://www.xxxxxxxxx..com/forum/index.php
IP Address : xxxxxxxxxxxx
Username : admin
Classname : vB_Database
MySQL Version : 5.0.77-community
Any ideas?
Thanks