Invision Power Board 1.1 Importer needs testing

[pogo]

The importer is now available in the Members Area at

http://www.vbulletin.com/members/imports.html
or
http://www.vbulletin-germany.com/members/imports.html

I have heard all the requests for an Invision Power Board 1.1/1.2 import script and now it is done (I hope).
It is possible that it could work with all vB 2.2.x versions but I have tested it only with vB 2.2.9+. I don't know how much bbimport.php changed over the versions and if it will work with older ones.

It imports users, custom avatars, usergroups, buddys, categories, forums, threads, posts, attachments, polls, private messages, private message folders, subscribed forums and subscribed threads.

To make it easy to use it is written as a plugin like all the other official importers.


Requirements: vBulletin and IPB 1.1/1.2 on the same MySQL server. It doesn't matter if they are in the same or in different databases (but different databases need the same MySQL user/pass).


Sucsessful imported IPBs
http://www.aximsite.com/boards


01/30/03 imports usergroups

[Dean C]

Sounds very nice pogo - i'm sure a lot of people will thank your for this :)

- miSt

[sbywebs]

3 days late for me :-/

But i still have my old IPB boards online if you would like to test it.

[Gohan]

I have vB 2.2.9 and inVision 1.1

if you need someone tester or whatevers.. you could send PM to me and i wish helped to you :)

[colicab-d]

like wise i have an old ib database on my server and am now running vb 2.2.9

[pogo]

Originally posted by colicab-d
like wise i have an old ib database on my server and am now running vb 2.2.9

Is it a 1.1 database?

I am sure that the import script is not compatible with IPB 1.0.1 because of all the changes between 1.0.1 and 1.1.

[colicab-d]

its 1.1 rc 1 :D and it was converted from 1.0.1 after they released 1.1 :D

[DWZ]

You are going to be loved by a lot of people now pogo :)

[pogo]

Originally posted by DWZ
You are going to be loved by a lot of people now pogo :)

You don't know how much love I put into this importer. Now I need all the love I can get. :p

[Dean C]

Just curious - how long did it take you?

- miSt

[pogo]

Hmm I would say about 10 hours of work. Don't know exactly.

Good thing was that the import script for WWWThreads has been a nice inspiration.

1 tester replied and had no problems. More to come.

[C.Birch]

i had alot of probs with it :(

1) it added some users has admin, supermods and so on.
2) added some users to more then one group.
3) added people to your contacts list that where not on it.
4) imports all smilies and tags has html

:( oh well i just dont a clean install of vb now and people have had to resign up because i could not get this to work.

[Seany]

Hey pogo, could I use it? I've e-mailed you, but I haven't gotten a reply back yet :(

Anyways, I really need this! And yes, it is a 1.1 database.

[pogo]

Originally posted by C.Birch
i had alot of probs with it :(

1) it added some users has admin, supermods and so on.
2) added some users to more then one group.
3) added people to your contacts list that where not on it.
4) imports all smilies and tags has html

1) Hard to say where the problem is, in my 2 test boards all users and usergroups were imported correctly.

2) This isn't possible in vB2 because one user can only belong to one usergroup. Perhaps two users have the same name?

3) Yup. I am working on this right now....DONE!

4) This is already done.

[JasonP]

I need this importer for invision 1.1 to vbulletin, where do I get it?

Thanks

[Peter204]

I sent an email off pogo :)

[pogo]

Originally posted by C.Birch
1) it added some users has admin, supermods and so on.
2) added some users to more then one group.

I guess both of these errors are related to users that are in mgroup=0 (mgroup = usergroup) or any other undefined usergroup (don't know yet how this can happen).

I will add some checks to avoid this.

[Peter204]

Any progress on this? :)

[pogo]

Yes, this is solved.
There is only one other thing with importing the rights of the standard usergroups which I want to do before sending out the next batch of scripts. Hopefully in a couple of days.

[Rapid Gaming]

I installed it as you know Pogo, and it works GREAT, well done and thank you.

Demo is here: http://forums.gamewizards.net

[f-a_org]

Can anyone post Screenshots of the Script ?

[pogo]

