errors caused after adding custom user profile field.....

[Fking]

when i try to add new user profile field it gives me the following error:
----------------------
There seems to have been a slight problem with the xxxxxxxxxxxxxxx! database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff , who you can also contact if the problem persists.


We apologise for any inconvenience.


Database error in vBulletin Control Panel 2.3.0:
Invalid SQL: ALTER TABLE userfield ADD field11 CHAR(250) NOT NULL
mysql error: alter command denied to user: '[email protected]' for table 'userfield'
mysql error number: 1142
Date: Tuesday 16th of March 2004 12:59:26 PM
Script: http://mydomain.com/admin/profilefield.php
Referer: http://www.mydomain.com/admin/profil...hp?action=add&
--------------------------------------------------------

but when i click on modify, the field is there, it's created......ok i left it

but when someone tries to register i get the following error message on my mail
------------
Database error in vBulletin Control Panel 2.3.0:
Invalid SQL: ALTER TABLE userfield ADD field9 CHAR(250) NOT NULL
mysql error: alter command denied to user: '[email protected]' for table 'userfield'
mysql error number: 1142
Date: Tuesday 16th of March 2004 12:29:27 PM
Script: http://mydomain.com/admin/profilefield.php
Referer: http://www.mydomain.com/admin/profil...hp?action=add&
---------------


the user also gets error msg, but the registration is processed, and he is registered......

[Floris]

Hi there, the error implies that you do not have the permissions in MySQL to run the 'ALTER' command to modify your records. You are best of contacting your hosting provider and ask them if they can give you permissions to use the ALTER in MySQL queries. (If he runs version 3.x maybe request to upgrade to 4.x)