Loading...
 
Skip to main content

Fatal error when trying to Reset System Menu (menu ID 42)

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Fatal error when trying to Reset System Menu (menu ID 42)
Version
30.x
Category
  • Error
Feature
Menu
Resolution status
Fixed or Solved
Submitted by
luci
Volunteered to solve
Ushindi Gedeon
Lastmod by
Ushindi Gedeon
Rating
(0)
Description

I have noticed that at some point my System Menu optionIds on my localhost test Tiki changed to 202,203,204 etc. instead of 1,2,3,... in the database tiki_menu_options table so I wanted to give a try to the "Reset" button in the tiki-admin_menus.php trying to reset the menu to its original state but instead I got the fatal error on http://localhost/tiki/tiki-admin_menus.php?reset=y&menuId=42Question

Here is a screenshot:
Image

Here is the error message:

Copy to clipboard
System error.
The following error message was returned:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
The query was:

INSERT INTO `tiki_menu_options` (`menuId`,`type`,`name`,`url`,`position`,`section`,`perm`,`groupname`,`userlevel`,`icon`) VALUES
The built query was likely:

INSERT INTO `tiki_menu_options` (`menuId`,`type`,`name`,`url`,`position`,`section`,`perm`,`groupname`,`userlevel`,`icon`) VALUES
Solution
Workaround
Importance
5
Easy to solve?
5
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
8848
Created
Thursday 23 October, 2025 11:02:39 UTC
by luci
LastModif
Wednesday 19 November, 2025 05:54:23 UTC


Show PHP error messages