Announcement

Collapse
No announcement yet.

SQL errors

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

  • SQL errors

    I installed vBulletin2, imported from UBB Classic and then upgraded to vB3.

    Although all seems well with most of the board's functions, when I try and alter user information in the Admin section I get this SQL error:

    Code:
     
    Database error in vBulletin 3.0.0:
     
    Invalid SQL: UPDATE userfield SET userid = 1720,field1 = '',field2 = 'Guernsey C.I.',field3 = 'football,cricket',field4 = 'storeman',field5 = '',field6 = '' WHERE userid = 1720
     
    mysql error: Unknown column 'field5' in 'field list'
     
    mysql error number: 1054
     
    
    Even though on refreshing the user info, the change seems to have been made.

    I have tried rebuilding the tables, which come back with all ok, but to no avail. Any ideas please?

  • #2
    You could try uploading all the original vbulletin 3.0.0 files again in ascii (you can skip images with this upload) and see if that helps. (Download a new .zip from the member area, unless you aren't running the . gold . version)

    Comment


    • #3
      Nope...

      Database error in vBulletin 3.0.0:

      Invalid SQL: UPDATE userfield SET userid = 1,field1 = '',field2 = '',field3 = '',field4 = '',field5 = '',field6 = '' WHERE userid = 1
      mysql error: Unknown column 'field5' in 'field list'

      mysql error number: 1054

      Date: Thursday 01st of April 2004 12:48:53 PM
      Script: http://bb.blackcountry.com/community...mincp/user.php
      Referer: http://bb.blackcountry.com/community...=edit&userid=1

      Also, one of our users can send but not receive PMs - any thoughts on this?

      Comment


      • #4
        That may have been a problem with the original import script. This field needs to be manually added to the db. Fill out a support ticket at:

        http://www.vbulletin.com/members/mem...ontactform.php

        Be sure to include the login info to your Admin CP and phpMyAdmin.
        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.


        Comment

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