| ForgotenDynasty |
09-14-2008 01:24 AM |
Huge problem :(
I have no idea when this happened but one of my members just pointed it out to me
http://www.ultimate-ipod.com/forums/...hp?searchid=40
my when ever someone searches it gives them that Database error
So after i noticed that my first instinct was that i would upgrade to 3.7.3 because then all my files would be replaced (i thought it was a file issue) now the upgrade went smoothly.
So im now running 3.7.3 and i still get the same problem :(
i have also noticed that all my custom user profile fields have gone missing in the ACP but i can still set them in my UCP
edit heres the error i get
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,
replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.lastpost, thread.lastposter, thread.lastpostid
,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
FROM vb_thread AS thread
LEFT JOIN vb_user AS user ON(user.userid = thread.postuserid)
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb_subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb_attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png')) LEFT JOIN vb_attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(56, 69, 53);
MySQL Error : Not unique table/alias: 'attachment'
Error Number : 1066
Request Date : Saturday, September 13th 2008 @ 10:24:53 PM
Error Date : Saturday, September 13th 2008 @ 10:24:53 PM
Script : http://www.ultimate-ipod.com/forums/search.php?searchid=40
Referrer : https://vborg.vbsupport.ru/showthread.php?p=1621623
IP Address : **My ip**
Username : Forgoten Dynasty
Classname : vB_Database
MySQL Version : 5.0.51a-community
|
More Information