Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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......
    Arcade Games - Some free fun for the free time!

  • #2
    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)

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X