import error - please help

[mikelo]

Dear Support,

I just purchased your vbulletin program today. I am attempting to import my existing database from phpbb 2.18 Anyway, when I click on import in the admin control panel, I receive the following errors:

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(): Failed opening './includes/adminfunctions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mailm4/public_html/forums/impex/index.php on line 97
Connection to source server failed. Check username and password.

Any help most appreciated.

Mike

[Jerry]

Are you running ImpEx installed or standalone, and what version of vBulletin are you importing into ?

[mikelo]

Hi Jerry,

I am not sure which method - install or standalone I am running - I installed vbulletin owned (3.6.0) and downloaded impex from my member's website. I then changed the config file and uploaded the impex directory. I then went to the admin panel and hit import- the program asked me for my userid and then displayed the above errors.

Regards,
Mike

[Steve Machol]

This line indicates you are missing the ./includes/adminfunctions.php file. Either you have not installed Impex in the correct directory, or you are in fact missing that file.

[Jerry]

Well the warnings come from ImpEx not being in the dir it thinks it is, though the bigger issue, is the :


Connection to source server failed. Check username and password.

That means the source database isn't being connected to, you'll need to check the user/pass and connectivity.

[mikelo]

Hi Steve,

The impex folder is installed in the forums directory per the instructions. I do see adminfunctions.php in the includes directory.

Out of curiousity, I removed the information in impexconfig.php

and I am now recieving a new error:

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(): Failed opening './includes/adminfunctions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mailm4/public_html/forums/impex/index.php on line 97

There seems to have been a problem with the database.

ImpEx Database errormysql error: Invalid SQL: INSERT INTO vbfields VALUES ('newpostemail', 'forum', 'N', '!##NULL##!', 'return true;', 'vbulletin')

mysql error: Table 'mailm4_vbulletin.vbfields' doesn't exist

mysql error number: 1146

Date: Tuesday 29th of August 2006 11:13:56 AM
Database: mailm4_vbulletin
MySQL error: Table 'mailm4_vbulletin.vbfields' doesn't exist

Pleae let me know how I resolve this.

Regards,
Mike

[mikelo]

Hi Guys,

I have another quick question - in impexconfig.php I assigned the following value:
$impexconfig['source']['tableprefix'] = 'phpbb_';
is that the correct setup for tables in my database that
have phpbb_ before them? I am wondering if it should not be just phpbb if the underscore is assumed. Please let me know.

Regards,
Mike

[Jerry]

Out of curiousity, I removed the information in impexconfig.php


If you removed the config, then ImpEx isn't going to be able to connect at all.

the impex/ folder is in your forum in the same dir as the admincp/ folder ?

The target details in ImpExConfig are the same as includes/config for vBulletin and the source user/pass has permissions to the phpBB database ?

[mikelo]

Hi Jerry,

All I did was remove the target information - NOT all the information based upon the following:
# If impex is installed in vBulletin you can ignore the target details
# as includes/config.php

When I did this, in addition to the errors before, I received the following:

There seems to have been a problem with the database.

ImpEx Database errormysql error: Invalid SQL: INSERT INTO vbfields VALUES ('newpostemail', 'forum', 'N', '!##NULL##!', 'return true;', 'vbulletin')

mysql error: Table 'mailm4_vbulletin.vbfields' doesn't exist

mysql error number: 1146

Date: Tuesday 29th of August 2006 11:13:56 AM
Database: mailm4_vbulletin
MySQL error: Table 'mailm4_vbulletin.vbfields' doesn't exist

With regards to " the impex/ folder is in your forum in the same dir as the admincp/ folder ?"
yes it is - but I renamed my admincp "admin"

The source user/pass does have permissions to the phpbb database.

Regards,
Mike

[mikelo]

One correction to my last post - the source pass was incorrect - I have fixed this and no longer receive the connection to source server failed message. I do however still receive everything else:

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(): Failed opening './includes/adminfunctions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mailm4/public_html/forums/impex/index.php on line 97

ImpEx Database errormysql error: Invalid SQL: INSERT INTO vbfields VALUES ('lastthreadid', 'forum', 'N', '!##NULL##!', 'return true;', 'vbulletin')

mysql error: Table 'mailm4_vbulletin.vbfields' doesn't exist

mysql error number: 1146

Date: Tuesday 29th of August 2006 11:38:59 AM
Database: mailm4_vbulletin
MySQL error: Table 'mailm4_vbulletin.vbfields' doesn't exist

[mikelo]

One more update - I included all the target information in impexconfig.php and now receive a screen with the following:
ImpEx build version : 1.65
Database cleanup & restart ||| Online manual

Using includes/config.php for target config.


and a bunch of menus to select, etc

However, I still receive the following error messages at the top:

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(): Failed opening './includes/adminfunctions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mailm4/public_html/forums/impex/index.php on line 97


Is it safe to proceed? Please let me know.

[Jerry]

You have posted 3 different things now.

Can you please stick to one issue before posing again.

I suggest running ImpEx standalone.

[mikelo]

Hi jerry,

I am not sure what you mean by saying that I have posted three different things. All I have done is posted updates to my original issue. Where I stand now is I receive the following:

I receive a screen with:
ImpEx build version : 1.65
Database cleanup & restart ||| Online manual

Using includes/config.php for target config.


and a bunch of menus to select, etc seemingly to begin the import. However, I still receive the following warning error messages at the top:

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(./includes/adminfunctions.php): failed to open stream: No such file or directory in /home/mailm4/public_html/forums/impex/index.php on line 97

Warning: main(): Failed opening './includes/adminfunctions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mailm4/public_html/forums/impex/index.php on line 97


Is it safe to proceed with the import even though I am still receiving warning messages?

What do you mean by running the program standalone? All I have done is followed the instructions for installing impex at: http://www.vbulletin.com/docs/html/

Best Regards,
Mike

[Jerry]

Standalone means outside of the vBulletin dir, and yes you can carry on with thoses warnings.

[cfish]

I was getting the exact same errors when running Impex. Then I remembered that I had renamed the admincp folder (security reasons). Impex assumes that folder is called "admincp" and so does not find what it is looking for. I renamed admincp back to it's default name and the errors went away.

Lesson:

Don't rename admincp until your import is complete.

[Jerry]

I was getting the exact same errors when running Impex. Then I remembered that I had renamed the admincp folder (security reasons). Impex assumes that folder is called "admincp" and so does not find what it is looking for. I renamed admincp back to it's default name and the errors went away.

Lesson:

Don't rename admincp until your import is complete.

Or just run ImpEx standalone.