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).

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jci’s picture

have to agree... such a great module, but this error is really annoying.

donquixote’s picture

Can you give me a stack trace?
Or any other information?

donquixote’s picture

Guys, please, a stack trace!

jci’s picture

FileSize
94.16 KB

Okay, 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:
Screenshot PDO MEnu Editor

donquixote’s picture

Status: Active » Needs review
FileSize
669 bytes

Can you try with the latest -dev from today (or latest beta, that's the same), and this patch?

jci’s picture

will give it a try, give you some feedback in the next few days - thx

webmestre’s picture

I applyed the last patch and got the following message :

patching file b/menu_editor.admin.inc
Hunk #1 FAILED at 410.
1 out of 1 hunk FAILED -- saving rejects to file b/menu_editor.admin.inc.rej

liza’s picture

Same 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.

donquixote’s picture

Try this.
I noticed that we need numeric 0/1 instead of boolean for the database.

donquixote’s picture

My local branch was not up to date.
New patch to see the diff.
But I am pushing it to 7.x-1.x anyway.

jci’s picture

Patch from comment 10 succesfully tested. Thx, great work! Solved my issue!!!

chefnelone’s picture

Patch worked for me too. Thanks!

donquixote’s picture

Status: Needs review » Fixed

Fixed in 7.x-1.0-beta3

liza’s picture

CONFIRMING that Beta-3 fixed this problem.
thanks peeps!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.