JimmyFMG
21.01.2004, 22:29
Ich wollte ein Portal einbauen. Hat auch soweit geklappt. Nur wenn ich meine ID eingebe vom News Forum erscheint im Portal folgendes. Weiß jemand was ich da machen kann ?
Database error in vBulletin 3.0.0 Release Candidate 3:
Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline
,thread.iconid
,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM vb3_thread AS thread
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_user AS user ON (user.userid = post.userid)
LEFT JOIN vb3_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb3_attachment AS attachment ON (post.postid = attachment.postid)
WHERE forumid IN(77)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous
mysql error number: 1052
Date: Wednesday 21st of January 2004 10:27:10 PM
Script: http://www.fmgate.de/vbulletin/adv_index.php
Referer:
Username: Jimmy
IP Address: xxxxx
Database error in vBulletin 3.0.0 Release Candidate 3:
Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline
,thread.iconid
,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM vb3_thread AS thread
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_user AS user ON (user.userid = post.userid)
LEFT JOIN vb3_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb3_attachment AS attachment ON (post.postid = attachment.postid)
WHERE forumid IN(77)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous
mysql error number: 1052
Date: Wednesday 21st of January 2004 10:27:10 PM
Script: http://www.fmgate.de/vbulletin/adv_index.php
Referer:
Username: Jimmy
IP Address: xxxxx