Key 'lastactivity' doesn't exist in table 'user'

[Roonie]

Hi to all, i am importing my SQL database to my new hosting and i have done this way:

1. Install vBull 3.6.8
2. build new Style
3. install step by step every mods i had installed on my old board
4. importing users, forums, settings... everything but attachment tables.

When I try to access to my forum home: www.el-apeadero.net/index.php i get this:

Database error in vBulletin 3.6.8:
Invalid SQL:
   SELECT * FROM user FORCE INDEX (lastactivity)
   WHERE lastactivity > 1196969004 ORDER BY username;
MySQL Error  : Key 'lastactivity' doesn't exist in table 'user'
Error Number : 1176
Date         : Friday, December 7th 2007 @ 07:23:24 PM
Script       : http://www.el-apeadero.net/index.php
Referrer     : http://www.el-apeadero.net/naranjones/index.php
IP Address   : 85.136.148.9
Username     : Roonie
Classname    : vb_database

In the past have already solved some basic SQL errors, but dont know how to deal with this one.

Thnks

--------------- Added [DATE]1197080058[/DATE] at [TIME]1197080058[/TIME] ---------------

finally i could fix this error Thnks anyway

[Marco van Herwaarden]

This is a sure recipy for disaster...

You should never install vBulletin and then restore individual tables (and probably from a different vB version). I strongly suggest you reconsider starting again and then simply upgrade the old database.