It looks like any other official import script.

Basically it just says:
"Next thing to import is the users"
Start import <- Button

"Next thing to import is the usergroups"
Start import <- Button

And so on. :)

Just launch one of the import scripts and you will see it.

[WickedVixsen]

Where can we get this script ? I'd love to give it a try.

[Rapid Gaming]

I'd just like to add, DO NOT PM ME FOR IT, I will not send it you!

[Peter204]

Well, was only asking... a polite no from the start would've been nice.

So much for a community helping each other..

Anyway, Pogo still looking forward to receiving it! :) Thanks a ton!

[pogo]

And I will send it to you!

Please give me some time. I know that every second is too long when you are waiting. :)

[Peter204]

I don't mind about waiting, you're creating something to help us. :)

[WickedVixsen]

EEK I did email Pogo :) but not Game Wizards !!

I'll wait patiently <G> ...or perhaps impatiently, but I'll wait LOL

[TeEq]

pogo can you sent to me ... teeq@irc.pl

[pogo]

I sent out the latest import script version to the users who have sent me an email.

If you are one of these and didn't get the import script it is because I am not at home and don't have access to all emails here.

Please send it again.

[Peter204]

PM sent ;)

Thanks for the great contribution!

[Peter204]

Worked great! :)

[Da`Nacho]

I have sent an email requesting this script... hope to have it in my hands soon so I can convert my forums back to vBulletin.

[hockyfan]

Originally posted by Da`Nacho
I have sent an email requesting this script... hope to have it in my hands soon so I can convert my forums back to vBulletin.
Sent an email as well via the link in the first post; no response as of yet...


h

[nissanpower]

pogo, can you please send me the importer script to webmaster@nissanpower.net? Thank you!!!!

[kyzen]

Hey pogo, just got vBul, upgrading from invision, will test it out,
but I have vBul 2.3.0 :o hope it work ;)

[kyzen]

can you email it to me again mate? the rar you send me was corrupt! Thanks Champ, kenny@ncable.net.au

[crowfield99]

How can I download this hack? I cant sem to download it and yes I am a valid VBulletin Member.

[Da`Nacho]

I got the script from pogo, I ended up hunting him down on the vBulletin-Germany forums though.

It's definately a rough script. but it worked and I got all the posts and users converted.

Those of you who do get the script should watch out for:

usergroups are converted, but instead of putting admin, moderator, super moderator, registered, etc in the existing vBulletin usergroups the script seems to make all new usergroups with similar names, and then imports all the users adding them to these new usergroups. It's not a big deal really, if you are versed in MySQL you can fix this with a few commands.
My account was imported to the forum and instead of replacing userid 1 it was given userid 2, which makes me the second user in the database and as such some admin functions in vB are visible to userid 1. Again, this was easily fixed with some MySQL commands meant to search and replace userids.
Forum options and permissions are not converted, or are converted poorly.


There were some other issues but they were minor, and all in all I am extremely grateful for the converter pogo wrote. CandidForums are now back on Vbulletin, where they belong. :p

[crowfield99]

Thank you very much for that, I didn't know you could not download it from here!

Thanks again :cool:

[pogo]

Originally posted by Da`Nacho
Those of you who do get the script should watch out for:

usergroups are converted, but instead of putting admin, moderator, super moderator, registered, etc in the existing vBulletin usergroups the script seems to make all new usergroups with similar names, and then imports all the users adding them to these new usergroups. It's not a big deal really, if you are versed in MySQL you can fix this with a few commands.
My account was imported to the forum and instead of replacing userid 1 it was given userid 2, which makes me the second user in the database and as such some admin functions in vB are visible to userid 1. Again, this was easily fixed with some MySQL commands meant to search and replace userids.
Forum options and permissions are not converted, or are converted poorly.


IPB has 4 default usergroups (admin, members, guest, awaiting confirmation). Users out of these groups are imported in the corresponding vB usergroups. Every other IPB usergroup is a custom one and created for vB.
The only thing where vBulletin relies on userids exclusivley is the viewing and pruning of the adminlog. You can change the userid in admin/config.php.
The systems are very different in saving forum permissions. No I won't try to include it and you learn how to set forum permissions. ;) The importer imports all forum settings that can be imported, I hope.

[AlexanderT]

I want to add that I successfully converted my IB 1.1 board to VB 2.2.9. Not only this - Pogo was *very* responsive to my emails and suggestions and I couldn't think of any better support.

Thanks again, Pogo.

[[hhhh]]

]Pogo , PLease send for me your script to email webnhkv@yahoo.com or nguyenvu@yeuamnhac.com

[Sinko]

Hey, send me a copy over at craigmaloof@cfl.rr.com please.

[bspiller82]

Yes same here. Where do I get this please?

[Eyes on me]

When i covert from IBF 1.1.1 to vBB 2.3.0, the vBB said me input the Admin user.

But when I covert from IBf 1.1 to vBB 2.3.0, the covert successful

Who can help me covert from IBF 1.1.1 to vBB 2.3.0 :(

Soryy for my english bad :(

[pogo]

I just tested an import from IPB 1.1.1 to vB 2.3.0 without any error.

You'll have to be more specific about the error you got.

I will send you the script if you send me an email. The address is in the first post.

[Emrys]

I am getting to the point right after you set the database name and prefix, and then it kicks me out saying I don't have administrator privileges. Anybody else get this? All the information seems correct, and I can log into the board fine and change my password. But when I get to that point where it imports usergroups, it locks me outta the admin panel and I can't get back in.

I am using the right username/password for the databases, and everything seems to be fine as far as configuration is concerned. I just get dumped out. My vbulletin username has the right settings to be an administrator in the database.

What am I missing?

Thanks

[Jagang]

Hey pogo I have a challenge for ya. I have a Xoops site running IPB 1.1.1 as a module that I need converted to vB 2.3.0 Intergrated with vBPortal 3 Beta. Think your script can manage that? If so please forward a copy over to webmaster@evhallion.com If not, thanks anyways.

[Fallout2man]

Send a copy of your script over to my email, fallout2man@hotmail.com if you can please.

and why haven't you just posted this allready? Wouldn't it be much easier to just have a public beta test? If you want to make it more private that's understandable but why the whole email thing? Why not either public or private only testing, just seems a bit odd to me.

[pogo]

First I didn't say "post your email address and I will send you the script". My instructions of how I want this to go are clear I think.

No I didn't want a public beta test because of all the screaming that could come up if there were bad bugs in the script. I wanted to have the links to the IPBs just to see where the importer is being tested therefor the email. Plus I don't want to copy all the emails out of this thread and paste them into my email program.

So please write me an email if you want to test the script or wait until vB3 is out and an official importer is released.

[Lord Man]

Pogo, plase send it to me :)

[Cyclonus]

Just sent you an e-mail pogo. I need this script badly.

[Lord Man]

04-01-03 at 01:24 PM Emrys said this in Post #48 (https://vborg.vbsupport.ru/showthread.php?postid=376307#post376307)
I am getting to the point right after you set the database name and prefix, and then it kicks me out saying I don't have administrator privileges. Anybody else get this? All the information seems correct, and I can log into the board fine and change my password. But when I get to that point where it imports usergroups, it locks me outta the admin panel and I can't get back in.

I am using the right username/password for the databases, and everything seems to be fine as far as configuration is concerned. I just get dumped out. My vbulletin username has the right settings to be an administrator in the database.

What am I missing?

Thanks
Me 2 Pogo

i have test the hack on 3 forums
2 work good, and 1 say that to me :
Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT g_id AS importusergroupid,g_view_board AS canview,g_mem_info AS canviewmembers,
g_other_topics AS canviewothers,g_use_search AS cansearch,g_email_friend AS canemail,
g_edit_profile AS canmodifyprofile,g_post_new_topics AS canpostnew,
g_reply_own_topics AS canreplyown,g_reply_other_topics AS canreplyothers,
g_edit_posts AS caneditpost,g_delete_own_posts AS candeleteownpost,
g_open_close_posts AS canopenclose,g_delete_own_topics AS candeletethread,
g_post_polls AS canpostpoll,g_vote_polls AS canvote,g_use_pm AS canusepm,
g_is_supmod AS ismoderator,g_access_cp AS cancontrolpanel,g_title AS title,
g_max_mass_pm AS maxbuddypm
FROM forum.ibf_groups
ORDER BY importusergroupid
LIMIT 0,4
mysql error: select command denied to user: '***@localhost' for table 'ibf_groups'

mysql error number: 1142

Date: Thursday 17th of April 2003 03:42:13 PM
Script: http://www.***.net/vb/vb/importers/bbimport_invib.php
Referer: http://www.***.net/vb/importers/bbimport_invib.php

[Cyclonus]

I ran it earlier, and everything imported just fine. Thanks pogo!

[pogo]

Yesterday at 10:49 PM Lord Man said this in Post #54 (https://vborg.vbsupport.ru/showthread.php?postid=383508#post383508)
mysql error: select command denied to user: '***@localhost' for table 'ibf_groups'

mysql error number: 1142


Something is wrong with your mysql user settings. Ask your host about it.

[b3nnyboy]

Great hack, many thanks pogo :)

