vb.org Archive - Upgrading 'manually'

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Upgrading 'manually' (https://vborg.vbsupport.ru/showthread.php?t=179325)

Arkidas

05-15-2008 12:01 PM

Upgrading 'manually'

My database is not very healthy and as I tried to upgrade 'automatically' ( like in the vBulletin ReadMe ) I got many SQL errors during upgrade and after the upgrade the forum isn't stable.

I made a backup before upgrading so I'm all safe, but I think it may be a better idea to set up a fresh 3.7 forum and them import the important tables back like posts, users etc.

What I need is a list of important tables, can you give me one?

snakes1100

05-15-2008 12:18 PM

Why dont you post the database error you got and the current issues your having, that way we can help you fix the current issues.

If you want to setup a new forum/db, then use Impex provided by vb.com and just let it handle the import of all important info to the new forum for you.

Arkidas

05-15-2008 12:27 PM

Can you explain how to do this with ImpEx?

This was the first error I got:

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

ALTER  TABLE  userlist ADD friend ENUM('yes', 'no', 'pending', 'denied') NOT NULL DEFAULT 'no';



MySQL Error   : Table 'blizzard_vbulletin.userlist' doesn't exist

Error Number  : 1146

Marco van Herwaarden

05-15-2008 12:58 PM

I don't suggest using ImpEx for this.

Please:
- Restore your backup
- Start the upgrade process again, and stop on the first error!
- post the error you get.

Arkidas

05-15-2008 01:36 PM

Ok. The back up stands of over hundred .SQL files, one for each table. What is the easiest way to restore the backup? I tried zipping the SQL files together and then uploading the ZIP file but that resulted in only the adminlog table being restored.

All times are GMT. The time now is 10:29 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00914 seconds Memory Usage 1,711KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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: