Hi,
Been trying to migrate from webwiz and doing a test run to try and import. Have WebWiz running on MS-SQL Express 2005, but can't seem to use the importer to contact this SQL server. So i decided to use intelligent converter's MSSQL-to-MySQL to move a test database over to MySQL and try to import from MySQL.
So far... have moved a test database and when I try to import, I get a success with all tables except for tblActiveUsers and tblBookmarks but i don't have these tables in WebWiz anyway...
However, when I try to import usegroups I get this error:
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
(
'1',
'Admin Group',
'Admin Group',
'',
0,
'',
mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
mysql error number: 1366
Date: Friday 01st 2007f June 2007 04:20:18 PM
Database: forum
I am trying to import into 3.6.7 and i might also add, i had to change the 000.php in the webwiz impex so that the array was turned into lowercase... ie Author became author, because since I am running windows, the tables in MySQL are seen in lowercase for some reason....
I could not find a workaround for the tables to be recognised in upper and lower case... Has anyone else had any experiences with WebWiz on a windows based machine moving from MSSQL or MySQL?
Been trying to migrate from webwiz and doing a test run to try and import. Have WebWiz running on MS-SQL Express 2005, but can't seem to use the importer to contact this SQL server. So i decided to use intelligent converter's MSSQL-to-MySQL to move a test database over to MySQL and try to import from MySQL.
So far... have moved a test database and when I try to import, I get a success with all tables except for tblActiveUsers and tblBookmarks but i don't have these tables in WebWiz anyway...
However, when I try to import usegroups I get this error:
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
(
'1',
'Admin Group',
'Admin Group',
'',
0,
'',
mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
mysql error number: 1366
Date: Friday 01st 2007f June 2007 04:20:18 PM
Database: forum
I am trying to import into 3.6.7 and i might also add, i had to change the 000.php in the webwiz impex so that the array was turned into lowercase... ie Author became author, because since I am running windows, the tables in MySQL are seen in lowercase for some reason....
I could not find a workaround for the tables to be recognised in upper and lower case... Has anyone else had any experiences with WebWiz on a windows based machine moving from MSSQL or MySQL?
Comment