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

[jbart04]

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???

[Lynne]

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.

[jbart04]

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.

[Trevor Hannant]

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...