Jump to content


Issue information

  • #035729

  • Fixed

  • 3.3.0 Beta 1

  • 3.3.0 Beta 1

  • 5 - Critical


Issue Confirmations

  • Yes (0)No (0)
Photo

Driver error archiving posts

Posted by teraßyte on 06 February 2012 - 06:00 AM

Log says it all, strict mode error:
mySQL query error: INSERT INTO forums_archive_posts (`archive_id`,`archive_author_id`,`archive_author_name`,`archive_ip_address`,`archive_content_date`,`archive_content`,`archive_queued`,`archive_topic_id`,`archive_is_first`,`archive_bwoptions`,`archive_added`,`archive_attach_key`,`archive_html_mode`,`archive_show_signature`,`archive_show_emoticons`,`archive_show_edited_by`,`archive_edit_time`,`archive_edit_name`,`archive_edit_reason`) VALUES(705,2,'test','127.0.0.1',1317056533,'reply from test',0,291,0,0,1328525903,'ef2b167c92c48da0e0b653dc5a573f55',0,1,1,0,'','','') ON DUPLICATE KEY UPDATE archive_id=VALUES(archive_id),archive_author_id=VALUES(archive_author_id),archive_author_name=VALUES(archive_author_name),archive_ip_address=VALUES(archive_ip_address),archive_content_date=VALUES(archive_content_date),archive_content=VALUES(archive_content),archive_queued=VALUES(archive_queued),archive_topic_id=VALUES(archive_topic_id),archive_is_first=VALUES(archive_is_first),archive_bwoptions=VALUES(archive_bwoptions),archive_added=VALUES(archive_added),archive_attach_key=VALUES(archive_attach_key),archive_html_mode=VALUES(archive_html_mode),archive_show_signature=VALUES(archive_show_signature),archive_show_emoticons=VALUES(archive_show_emoticons),archive_show_edited_by=VALUES(archive_show_edited_by),archive_edit_time=VALUES(archive_edit_time),archive_edit_name=VALUES(archive_edit_name),archive_edit_reason=VALUES(archive_edit_reason)
SQL error: Incorrect integer value: '' for column 'archive_edit_time' at row 1
SQL error code: 1366
Date: Monday 06th February 2012 10:58:24 AM

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 06 Feb 2012 10:58:24 +0000
Error: 1366 - Incorrect integer value: '' for column 'archive_edit_time' at row 1
IP Address: 127.0.0.1 - /admin/index.php?adsess=0765404bfff5e7143125248f6fc5526f&app=core&module=system&section=taskmanager&do=task_run_now&task_id=77&tab=core
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forums_archive_posts (`archive_id`,`archive_author_id`,`archive_author_name`,`archive_ip_address`,`archive_content_date`,`archive_content`,`archive_queued`,`archive_topic_id`,`archive_is_first`,`archive_bwoptions`,`archive_added`,`archive_attach_key`,`archive_html_mode`,`archive_show_signature`,`archive_show_emoticons`,`archive_show_edited_by`,`archive_edit_time`,`archive_edit_name`,`archive_edit_reason`) VALUES(705,2,'test','127.0.0.1',1317056533,'reply from test',0,291,0,0,1328525903,'ef2b167c92c48da0e0b653dc5a573f55',0,1,1,0,'','','') ON DUPLICATE KEY UPDATE archive_id=VALUES(archive_id),archive_author_id=VALUES(archive_author_id),archive_author_name=VALUES(archive_author_name),archive_ip_address=VALUES(archive_ip_address),archive_content_date=VALUES(archive_content_date),archive_content=VALUES(archive_content),archive_queued=VALUES(archive_queued),archive_topic_id=VALUES(archive_topic_id),archive_is_first=VALUES(archive_is_first),archive_bwoptions=VALUES(archive_bwoptions),archive_added=VALUES(archive_added),archive_attach_key=VALUES(archive_attach_key),archive_html_mode=VALUES(archive_html_mode),archive_show_signature=VALUES(archive_show_signature),archive_show_emoticons=VALUES(archive_show_emoticons),archive_show_edited_by=VALUES(archive_show_edited_by),archive_edit_time=VALUES(archive_edit_time),archive_edit_name=VALUES(archive_edit_name),archive_edit_reason=VALUES(archive_edit_reason)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| XXXXXXXXXXXXXXXXXXXX\admin\sources\classes\archive\writer\sql.php		  | [db_main_mysql].replace													   | 163			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| XXXXXXXXXXXXXXXXXXXX\admin\sources\classes\archive\writer.php			  | [classes_archive_writer_sql].set											  | 202			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| XXXXXXXXXXXXXXXXXXXX\admin\sources\classes\archive\writer.php			  | [classes_archive_writer].write												| 399			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| XXXXXXXXXXXXXXXXXXXX\admin\applications\core\tasks\archive.php			 | [classes_archive_writer].processBatch										 | 92				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| XXXXXXXXXXXXXXXXXXXX\admin\applications\core\modules_admin\system\taskmanager.php| [task_item].runTask													 | 470			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| XXXXXXXXXXXXXXXXXXXX\admin\applications\core\modules_admin\system\taskmanager.php| [admin_core_system_taskmanager].taskManagerRunTask					  | 97				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| XXXXXXXXXXXXXXXXXXXX\admin\sources\base\ipsController.php				  | [admin_core_system_taskmanager].doExecute									 | 302			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

changed status to: Fixed
changed fixed-in version to: 3.3.0 Beta 1





1 user(s) are reading this issue

0 members, 1 guests, 0 anonymous users