[fred70]

can someone please send me the file, thanx (email also sent to pogo)

[fred70]

ANYBODY AROUND ???

IM GOIN' CRAZY :banana:, SOMEONE ?

[fred70]

k, the script works great, a few of the user permissions didn't get transferred, but thats not a big problem. imported from IPB 1.1 to vB 2.3.0, recommend this script to all.

anyway, vB doesn't have enough hacks/mods, and after the original programmer left, vB has not made much progress. I'm going back to Invision Board (although some features might have been copied from vB). Since it's FREE and is getting better by the day, there are much more hacks/mods available. Not too many hackers around vB anymore because of the license issue. vB was the best, now competition is over-taking it, vB saw a chance to cash in on its software, now since competition is equally good and most importantly FREE, majority use IPB.

vB should get rid of the license to get more people supporting this software, more people = more hackers = more mods = even more people = then vB can think of cashing in on their software (sell priority support, etc while still allowing free use of vB - do wat IPB is doing !). If there are more people working on the software, then the development time will reduce... whats the point in me saying all this...
all that is left to say is that 'if vB continues like this, it's gonna die a slow death'. i dont mean any offence to anyone.

and for god-sake, improve the default skin - it WILL NO DOUBT improve vB's overall image.

[gerlando]

Pogo, sent you an email last night. Waiting for a reply :)

[Emrys]

Got this script work ( sorta ). Had to change my admin user to a different usergroup and then it went through. There are 2 "Administrator" groups now, and only one is valid. There is a ID 6 and an ID 9. I assume ID 6 is the original vB Administrator Group ID. This is the one that isn't valid.

I don't see that this script takes care of the userbase correctly. A lot of my Invision registered users are marked as unregistered in vB, and most of the unregistered users in Invision are now members in vB.

All my posts came over correctly though. So that is cool. But I can't have a database that is this messed up. I don't think vB3 will be very nice when it comes time to upgrade and the database isn't in the format it expects/wants.

Haven't even gotten to the point where I can check permissions, because all the users are screwed up. So I have no info about that at this point.

Am I doing something wrong? I know Pogo says he's done it a bunch of times, and others say they have as well. Are you guys having these same issues?

I am using Invision 1.1.2 which has the same database structure as 1.1 ( only different is security issues in the code ) and vBulletin 2.2.9.

Thanks

[gerlando]

I did a test run of the importer on my DB last night and it went very smoothly. I think I saw a couple of registered users get dumped into the COPPA member group during import but that's something I could easily fix manually.

[crowfield99]

Is there anyway you could also send me a copy? My address is david@crowfield99.co.uk and will test it out too.

Many thanks,

[FutureXec]

Does anyone know the current status with this hack?

When was the last time it was sent out?

[FutureXec]

I suppose a couple of preliminary questions before I get the script...maybe someone can help answer these.

My Invision board is located at www.loudrant.com/forum

Do I have to install the vB board at a different url such as www.loudrant.com/forums ?

Because I do need to install vB first, correct? And if they are at the same address that would present a problem, yes?


