username database error

[stunod]

I have exported and then imported the all of the user sql tables in the database backup on my old "3.8.5" forum into my new "4.0.3" forum. After I uploaded the user sql tables into the database it said it was successful in doing so.

When I look at the new "4.0.3" forum the users are there but when I click on any of them I get a database error page showing. Can someone tell me what I did wrong or how to fix it? That would be great!!!

Here is the error message in the database error page that is showing;

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT COUNT(*) AS files FROM stunodracing_dl2_files WHERE uploaderid = 1 AND modqueue = 0;

MySQL Error   : Unknown column 'modqueue' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, April 15th 2010 @ 10:22:27 PM
Error Date    : Thursday, April 15th 2010 @ 10:22:27 PM
Script        : http://stunodracingdesignteam.com/member.php?1-Stunod
Referrer      : http://stunodracingdesignteam.com/forum.php
IP Address    : xxx.xx.xxx.xxx
Username      : Stunod
Classname     : vB_Database
MySQL Version : 5.0.86-log

Thanks for your time,
Adam

Oh yeah, I have ran both the "repair / optimize tables" and the "update counters" as well and still shows the same error.

[Lynne]

That isn't a default vbulletin table. But basically, it's missing the modqueue field in the table. You'll have to find the modification information in order to find the properties for that field and then add it.

[stunod]

ok thanks for the info, but where would I find the modification information for the modqueue field to put back into the database?

Or

How much would it cost me for someone else to get the usernames and the forum threads up and running. I need help, I am still new to database working and have a very little grasp on what I am doing. I am trying to export and import from old to new a bunch of stuff but just really need users, threads and downloads!

Let me know how much you "anyone that knows how" are willing to set this up for me!
Post or PM

Thanks,
Adam

[metalguy639]

This may seem like a really stupid question but why did you export the database and then import it back? Why not just run the vb upgrade script on your old 3.8 forum?

[Lynne]

If you want to pay someone to do this for you, please post in Requests For Paid Services. Read the notices at the top of the forum first.