Source Database MySQL help

[Terry2424]

I have the source Database, its example_php1.sql When I go to create a new database it says invalid do not use "_".

My question, do I need just the file or must it be setup on the server as an active database?

thanks

[Steve Machol]

You can create a database with a different name from the backup files. Just choose one without the '_' in it.

[Terry2424]

Re: Source Database MySQL help

Ok, I will set up a new database then do a restore with example_php1.sql. ?

When uploading the files after configuring impexconfig.php I move the upload folder in the same directory as admincp, do I rename this folder ?

This is not stated in the manual.

Thanks very much

[Steve Machol]

No, Impex should not be in the same directory as the Admin CP. It should be in an 'impex' subdirectory off the main forum directory.

[Terry2424]

Re: Source Database MySQL help

Ok "impex" folder in the main directory. The admincp is also in the main directory but I see it could be easy to confuse to put impex into admincp. Someone should update the documentation to be a bit more specific.

The actual impex folder that I will upload will be the "upload" folder renamed to "impex".

The main impex(followed by customer number) does not need to be uploaded.

I will be doing this tonight, just wanted to cover my bases.

Thanks Steve.

[Terry2424]

Ok I get the following error during the first step, the board is PHPBB

Altering tables

ImpEx will now Alter the tables in the vB database to include import id numbers.

This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.
They will also be left after the import if you need to link back to the origional vB userid.


moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
usernote - importusernoteid OK
phrase - importphraseid OK
subscription - importsubscriptionid OK
subscriptionlog - importsubscriptionlogid OK
Testing source against : phpBB1 ::0.0.1


Valid found tables :


Possibly custom tables or incorrect prefix :

Moderator_Action NOT found.
access NOT found.
backup NOT found.
banlist NOT found.
categories NOT found.
config NOT found.
disallow NOT found.
forum_access NOT found.
forum_mods NOT found.
forums NOT found.
free_email NOT found.
headermetafooter NOT found.
ignore_list NOT found.
installdefs NOT found.
lforums NOT found.
markread NOT found.
poll_data NOT found.
poll_topics NOT found.
posts NOT found.
posts_text NOT found.
priv_msgs NOT found.
ranks NOT found.
sessionkeys NOT found.
sessions NOT found.
smiles NOT found.
spellcheck_words NOT found.
subscribe NOT found.
themes NOT found.
topics NOT found.
users NOT found.
visitors NOT found.
whosonline NOT found.
words NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :

phpbb_acl_
Failed Check database permissions and connection, or table prefix to ensure its correct

[Terry2424]

got passed it by adding a prefix "phpbb_"

but now IMPEX is broken my screen is stuck at

ImpEx Database error

mysql error: Invalid SQL:
SELECT * FROM phpbb_categories


mysql error: Table 'sudburydb.phpbb_categories' doesn't exist

mysql error number: 1146

Date: Monday 29th 2010f November 2010 05:35:27 PM
Database: sudburydb
MySQL error: Table 'sudburydb.phpbb_categories' doesn't exist

i cannot return to the list of modules or restart the import

[Steve Machol]

You are missing the 'phpbb_categories' table. Which version of vB are you importing and which import module did you choose?

You can restart the import by using '.../impex/help.php'.

[Terry2424]

the board is phpbb the version is 3.0.1

is that phpbb3?

it doesn't say on the board, it just says phpbb

[Steve Machol]

So you should be using the phpBB3 importer. And according to Impex, you are missing that table.

[Terry2424]

Thanks Steve, yes it worked with phpbb3

The forum section imported, it would be the categories but the Threads and Posts are not there yet impex says they are imported.

The users are there.


I have updated the counters in maintenance>update counters


posts and threads are not in any modification queue either.

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[Terry2424]

Ok figured it out, forum was set to category and not forum, thats why the posts were not showing up

[Steve Machol]

Glad to hear you figured it out.

[Terry2424]

Re: Source Database MySQL help

One last question if you don't mind. All is well on the test site, I thank you very much for your assistance.

I am confused with the second module. Associate users. What exactly is this?


My guess is if both boards have some of the same members then those users can then just be merged into one because it is the same user.

At first I thought the user ID referred to the usergroup.

Thanks.