ImpEx Build v. 1.83 и phpBB 2.0.22

08-05-2007, 01:42 PM

Добрый день.

Проблема следующая, имеется БД от форума phpBB 2.0.16 и ImpEx 1.83. При попытке экспорта на этапе Import usergroup выдет ошибку в SQL запросе:

Code:

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

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

mysql error number: 1366

Date: Sunday 05th 2007f August 2007 02:41:30 PM
Database: vb
MySQL error:

И:

Code:

ImpEx Database errormysql error: Invalid SQL: SELECT * FROM phpbb_groups WHERE group_single_user=0 ORDER BY group_id LIMIT , 50

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 50' at line 1

mysql error number: 1064

Date: Sunday 05th 2007f August 2007 02:42:22 PM
Database: phpbbtim
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 50' at line 1

Ну и следовательно дальше ничего сделать нельзя.

Попытался обновить БД phpBB до версии 2.0.22. Ошибки остались те же.