PDA

View Full Version : Snitz to VB



Rahro
Wed 29th Apr '09, 11:53am
hello
i faced an error when i was importing from a MS-SQL db ( Snitz ) to MySql (VBulletin ), and error is :

Remove ImpEx once import is complete and final
ImpEx build version : 1.92 You do not have MSSQL support in this version/compile of php, the importer will not be able to connect to the source database.

what should i do ?

Zachery
Wed 29th Apr '09, 12:04pm
You should contact your host and ask if its possible to get MSSQL support compiled in.

Rahro
Sat 2nd May '09, 3:24am
whilde importing data from snitz this error happened :

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',
'Usergroup description',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)


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

mysql error number: 1366

Date: Saturday 02nd 2009f May 2009 06:06:57 AM
Database: vb_forum
MySQL error: Incorrect integer value: '' for column 'passwordhistory' at row 1

-----------
what should i do ?

Rahro
Sat 2nd May '09, 8:10am
wont any body answer me ?:mad: