Problem mysql error: Unknown column 'product' in 'where clause'

[mlee]

Hi,
I'm using Vbulletin 3.7.2.
I'm getting the following error when trying to do an import:



ImpEx Database errormysql error: Invalid SQL:
SELECT fieldname, vbmandatory, defaultvalue, dictionary
FROM vbfields
WHERE tablename = 'usergroup'
AND product='vbulletin'
ORDER BY vbmandatory


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

mysql error number: 1054

Date: Thursday 07th 2008f August 2008 11:55:06 AM
Database: db219539753
MySQL error:



I checked the target database table vbfields and there is really no column
"product".

What is wrong here?
Why is this field missing in my vbulletin installation? Maybe it was missing in any update scripts?

Please help, i need to get the new board up asap!

Thank ou and regards
mlee

[mlee]

Forgot to mention
ImpEx build version : 1.90

[Steve Machol]

Clear out the import data and session, and drop the vbfields table. Then try again.

[mlee]

Hi, okay just for the record if anyone else has the same problem.

I deleted all as you sayed and after creation i had the same problem.

I then created the table manually with the query i got from the impex file, and restarted the import all worked fine, this way.

I guess he had some problems with writing temporary sql data to the tmp dir under windows.

Regards mlee

[staticrebelle]

I believe this may be a bug. I just had the exact same issues apply to my Linux system (vBullterin 3.7.4 to vBulletin 3.7.4 import, ImpEx 1.92, CentOS 5.2).

I had to manually delete vbfields, clear the session, and manually recreate vbfields. Everything is now working perfectly.