No announcement yet.

Error 1054

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error 1054

    Hi all,

    suddenly using vBulletin 2.3.4 when try to update an existing user it gives me following error:

    Database error in vBulletin Control Panel 2.3.4:

    Invalid SQL: UPDATE userfield SET userid=13329,field5='',field6='',field1='',field2='Bichon Underground',field3='',field4='Legend of Mir' WHERE userid=13329

    mysql error: Unknown column 'field5' in 'field list'

    mysql error number: 1054

    The problem is that table USERFIELD has field1,2,3,4

    field 5,6 not existing.

    PHP code does not make any insert in field 5 or 6

    Please help

    Tks in advance.

    Now it's giving me :
    Database error in vBulletin :
    Link-ID == false, connect failed
    mysql error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    mysql error number: 1251
    Date: Thursday 16th of December 2004 03:39:26 PM
    Script: /index.php
    and it is not connecting anymore

    Last edited by guybrush; Thu 16th Dec '04, 5:20am.
    Guybrush Threepwood

  • #2
    Something happened to your database. Do you have more that four profile fields in the Admin CP? Have you installede any hacks or modified any code?

    As for the 'false' error, this means that either the info in your config.php file is wrong (in which case your forums w
    ouldn't work at all) or there is a problem with the MySQL server. If you are sure that the db info is correct then you need to contact your host.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.