SQL error

[DarkDraco07]

u might know i had problems moving my querys but i moved them finally. now when u click a post to open i get 2 error:

Database error in vBulletin 2.2.6:

Invalid SQL:
SELECT username,invisible,userid
FROM user
WHERE inthread=892
AND lastactivity>1030998871
AND lastvisit<>lastactivity

mysql error: Unknown column 'inthread' in 'where clause'

mysql error number: 1054

Date: Monday 02nd of September 2002 02:49:31 PM
Script: http://www.darknemesis.com/forums/fo...p?threadid=892
Referer: http://www.darknemesis.com/forums/fo....php?forumid=3

and

Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE user SET lastactivity=1030999771,inforum='3',inthread='892' WHERE userid='2'
mysql error: Unknown column 'inthread' in 'field list'

mysql error number: 1054

Date: Monday 02nd of September 2002 02:49:32 PM
Script: http://www.darknemesis.com/forums/fo...p?threadid=892
Referer: http://www.darknemesis.com/forums/fo....php?forumid=3

what did i do wrong

[futureal]

The column "inthread" is not part of the default vBulletin user table -- it is added in a hack (I am assuming it is from the "users browsing this thread" hack that vb.org uses).

It looks like you will have to re-do the ALTER query from that hack you installed.

[DarkDraco07]

so um..... what do i do? how do i "re-do" the alter query?

[Issvar]

You find that hack again and run only the mysql query/ies that has to do with inthread. No need to edit files again.

[DarkDraco07]

stupid me.

can someone please help me on this...here is the story...
1. my new forum has a bunch of new hacks installed on it
2. when i transfer my querys, the previous ones disappear
3. i want to know if there is a way i can move info from old forum to new without it editing the tables. i just want the info to go there