Errors Importing IPB 1.3 into vBulletin

[Incendium]

I tried several times to import IPB on a test board. After each run I reinstalled vB3.

The first time i tried i got an error with importing the avatar data. I cleared the avatar data from the source database and tried again.

The second time through everything seemed to work. I then reloaded the admin panel and it seemed that all the phrases were gone and my login info had changed.

The third time went the same way. I figured it was something with the styles so i tried things differently the next time.

The fourth (and last) time i tried i did everything similar until i got to the styles. I told it not to import the styles and it got stuck on a blank page.

I am at a loss of what to do. It is crucial that i merge 2 databases into an already existing vB3 database. What should i do?

[Zachery]

I have not done a IPB import yet however ive never expirenced anything like that.

My best suggestion is to import users and threads / posts and forums and dont import anything else.

[Incendium]

I did this but how do i close the import session after i am done and insert all the information into the main tables?

[Jerry]

The SQL in there will delete the session and various data.

http://www.vbulletin.com/forum/showpost.php?p=657820&postcount=7


The fourth (and last) time i tried i did everything similar until i got to the styles. I told it not to import the styles and it got stuck on a blank page.

Impex dosen't currently import styles, it just returns a "true" value each time, to skip styles importing don't even click on that module, no others should be dependant on it.

[Incendium]

Thanks alot jerry i think i have everything figured out. :)

[Incendium]

I just noticed that on the members list, the only username there is the one i registered with when installing the board. How do i fix this?

[Zachery]

Have you update your counters since you imported?

[Incendium]

I updated every single counter on the counter page. Still won't show.

[Incendium]

I tried running the import again after re-installing vB3 and got the same problem. The memberlist won't show.

[Zachery]

Please report it to the bug tracker

[Incendium]

Will do. Thanks.

[mOdEtWo]

I believe Jerry already know about this.

Try to add a new user. The member counter should then update.

[Jerry]

I've added a step after the completion of all user imports that rebuilds the user cache now, that should do it.

[mOdEtWo]

Great!

[Incendium]

Here is another problem, occurs when importing usergroups:



Database error in vBulletin:ImpEx Target 3.0.1:

Invalid SQL:
INSERT INTO usergroup
(
importusergroupid, title, description,
usertitle, passwordexpires, passwordhistory,
pmquota, pmsendmax, pmforwardmax,
opentag, closetag, canoverride,
ispublicgroup, forumpermissions, pmpermissions,
calendarpermissions, wolpermissions, adminpermissions,
genericpermissions, genericoptions, attachlimit,
avatarmaxwidth, avatarmaxheight, avatarmaxsize,
profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize
)
VALUES
(
'4',
'Command Staff (Admin)',
'',
'Command Staff (Admin)',
'',
'',
'',
'6',
'6',
'<span style=\"color:red\"><b>',
'</b></span>',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Unknown column 'pmforwardmax' in 'field list'

mysql error number: 1054

Date: Monday 26th of April 2004 03:05:18 PM
Script: http://the101stairborne.com/cod/impex/index.php
Referer: http://the101stairborne.com/cod/impex/index.php
Username: [101st]Incendium
IP Address: xx.x.xxx.xxx

[adwhitworth]

Jerry, are the IPB bugs all sorted now?:)

[Jerry]

Jerry, are the IPB bugs all sorted now?:)

Unfortunately not, though after a nice weekend off I'm back on the case with a vengeance now :)

[Jerry]

Here is another problem, occurs when importing usergroups:

[code]
Database error in vBulletin:ImpEx Target 3.0.1:

..............................

pmforwardmax is a valid column name in the usergroup table, can yo confirm that you've got it ?

[adwhitworth]

Jerry, just done a brand new re-import and it seems to be better than last time. The only bugs I can find now is on SOME of the images (not all) they have an [/IMG] tag on the end like they should but some have "<img src='" on start.

The other bug is the join date of everyone joining in Jan 1970.

Also, do you have the SQL to remove Custom Titles, Avatars and Signatures

[Jerry]

Yup know about the join date one.

There is a clean up script in the tools dir for catching HTML that slipped through, the HTML parser is good but there is some things that get through.

Clearing all the signatures :


UPDATE usertextfield SET signature = '';

Clearning avatars from users :


UPDATE user SET avatarid = 0

Clearing custom title from users:


UPDATE user SET customtitle = 0

If you can find the origional posts in your source board and find the img HTML I'll be able to update the parser to get that as well.

[adwhitworth]

Do you need all the posts that have the IMG problem or just some of them as there are quite a few. Thanks for the other things... :)

[adwhitworth]

Sorry for being an annoying person again..Does it matter where I insert the above lines into the cleaner tool?

[Jerry]

Personally, I'd do an import then run them against the database directly to clean up after you've done an import.

If you run the cleaner SQL txt file I put in the sticky status thread, that will delete all the imported data.

[adwhitworth]

Personally, I'd do an import then run them against the database directly to clean up after you've done an import.

Is that done by just running a query?

[Jerry]

Yes, the 3 lines of SQL I posted above will remove the data you asked about removing.

[adwhitworth]

OK Thanks Jerry. Just so I know, when are you sorting out the Join Date bug but as I said in PM, don't worry about rushing things as I have some time :)

Also, the avatar SQL Query isn't working for some reason.

Sorry to be a complete pain in the ass!

[Jerry]

