vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB5 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=263)
-   -   Importing db v5.0.85-community-nt to db v5.6.24-log (https://vborg.vbsupport.ru/showthread.php?t=318443)

NumNum 04-27-2015 11:57 AM

Importing db v5.0.85-community-nt to db v5.6.24-log
 
I have been trying to import my old db on a windows 2000 server to a windows 2012r2 and am getting the following error using impexe.

PHP Code:

ImpEx Database error

mysql error
Invalid SQL
            
ALTER TABLE `user`
            
ADD INDEX `importuser_index` ( `importuserid` )
            

mysql errorKey column 'importuserid' doesn't exist in table

mysql error number: 1072

Date: Friday 24th 2015f April 2015 05:34:05 PM
Database: vbulletin
MySQL error: 

Looking for any help on this.

ForceHSS 04-27-2015 12:12 PM

You need to add the missing column to the user table as it needs to add the missing index importuser_index

NumNum 04-27-2015 12:29 PM

I can do this manually?

ForceHSS 04-27-2015 01:01 PM

Yes if you can find the sql query you have part of it above but just need the one for putting the column in place first

NumNum 04-28-2015 06:55 PM

There has got to be an easier way than doing this manually.

ForceHSS 04-28-2015 07:11 PM

If you can't do a few queries you could hire someone. If I had vb5 I would give you the queries or a copy of vb5 I would put up a test server and get you the queries

NumNum 04-28-2015 07:17 PM

I'm using 3.8.8, eventual 5.1.6

moving 3.8.8 to a whole new server so i can eventually run 5.

ForceHSS 04-28-2015 07:18 PM

If you are using vb3 why post in vb5? Before you make the mistake and install vb5 don't far to many problems with it give them time to fix them if you really want to upgrade install vb4.2.3 beta. So the column above is that from a custom mod?

NumNum 04-28-2015 07:26 PM

It should be in 3 and not in 5, I can't move it.

I have no custom mods.

ForceHSS 04-28-2015 07:35 PM

So the old db you where trying was it 3.8.8 PL1 and your site is the same?


All times are GMT. The time now is 05:32 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03027 seconds
  • Memory Usage 1,725KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete