DB Error on attempting to edit Details/Options of menu items - cannot update any menu options
- Status
- Pending
- Subject
- DB Error on attempting to edit Details/Options of menu items - cannot update any menu options
- Version
- 26.x
- Category
- Error
- Feature
- Database MySQL (InnoDB)
Menu - Resolution status
- Please retest
- Submitted by
- Coyote
- Lastmod by
- Josue Zirimwabagabo
- Rating
- Description
Under Menu > Navigation in the admin settings, attempting to edit the menu's Details/Options (via the dialog accessed using the edit/pencil button) results in the following error:
- Incorrect integer value: '' for column `tikiwiki`.`tiki_menu_options`.`userlevel` at row 1
This means that no options can be updated for menus. Name, group restrictions, et al. Menus can still be re-ordered and re-arranged, but no settings, labels, or other features are saving.This is a brand-new, fresh install, and I am not seeing any errors when updating any other content or items.
Steps to reproduce:
- Visit Admin > Menu > Navigation
- Click on the Pencil/Edit Icon next to a menu option
- Make changes and click "Save"
Faulty consequence:- Error appears at top of page, and no settings are changed.
Expected behavior:- I expect the settings to be saved and no error to appear.
Workaround:
Use menus without permissions or customization. This means that menu items that should not appear for, say, anonymous users will still appear, and take the visitor to an error/access denied message. Menu link, title and position are the only things that can be changed, as they can be adjusted through the menu options list.- Incorrect integer value: '' for column `tikiwiki`.`tiki_menu_options`.`userlevel` at row 1
- Solution
- Workaround
- Importance
- 7
- Easy to solve?
- 5
- Priority
- 35
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 8598
- Created
- Wednesday 21 February, 2024 10:40:35 UTC
by Coyote - LastModif
- Friday 21 March, 2025 06:09:30 UTC