phpbb3 to vb 3.8 ISSUES

[Bulldog Stang]

I keep getting this error and I have no idea what is wrong. I have checked the user names, passwords, and the db information and all looks to be fine ... I have searched the site, but have not found the answer so I am posting this thread ...

Here is the error code i get after i click on Start Module for Module 001:

ImpEx Database errormysql error: Invalid SQL:
INSERT INTO usergroup
(
importusergroupid, title, description,
usertitle, passwordexpires, passwordhistory,
pmquota, pmsendmax,
opentag, closetag, canoverride,
ispublicgroup, forumpermissions, pmpermissions,
calendarpermissions, wolpermissions, adminpermissions,
genericpermissions, genericoptions, attachlimit,
avatarmaxwidth, avatarmaxheight, avatarmaxsize,
profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize,
signaturepermissions, sigpicmaxwidth, sigpicmaxheight,
sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars,
sigmaxrawchars, sigmaxlines
)
VALUES
(
'69',
'Active Imported Users',
'Usergroup description',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)


mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1

mysql error number: 1366

Date: Tuesday 20th 2009f January 2009 02:19:37 PM
Database: xxxxxxxxxxxxxx (I removed this for obvious reasons)
MySQL error:


Any help is greatly appreciated ....

[Jerry]

Set this in your ImpExConfig.



define('forcesqlmode', true);

[Bulldog Stang]

Set this in your ImpExConfig.



define('forcesqlmode', true);



That worked, but now I get this ....


moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed Failed Check database permissions and connection, or table prefix to ensure its correct

I checked the table prefix and compared it to the config.php file in the phpbb3 folder. It is "phpbb_" ... any thoughts ?

[Steve Machol]

You need to edit ImpExConfig.php and change the source table prefix to: phpbb_

[Bulldog Stang]

same thing ... I am at a loss...

[Steve Machol]

You can't get the exact same message if you did that. What's the new one?

[Bulldog Stang]

subscriptionlog - importsubscriptionlogid Completed Failed Check database permissions and connection, or table prefix to ensure its correct

[Bulldog Stang]

Can I post the whole code here and have you take a look at it ??

[Steve Machol]

Please post the complete message.

[Bulldog Stang]

Altering tables

ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed Failed Check database permissions and connection, or table prefix to ensure its correct

[Bulldog Stang]

Here is the code that I have changed/typed in ... I removed the passwords ...

$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'octanezonedb';
$impexconfig['target']['password'] = '**********';
$impexconfig['target']['database'] = 'octanezoneforum';
$impexconfig['target']['tableprefix'] = '';


$impexconfig['source']['databasetype'] = 'mysqli'; // mysql OR mssql
$impexconfig['source']['server'] = 'rack4.cyberbay.com';
$impexconfig['source']['user'] = 'octane';
$impexconfig['source']['password'] = '*********';
$impexconfig['source']['database'] = 'octane';
$impexconfig['source']['tableprefix'] = 'phpbb_';

[Steve Machol]

The most likely cause now is that the target db info in ImpExConfig.php is wrong.

[Steve Machol]

$impexconfig['source']['server'] = 'rack4.cyberbay.com';

It is very unlikely that you will be able to import data from another server. You will need to move that phpBB database to the same server that is running vB.

[Bulldog Stang]

they are on the same server .. when I log into my ftp, they are both installed in the root folder .. I have the "forums" folder in there as well as the "phpbb3" folder in there ...

[Bulldog Stang]

should both of the servers be set to the rack4.cyberbay.com or to localhost ??

[Steve Machol]

Then you should use the same server name.

[Bulldog Stang]

OK. I used the server name "rack4.cyberbay.com" and the "localhost" on both. I still get the same message ...

[Bulldog Stang]

I have been at this for a week. I have been on the phone with the Host for 4 hours and we could not figure out what was wrong or going on.

If I have to start from scratch, then that is fine, I was just hoping to save the members and their post ...

[Steve Machol]

The info in your ImpExConfig.php file is wrong. Otherwise you would not get this message:

Failed Check database permissions and connection, or table prefix to ensure its correct

We have no way of knowing what your info is. However the target info should be the same as what is in the vB config.php file.

[Bulldog Stang]

Thats just it. I have checked the Target info in the config.php file and it all looks correct ...

Here is the target info from my config.php file ...

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'octanezoneforum';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'octanezonedb';
$config['MasterServer']['password'] = 'xxxxxxxxxx'; Password Removed

[Bulldog Stang]

Here is the info from the config.php file from the phpbb3 folder ...

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysqli';
$dbhost = 'rack4.cyberbay.com';
$dbport = '';
$dbname = 'octane';
$dbuser = 'octane';
$dbpasswd = 'xxxxxxxxxx';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

[Steve Machol]

Then this means your source db info is wrong. It has to be one or the other.

[Bulldog Stang]

Thank You for taking the time to help me ...

[Bulldog Stang]

I think I found it ... In the ImpexConfig file, I had this ...

$impexconfig['source']['databasetype'] = 'mysqli'; // mysql OR mssql

I removed the "i" and this is what i got ....

Altering tables

ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

Valid found tables :

phpbb_acl_groups found.
phpbb_acl_options found.
phpbb_acl_roles found.
phpbb_acl_roles_data found.
phpbb_acl_users found.
phpbb_attachments found.
phpbb_banlist found.
phpbb_bbcodes found.
phpbb_bookmarks found.
phpbb_bots found.
phpbb_config found.
phpbb_confirm found.
phpbb_disallow found.
phpbb_drafts found.
phpbb_extension_groups found.
phpbb_extensions found.
phpbb_forums found.
phpbb_forums_access found.
phpbb_forums_track found.
phpbb_forums_watch found.
phpbb_groups found.
phpbb_icons found.
phpbb_lang found.
phpbb_log found.
phpbb_moderator_cache found.
phpbb_modules found.
phpbb_poll_options found.
phpbb_poll_votes found.
phpbb_posts found.
phpbb_privmsgs found.
phpbb_privmsgs_folder found.
phpbb_privmsgs_rules found.
phpbb_privmsgs_to found.
phpbb_profile_fields found.
phpbb_profile_fields_data found.
phpbb_profile_fields_lang found.
phpbb_profile_lang found.
phpbb_ranks found.
phpbb_reports found.
phpbb_reports_reasons found.
phpbb_search_results found.
phpbb_search_wordlist found.
phpbb_search_wordmatch found.
phpbb_sessions found.
phpbb_sessions_keys found.
phpbb_sitelist found.
phpbb_smilies found.
phpbb_styles found.
phpbb_styles_imageset found.
phpbb_styles_template found.
phpbb_styles_template_data found.
phpbb_styles_theme found.
phpbb_topics found.
phpbb_topics_posted found.
phpbb_topics_track found.
phpbb_topics_watch found.
phpbb_user_group found.
phpbb_users found.
phpbb_warnings found.
phpbb_words found.
phpbb_zebra found.

If you have all red tables, i.e. none correct this could possible be your table prefix :

phpbb_


So I am assuming it worked ????

[Steve Machol]

Yep, it looks like you got it. :)

[Bulldog Stang]

Thanks a Million Steve for taking the time out of your busy schedule to sit here and assist me through this :)