Пытался конвертировать phpbb 3.0.11 в ipb 3.3.2 официальным IPS Converters. При попытке перенести пользователей выпадает белый экран с надписью "Служба недоступна". В error.log следующее:

 

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 08 Jan 2013 01:32:50 +0000
Error: 1366 - Incorrect integer value: '' for column 'pp_main_width' at row 1

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO profile_portal (`signature`,`pp_setting_count_comments`,`pp_setting_count_friends`,`pp_member_id`,`pp_thumb_photo`,`pp_main_photo`,`pp_main_width`,`pp_main_height`,`pp_thumb_width`,`pp_thumb_height`,`pp_photo_type`) VALUES('',1,1,37,'','','','','','','')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| \www\forum3\admin\applications_addon\ips\convert\sources\lib_master.php| [db_main_mysql].insert                                                        | 1626              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| \www\forum3\admin\applications_addon\ips\convert\modules_admin\board\phpbb.php| [lib_master].convertMember                                                    | 682               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|                                                                            | [admin_convert_board_phpbb].convert_members                                   |                   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| \www\forum3\admin\applications_addon\ips\convert\modules_admin\board\phpbb.php| [].call_user_func                                                             | 94                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| \www\forum3\admin\sources\base\ipsController.php     | [admin_convert_board_phpbb].doExecute                                         | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

 

Может кто подскажет, что за ерунда и как с этим бороться?

Нужно отключить режим STRICT_TRANS_TABLES (sql_mode) в mysql.

 

http://www.mysqlfaqs.net/mysql-faqs/Client-Server-Commands/What-is-sql-mode-in-MySQL-and-how-can-we-set-it