vb.org Archive

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.


All times are GMT. The time now is 02:25 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01182 seconds
  • Memory Usage 1,740KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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