Thanks for any help...just trying to become familiar with all of this.

[gerlando]

Today at 05:49 AM FutureXec said this in Post #65 (https://vborg.vbsupport.ru/showthread.php?postid=390265#post390265)
Does anyone know the current status with this hack?

When was the last time it was sent out?

It's been posted in the hack DB.

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=913

[gerlando]

Today at 06:48 AM FutureXec said this in Post #66 (https://vborg.vbsupport.ru/showthread.php?postid=390281#post390281)
I suppose a couple of preliminary questions before I get the script...maybe someone can help answer these.

My Invision board is located at www.loudrant.com/forum

Do I have to install the vB board at a different url such as www.loudrant.com/forums ?

Because I do need to install vB first, correct? And if they are at the same address that would present a problem, yes?


Thanks for any help...just trying to become familiar with all of this.

How you migrate is entirely up to you. You're probably best off moving your forums to a new folder and forwarding users to your new ones. Otherwise you'd loose any search engine placement and bookmarks for your current board.

The importer is about as solid an importer as I've come across, it had no problem with my board (1200 members | 100,000 posts) so yours should be no prob.

[FutureXec]

Today at 02:03 AM gerlando said this in Post #67 (https://vborg.vbsupport.ru/showthread.php?postid=390285#post390285)
It's been posted in the hack DB.

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=913


I suppose you mean this : Testing is on hold while I do some bugfixing and I won't send the script out until further notice! Thanks to all who helped me a lot so far.

Ya, I was just trying to find out if the author was keeping up with this so I was curious when the last time it was sent out...thanks though.

[gerlando]

Doh! Sorry, I didn't notice the DL link didn't contain a file.

[FutureXec]

Today at 02:06 AM gerlando said this in Post #68 (https://vborg.vbsupport.ru/showthread.php?postid=390286#post390286)
How you migrate is entirely up to you. You're probably best off moving your forums to a new folder and forwarding users to your new ones. Otherwise you'd loose any search engine placement and bookmarks for your current board.

The importer is about as solid an importer as I've come across, it had no problem with my board (1200 members | 100,000 posts) so yours should be no prob.

It's definitely reassuring to hear that such a large board was successfully converted.

So what your suggesting is that I move my current forum to a different folder and install vB in the folder previously used for Invisionboard? You're right...I don't want to lose my bookmarks...

Please bare with me...thanks!

Also, could you check your PM?

[kevinnguyen]

anyone send it to me pliz Thanks be4 hands my email minhtrung@viet-online.org. Thanx

[Ryoku]

i e-mailed you but u never reply my e-mail is - digital5kp@aol.com

[FutureXec]

Read the first post, the script is on hold. It will not be sent out until some bugs are fixed and features are added.

[Emrys]

Got it to work fine. Converted IPB 1.1.2 -> vB2.3.0. My database was a little screwed up from an earlier conversino to IPB. But after that was cleaned up, the conversion went perfect.

Thanks Pogo!

[FutureXec]

Today at 12:29 PM Emrys said this in Post #75 (https://vborg.vbsupport.ru/showthread.php?postid=391795#post391795)
Got it to work fine. Converted IPB 1.1.2 -> vB2.3.0. My database was a little screwed up from an earlier conversino to IPB. But after that was cleaned up, the conversion went perfect.

Thanks Pogo!


When did you get the script?

[pogo]

Emrys got it over a month ago.

[CardinS2U]

nice I want to download this. I hate IBF NOW

[jagoar]

v good

pleas send it to me ...

jagoar@hotmail.com

[FutureXec]

Pogo, could we get a status update? :)

[pogo]

The importer is finished now but has a problem importing pms that will occupy your computer for several minutes.
This needs to be fixed first.

[FutureXec]

Today at 02:09 PM pogo said this in Post #81 (https://vborg.vbsupport.ru/showthread.php?postid=398165#post398165)
The importer is finished now but has a problem importing pms that will occupy your computer for several minutes.
This needs to be fixed first.

Thanks for the update!

Any idea how long it will take for the PM issue to be resolved?

[pogo]

Sorry no. But I am on it and you will see it here when it is done.

[pogo]

Ok, I think I have found the bug but I still don't know if it was related to my computer only or a problem in general. Nevertheless the one line solution will hurt no server :) I had to write tons of code until I came up with the hopefully final solution.

I sent the script to Kier for some extreme testing and if he says that everything is alright you will be able to download it very soon.

Thanks for all your help and patience. :)

[FutureXec]

Yea!!!

[NightWalk8r]

finally!!!! i really want to switch too =D

[FutureXec]

pogo, will we need to re-send you an email requesting it?

[pogo]

No, I will write an update here on how to go on.

[NightWalk8r]

hey pogo, how much longer do u thing it'll take until u finish testing it and everything?

[pogo]

Sorry, I don't know when it will be available in the members area.
I hope very soon, though.

[djhenry21]

:disappointed:

I'm really interested in getting this converter. Seems like the only one available. Just wondering if you'll answer my e-mail I sent yesterday. Do you think you can send it today? If not I'll just go through w/ invision to phpbb then to vb.

Thanks pogo.

[Frankie]

05-28-03 at 11:07 AM pogo said this in Post #90 (https://vborg.vbsupport.ru/showthread.php?postid=401012#post401012)
Sorry, I don't know when it will be available in the members area.
I hope very soon, though.


Pogo, I hope it also but can you send (the converter) to me in the meantime, because I have to do also a server move and then it?s better to have it come up as VB (because) I have already then some downtime and then I don?t need to close the board twice.

Regards,
Frankie

[G20 Sport 2002]

Any word on the hack? Really wanna bring over my old forum!

[Rapid Gaming]

Give him time he's working on it..

Give him time he's working on it..

Give him time he's working on it..

[G20 Sport 2002]

lmao sorry about that I didnt know it came out three times..
I hope it comes out soon!

[vurton]

Where can I get it? What members section?

[pogo]

The members area at vbulletin.com.

I guess they will get the script released after the vB3 public beta as they are spending all resources to get this baby done.

[G20 Sport 2002]

Yesterday at 09:07 PM pogo said this in Post #97 (https://vborg.vbsupport.ru/showthread.php?postid=405741#post405741)
The members area at vbulletin.com.

I guess they will get the script released after the vB3 public beta as they are spending all resources to get this baby done.


so theres no other way to get it, I really need to bring my board over to vb

[vurton]

So we'll have to pay for it?

[Rapid Gaming]

Did he say that?

[FutureXec]

Pogo, any update?

[pogo]

The only update I can give is that I had no problems using this importer on my IPB 1.2 Beta.

[jackyhow]

where to download this hack??

[TRStealth]

You can't, it's in production I think.

Pogo, can you tell me if IPB1.2 will convert to vB3? Or what version of vB?

[pogo]

The importer imports only into vB2.2.9/2.3.x.

At least these are the versions I used during development.

[Soulblighter]

pogo plz i emailed u with my email address to send it :)

[TRStealth]

Yesterday at 10:00 PM pogo said this in Post #105 (https://vborg.vbsupport.ru/showthread.php?postid=409345#post409345)
The importer imports only into vB2.2.9/2.3.x.

At least these are the versions I used during development.

Alright, that's perfect. Can't wait for the release.

[TRStealth]

Any updates?

[cipciop]

Hi Pogo,

Can I have this script into my e-mail

Best Regards

[achtungbaby]

Can someone send me a copy of the hack? I've emailed Pogo twice (the last time was earlier this week) and I haven't heard anything.

[TRStealth]

I'm going to need this really soon if it works with IPB 1.2

Any updates?

[Shr3d]

@ Pogo: tried to e-mail you via the contact form, but i think that went wrong :S

Looking for your e-mail right now.

i'll just post my e-mail addy and hope you send me the importer: info@i-magination.nl. Thanks in progress!

[Paris Holley]

I REALLY NEED THIS AS SOON AS POSSIBLE! I dont really care about the bugs........my email is parisholley@pixel-lab.net

[Winnie]

Does anyone have any version of this converter, or knows any place to download it? I couldn't find it in the member's area and already sent an emal to Pogo.

