Announcement

Collapse
No announcement yet.

MySQL Error : Unknown column 'converted' in 'where clause'

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

  • [Suite] MySQL Error : Unknown column 'converted' in 'where clause'

    Code:
    Database error in vBulletin 3.8.2:
    
    Invalid SQL:
    
                            UPDATE usercss
                            SET
                                value = '2,2611]',
                                converted = 1
                            WHERE
                                property = 'background_image'
                                    AND
                                value = '2,35700'
                                    AND
                                userid = 35700
                                    AND
                                converted = 0;
    
    MySQL Error   : Unknown column 'converted' in 'where clause'
    Error Number  : 1054
    Request Date  : Tuesday, February 16th 2010 @ 10:32:18 PM
    Error Date    : Tuesday, February 16th 2010 @ 10:32:18 PM
    Script        : http://www.xxxxxxx.com/convert/install/upgrade_400a1.php?step=9
    Referrer      : http://www.xxxxxxx.com/convert/install/upgrade_400a1.php?step=9
    IP Address    : xxxxxxxx
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.0.89-community-log
    That's the error. Apparently I didn't have the usercss table. So I already had a test board with 4.0 on it so I could have a skin ready when I upgraded...so I just copied over the table and I still get this error. What is wrong???


  • #2
    According to your error, your database is a 3.8.2 database, yet you say you are running on 4.0? You need to run the upgrade.php script in order to upgrade your database to run with the vB4 files.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      You misread. I'm running a test conversion. I already had another test board running 4.0 so I could have my designer/coder create a new skin before I actually do the upgrade on my live site. So with this error you see, I'm trying to do a test conversion on a copy of my live sites db that was running 3.8.2. I've updated the live site to 3.8.4pl2 to see if it created the usercss, but it didn't.

      I hope that makes more sense for you.

      Comment


      • #4
        Try reuploading the vB4 files again and rerun that step - the column should be added earlier in the process so sounds like something hasn't gone right before then...
        Vote for:

        - *Admin Settable Paid Subscription Reminder Timeframe*
        -
        *PM - Add ability to reply to originator only*
        - Add Admin ability to auto-subscribe users to specific channel(s)
        - Highlight the correct navigation tab when you are on a custom page
        - "Quick Route" Interface...
        - Allow to use custom icons for individual forums

        Comment

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