I get this error when trying to save.
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'hidden' at row 1: UPDATE {menu_links} SET menu_name=:db_update_placeholder_0, plid=:db_update_placeholder_1, link_path=:db_update_placeholder_2, router_path=:db_update_placeholder_3, hidden=:db_update_placeholder_4, external=:db_update_placeholder_5, has_children=:db_update_placeholder_6, expanded=:db_update_placeholder_7, weight=:db_update_placeholder_8, depth=:db_update_placeholder_9, p1=:db_update_placeholder_10, p2=:db_update_placeholder_11, p3=:db_update_placeholder_12, p4=:db_update_placeholder_13, p5=:db_update_placeholder_14, p6=:db_update_placeholder_15, p7=:db_update_placeholder_16, p8=:db_update_placeholder_17, p9=:db_update_placeholder_18, module=:db_update_placeholder_19, link_title=:db_update_placeholder_20, options=:db_update_placeholder_21, customized=:db_update_placeholder_22 WHERE (mlid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => main-menu [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => node/264 [:db_update_placeholder_3] => node/% [:db_update_placeholder_4] => [:db_update_placeholder_5] => 0 [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 0 [:db_update_placeholder_8] => -50 [:db_update_placeholder_9] => 1 [:db_update_placeholder_10] => 3578 [:db_update_placeholder_11] => 0 [:db_update_placeholder_12] => 0 [:db_update_placeholder_13] => 0 [:db_update_placeholder_14] => 0 [:db_update_placeholder_15] => 0 [:db_update_placeholder_16] => 0 [:db_update_placeholder_17] => 0 [:db_update_placeholder_18] => 0 [:db_update_placeholder_19] => menu [:db_update_placeholder_20] => Galería [:db_update_placeholder_21] => a:2:{s:10:"attributes";a:0:{}s:5:"alter";b:1;} [:db_update_placeholder_22] => 1 [:db_condition_placeholder_0] => 3578 ) en menu_link_save() (línea 3199 de /Applications/MAMP/htdocs/mysite.com/includes/menu.inc).
Comment | File | Size | Author |
---|---|---|---|
#10 | menu_editor-7.x-1.x-hidden-items-pdo-exception-1922278-10.patch | 852 bytes | donquixote |
#9 | menu_editor-7.x-1.x-hidden-items-pdo-exception-1922278-9.patch | 849 bytes | donquixote |
#5 | menu_editor-7.x-1.x-hidden-item-checkbox-1922278-5.patch | 669 bytes | donquixote |
#4 | pdo_menu-editor.jpg | 94.16 KB | jci |
Comments
Comment #1
jci CreditAttribution: jci commentedhave to agree... such a great module, but this error is really annoying.
Comment #2
donquixote CreditAttribution: donquixote commentedCan you give me a stack trace?
Or any other information?
Comment #3
donquixote CreditAttribution: donquixote commentedGuys, please, a stack trace!
Comment #4
jci CreditAttribution: jci commentedOkay, here is how it shows up:
I just (de)activate a menu link through this module and before I save, I rearrange some links. After clicking on save I got the error message.
Here are the screenshots:
Comment #5
donquixote CreditAttribution: donquixote commentedCan you try with the latest -dev from today (or latest beta, that's the same), and this patch?
Comment #6
jci CreditAttribution: jci commentedwill give it a try, give you some feedback in the next few days - thx
Comment #7
webmestre CreditAttribution: webmestre commentedI applyed the last patch and got the following message :
Comment #8
liza CreditAttribution: liza commentedSame exact error:
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'hidden' at row 1: UPDATE {menu_links} SET menu_name=:db_update_placeholder_0, plid=:db_update_placeholder_1, link_path=:db_update_placeholder_2, router_path=:db_update_placeholder_3, hidden=:db_update_placeholder_4, external=:db_update_placeholder_5, has_children=:db_update_placeholder_6, expanded=:db_update_placeholder_7, weight=:db_update_placeholder_8, depth=:db_update_placeholder_9, p1=:db_update_placeholder_10, p2=:db_update_placeholder_11, p3=:db_update_placeholder_12, p4=:db_update_placeholder_13, p5=:db_update_placeholder_14, p6=:db_update_placeholder_15, p7=:db_update_placeholder_16, p8=:db_update_placeholder_17, p9=:db_update_placeholder_18, module=:db_update_placeholder_19, link_title=:db_update_placeholder_20, options=:db_update_placeholder_21, customized=:db_update_placeholder_22 WHERE (mlid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => navigation [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => filter/tips [:db_update_placeholder_3] => filter/tips [:db_update_placeholder_4] => [:db_update_placeholder_5] => 0 [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 0 [:db_update_placeholder_8] => 0 [:db_update_placeholder_9] => 1 [:db_update_placeholder_10] => 3 [:db_update_placeholder_11] => 0 [:db_update_placeholder_12] => 0 [:db_update_placeholder_13] => 0 [:db_update_placeholder_14] => 0 [:db_update_placeholder_15] => 0 [:db_update_placeholder_16] => 0 [:db_update_placeholder_17] => 0 [:db_update_placeholder_18] => 0 [:db_update_placeholder_19] => system [:db_update_placeholder_20] => Compose tips [:db_update_placeholder_21] => a:1:{s:10:"attributes";a:1:{s:5:"title";s:0:"";}} [:db_update_placeholder_22] => 1 [:db_condition_placeholder_0] => 3 ) in menu_link_save() (line 3200 of C:\xampp\htdocs\byblogdivalabs\includes\menu.inc).
This also happened when I massed enabled/disabled links. This is the NAVIGATION menu. In this error, the FILTER/TIPS link was disabled. I enabled it (along with the others I disabled and enabled) and this is what happened.
Comment #9
donquixote CreditAttribution: donquixote commentedTry this.
I noticed that we need numeric 0/1 instead of boolean for the database.
Comment #10
donquixote CreditAttribution: donquixote commentedMy local branch was not up to date.
New patch to see the diff.
But I am pushing it to 7.x-1.x anyway.
Comment #11
jci CreditAttribution: jci commentedPatch from comment 10 succesfully tested. Thx, great work! Solved my issue!!!
Comment #12
chefnelone CreditAttribution: chefnelone commentedPatch worked for me too. Thanks!
Comment #13
donquixote CreditAttribution: donquixote commentedFixed in 7.x-1.0-beta3
Comment #14
liza CreditAttribution: liza commentedCONFIRMING that Beta-3 fixed this problem.
thanks peeps!