kongondo / MenuBuilder

Easily create navigation lists/menus using drag and drop
GNU General Public License v2.0
21 stars 9 forks source link

Database error when adding menu #36

Closed tobaco closed 6 years ago

tobaco commented 6 years ago

I just installed MenuBuilder in a new Project (PW 3.0.104) and got the following error when i tried to add a menu:

Session: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' in /Users/dev/wire/core/WireDatabasePDO.php:454 Stack trace: 0 /Users/dev/wire/core/WireDatabasePDO.php(454): PDOStatement->execute() 1 /Users/dev/site/assets/cache/FileCompiler/site/modules/ProcessSetupPageName/ProcessSetupPageName.module(333): ProcessWire\WireDatabasePDO->execute(Object(PDOStatement), true, 2) 2 /Users/dev/site/assets/cache/FileCompiler/site/modules/ProcessSetupPageName/ProcessSetupPageName.module(354): ProcessSetupPageName->getSameNameArray('2018-05-29-15-5...', 0, 1039, NULL) 3 /Users/dev/site/assets/cache/FileCompiler/site/modules/ProcessSetupPageName/ProcessSetupPageName.module(301): ProcessSetupPageName->makeUnique('2018-05-29-15-5...', 0, 1039) 4 /Users/dev/wire/core/Wire.php(386): ProcessSetupPageName->_SetupPageName(Object(ProcessWire\Page), Array) 5 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_SetupPageNam...', Array) 6 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessSetupPageName), 'SetupPageName', Array) 7 /Users/dev/site/assets/cache/FileCompiler/site/modules/ProcessSetupPageName/ProcessSetupPageName.module(90): ProcessWire\Wire->call('SetupPageName', Array) 8 /Users/dev/wire/core/WireHooks.php(813): ProcessSetupPageName->{closure}(Object(ProcessWire\HookEvent)) 9 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\Pages), 'setupPageName', Array) 10 /Users/dev/wire/core/PagesEditor.php(310): ProcessWire\Wire->_call('setupPageName', Array) 11 /Users/dev/wire/core/Pages.php(790): ProcessWire\PagesEditor->setupNew(Object(ProcessWire\Page)) 12 /Users/dev/wire/core/Wire.php(383): ProcessWire\Pages->setupNew(Object(ProcessWire\Page)) 13 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_setupNew', Array) 14 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\Pages), 'setupNew', Array) 15 /Users/dev/wire/core/PagesEditor.php(511): ProcessWire\Wire->_call('setupNew', Array) 16 /Users/dev/wire/core/Pages.php(411): ProcessWire\PagesEditor->save(Object(ProcessWire\Page), rray) 17 /Users/dev/wire/core/Wire.php(386): ProcessWire\Pages->save(Object(ProcessWire\Page), Array) 18 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_save', Array) 19 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\Pages), 'save', Array) 20 /Users/dev/wire/core/Page.php(2409): ProcessWire\Wire->_call('save', Array) 21 /Users/dev/site/modules/ProcessMenuBuilder/ProcessMenuBuilder.module(2792): ProcessWire\Page->save() 22 /Users/dev/site/modules/ProcessMenuBuilder/ProcessMenuBuilder.module(2039): ProcessWire\ProcessMenuBuilder->saveNewMenu(Object(ProcessWire\WireInputData)) 23 /Users/dev/site/modules/ProcessMenuBuilder/ProcessMenuBuilder.module(160): ProcessWire\ProcessMenuBuilder->save(Object(ProcessWire\InputfieldForm)) 24 /Users/dev/wire/core/Wire.php(380): ProcessWire\ProcessMenuBuilder->execute() 25 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_execute', Array) 26 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\ProcessMenuBuilder), 'execute', Array) 27 /Users/dev/wire/core/ProcessController.php(263): ProcessWire\Wire->_call('execute', Array) 28 /Users/dev/wire/core/Wire.php(380): ProcessWire\ProcessController->execute() 29 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_execute', Array) 30 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\ProcessController), 'execute', Array) 31 /Users/dev/wire/core/admin.php(113): ProcessWire\Wire->_call('execute', Array) 32 /Users/dev/wire/modules/AdminTheme/AdminThemeUikit/controller.php(15): require('/Users/dev...') 33 /Users/dev/site/templates/admin.php(15): require('/Users/dev...') 34 /Users/dev/wire/core/TemplateFile.php(287): require('/Users/dev...') 35 /Users/dev/wire/core/Wire.php(380): ProcessWire\TemplateFile->render() 36 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_render', Array) 37 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\TemplateFile), 'render', Array) 38 /Users/dev/wire/modules/PageRender.module(514): ProcessWire\Wire->_call('render', Array) 39 /Users/dev/wire/core/Wire.php(383): ProcessWire\PageRender->renderPage(Object(ProcessWire\HookEvent)) 40 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('renderPage', Array) 41 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\PageRender), 'renderPage', Array) 42 /Users/dev/wire/core/WireHooks.php(822): ProcessWire\Wire->call('renderPage', Array) 43 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\Page), 'render', Array) 44 /Users/dev/wire/modules/Process/ProcessPageView.module(205): ProcessWire\Wire->call('render', Array) 45 /Users/dev/wire/core/Wire.php(383): ProcessWire\ProcessPageView->execute(true) 46 /Users/dev/wire/core/WireHooks.php(723): ProcessWire\Wire->_callMethod('_execute', Array) 47 /Users/dev/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\ProcessPageView), 'execute', Array) 48 /Users/dev/index.php(55): ProcessWire\Wire->call('execute', Array) 49 {main}

The menu get's added nevertheless. But when I try to add pages to the menu, these pages don't get saved and the menu returns empty. I don't know if these to issues are connected, but this error is the only reason i can think of.

My setup:

Thanks!

tobaco commented 6 years ago

Sorry error message was not related to my problem. SetupPageName (Module) was causing this error. I'll close this issue and open another one.