[pogo]

Go to

http://www.vbulletin.com/members/imports.html
or
http://www.vbulletin-germany.com/members/imports.html

to get this importer.


Have fun with vBulletin!

[TRStealth]

Hmm, alright great :D

[Cary]

Would anybody with a large Invision Board database please email me at cary.sidhom@vbulletin.com?

Thanks. (When I say large, I mean with 20,000+ posts and/or 1,000 members)

[narulure]

When it gets to the PM part......it doesnt complete O_o or load....Iv been waiting 30 min!!

[Vivi01]

so far everything has installed right, but I get an error when I try top use the Update Thread Info

I get this error

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1059429553,replycount=4,postusername='Nes s', postuserid='9', lastposter='DODpants',attach= WHERE threadid=1087
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=1087' at line 1

mysql error number: 1064

Date: Monday 28th of July 2003 08:15:04 PM
Script: http://www.gameteller.com/vbulletin2/vbulletin2/admin/misc.php
Referer: http://www.gameteller.com/vbulletin2/admin/misc.php?action=chooser&

[pogo]

This is a vBulletin bug.

Here is a fix:
http://www.vbulletin.com/forum/showpost.php?p=463548&postcount=2

[slowroastedx]

hey when i try to start the import i get this error message, any ideas? Im going from ib 1.2 to vb 2.0.3

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT g_id AS importusergroupid,g_view_board AS canview,g_mem_info AS canviewmembers,
g_other_topics AS canviewothers,g_use_search AS cansearch,g_email_friend AS canemail,
g_edit_profile AS canmodifyprofile,g_post_new_topics AS canpostnew,
g_reply_own_topics AS canreplyown,g_reply_other_topics AS canreplyothers,
g_edit_posts AS caneditpost,g_delete_own_posts AS candeleteownpost,
g_open_close_posts AS canopenclose,g_delete_own_topics AS candeletethread,
g_post_polls AS canpostpoll,g_vote_polls AS canvote,g_use_pm AS canusepm,
g_is_supmod AS ismoderator,g_access_cp AS cancontrolpanel,g_title AS title,
g_max_mass_pm AS maxbuddypm
FROM dahonk_ivdb1.ibf_groups
ORDER BY importusergroupid
LIMIT 0,4
mysql error: select command denied to user: 'dahonk_orphen@localhost' for table 'ibf_groups'

mysql error number: 1142

Date: Tuesday 05th of August 2003 12:24:58 AM
Script: http://www.dbzgfx.com/forum/forum/importers/bbimport_invib.php
Referer: http://www.whatever.a-techweb.com/forum/importers/bbimport_invib.php

[pogo]

If the IPB is in another database you need to make sure that both databases are accessible with the same MySQL user/pass.

[slowroastedx]

hmmm ok ill try and see if thats the problem

[=DH=Demon]

thanks a lot pogo , not one error going from invision 1.2 to vb 2.3 , posts users, everything is moved, THANKS !


* =DH=Demon loves you

:)

[frozen]

Any Chance of this being modifed to connect to a different database with a different username/pass. I run a medium size hosting company and have had several clients come to me asking if they can put their databases under the same username but due to the way our customer control panel(Plesk) works, it does not allow more then one database per username/passwd.

[tanhadil]

I have sent a pm to Pogo and a email as well...and that too 5 Days back!

Pogo dear wake up

Salam

[tanhadil]

ok got the script from members area..

Now i tried with the importer...

