vb.org Archive - Invision Power Board 1.1 Importer needs testing

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)

- - Invision Power Board 1.1 Importer needs testing (https://vborg.vbsupport.ru/showthread.php?t=48281)

slowroastedx

08-05-2003 03:24 AM

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

Code:

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/im...port_invib.php

Referer: http://www.whatever.a-techweb.com/fo...port_invib.php

pogo	08-05-2003 09:10 AM

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

slowroastedx

08-05-2003 11:54 PM

hmmm ok ill try and see if thats the problem

=DH=Demon

08-13-2003 12:33 AM

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

[high]* =DH=Demon loves you
[/high]

:)

frozen

08-15-2003 11:36 PM

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

09-04-2003 08:57 AM

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

Pogo dear wake up

Salam

tanhadil

09-04-2003 09:02 AM

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	09-04-2003 09:05 AM

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

09-04-2003 03:40 PM

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	09-04-2003 08:51 PM

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

09-05-2003 11:16 AM

sounds cool im going to try this out today

maxboost107

10-12-2003 07:04 PM

I like to test it
green_eyed_prican@yahoo.com

maxboost107

10-12-2003 07:29 PM

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	10-12-2003 08:29 PM

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

MaxScript

10-14-2003 11:36 PM

Quote:

Originally Posted by 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://forum.gamewizards.net/
http://www.aximsite.com/boards

01/30/03 imports usergroups

worked great ... thanks

MkJnr

11-12-2003 07:16 AM

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:

</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'>

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	11-12-2003 09:56 AM

Try this to convert the quotes correctly:

Open bbimport_invib.php and change in line 47

PHP Code:


		
			
$post = preg_replace('#<!--QuoteBegin--([^"]*)\+([^"]*)-->([^"]*)<!--QuoteEBegin-->#siU'

PHP Code:


		
			
$post = preg_replace('#<!--QuoteBegin-{1,2}([^"]*)\+([^"]*)-->([^"]*)<!--QuoteEBegin-->#si'

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

MkJnr

11-12-2003 10:47 AM

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	11-12-2003 03:58 PM

Ok, change line 37 from

PHP Code:


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

PHP Code:


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

CdaKnight

12-09-2003 01:50 AM

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	12-13-2003 07:03 PM

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

All times are GMT. The time now is 04:18 AM.

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01361 seconds Memory Usage 1,776KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (21)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: