DB issue after upgrading from 3.5.4 to 3.6.0

[rnmcd]

Here's my error:


Database error in vBulletin 3.6.0:

Invalid SQL:
select title from profilefield where profilefieldid=2;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Sunday, August 13th 2006 @ 11:02:32 AM
Script :
http://www.sitename.com/board/showthread.php?t=7
(http://www.classboards.com/hi/showthread.php?t=7)Referrer : http://www.sitename.com/board/forumdisplay.php?f=16
IP Address : xx.x.xxx.xx
Username : iowa
Classname : vb_database

[Steve Machol]

This error means that you did not upload all the 3.6.0 files. Reupload all the original vB 3.6.0 non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

[rnmcd]

My FTP client said everything in the upload was successful.

Are you sure this doesn't have anything to do with me not reverting all templates yet?

[Steve Machol]

Yes, I'm absolutely sure of this. That's because there is no 'title' field in the vB 3.6.0 'profilefield' table so this query is not coming from vB 3.6.0 code.

[rnmcd]

Maybe my FTP client didn't tranfer the file types correctly. I had it set to AUTO. I will change it to ASCII as you suggested.

How do I find all the files that are NON-image files? Do I need to go folder-to-folder to look at all the file type?:eek:

[Steve Machol]

Don't upload the images directory.

[rnmcd]

But what the images that are in other directories such as admincp\control_examples ?

Will I need to run the install script again?

[rnmcd]

I re-uploaded all non-image files via ASCII then I ran the install program.

I am still getting the same database error.

Any other suggestions?

[Steve Machol]

Nope. This is still a file issue. Run 'Suspect File Version' in Diagnostics and report back the results.

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

Do any show as 'File does not contain expected contents'. If so, you need to reupload the original vB non-image files. Make sure you upload these in ASCII format and overwrite the ones on the server.


If you still have a problem after this, then disable your plugins. To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[rnmcd]

I ended up uploading a backup to my forum so I could be up and running still.

What I would like to try is copying my existing forum to a different directory on the same website and do the upgrade, testing, and diagnostics from that 'test' directory.

How would I go about copying all the needed files/database to a new directory on the same site?

By the way, I upgraded my other licenses vbulletin site from 3.5.4 to 3.6.0 and it went fine. It didn't have any plugins though.

[rnmcd]

bump

[Steve Machol]

You need instructions on copying files? :confused: I don't understand.

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

[rnmcd]

What I meant to say was, will copying all of my files and folders in my renamed upload folder to another folder will suffice for copying my forum. I wasn't sure how well that would work since I am not running the install program for the new directory.

What would I have to tell my host in order for them to properly copy over my database files? Do I just tell them my existing database name and tell them to copy it to....where?

[Steve Machol]

You have to copy the files and backup and restore the database to a new database if you want to test with a copy of your existing db.

[rnmcd]

Nope. This is still a file issue. Run 'Suspect File Version' in Diagnostics and report back the results.

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

Do any show as 'File does not contain expected contents'. If so, you need to reupload the original vB non-image files. Make sure you upload these in ASCII format and overwrite the ones on the server.



I ran the Suspect File Versions and about 60 files were tagged as 'File does not contain expected contents.'

Coincidentally I noticed that the files were in directories that I renamed in config.php. The directories with the 'File does not contain expected contents' are:

./admincpl5
./modcp2 Any idea why the files didn't get copied properly to these directories?

[Steve Machol]

Reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp and modcp files to whichever directories you have set in your config.php file.

[rnmcd]

If decided to rename my admincpl5 and modcp2 directories to their default names and then delete those directories.

I ran the Suspect File Versions and this time did not have any that were flagged.

But I am still getting the
Database error in vBulletin 3.6.0:

Invalid SQL:
select title from profilefield where profilefieldid=5;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Saturday, August 19th 2006 @ 11:47:29 AM
Script :
http://www.site.com/test_hi/showthread.php?t=8
(http://www.classboards.com/test_hi/showthread.php?t=8)Referrer :
http://www.site.com/test_hi/forumdisplay.php?f=14
IP Address : 69.5.148.47
Username : iowdfaa
Classname : vb_database
Would this error have anything to do with this note on my Admin Panel Home:


After upgrading to vBulletin 3.6, you must rebuild thread information and then forum information on this page (http://www.vbulletin.com/forum/misc.php?do=chooser).

Click "Address" to rebuild thread information now. Once this has completed, you should still rebuild forum information! As of vBulletin 3.6.0 RC1
The Allow Signatures option has been removed. If you had this option disabled, you should use signature permissions to deny signatures for specific usergroups.
Apple™ has updated the iTunes podcast categories. We have followed suit and updated the categories within vBulletin. You will need to edit any podcasting forums and update to the proper category


Out-of-Date Custom Templates Found! There are currently 7 customized template(s) that need to be updated or reverted. Some sections of vBulletin may not function if you do not do this!

[Steve Machol]

See post #2. This is the same problem with the same fix. You need to reupload the original vB files. You may also need to disable your plugins.

[rnmcd]

I had already reuploaded the files several times so I disabled the plugins and everything now works fine.