thread errors

[afriman]

Hi Guys,

I have a problem after updating from 3.5 to 3.6, yip you guessed it - my threadS have gone.

See this link - click on the any of the threads!! AND A ERROR MESSAGE COMES UP

Any ideas anybody - please
James

[Cool Matty]

It would help greatly if you could post the database error that results from clicking on the threads. (It should be sent to you via email.)

[afriman]

the db error is as follows::::::

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)

WHERE post.postid IN (0,131)
ORDER BY post.dateline;

MySQL Error : Table '****DBNAME****.post_parsed' doesn't exist Error Number : 1146
Date : Friday, September 1st 2006 @ 04:01:46 PM
Script : http://www.africatravelforum.com/showthread.php?p=131
Referrer :
IP Address : 72.30.133.218
Username : Unregistered
Classname : vb_database

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::


This error message is pretty much the same other than the "Script & Referer" tags

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

[afriman]

Thread

Thanks steve, will do.

Smartftp sometimes does miss a file or two (will do manual this time)

[afriman]

All working

Thanks Steve,

Once again you have saved my butt,

Reuploaded all files again (file by file so as not to miss anything) and it all works perfectly.

just one last question, in my admin cp I get this message:::

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

The Allow Signatures option has been removed. If you had this option disabled, you should use signature permissions to deny signatures for specific usergroups.

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Where do I go to get this changed??

Thanks again

[shanthp]

I'm getting this same error. I tried to upgrade to 3.6 but i got the error about mySQL being the wrong version. I tried to reupload 3.5.5 and install that, but I'm still getting the error. What do I do?

[Marco van Herwaarden]

Signature permissions are now stored per usergroup instead of a vBulletin Option.

You can find them now by editing your usergroups.

[shanthp]

When I say I'm getting the same error, I mean the original one he posted. Can someone give me some guidance on getting back to 3.5 after not being able to upgrade to 3.6?

[Marco van Herwaarden]

If you are getting the original error even after re-uploading all vBulletin files, then this is caused by a modification that still uses the old tablename.

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[shanthp]

When you say to reupload all the vBulletin files, does that mean I delete all the 3.6 files I uploaded first and then reupload the 3.5.5 files?

[Marco van Herwaarden]

No i mean that you should upload all the 3.6 files again.

[shanthp]

But my server can't run the 3.6 upgrade because they are running a mySQL ver 3.xxx? What should I do?

[Marco van Herwaarden]

Sorry i missed that part.

In that case upload your old version again and then run the following query:

RENAME TABLE postparsed TO post_parsed;

[shanthp]

Thank you very much. That fixed the problem.