Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

VB Post conversion error, edit_time

Submitted eyeIIeye, Dec 18 2010 12:43 AM | Last updated Dec 18 2010 12:43 AM

When attempting to convert posts from vb 3.8.5 to IPB 3.1.4 the following error is encountered.  The specific post cited was not edited in VB & therefore has no associated row in postedithistory.  It would seem edit time should be null ?

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sat, 18 Dec 2010 05:33:25 +0000
Error: 1366 - Incorrect integer value: '' for column 'edit_time' at row 1
IP Address: 127.0.0.1 - /mistyair/ips/admin/index.php?adsess=a3ba6dad42bcc2c4ce57a941cdac23bd&app=convert&module=board&section=vbulletin_legacy
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO posts (`append_edit`,`edit_time`,`edit_name`,`post_edit_reason`,`author_id`,`author_name`,`use_sig`,`use_emo`,`ip_address`,`post_date`,`post`,`queued`,`topic_id`,`post_title`) VALUES(0,'','','',0,'Unregistered',0,1,'206.174.72.121',1241924721,'Help, I\'m having login problems.',0,2,'Test Thread')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| C:\inetpub\wwwroot\mistyair\ips\admin\applications_addon\ips\convert\sources\lib_board.php| [db_main_mysql].insert                                                        | 1069              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| C:\inetpub\wwwroot\mistyair\ips\admin\applications_addon\ips\convert\modules_admin\board\vbulletin_legacy.php| [lib_board].convertPost                                                       | 1059              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|                                                                            | [admin_convert_board_vbulletin_legacy].convert_posts                          |                   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| C:\inetpub\wwwroot\mistyair\ips\admin\applications_addon\ips\convert\modules_admin\board\vbulletin_legacy.php| [].call_user_func                                                             | 192               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| C:\inetpub\wwwroot\mistyair\ips\admin\sources\base\ipsController.php       | [admin_convert_board_vbulletin_legacy].doExecute                              | 285               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Status:	Cannot Reproduce
Version:
Fixed In:

3 Comments

eyeIIeye

Dec 18 2010 01:24 PM

I got around the issue by adding:

if (!$info['edit_time'] || $info['edit_time'] == '')
{ unset($info['edit_time']); }

to the convertPost function.

Guest

Dec 27 2010 11:16 AM

Updating status to: Confirmed - General
Updating severity to: 1 - Low

Are you using MySQL 5 in strict mode?

Guest

Jan 18 2011 03:25 PM

Updating status to: Cannot Reproduce

Will occur if edit_time column is set to NOT NULL in strict mode. Can't reproduce in default install.

VB Post conversion error, edit_time

3 Comments

Sign In