PDA

View Full Version : mySQL error after upgrading from 3.5.4. to 3.6.0



completec
Thu 17th Aug '06, 10:37pm
The whole installation went smooth. I reverted all the templates to make sure everything works with 3.6.0.

I'm able to browse the forum and everything seems to work so far, except for when I go to view any of the thread, I get this mySQL error.

Database error in vBulletin 3.6.0:

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

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Thursday, August 17th 2006 @ 06:34:48 PM
Script : http://www.martial-forums.com/forums/showthread.php?t=389
Referrer : http://www.martial-forums.com/
IP Address : 67.113.109.220
Username : complete
Classname : vb_database

What do I need to do?

Steve Machol
Fri 18th Aug '06, 2:15am
There is no 'title' field in the 3.6.0 'profilefield' table. 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.

completec
Fri 18th Aug '06, 3:12am
I checked again and uploaded all new 3.6.0 files, ran the upgrade again. But I still get the exact same error.

Is there a particular file I should look at?

The error only occurs in showthread.php and the file is dated today.

Steve Machol
Fri 18th Aug '06, 3:14am
Showthread.php definitely. But I would be more worried about your FTP client not overwriting existing files.

completec
Fri 18th Aug '06, 3:17am
I just found something else interesting.

Certain threads are readable (ones with no other reply) and I'm guessing it might be something to do with the User Profile Field. I had put some hack into it and added few custom profile field display on the thread itself.

So, some threads without anybody's custom field might be displaying OK but maybe an offending person's thread is not being displayed.

I uninstalled the module and now it's working.