upgrade from 3.8.3 to 4 and having problem

**jskoh** · 06-07-2010 04:01 PM

hi, i have upgrade my forums to 3.8.3 to 4 but it seem that the directing thread could not be found. what should i do? my site

i got this in my email(see attachment)

**Brian Cummiskey** · 06-07-2010 04:30 PM

You have many issues on your site.

You seem to be using vb3 products on a vb4 site. You must disable all vb3 products. They are not compatible.

This includes vbseo. You are using vbseo 3.3 according to your footer. You must upgrade to vbseo 3.5 for vb4 boards. vbseo 3.3.2 and lower are NOT compatible with vb4.

**jskoh** · 06-07-2010 09:51 PM

i have disable all vb3 product except for vbseo. once i disable vbseo. the error start appearring..

**Brian Cummiskey** · 06-07-2010 11:42 PM

The first thing to do is to disable all your products via the product manager.
If you are still having this issue, it is not related to vbseo.

Then, you can install vbseo 3.5 back on to your forum.

**jskoh** · 06-08-2010 04:59 AM

i have disable vbseo. now im having database error...

**Mert Gökçeimam** · 06-08-2010 05:12 AM

What are the details of database error ? You can view page source and copy error details.

**jskoh** · 06-08-2010 05:46 AM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Singapore (SG) Classifieds & Media Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">

</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://sg-classifieds.com/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The Singapore (SG) Classifieds & Media database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">sg-classifieds.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The sg-classifieds.com forum technical staff have been notified of the error, though you may <a href="mailto:contact@sg-classifieds.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount,
user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
FROM thread AS thread
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN (0,1590,1540,1396,1360,1288,647,64,11,77,1660) GROUP BY thread.threadid
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Unknown column 'attachment.thumbnail_filesize' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 8th 2010 @ 02:41:34 AM
Error Date : Tuesday, June 8th 2010 @ 02:41:34 AM
Script : http://sg-classifieds.com/forumdispl...ssifieds-board
Referrer : Singapore (SG) Classifieds & Media
IP Address : 220.255.7.138
Username : admin
Classname : vB_Database
MySQL Version : 5.0.66a-log</textarea></form>

</body>
</html>

some of the forums can be view, but some cant..

**Mert Gökçeimam** · 06-08-2010 10:10 AM

This error is not related to vBSEO . You may need to contact vBulletin or any modification author you are using.

upgrade from 3.8.3 to 4 and having problem

LinkBack

Thread Tools

Display

upgrade from 3.8.3 to 4 and having problem

Similar Threads

vBulletin 3.x problem after upgrade to vb 3.8.5

Url problem before upgrade

Problem! after vBulletin upgrade and Vbseo upgrade

Vbulletin 3.6.2 upgrade and 3.0 rc6 upgrade problem with pingbacks/trackbacks

Posting Permissions