Database error in vBulletin 3.6.8:

[Omeka]

Hello

This error has been taken place after to have upgrade vBulletin from the versione 2.3.6 to the 3.6.8.

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE userfield SET
field1 = '',
field2 = 'Roma',
field3 = '',
field4 = ''
WHERE userid = 6328;

MySQL Error : Unknown column 'field1' in 'field list'
Error Number : 1054
Date : Saturday, December 8th 2007 @ 12:30:10 PM
Script : http://www.m4d.it/forum/admincp/user.php?do=update
Referrer : http://www.m4d.it/forum/admincp/user.php?do=edit&u=6328
IP Address : **********
Username : *********
Classname : vB_Database

[Steve Machol]

You have somehow deleted one of the default vB fields. You need to manually add a new field named 'field1' to the userfield table in the database.

[Omeka]

GIve me an example....thanks.

[Steve Machol]

Create a new field in the userfield table named 'field1' with the same properties as the other fields in that table.

[Omeka]

Hi Steve

view screenshot,thanks.

[Steve Machol]

I can't tell what you did from that screenshot. Please explain.

[Omeka]

Hello Steve.

I have sended the query as you have said to me and it has given back an error to me, sees the screenshot.

[Steve Machol]

I didn't give you a query. What did you do exactly?

[Omeka]

From the database I have sended following query:

' field1' mediumtext NOT NULL,

Hello

[Steve Machol]

That is not a full query. This is:

UPDATE userfield ADD field1 mediumtext NOT NULL

[Omeka]

Hello Steve

Thanks to your suggestion are successful to resolve the problem.