Import problem

[RichieBoy67]

Go into phpadmin and just look at the tables in your database.

Do they have a prefix like

VB_Tablename

Chances are they do not if you did not add one when you set up the site.

BTW - It is normal for many tables to show up in the red like that because phpbb does not have many of the same tables as Vbulletin. Were you able to move onto the next step? Or is it not allowing you to?

It looks like many of the tables were imported correctly so I doubt it is a prefix or anything. Try moving on to the next step and see if it lets you.

[CaptainAwesome]

Taking a closer look at the info, the ok parts were vb, the red parts were phpbb. I looked at the table and there was a prefix. I added that to the impexconfig file and all is working well so far.

I did try and clean up the user table since i have a handful of users to transfer but 16,000+ users in the table thanks to the bots. Even thou i deleted everything from the table, vb is still importing a bunch over and is currently at 3500. I would have thought deleting it from the table would have prevented that, i'm not sure if there is a lag from making changes to the database to it taking on the server, or if vb copies the database to another location for the transfer and uses that. Whatever it is, i guess i will try and clean that up afterwards. Whats the best way to do that, go into the table and delete all but the real ones? Or is there a better way?

Should i restart the import? If so, should i wait a bit? These are the options i get when i click on "Database cleanup & restart"

Impex Help page

These links will allow you to restart an import, remove a session or remove the importid's to allow consecutive imports.

Using includes/config.php for target config.


Cancel
To cancel and return to the import, click here.

Delete Session
To delete the import session and continue with the import, click here.

Delete Session and all imported data
FORUM data - To delete the import session and all imported data for a clean retry, click here.

CMS data - To delete the import session and all imported data for a clean retry, click here.

BLOG data - To delete the import session and all imported data for a clean retry, click here.

Remove Importids
FORUM importids - To delete the importids in the database, click here, also removes the session. This will allow you to do consecutive imports

CMS importids - To delete the importids in the database, click here, also removes the session. This will allow you to do consecutive imports

BLOG importids - To delete the importids in the database, click here, also removes the session. This will allow you to do consecutive imports

Remove duplicate forums/threads/posts.
This will remove anything that has a duplicate importid and a diffrent vBulletin id. Use with EXTREME caution, results will vary between source systems, ALWAYS TAKE A BACK UP BEFORE USING

--------------------------------------------------------------------------------------------------

Which should i be going with? I tried a couple of them while the user import was going on but when i start the process it seems to transfer the big list of users, possibly from where it left off since the last time.

--------------- Added [DATE]1402714289[/DATE] at [TIME]1402714289[/TIME] ---------------

Just wanted to add that i ran it again but it did start at the beginning not from where it left off.

--------------- Added [DATE]1402717802[/DATE] at [TIME]1402717802[/TIME] ---------------

More problems......yay!

Every module has a warning similar to the first one:

Warning: Declaration of phpBB3_001::init() should be compatible with ImpExModule::init(&$sessionobject, &$displayobject, &$Db_target, &$Db_source, $resume = false) in ..../impex/systems/phpBB3/001.php on line 146

When i go to that line in that file, there is not the line mentioned, in some cases there is nothing in the line stated at all.

I have several of the modules done, and when go to the main index page of the forum, it has the following right at the top:

Warning: Illegal string offset 'numbermembers' in ..../forum.php on line 630

Warning: number_format() expects parameter 1 to be double, string given in ..../includes/functions.php on line 840

Warning: Illegal string offset 'newuserid' in ..../forum.php on line 632

Warning: Illegal string offset 'newusername' in ..../forum.php on line 633

Warning: Illegal string offset 'activemembers' in ..../forum.php on line 635

Warning: number_format() expects parameter 1 to be double, string given in ..../includes/functions.php on line 840


--------------- Added [DATE]1402718107[/DATE] at [TIME]1402718107[/TIME] ---------------

And should the import take effect right away? I've run the modules, they ran successfully, but when i go to the site nothing has changed.

--------------- Added [DATE]1402719349[/DATE] at [TIME]1402719349[/TIME] ---------------

And when i look at the tables of the database for the new forum, its all there. Whats going on?

And is it safe to delete entries from the tables? Will that mess up anything else?

[RichieBoy67]

You have to go into maintenance and update the counters in the admincp..no sure about the other stuff now. Getting ready to crash.

[CaptainAwesome]

I had did some of that and nothing had happened, but when i logged in later that had changed.

I'm going through the general update tools right now and things are showing up.

Thanks for the advice and help