Impex - database errors

[nxl1]

Type of import - MERGE
Source board system and version - Yahoo eGroups in a .mdb file
Target version - vBulletin v3.6.0
Module issue occurred on - 001 (check and update database)

I am not sure how to point to the .mdb file to import it either to do the import.


It made it this far through the module:

moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
usernote - importusernoteid OK




Then I get the error message. Any ideas as to how to fix this or where to start would greatly be appreciated. Thanks.

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',
'Imported Users',
'',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Field 'uploaderperm' doesn't have a default value
mysql error number: 1364
Date: Thursday 24th 2006f August 2006 09:33:50 AM
Database: ambpforum
MySQL error: Field 'uploaderperm' doesn't have a default value

[Jerry]

Your MySQL is running it strict mode, in your ImpExConfig, set this :



define('forcesqlmode', true);

[nxl1]

Thanks Jerry, that got me a little further. Now it is asking me to define the source database. I am not sure what exactly I need to put in here. Our source data base is Yahoo Egroups. I realize that I probably use the master user name and password that I log into the site with and probably use the URL for the location but it also wants to know what the database is called and what type of database it is.

[Jerry]

The yahoo groups import import from either a flat file of the mail back up or a MySQL database.

[nxl1]

This is the error message I am getting now:

Parse error: syntax error, unexpected T_STRING in C:\Inetpub\wwwroot\ambpforum\forums\impex\ImpExCon fig.php on line 36

(line 36 is the user name of the source database)

This is the settings in the ImpExConfig.php file:

if (!defined('IDIR')) { die; }
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = '********';
$impexconfig['target']['password'] = '********';
$impexconfig['target']['database'] = 'vbulletin';
$impexconfig['target']['tableprefix'] = '';

# 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
$impexconfig['sourceexists'] = true;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'http://groups.yahoo.com;
$impexconfig['source']['user'] = '********';
$impexconfig['source']['password'] = '********';
$impexconfig['source']['database'] = 'AccountMate_Community';
$impexconfig['source']['tableprefix'] = '';

I am not sure what setting's I need to put in the source to connect to the yahoo groups or the .mdb file I have backed up on my desktop. Please let me know if you know what I should enter here.

Thanks,

Brady

[Jerry]

The mdb file will need converting into MySQL then restoring, I can do the database conversation so you can carry on if you contact me via PM or in the support area.

[nxl1]

Hi Jerry,

I have got the adminmyphp running and created a new database of "ygroups", I click on the new database to select it and then click on Import to import the ygroups.sql file you had converted for me, then I click on "GO" and it sits for a bit and thinks then gives me a "page cannot be displayed error". Am I doing something wrong?

[Jerry]

Restore it via the command line, its much more reliable.

[nxl1]

Is this error below something I should worry about?




The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results..

[Jerry]

Yes, use the command line to restore the data.