1. Created a views page display with a menu link "Founding Sponsors" in Main Menu.
2. Hit save.
3. Menu item didn't get saved, and now the error below is being thrown several times per pageview.
Same error, over and over:
WD menu: PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column [error]
'weight' at row 15: INSERT INTO {menu_router} (path, load_functions, to_arg_functions, access_callback,
access_arguments, page_callback, page_arguments, delivery_callback, fit, number_parts, context, tab_parent,
tab_root, title, title_callback, title_arguments, theme_callback, theme_arguments, type, description,
position, weight, include_file) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1...db_insert_placeholder_457, :db_insert_placeholder_458,
:db_insert_placeholder_459); Array
(
[:db_insert_placeholder_0] => node
[:db_insert_placeholder_1] =>
[:db_insert_placeholder_2] =>
[:db_insert_placeholder_3] => user_access
[:db_insert_placeholder_4] => a:1:{i:0;s:14:"access content";}
[:db_insert_placeholder_5] => node_page_default
[:db_insert_placeholder_6] => a:0:{}
[:db_insert_placeholder_7] =>
[:db_insert_placeholder_8] => 1
[:db_insert_placeholder_9] => 1
[:db_insert_placeholder_10] => 0
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] => node
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] => t
[:db_insert_placeholder_15] =>
[:db_insert_placeholder_16] =>
[:db_insert_placeholder_17] => a:0:{}
[:db_insert_placeholder_18] => 0
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] => 0
[:db_insert_placeholder_22] =>
[:db_insert_placeholder_23] => r4032login
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] => r4032login_access_callback
[:db_insert_placeholder_27] => a:0:{}
[:db_insert_placeholder_28] => r4032login_redirect
[:db_insert_placeholder_29] => a:0:{}
[:db_insert_placeholder_30] =>
[:db_insert_placeholder_31] => 1
[:db_insert_placeholder_32] => 1
[:db_insert_placeholder_33] => 0
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => r4032login
[:db_insert_placeholder_36] => Access denied
[:db_insert_placeholder_37] => t
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => a:0:{}
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => You are not authorized to access this page.
[:db_insert_placeholder_43] =>
[:db_insert_placeholder_44] => 0
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] => poll
[:db_insert_placeholder_47] =>
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] => user_access
[:db_insert_placeholder_50] => a:1:{i:0;s:14:"access content";}
[:db_insert_placeholder_51] => poll_page
[:db_insert_placeholder_52] => a:0:{}
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => 1
[:db_insert_placeholder_55] => 1
[:db_insert_placeholder_56] => 0
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] => poll
[:db_insert_placeholder_59] => Polls
[:db_insert_placeholder_60] => t
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] => a:0:{}
[:db_insert_placeholder_64] => 20
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] => 0
[:db_insert_placeholder_68] => modules/poll/poll.pages.inc
[:db_insert_placeholder_69] => rss.xml
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] => user_access
[:db_insert_placeholder_73] => a:1:{i:0;s:14:"access content";}
[:db_insert_placeholder_74] => node_feed
[:db_insert_placeholder_75] => a:2:{i:0;b:0;i:1;a:0:{}}
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] => 1
[:db_insert_placeholder_78] => 1
[:db_insert_placeholder_79] => 0
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] => rss.xml
[:db_insert_placeholder_82] => RSS feed
[:db_insert_placeholder_83] => t
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] => a:0:{}
[:db_insert_placeholder_87] => 0
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] => 0
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => search
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] => search_is_active
[:db_insert_placeholder_96] => a:0:{}
[:db_insert_placeholder_97] => search_view
[:db_insert_placeholder_98] => a:0:{}
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] => 1
[:db_insert_placeholder_101] => 1
[:db_insert_placeholder_102] => 0
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] => search
[:db_insert_placeholder_105] => Search
[:db_insert_placeholder_106] => t
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] => a:0:{}
[:db_insert_placeholder_110] => 20
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] => 0
[:db_insert_placeholder_114] => modules/search/search.pages.inc
[:db_insert_placeholder_115] => admin
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] =>
[:db_insert_placeholder_118] => user_access
[:db_insert_placeholder_119] => a:1:{i:0;s:27:"access administration pages";}
[:db_insert_placeholder_120] => system_admin_menu_block_page
[:db_insert_placeholder_121] => a:0:{}
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] => 1
[:db_insert_placeholder_124] => 1
[:db_insert_placeholder_125] => 0
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] => admin
[:db_insert_placeholder_128] => Administration
[:db_insert_placeholder_129] => t
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
[:db_insert_placeholder_132] => a:0:{}
[:db_insert_placeholder_133] => 6
[:db_insert_placeholder_134] =>
[:db_insert_placeholder_135] =>
[:db_insert_placeholder_136] => 9
[:db_insert_placeholder_137] => modules/system/system.admin.inc
[:db_insert_placeholder_138] => contact
[:db_insert_placeholder_139] =>
[:db_insert_placeholder_140] =>
[:db_insert_placeholder_141] => user_access
[:db_insert_placeholder_142] => a:1:{i:0;s:29:"access site-wide contact form";}
[:db_insert_placeholder_143] => drupal_get_form
[:db_insert_placeholder_144] => a:1:{i:0;s:17:"contact_site_form";}
[:db_insert_placeholder_145] =>
[:db_insert_placeholder_146] => 1
[:db_insert_placeholder_147] => 1
[:db_insert_placeholder_148] => 0
[:db_insert_placeholder_149] =>
[:db_insert_placeholder_150] => contact
[:db_insert_placeholder_151] => Contact
[:db_insert_placeholder_152] => t
[:db_insert_placeholder_153] =>
[:db_insert_placeholder_154] =>
[:db_insert_placeholder_155] => a:0:{}
[:db_insert_placeholder_156] => 20
[:db_insert_placeholder_157] =>
[:db_insert_placeholder_158] =>
[:db_insert_placeholder_159] => 0
[:db_insert_placeholder_160] => modules/contact/contact.pages.inc
[:db_insert_placeholder_161] => batch
[:db_insert_placeholder_162] =>
[:db_insert_placeholder_163] =>
[:db_insert_placeholder_164] => 1
[:db_insert_placeholder_165] => a:0:{}
[:db_insert_placeholder_166] => system_batch_page
[:db_insert_placeholder_167] => a:0:{}
[:db_insert_placeholder_168] =>
[:db_insert_placeholder_169] => 1
[:db_insert_placeholder_170] => 1
[:db_insert_placeholder_171] => 0
[:db_insert_placeholder_172] =>
[:db_insert_placeholder_173] => batch
[:db_insert_placeholder_174] =>
[:db_insert_placeholder_175] => t
[:db_insert_placeholder_176] =>
[:db_insert_placeholder_177] => _system_batch_theme
[:db_insert_placeholder_178] => a:0:{}
[:db_insert_placeholder_179] => 0
[:db_insert_placeholder_180] =>
[:db_insert_placeholder_181] =>
[:db_insert_placeholder_182] => 0
[:db_insert_placeholder_183] => modules/system/system.admin.inc
[:db_insert_placeholder_184] => events-upcoming.xml
[:db_insert_placeholder_185] =>
[:db_insert_placeholder_186] =>
[:db_insert_placeholder_187] => views_access
[:db_insert_placeholder_188] => a:1:{i:0;a:2:{i:0;s:16:"views_check_perm";i:1;a:1:{i:0;s:14:"access
content";}}}
[:db_insert_placeholder_189] => views_page
[:db_insert_placeholder_190] => a:2:{i:0;s:23:"commons_events_upcoming";i:1;s:4:"feed";}
[:db_insert_placeholder_191] =>
[:db_insert_placeholder_192] => 1
[:db_insert_placeholder_193] => 1
[:db_insert_placeholder_194] => 0
[:db_insert_placeholder_195] =>
[:db_insert_placeholder_196] => events-upcoming.xml
[:db_insert_placeholder_197] =>
[:db_insert_placeholder_198] => t
[:db_insert_placeholder_199] =>
[:db_insert_placeholder_200] =>
[:db_insert_placeholder_201] => a:0:{}
[:db_insert_placeholder_202] => 0
[:db_insert_placeholder_203] =>
[:db_insert_placeholder_204] =>
[:db_insert_placeholder_205] => 0
[:db_insert_placeholder_206] =>
[:db_insert_placeholder_207] => featured.xml
[:db_insert_placeholder_208] =>
[:db_insert_placeholder_209] =>
[:db_insert_placeholder_210] => views_access
[:db_insert_placeholder_211] => a:1:{i:0;a:2:{i:0;s:16:"views_check_perm";i:1;a:1:{i:0;s:14:"access
content";}}}
[:db_insert_placeholder_212] => views_page
[:db_insert_placeholder_213] => a:2:{i:0;s:16:"commons_featured";i:1;s:26:"commons_home_featured_feed";}
[:db_insert_placeholder_214] =>
[:db_insert_placeholder_215] => 1
[:db_insert_placeholder_216] => 1
[:db_insert_placeholder_217] => 0
[:db_insert_placeholder_218] =>
[:db_insert_placeholder_219] => featured.xml
[:db_insert_placeholder_220] =>
[:db_insert_placeholder_221] => t
[:db_insert_placeholder_222] =>
[:db_insert_placeholder_223] =>
[:db_insert_placeholder_224] => a:0:{}
[:db_insert_placeholder_225] => 0
[:db_insert_placeholder_226] =>
[:db_insert_placeholder_227] =>
[:db_insert_placeholder_228] => 0
[:db_insert_placeholder_229] =>
[:db_insert_placeholder_230] => featured
[:db_insert_placeholder_231] =>
[:db_insert_placeholder_232] =>
[:db_insert_placeholder_233] => views_access
[:db_insert_placeholder_234] => a:1:{i:0;a:2:{i:0;s:16:"views_check_perm";i:1;a:1:{i:0;s:14:"access
content";}}}
[:db_insert_placeholder_235] => views_page
[:db_insert_placeholder_236] => a:2:{i:0;s:16:"commons_featured";i:1;s:26:"commons_home_featured_page";}
[:db_insert_placeholder_237] =>
[:db_insert_placeholder_238] => 1
[:db_insert_placeholder_239] => 1
[:db_insert_placeholder_240] => 0
[:db_insert_placeholder_241] =>
[:db_insert_placeholder_242] => featured
[:db_insert_placeholder_243] =>
[:db_insert_placeholder_244] => t
[:db_insert_placeholder_245] =>
[:db_insert_placeholder_246] =>
[:db_insert_placeholder_247] => a:0:{}
[:db_insert_placeholder_248] => 0
[:db_insert_placeholder_249] =>
[:db_insert_placeholder_250] =>
[:db_insert_placeholder_251] => 0
[:db_insert_placeholder_252] =>
[:db_insert_placeholder_253] => commons-groups-directory.xml
[:db_insert_placeholder_254] =>
[:db_insert_placeholder_255] =>
[:db_insert_placeholder_256] => views_access
[:db_insert_placeholder_257] => a:1:{i:0;a:2:{i:0;s:16:"views_check_perm";i:1;a:1:{i:0;s:14:"access
content";}}}
[:db_insert_placeholder_258] => views_page
[:db_insert_placeholder_259] => a:2:{i:0;s:24:"commons_groups_directory";i:1;s:4:"feed";}
[:db_insert_placeholder_260] =>
[:db_insert_placeholder_261] => 1
[:db_insert_placeholder_262] => 1
[:db_insert_placeholder_263] => 0
[:db_insert_placeholder_264] =>
[:db_insert_placeholder_265] => commons-groups-directory.xml
[:db_insert_placeholder_266] =>
[:db_insert_placeholder_267] => t
[:db_insert_placeholder_268] =>
[:db_insert_placeholder_269] =>
[:db_insert_placeholder_270] => a:0:{}
[:db_insert_placeholder_271] => 0
[:db_insert_placeholder_272] =>
[:db_insert_placeholder_273] =>
[:db_insert_placeholder_274] => 0
[:db_insert_placeholder_275] =>
[:db_insert_placeholder_276] => commons-radioactivity-admin
[:db_insert_placeholder_277] =>
[:db_insert_placeholder_278] =>
[:db_insert_placeholder_279] => views_access
[:db_insert_placeholder_280] => a:1:{i:0;a:2:{i:0;s:16:"views_check_perm";i:1;a:1:{i:0;s:24:"administer
content types";}}}
[:db_insert_placeholder_281] => views_page
[:db_insert_placeholder_282] => a:2:{i:0;s:27:"commons_radioactivity_admin";i:1;s:4:"page";}
[:db_insert_placeholder_283] =>
[:db_insert_placeholder_284] => 1
[:db_insert_placeholder_285] => 1
[:db_insert_placeholder_286] => 0
[:db_insert_placeholder_287] =>
[:db_insert_placeholder_288] => commons-radioactivity-admin
[:db_insert_placeholder_289] =>
[:db_insert_placeholder_290] => t
[:db_insert_placeholder_291] =>
[:db_insert_placeholder_292] =>
[:db_insert_placeholder_293] => a:0:{}
[:db_insert_placeholder_294] => 0
[:db_insert_placeholder_295] =>
[:db_insert_placeholder_296] =>
[:db_insert_placeholder_297] => 0
[:db_insert_placeholder_298] =>
[:db_insert_placeholder_299] => user
[:db_insert_placeholder_300] =>
[:db_insert_placeholder_301] =>
[:db_insert_placeholder_302] => 1
[:db_insert_placeholder_303] => a:0:{}
[:db_insert_placeholder_304] => user_page
[:db_insert_placeholder_305] => a:0:{}
[:db_insert_placeholder_306] =>
[:db_insert_placeholder_307] => 1
[:db_insert_placeholder_308] => 1
[:db_insert_placeholder_309] => 0
[:db_insert_placeholder_310] =>
[:db_insert_placeholder_311] => user
[:db_insert_placeholder_312] => User account
[:db_insert_placeholder_313] => user_menu_title
[:db_insert_placeholder_314] =>
[:db_insert_placeholder_315] =>
[:db_insert_placeholder_316] => a:0:{}
[:db_insert_placeholder_317] => 6
[:db_insert_placeholder_318] =>
[:db_insert_placeholder_319] =>
[:db_insert_placeholder_320] => -10
[:db_insert_placeholder_321] => modules/user/user.pages.inc
[:db_insert_placeholder_322] => home
[:db_insert_placeholder_323] =>
[:db_insert_placeholder_324] =>
[:db_insert_placeholder_325] => ctools_access_menu
[:db_insert_placeholder_326] => a:1:{i:0;a:2:{s:4:"type";s:4:"none";s:8:"settings";N;}}
[:db_insert_placeholder_327] => page_manager_page_execute
[:db_insert_placeholder_328] => a:1:{i:0;s:12:"commons_home";}
[:db_insert_placeholder_329] =>
[:db_insert_placeholder_330] => 1
[:db_insert_placeholder_331] => 1
[:db_insert_placeholder_332] => 0
[:db_insert_placeholder_333] =>
[:db_insert_placeholder_334] => home
[:db_insert_placeholder_335] =>
[:db_insert_placeholder_336] => t
[:db_insert_placeholder_337] =>
[:db_insert_placeholder_338] =>
[:db_insert_placeholder_339] => a:0:{}
[:db_insert_placeholder_340] => 0
[:db_insert_placeholder_341] =>
[:db_insert_placeholder_342] =>
[:db_insert_placeholder_343] =>
[:db_insert_placeholder_344] =>
profiles/commons/modules/contrib/ctools/page_manager/plugins/tasks/page.inc
[:db_insert_placeholder_345] => events
[:db_insert_placeholder_346] =>
[:db_insert_placeholder_347] =>
[:db_insert_placeholder_348] => ctools_access_menu
[:db_insert_placeholder_349] => a:1:{i:0;a:2:{s:4:"type";s:4:"none";s:8:"settings";N;}}
[:db_insert_placeholder_350] => page_manager_page_execute
[:db_insert_placeholder_351] => a:1:{i:0;s:25:"views_events_landing_page";}
[:db_insert_placeholder_352] =>
[:db_insert_placeholder_353] => 1
[:db_insert_placeholder_354] => 1
[:db_insert_placeholder_355] => 0
[:db_insert_placeholder_356] =>
[:db_insert_placeholder_357] => events
[:db_insert_placeholder_358] =>
[:db_insert_placeholder_359] => t
[:db_insert_placeholder_360] =>
[:db_insert_placeholder_361] =>
[:db_insert_placeholder_362] => a:0:{}
[:db_insert_placeholder_363] => 0
[:db_insert_placeholder_364] =>
[:db_insert_placeholder_365] =>
[:db_insert_placeholder_366] => 0
[:db_insert_placeholder_367] =>
profiles/commons/modules/contrib/ctools/page_manager/plugins/tasks/page.inc
[:db_insert_placeholder_368] => membership
[:db_insert_placeholder_369] =>
[:db_insert_placeholder_370] =>
[:db_insert_placeholder_371] => ctools_access_menu
[:db_insert_placeholder_372] => a:1:{i:0;a:2:{s:4:"type";s:4:"none";s:8:"settings";N;}}
[:db_insert_placeholder_373] => page_manager_page_execute
[:db_insert_placeholder_374] => a:1:{i:0;s:13:"ae_membership";}
[:db_insert_placeholder_375] =>
[:db_insert_placeholder_376] => 1
[:db_insert_placeholder_377] => 1
[:db_insert_placeholder_378] => 0
[:db_insert_placeholder_379] =>
[:db_insert_placeholder_380] => membership
[:db_insert_placeholder_381] => Membership
[:db_insert_placeholder_382] => t
[:db_insert_placeholder_383] =>
[:db_insert_placeholder_384] =>
[:db_insert_placeholder_385] => a:0:{}
[:db_insert_placeholder_386] => 6
[:db_insert_placeholder_387] =>
[:db_insert_placeholder_388] =>
[:db_insert_placeholder_389] => 0
[:db_insert_placeholder_390] =>
profiles/commons/modules/contrib/ctools/page_manager/plugins/tasks/page.inc
[:db_insert_placeholder_391] => groups
[:db_insert_placeholder_392] =>
[:db_insert_placeholder_393] =>
[:db_insert_placeholder_394] => ctools_access_menu
[:db_insert_placeholder_395] => a:1:{i:0;a:2:{s:4:"type";s:4:"none";s:8:"settings";N;}}
[:db_insert_placeholder_396] => page_manager_page_execute
[:db_insert_placeholder_397] => a:1:{i:0;s:16:"groups_directory";}
[:db_insert_placeholder_398] =>
[:db_insert_placeholder_399] => 1
[:db_insert_placeholder_400] => 1
[:db_insert_placeholder_401] => 0
[:db_insert_placeholder_402] =>
[:db_insert_placeholder_403] => groups
[:db_insert_placeholder_404] => Groups
[:db_insert_placeholder_405] => t
[:db_insert_placeholder_406] =>
[:db_insert_placeholder_407] =>
[:db_insert_placeholder_408] => a:0:{}
[:db_insert_placeholder_409] => 6
[:db_insert_placeholder_410] =>
[:db_insert_placeholder_411] =>
[:db_insert_placeholder_412] => -20
[:db_insert_placeholder_413] =>
profiles/commons/modules/contrib/ctools/page_manager/plugins/tasks/page.inc
[:db_insert_placeholder_414] => founding-sponsors
[:db_insert_placeholder_415] =>
[:db_insert_placeholder_416] =>
[:db_insert_placeholder_417] => views_access
[:db_insert_placeholder_418] => a:1:{i:0;a:2:{i:0;s:16:"views_check_perm";i:1;a:1:{i:0;s:14:"access
content";}}}
[:db_insert_placeholder_419] => views_page
[:db_insert_placeholder_420] => a:2:{i:0;s:17:"founding_sponsors";i:1;s:4:"page";}
[:db_insert_placeholder_421] =>
[:db_insert_placeholder_422] => 1
[:db_insert_placeholder_423] => 1
[:db_insert_placeholder_424] => 0
[:db_insert_placeholder_425] =>
[:db_insert_placeholder_426] => founding-sponsors
[:db_insert_placeholder_427] => Founding Sponsors
[:db_insert_placeholder_428] => t
[:db_insert_placeholder_429] =>
[:db_insert_placeholder_430] =>
[:db_insert_placeholder_431] => a:0:{}
[:db_insert_placeholder_432] => 6
[:db_insert_placeholder_433] => Founding Sponsors
[:db_insert_placeholder_434] =>
[:db_insert_placeholder_435] => 0
[:db_insert_placeholder_436] =>
[:db_insert_placeholder_437] => admin/tasks
[:db_insert_placeholder_438] =>
[:db_insert_placeholder_439] =>
[:db_insert_placeholder_440] => user_access
[:db_insert_placeholder_441] => a:1:{i:0;s:27:"access administration pages";}
[:db_insert_placeholder_442] => system_admin_menu_block_page
[:db_insert_placeholder_443] => a:0:{}
[:db_insert_placeholder_444] =>
[:db_insert_placeholder_445] => 3
[:db_insert_placeholder_446] => 2
[:db_insert_placeholder_447] => 1
[:db_insert_placeholder_448] => admin
[:db_insert_placeholder_449] => admin
[:db_insert_placeholder_450] => Tasks
[:db_insert_placeholder_451] => t
[:db_insert_placeholder_452] =>
[:db_insert_placeholder_453] =>
[:db_insert_placeholder_454] => a:0:{}
[:db_insert_placeholder_455] => 140
[:db_insert_placeholder_456] =>
[:db_insert_placeholder_457] =>
[:db_insert_placeholder_458] => -20
[:db_insert_placeholder_459] => modules/system/system.admin.inc
)
in _menu_router_save() (line 3828 of /usr/local/var/www/aea/www/includes/menu.inc).
Comments
Comment #1
ezra-g commentedThis appears to be an issue related to your custom view. A quick search for the error message you provided turns up #1350206: Incorrect integer value in tvi_update_settings() when assign view to the vocabulary.
If that does not seem accurate, please re-open this issue with specific steps to reproduce the problem in Commons.
Comment #3
hoangd commentedBecause some image content field missing when migrating, therefore you need to move all file from old version to sites/default/files
Comment #4
casivaagustin commentedJust in case someone is lost, I had a similar issue with image fields and the problem was that the GD extension was not installed so Drupal was not able to calculate the dimensions.