Announcement

Collapse
No announcement yet.

MYSQL Error When Saving A Users Profile In The AdminCP

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

  • DanBratt
    replied
    Thank You! Worked!

    Leave a comment:


  • Jake Bunce
    replied
    This query will add the missing field:

    ALTER TABLE userfield ADD field50 MEDIUMTEXT

    The userfield table stores the values for profile fields. Somehow you lost the field for field50.

    Leave a comment:


  • DanBratt
    started a topic MYSQL Error When Saving A Users Profile In The AdminCP

    MYSQL Error When Saving A Users Profile In The AdminCP

    Database error in vBulletin 3.6.5:
    Invalid SQL:
    UPDATE userfield SET
    field68 = '',
    field2 = 'Dover, DE',
    field5 = '',
    field69 = '',
    field3 = 'Mudding and Speeding',
    field4 = 'Law Enforcement',
    field6 = '',
    field50 = ''
    WHERE userid = 761;
    MySQL Error : Unknown column 'field50' in 'field list'
    Error Number : 1054
    Date : Monday, December 31st 2007 @ 03:04:22 PM
    Script : http://www.virtualdodge.com/vdforum/....php?do=update
    Referrer : http://www.virtualdodge.com/vdforum/...?do=edit&u=761
    IP Address : 76.64.211.191
    Username : Bullet
    Classname : vb_database

    Seems to be an unknown field in the field list "field50"

    Is there somewhere in the templates I need to delete this coding so it doesn't effect anything?

    Anything you can do would be GREAT!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X