Today is IPB day :) as yesterday was phpBB day, got 1 PM thing to sort then I'll get these thingys done.

[adwhitworth]

YAY. I'll hang fire then before doing anything. :D

P.S. What you were saying about the images...is that going to be resolved as well because it will be a life saver if you are.:)

[Jerry]

RE : Images.

If you can show me the HTML that hasn't been parsed I can updage the parser to sort it out.

[Jerry]

Well I've done all the reported bugs, just got to redo the PM's now for version 1.5 and wait for the bug reports from that release :).

[adwhitworth]

Well I've done all the reported bugs, just got to redo the PM's now for version 1.5 and wait for the bug reports from that release :).

Absolutely fantastic Jerry :) You should have a PM Re: images. I'll do another import tonight.:)

[Jerry]

Yea got it, its done.

1.5 can be downloaded now.

[ESCal]

Yea got it, its done.

1.5 can be downloaded now.
1.5 appears to have fixed most of my problems except for one thing. All users join dates are 01-01-1970. :confused:

Am I missing something? I imported everything and rebuilt everything (I think).

[adwhitworth]

Just to check ESCal, I persume you've run all the counters?

Thanks Jerry! Excellent Work! I'll go and delete the test copy of vB that's running atm and reinstall from scratch and try another import before I try the proper install. :)

[adwhitworth]

Just to check ESCal, I persume you've run all the counters?

Thanks Jerry! Excellent Work! I'll go and delete the test copy of vB that's running atm and reinstall from scratch and try another import before I try the proper install. :)

OK. Everything is sorted. The only thing is the join date is still 1970 but everything else is 100% perfect.

[ESCal]

I did run all of the counters and the join date still reads as 1970. Everything else looks very promising so far...

-Brian


Just to check ESCal, I persume you've run all the counters?

Thanks Jerry! Excellent Work! I'll go and delete the test copy of vB that's running atm and reinstall from scratch and try another import before I try the proper install. :)

[Jerry]

My bad.

One of the changes that didn't make it into 1.5.

I've put it in now and updated the download (seeing as it should of been in there, I left the version as 1.5).

[adwhitworth]

OK. Uploading now. Will let you know the results in 5mins.

[ESCal]

How did it go?


OK. Uploading now. Will let you know the results in 5mins.

[adwhitworth]

Sorry, I did it and went to bed. It finished at 12:38ish AM and had to be up for now (7am).

It's 99.9% perfect now. There's just the avatars to remove so we can start a theme going but that's not the importers fault. That's just me :p

[Aeolian]

ok few things..
does the importer imports avatar/attachment/image/ignature now?
and does it still imports the the PMs with LOGs.

thanx...

[Jerry]

ok few things..
does the importer imports avatar/attachment/image/ignature now?
and does it still imports the the PMs with LOGs.

thanx...

Which logs ?

[Aeolian]

Which logs ?in invision every pm sent has log.. so after i tried to import i found all the pms with the logs in the inbox.. resulting into double the number of pms..

and also does it import attachment/image/avatar/signature now?

thank you

[Jerry]

Ah, PM recipts. Currently no.
avatar = yes.
signature = yes
attachment = no

image = which one ?

These details are on the status page also.

[Aeolian]

hai jerry .. u told like this importer is the modified version of the 1 by pogo (of http://www.vbulletin-germany.com/).. then why the attachments are not imported..
coz with his importer i could import the attachments (file/image)..

by image i mean images in any post (not attachment) or image in signature..

thank you..

[Palatino]

Hello,

After import the threads, they're all with the ~ 1970 date; is it a known bug? :confused:

Thank you, Palatino.

[Jerry]

hai jerry .. u told like this importer is the modified version of the 1 by pogo (of http://www.vbulletin-germany.com/).. then why the attachments are not imported..
coz with his importer i could import the attachments (file/image)..

by image i mean images in any post (not attachment) or image in signature..

thank you..

Images that are linked to posts via URL's are parsed, or do you mean something else ?

[Jerry]

Hello,

After import the threads, they're all with the ~ 1970 date; is it a known bug? :confused:

Thank you, Palatino.

Updated all the counters ?

[Palatino]

Updated all the counters ?
Ok, it solved the date issue.. thank you; but there are still many problems. I have ~ 50.000 posts and the posts import system just goes until ~ 24.000 and then stops. Why?

[Palatino]

Hi again,

I noticed that some forums are missing.. I mean, they were not imported. What could be happening?

Thank you, Palatino.

[Aeolian]

so now image links r phrased and shown as URL or any url with [img] tag displays the image in post?
and let us know about attachments..

thanx

[samcurry]

Jerry any idea when Attachment will be able to be imported? It appears most of everything else is done but i cant afford to lose 2 years of attachments. members might want to hurt me. :)

[Aeolian]

Jerry any idea when Attachment will be able to be imported? It appears most of everything else is done but i cant afford to lose 2 years of attachments. members might want to hurt me. :)use the importer by pogo that imports everything..

[Nemon]

link?

[Pogo]

To be clear here:

I wrote the IPB importer that is included in the vBulletin 2 import.zip which you can download in the Member Area..
This will only work with vBulletin 2.

If you want to use it, install vB2, import IPB and then upgrade your vB2 to vB3.

[Palatino]

I noticed that some forums are missing.. I mean, they were not imported. What could be happening?
Hello? Is there anybody here? ...