half of my users got Unregistered in VB ...and the remaining ones had incorrect post counts :(

Any way to fix this?

Regards,

and yeah i am converting from 1.1.2 to 2.3.2


POGO -> genius

[pogo]

Come on.
You wrote the pm at 08-31-03 08:26 AM.
I answered at 08-31-03 10:59 AM.
Your read the answer at 08-31-03 12:17 PM.

I guess I am quite awake....

As I said in the pm please contact the support at vbulletin.com or send me all the details to get access to your IPB, vB and phpmyadmin.

[blakkboy]

if i installed this script to my vbulletin board to import my invisionboard files, once it was done importing could i delete my invisionboard 1.1.2 off my database???

[pogo]

Once all data is in vBulletin you don't need the IPB database tables anymore.

So delete them or make a backup before. However you like it.

[blakkboy]

sounds cool im going to try this out today

[maxboost107]

I like to test it
green_eyed_prican@yahoo.com

[maxboost107]

ok , i think i have downloaded it but , how do i run it ?

Warning: main(./../admin/bbimport.php): failed to open stream: No such file or directory in /opt/lampp/htdocs/db/1/bbimport_invib.php on line 4

where is this file @ ?
sorry for newbie questions

[pogo]

You have to copy it in a directory called importers inside your vbulletin directory.

[MaxScript]

The importer is now available in the Members Area at

http://www.vbulletin.com/members/imports.html
or
http://www.vbulletin-germany.com/members/imports.html

I have heard all the requests for an Invision Power Board 1.1/1.2 import script and now it is done (I hope).
It is possible that it could work with all vB 2.2.x versions but I have tested it only with vB 2.2.9+. I don't know how much bbimport.php changed over the versions and if it will work with older ones.

It imports users, custom avatars, usergroups, buddys, categories, forums, threads, posts, attachments, polls, private messages, private message folders, subscribed forums and subscribed threads.

To make it easy to use it is written as a plugin like all the other official importers.


Requirements: vBulletin and IPB 1.1/1.2 on the same MySQL server. It doesn't matter if they are in the same or in different databases (but different databases need the same MySQL user/pass).


Sucsessful imported IPBs
http://forum.gamewizards.net/
http://www.aximsite.com/boards


01/30/03 imports usergroups
worked great ... thanks

[MkJnr]

I have tried to convert my Invision Board using this script and it does all the posts and members and everything it should, just the problem is that it's not converting quotes used:

e.g

This is what a quote shows like in my vB:

<!--QuoteBegin-Mark+Nov 12 2003, 01:36 AM--></span><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (Mark @ Nov 12 2003, 01:36 AM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->

It seems as if it hasn't converted it correctly? Also member's signatures just show up as html rather than BB Code as I was expected. I have Invision Board version 1.2 and the vB 2.3.2 is the one I was converting to.

Thanks for any help,

Mark

[pogo]

Try this to convert the quotes correctly:

Open bbimport_invib.php and change in line 47
$post = preg_replace('#<!--QuoteBegin--([^"]*)\+([^"]*)-->([^"]*)<!--QuoteEBegin-->#siU'to$post = preg_replace('#<!--QuoteBegin-{1,2}([^"]*)\+([^"]*)-->([^"]*)<!--QuoteEBegin-->#si'

Are specific html tags not converted in the signatures or are all tags affected?

[MkJnr]

Hi,

Cheers for that I'll try it out when I try and convert again :)

Here's an example of how a signature shows on the forum:

<img src='http://news.bbc.co.uk/media/images/38275000/jpg/_38275077_juventus_ap300.jpg' border='0' alt='user posted image' /><img src='http://diem101.ing.unibo.it/personale/marra/image/italian_flag_a.gif' border='0' alt='user posted image' /><img src='http://sport.supereva.it/omartin/on.gif' border='0' alt='user posted image' /

So the [IMG] tag hasn't been converted properly I'm guessing?

When there was URL code used it has been converted correctlty however.

Mark

[pogo]

Ok, change line 37 from $post = preg_replace('#<img src=\'([^"]*)\' border=\'0\' alt=\'user posted image\'>#siU', 'https://vborg.vbsupport.ru/', $post);to $post = preg_replace('#<img src=\'([^"]*)\' border=\'0\' alt=\'user posted image\'(\s/)?>#siU', 'https://vborg.vbsupport.ru/', $post);

[CdaKnight]

I have a question: This hasn't been modified to work for Invision Board 1.3 has it? Or does it have the same database schema as 1.2x? I forget. I administrate another vB, and have been looking to get one for myself, but I have IPB 1.3 and would want to move everything (users, attachments, etc) over to the vB when it's purchased.(bloody piece of ++++e PIB is).

So if anybody knows, please reply!

[pogo]

I checked IPB 1.3 and it will work with this script.