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:

Install vBull 3.6.8
build new Style
install step by step every mods i had installed on my old board
importing users, forums, settings... everything but attachment tables.When I try to access to my forum home: www.el-apeadero.net/index.php (http://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 1197080058 at 1197080058 ---------------

finally i could fix this error :) Thnks anyway :D

[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.