PDA

View Full Version : Importing from JForum



StuBramley
Wed 29th Apr '09, 9:16am
Type of import - Clean Import
Source - JForum - 2.1.8
Target - vBulletin 3.8.2
Module - 005 - Import Forum


ImpEx Database errormysql error: Invalid SQL:
INSERT INTO forum
(
styleid, title, description,
options, daysprune, displayorder,
parentid, importforumid, importcategoryid,
title_clean, description_clean
)
VALUES
(
'',
'General',
'!Forum description',
89795,
'30',
'2',
'-1',
'0',
'3',
'General',
'!Forum description'
)


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

mysql error number: 1366

Date: Wednesday 29th 2009f April 2009 01:14:53 PM
Database: vB
MySQL error:

StuBramley
Wed 29th Apr '09, 9:56am
Please ignore this - changing the ImpExConfig.php setting forscesqlmode to true fixed it.

i.e. define('forcesqlmode', true);