Problems Importing from PHPBB

[rex_b]

Ok this is what I did...


Uploaded at VB files
Uploaded all Impex files

When to acp and did import/export

did button number 1

did button number 2

got this error

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/rexb2/public_html/forum/impex/db_mysql.php on line 220

tried to go back to import/export screen it was blank

reinstalled impex files in ascII and double checked config file

ran the delete impex thinging in the mysql

still have blank page.


What do I do?

[Steve Machol]

The first error was because you did not have the correct info in your Impex config script. The blank page was because the script had already been run once. You need to make sure you have the correct database info for both the target and source databases.

Once you've corrected this, run this query:

DELETE FROM datastore WHERE title='ImpExSession';

Then try the import again.

[rex_b]

Still no luck:

redid config here:



targetdatabasetype = mysql4
targetserver = localhost
targetuser = ***
targetpassword = ***
targetdatabase = rexb2_vb
targettableprefix = vb3
[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE
sourceexists = false
sourcedatabasetype = mysql4
sourceserver = localhost
sourceuser = ***
sourcepassword = ***
sourcedatabase = rexb2_parkweb
sourcetableprefix = phpbb_



ran that query got this:


MySQL said:


#1146 - Table 'rexb2_vb.datastore' doesn't exist





Still have blank page and nothing is imported.

[flanker]

You might want to try setting sourceexists to "true" ;)

[rex_b]

You might want to try setting sourceexists to "true" ;)

did that but I have still have a blank screen in the admin panel :(

[Steve Machol]

Once again, run this query:

DELETE FROM datastore WHERE title='ImpExSession';

Then try the import again.

[Zachery]

Run this again


DELETE FROM datastore WHERE title='ImpExSession';

[rex_b]

I said I already did that a million times and get this error:

MySQL said:


#1146 - Table 'rexb2_vb.datastore' doesn't exist

[Zachery]

DELETE FROM vb3_datastore WHERE title='ImpExSession';

Need to hcange it for your custom table prefix.

[rex_b]

DELETE FROM vb3_datastore WHERE title='ImpExSession';

Need to hcange it for your custom table prefix.

ok I figured out how to get that to work but I can't get the config right.. ugh

[rex_b]

Now I get this crap:

phpbb_admin_nav_module NOT found or a non standard table.
phpbb_album NOT found or a non standard table.
phpbb_album_cat NOT found or a non standard table.
phpbb_album_comment NOT found or a non standard table.
phpbb_album_config NOT found or a non standard table.
phpbb_album_rate NOT found or a non standard table

etc. etc. etc.


but some work and it shows 14 imported and 0 failed on the import/export screen is that ok?

[Zachery]

Things that say non standard table can be ingored, Its just data that impex didnt expect to get.

[rex_b]

good good. everythings seems to be going ok now, but i am just doing this so my mods can test out the system.. when I want to redo everything to go live to I need to clean the db and start the import over or just import over the other imported stuff?

[Zachery]

When your ready to go live, id do a fresh install and reimport :)

[rex_b]

When your ready to go live, id do a fresh install and reimport :)

well now I have run across another problem, after doing the import posts it did that screen for awhile and then went to a blank white page with just an hour glass and eventually went to can't find page.

So I go to click on import/export again and that page never comes up, so I tried to click on the forum homepage and that page never comes either..


:confused:

it just keep redirecting and redirecting to the same page saying:

Going to main page:
001 Check and update database002 Associate Users003 Import Users004 Import Ban List005 Import Styles006 Import Forums and Categories007 Import Threads008 Import Smilies009 Import Posts010 Import Polls011 Import Private Messages012 Import Ranks

vBulletin (http://www.vbulletin.com/)

[rex_b]

^that being said^

I updated the counters and all posts/users are in and there, just a bit jumbled. With the forum turned off can MODs see it or just ADMINs?


I take that back it didn't put all of my subforums in.. ugh..

[rex_b]

I have now deleted everything and am going to start from scratch once again. Whats the advice on the previous problems?

maybe I should just undo all subforms and make them regular forums for the import?

[ceint]

ok I figured out how to get that to work but I can't get the config right.. ugh

I have the same problem, have read all posts regarding this problem but do not know what else to do.

I am trying to import from phpBB to vb3 and get this error:

Database error in vBulletin:ImpEx Target 3.0.3:
Invalid SQL: SELECT title, data FROM datastore WHERE title = 'ImpExSession'
mysql error: Table 'paintball_forum.datastore' doesn't exist
mysql error number: 1146

Please advise.

Thanks,

Thomas

[Zachery]

Your impexconfig.php file does not have the right infomration in it.

But please start your own thread Ceint.