Dolibarr ERP & CRM » Bugs » bug #1783 SQL error when enabling 3rd party module with PostgreSQL and MySQL strict mode ONLatest modifications
Answer now
Snapshot Details |
Submitted by: | Marcos García (marcosgdf) | | Submitted on: | 2015-01-02 19:08 |
Last Modified On: | 2015-01-17 19:36 | |
Summary: | SQL error when enabling 3rd party module with PostgreSQL and MySQL strict mode ON |
Description: | DoliDBMysqli::query SQL error: INSERT INTO llx_menu(menu_handler,entity,module,type,mainmenu,leftmenu,fk_menu,fk_mainmenu,fk_leftmenu,position,url,target,titre,langs,perms,enabled,usertype) VALUES ( 'all', '1', 'YYYYYYYYY', 'top', 'ZZZZZZ', null, '0', null, null, '', '/UUUUUUU/area.php', '', 'XXXXXXXX', '', '1', '$conf->UUUUUUU->enabled', '2') DB_ERROR_1366 Incorrect integer value: '' for column 'position' at row 1 |
Step to reproduce bug: | // Main menu entries
$this->menu = array(
array(
'fk_menu' => 0,
'type' => 'top',
'mainmenu' => 'YYYYYYYYY',
'titre' => 'YYYYYYYYY',
'enabled' => '$conf->YYYYYYYYY->enabled',
'url' => '/YYYYYYYYY/area.php',
'perms' => 1,
'user' => 2
),
array(
'fk_menu' => 'fk_mainmenu=YYYYYYYYY',
'type' => 'left',
'titre' => 'YYYYYYYYY',
'leftmenu' => 'YYYYYYYYY',
'mainmenu' => 'YYYYYYYYY',
'enabled' => '$conf->YYYYYYYYY->enabled',
'url' => '/YYYYYYYYY/area.php',
'perms' => 1,
'user' => 2
),
array(
'fk_menu' => 'fk_mainmenu=YYYYYYYYY,fk_leftmenu=YYYYYYYYY',
'type' => 'left',
'titre' => 'Nueva',
'leftmenu' => 'YYYYYYYYY',
'mainmenu' => 'YYYYYYYYY',
'enabled' => '$conf->YYYYYYYYY->enabled',
'url' => '/YYYYYYYYY/crear.php',
'perms' => '$user->rights->YYYYYYYYY->create',
'user' => 2
),
array(
'fk_menu' => 'fk_mainmenu=YYYYYYYYY,fk_leftmenu=YYYYYYYYY',
'type' => 'left',
'titre' => 'Listado',
'leftmenu' => 'YYYYYYYYY',
'mainmenu' => 'YYYYYYYYY',
'enabled' => '$conf->YYYYYYYYY->enabled',
'url' => '/YYYYYYYYY/listado.php',
'perms' => 1,
'user' => 2
),
); |
Detected in version: | 3.6.1 | | Category: | Core Problem |
Severity: | 5 - Major | | OS Type/Version: | |
PHP version: | | | Database type and version: | |
Status |
Status: | Open | | Assigned to: | Marcos García (marcosgdf) |
Resolution: | Fixed | |
Comments- Marcos GarcĂa 2015-01-17 19:37
- The bug has been corrected. Pull request send inside GIT sources
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch. |
|
|
|
|
|
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch.
None→ Fixed