vBulletin Database Error

[mehbara]

Hello

I have this Error when i try to upgade 3.5.4 to 3.6.0

>>>
Database error in vBulletin 3.6.0 Beta 3:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1155600003
ORDER BY username ASC;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Monday, August 14th 2006 @ 06:15:03 PM
Script : http://www. .com/vb/index.php
Referrer :
IP Address :
Username :
Classname : vb_database


please help me

[Steve Machol]

This means you missed one or more upgrade steps. Try running this query:

ALTER TABLE user ADD infractiongroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0';

[mehbara]

Other Error

Database error in vBulletin 3.6.0 Beta 3:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires

FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.threadid IN (0,1400,1427,1469,1146,1335,1169,1324,1165,1315,12 86,1287,1233,1191,1161,1160)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table 'mehbarac_vb1.threadredirect' doesn't exist
Error Number : 1146
Date : Tuesday, August 15th 2006 @ 06:16:03 AM
Script : http://www.mehbara.com/vbnew/forumdisplay.php?f=27
Referrer : http://www.mehbara.com/vbnew/index.php
IP Address :
Username :
Classname : vb_database

[Steve Machol]

You didn't upgrade:

Database error in vBulletin 3.6.0 Beta 3

[mehbara]

Hello I do it a gain and every thig good but Now this Error

Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT points, infraction.*, thread.title, thread.forumid, thread.postuserid, user.username,
thread.visible AS thread_visible, post.visible, thread.postuserid, IF(ISNULL(post.postid) AND infraction.postid != 0, 1, 0) AS postdeleted
FROM infraction AS infraction
LEFT JOIN post AS post ON (infraction.postid = post.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN user AS user ON (infraction.whoadded = user.userid)
WHERE infraction.userid = 1
ORDER BY infraction.dateline DESC
LIMIT 5;
MySQL Error : Column 'points' in field list is ambiguous
Error Number : 1052
Date : Tuesday, August 15th 2006 @ 12:51:40 PM
Script : http://www.mehbara.com/vb/usercp.php
Referrer :
IP Address :
Username :
Classname : vb_database

[Steve Machol]

Something's wrong with the database, possibly from a previous hack you had installed. Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

[mehbara]

hello

he said the rong from the hacks.... like what you said

but

I used this query..... maybe this is the rong ?

CREATE TABLE threadredirect(
threadid INT UNSIGNED NOT NULL default '0',
expires INT UNSIGNED NOT NULL default '0',
PRIMARY KEY ( threadid ) ,
KEY expires( expires )
);


is that the rong or something else

note:- I used this query from another topic