vb.org Archive - Upgrade 3.8 to 4

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - Upgrade 3.8 to 4 (https://vborg.vbsupport.ru/showthread.php?t=248067)

BlueRad

08-05-2010 08:36 PM

Upgrade 3.8 to 4

I'm upgrading from 3.8.6 to 4.0.5 and running into errors.

First was a table called contenttype which didn't exist but claimed it did when I tried to make it.
I got that fixed with a simple drop and create.

Now I've hit a problem I'm not sure how to solve.

Step 6) Attachment System Alterations (3/5)
Database Error

Code:

Database error in vBulletin 3.8.6:



Invalid SQL:



                        SELECT attachmentid, postid, userid, dateline, visible, counter, filename

                        FROM filedata

                        WHERE attachmentid > 0

                        ORDER BY attachmentid ASC

                        LIMIT 0, 100;



MySQL Error   : Unknown column 'postid' in 'field list'

Error Number  : 1054

Request Date  : Thursday, August 5th 2010 @ 03:05:51 PM

Error Date    : Thursday, August 5th 2010 @ 03:05:51 PM

Script        : http://blu-ops.com/forum/install/upgrade_400a1.php?step=6

Referrer      : http://blu-ops.com/forum/install/upgrade_400a1.php?step=5

IP Address    : 76.66.24.205

Username      : 

Classname     : vB_Database

MySQL Version : 5.0.91-community

Anyone got a quick fix?

Lynne

08-05-2010 10:00 PM

Notice the top of the database error:

Code:

Database error in vBulletin 3.8.6:

It still thinks you are running 3.8.6 like it was never upgraded to 4.0.5. Did you run the upgrade script finally to completion? The database error where it talks about the postid column is an old pre-4.x column which was dropped in 4.0. So, if your files are 4.x files, then that error is caused by a modification.

Videx

08-05-2010 10:42 PM

None of your old mods will work in vb4, so remove those before you try to upgrade if you really want to avoid trouble. I don't mean just hit the 'uninstall' button. I mean read the install instructions and remove any files you uploaded and edits you made.

BlueRad

08-05-2010 10:59 PM

Quote:

Originally Posted by Lynne (Post 2079824)

Notice the top of the database error:

Code:

Database error in vBulletin 3.8.6:

I'm mid upgrade right now, that occurred on step 6.

I'll try the uninstall now.

All times are GMT. The time now is 03:19 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01923 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: