stefaandk
Wed 10th Aug '05, 6:22am
Do a fresh install of 3.0.8 and impex, every time I go the Import/Export in the control panel I get the following error:
Database error in vBulletin:ImpEx Target 3.0.8:
Invalid SQL: INSERT INTO TOGvB_vbfields VALUES (1,'userid','INT','NO','access','userid INT(10) UNSIGNED NOT NULL DEFAULT \'0\'','N','NULL','return true;')
mysql error: Table 'VBconvert1.TOGvB_vbfields' doesn't exist
mysql error number: 1146
This however only happens once, I click it again and it goes through OK, still somewhat worried about this as I'm unsure what this means.
FYI: My index.php file
<?php
/*================================================= =====================*\
|| ################################################## ##################// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'localhost';
// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = '*****';
$dbpassword = '*****';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'VBconvert1';
// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$technicalemail = 'dbmaster@example.com';
// ****** PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off.
// 0 = Off; 1 = On
$usepconnect = 0;
// ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
// This setting allows you to change the name of the folders that the admin and
// moderator control panels reside in. You may wish to do this for security purposes.
// Please note that if you change the name of the directory here, you will still need
// to manually change the name of the directory on the server.
$admincpdir = 'admincp';
$modcpdir = 'modcp';
// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user's ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$canviewadminlog = '1';
// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove ("prune") entries from the admin
// log. See the above entry for more information on the format.
$canpruneadminlog = '1';
// ****** 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 = '';
// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$undeletableusers = '';
// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$superadministrators = '';
// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'TOGvB_';
// Prefix that all vBulletin cookies will have
// For example
$cookieprefix = 'bb';
/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 23:00, Sat Aug 6th 2005
|| # CVS: $RCSfile: config.php.new,v $ - $Revision: 1.19 $
|| ################################################## ##################
\*================================================ ======================*/
?>
The ImpExConfig.php file:
[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
;
; If impex is installed in vBulletin you can ignore the target details
; as includes/config.php
targetdatabasetype = mysql
targetserver = localhost
targetuser = "*****"
targetpassword = "*****"
targetdatabase = VBconvert1
targettableprefix = TOGvB_
[ 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
; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "*****"
sourcepassword = "*****"
sourcedatabase = BBconvert1
sourcetableprefix = phpbb_
;| ################################################## ################## |;
;| # File ends with closing PHP tag... # |;
;| ################################################## ################## |;
;*/ ?>
--------
Database error in vBulletin:ImpEx Target 3.0.8:
Invalid SQL: INSERT INTO TOGvB_vbfields VALUES (1,'userid','INT','NO','access','userid INT(10) UNSIGNED NOT NULL DEFAULT \'0\'','N','NULL','return true;')
mysql error: Table 'VBconvert1.TOGvB_vbfields' doesn't exist
mysql error number: 1146
This however only happens once, I click it again and it goes through OK, still somewhat worried about this as I'm unsure what this means.
FYI: My index.php file
<?php
/*================================================= =====================*\
|| ################################################## ##################// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'localhost';
// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = '*****';
$dbpassword = '*****';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'VBconvert1';
// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$technicalemail = 'dbmaster@example.com';
// ****** PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off.
// 0 = Off; 1 = On
$usepconnect = 0;
// ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
// This setting allows you to change the name of the folders that the admin and
// moderator control panels reside in. You may wish to do this for security purposes.
// Please note that if you change the name of the directory here, you will still need
// to manually change the name of the directory on the server.
$admincpdir = 'admincp';
$modcpdir = 'modcp';
// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user's ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$canviewadminlog = '1';
// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove ("prune") entries from the admin
// log. See the above entry for more information on the format.
$canpruneadminlog = '1';
// ****** 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 = '';
// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$undeletableusers = '';
// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$superadministrators = '';
// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'TOGvB_';
// Prefix that all vBulletin cookies will have
// For example
$cookieprefix = 'bb';
/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 23:00, Sat Aug 6th 2005
|| # CVS: $RCSfile: config.php.new,v $ - $Revision: 1.19 $
|| ################################################## ##################
\*================================================ ======================*/
?>
The ImpExConfig.php file:
[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
;
; If impex is installed in vBulletin you can ignore the target details
; as includes/config.php
targetdatabasetype = mysql
targetserver = localhost
targetuser = "*****"
targetpassword = "*****"
targetdatabase = VBconvert1
targettableprefix = TOGvB_
[ 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
; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "*****"
sourcepassword = "*****"
sourcedatabase = BBconvert1
sourcetableprefix = phpbb_
;| ################################################## ################## |;
;| # File ends with closing PHP tag... # |;
;| ################################################## ################## |;
;*/ ?>
--------