Dolibarr ERP & CRM » Bugs » bug #1783 SQL error when enabling 3rd party module with MySQL strict mode ONSnapshot| Details |
| Submitted by: | Marcos García (marcosgdf) | | Submitted on: | 2015-01-02 19:08 |
| Last Modified On: | 2015-01-02 19:08 | |
| Summary: | SQL error when enabling 3rd party module with 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: | None |
| Resolution: | None | |
Answer now
|
|
|
|
|
|
|