after the update 3.0.0b2, the folowing error shows when previewing the "forumdisplay" pages..
.
.
.
.
.
.
Database error in vBulletin 3.8.7:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND
votenum > 0, votetotal / votenum, 0) AS voteavg,
thread.threadid,
thread.title AS threadtitle, thread.forumid, pollid, open, postusername,
postuserid, thread.iconid AS threadiconid,
thread.dateline, notes,
thread.visible, sticky, votetotal, thread.attach, thread.lastpost,
thread.lastposter, thread.lastpostid, thread.replycount,
IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS
views,
thread.prefixid, thread.taglist, hiddencount,
deletedcount
, user.dbtech_vbshop_purchase
FROM
thread AS thread
WHERE thread.threadid IN
(0,4023,4024,3989,3971,3987,3988,4039,4038,3932,723,3900,3849,3970,3451,3973,3533,3485,3848,3719,985,669)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error :
Unknown column 'user.dbtech_vbshop_purchase' in 'field list'
Error
Number : 1054
Request Date : Sunday, August 5th 2012 @ 04:54:58
AM
Error Date : Sunday, August 5th 2012 @ 04:54:59
AM
Script : http://www.alnebrase.com/forums/f107/
Referrer
:
.
.
.
.
.
.
now we're using the old xml file to avoid the error..
thanks..
.
.
.
.
.
.
Database error in vBulletin 3.8.7:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND
votenum > 0, votetotal / votenum, 0) AS voteavg,
thread.threadid,
thread.title AS threadtitle, thread.forumid, pollid, open, postusername,
postuserid, thread.iconid AS threadiconid,
thread.dateline, notes,
thread.visible, sticky, votetotal, thread.attach, thread.lastpost,
thread.lastposter, thread.lastpostid, thread.replycount,
IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS
views,
thread.prefixid, thread.taglist, hiddencount,
deletedcount
, user.dbtech_vbshop_purchase
FROM
thread AS thread
WHERE thread.threadid IN
(0,4023,4024,3989,3971,3987,3988,4039,4038,3932,723,3900,3849,3970,3451,3973,3533,3485,3848,3719,985,669)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error :
Unknown column 'user.dbtech_vbshop_purchase' in 'field list'
Error
Number : 1054
Request Date : Sunday, August 5th 2012 @ 04:54:58
AM
Error Date : Sunday, August 5th 2012 @ 04:54:59
AM
Script : http://www.alnebrase.com/forums/f107/
Referrer
:
.
.
.
.
.
.
now we're using the old xml file to avoid the error..
thanks..
