phpBB to vb transformation problem

[y2ksa]

Hi I have a problem transforming my phpBB2 forum to vb i got this error

Plus I got this error:

Database error in vBulletin:ImpEx Target 3.0.1:

cannot use database

mysql error: No Database Selected

mysql error number: 1046

And now i cant see the "Import / Export" it dos not load how can I get it back the page remains blank

Do I have to reinstall my vb again?

Please advice

[Zachery]

Have you edited the file Impexconfig.php ?

[y2ksa]

Yes I did every thing correctly

But the beginning I forgot to change the sourceexists to TRUE but I still cant get the

"Import / Export" page to appear

[Zachery]

Can you paste the contents of your impexconfig file here?

[y2ksa]

;vBulletin:Impex Config File<?php /*
;| #################################################################### |;
;| # vBulletin 3.0.1 - Licence Number
;| # ---------------------------------------------------------------- # |;
;| # Copyright ©2000–2004 Jelsoft Enterprises Ltd. All Rights Reserved. |;
;| # This file may not be redistributed in whole or significant part. # |;
;| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
;| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
;| #################################################################### |;

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.

targetdatabasetype = mysql
targetserver = localhost
targetuser = aratop_vb
targetpassword = ******
targetdatabase = aratop_vb
targettableprefix =
[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

sourceexists = TRUE

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = aratop_ara2
sourcepassword = *******
sourcedatabase = aratop_aratop2
sourcetableprefix = phpbb_
;| #################################################################### |;
;| # File ends with closing PHP tag... # |;
;| #################################################################### |;
;*/ ?>

[Zachery]

And all the files have been uploaded to a folder called impex in the root forum directory?

forums/impex
?

[y2ksa]

yes

[Zachery]

Just for future refrence dont post your license number anywhere i did remove it above.

http://www.vbulletin.com/forum/showpost.php?p=670237&postcount=10

Try running the querys in that file and starting again.

[y2ksa]

lol sorry im anoob

[Zachery]

We all are at some point any luck with getting things to work?

[y2ksa]

do i run the querys from Execute SQL Query?
if so i get this message:You are not authorized to execute SQL queries

[Zachery]

You can run it from phpmyadmin as well


To fix the error mesage

edit the regular config.php and add your userid to the bit below

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'X'; 

Replace X with your userid

[y2ksa]

ok i used phpmyadmin and i got this

SQL-query :
UPDATE ranks SET importranksid =0
MySQL said:

#1054 - Unknown column 'importranksid' in 'field list'

[Zachery]

DELETE FROM datastore WHERE title='ImpExSession';
That is the only important one.

[y2ksa]

Thankx man it's working now