Template questions...

[FleaBag]

/me cries for help in desperation.

[FleaBag]

Phew, disaster averted! I dropped the style, template, templateid, replacement and replacementid tables from my database, then did a dump of the same tables from a fresh install on vB. I then applied this dump to my database, and it seems to have fixed all my problems.

[high]* GamerForums wipes the sweat from his brow.[/high]

[Velocd]

Nice avatar

[FleaBag]

Thanks LOL. Can't remember where I got it from. Anyway, I can't view showthread.php now, I get database errors. It seems for some reason rather than stating the path as root/forums it's stating it as root/forums/forums... Here's the error. Anyone able to help please?

Database error in vBulletin 2.2.6:

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

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

mysql error number: 1054

Date: Thursday 20th of June 2002 11:34:04 PM
Script: http://www.gamerforums.com/forums/fo...8136#post38136
Referer: http://www.gamerforums.com/forums/

...and under that...

Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE user SET lastactivity=1024612444,inforum='24',inthread='762 ' WHERE userid='166'
mysql error: Unknown column 'inthread' in 'field list'

mysql error number: 1054

Date: Thursday 20th of June 2002 11:34:04 PM
Script: http://www.gamerforums.com/forums/fo...8136#post38136
Referer: http://www.gamerforums.com/forums/

[FleaBag]

Nevermind, looks like it was a hack causing the trouble. A LOT of problems to sort out here.

[Admin]

It's the "Users browsing this thread" hack, for some reason you dropped the inthread field from the user table.

[FleaBag]

Ah I see, thanks FireFly. Should have everything back up by the end of tonight, hopefully with at least 50 hacks and a new design.