Loading...
 
Skip to main content

Problem with duplicate menus when running tiki_1.8to1.9.sql multiple times.

Status
Closed
Subject
Problem with duplicate menus when running tiki_1.8to1.9.sql multiple times.
Version
1.9.x
Category
  • Error
Feature
Menu
Installer (profiles, upgrades and server-related issues)
Admin Interface (UI)
Infrastructure
Resolution status
Fixed or Solved
Submitted by
Marc Laporte
Volunteered to solve
Louis-Philippe Huberdeau
Lastmod by
Marc Laporte
Rating
(0)
Description

This code in db/tiki_1.8to1.9.sql used in upgrade script, is causing duplicate menu items.

Image
Copy to clipboard
INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Mobile','tiki-mobile.php',37,'feature_mobile','','');

Image
Copy to clipboard
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Users map','tiki-gmap_usermap.php',36,'feature_gmap','','');



Duplicates also happen for 187, and 188, 900, 1191, 1235, and in a minor way, 189, 780,

See screenshot attached.

Solution

This is handled differently in 3.0 and the problem will no longer happen:
DatabaseSchemaUpgrade


For old duplicates, you need to delete them manually.

Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1290
Created
Saturday 11 August, 2007 20:55:12 UTC
by Unknown
LastModif
Monday 20 April, 2009 17:46:05 UTC


Show PHP error messages