Loading...
 
Skip to main content

Possible bug at creating base Tiki DB tables

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Possible bug at creating base Tiki DB tables
Version
18.x
Category
  • Error
  • Easy for Newbie Dev
  • Less than 30-minutes fix
Feature
Installer (profiles, upgrades and server-related issues)
Resolution status
Invalid
Submitted by
hman
Lastmod by
hman
Rating
(0)
Description

The basic Tiki DB initalization IMHO contains an error. Maybe this is due to a change introduced later that made the INSERT incompatible to the CREATE. /db/tiki.sql contains this at lines 2867-2878:

Copy to clipboard
DROP TABLE IF EXISTS `users_usergroups`;
CREATE TABLE `users_usergroups` (
  `userId` int(8) NOT NULL default '0',
  `groupName` varchar(255) NOT NULL default '',
  `created` int(14) default NULL,
  `expire` int(14) default NULL,
  PRIMARY KEY (`userId`,`groupName`(225))
) ENGINE=MyISAM;

INSERT INTO users_groups (`groupName`,`groupDesc`) VALUES ('Anonymous','Public users not logged');
INSERT INTO users_groups (`groupName`,`groupDesc`) VALUES ('Registered','Users logged into the system');
INSERT INTO users_groups (`groupName`,`groupDesc`) VALUES ('Admins','Administrator and accounts managers.');


This should not work. Maybe the resulting error is just ignored? Values are entered into the non-existent column "groupDesc"...

Importance
5
Easy to solve?
10 easy
Priority
50
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7770
Created
Thursday 17 June, 2021 09:57:00 UTC
by hman
LastModif
Thursday 17 June, 2021 10:01:33 UTC


Show PHP error messages