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/forums/showthread.php?threadid=892
Referer: http://www.darknemesis.com/forums/forumdisplay.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/forums/showthread.php?threadid=892
Referer: http://www.darknemesis.com/forums/forumdisplay.php?forumid=3
what did i do wrong
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.
so um..... what do i do? how do i "re-do" the alter query?
You find that hack again and run only the mysql query/ies that has to do with inthread. No need to edit files again.
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