Loading...
 
Skip to main content

Kaltura-related SQL errors {installing/upgrading to} Tiki 18 alpha populating tiki_secdb

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Kaltura-related SQL errors {installing/upgrading to} Tiki 18 alpha populating tiki_secdb
Version
18.x
Category
  • Error
Feature
Installer (profiles, upgrades and server-related issues)
Resolution status
Confirmed
Submitted by
Bernard Sfez / Tiki Specialist
Lastmod by
Philippe Cloutier, Bernard Sfez / Tiki Specialist
Rating
(0)
Description

On Tiki 18 alpha during the DB installation I have errors related to Kaltura.

Image

Copy to clipboard
INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/AdminConsole/Service/ReportAdminService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
									Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
																										INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/AdminConsole/Service/UiConfAdminService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
									Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
																										INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/ContentDistribution/Service/ContentDistributionBatchService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
									Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
																										INSERT INTO `tiki_secdb` (`filename`, `md5_value`, `tiki_version`) VALUES('./vendor_bundled/vendor/kaltura/api-client-library/library/Kaltura/Client/Plugin/ContentDistribution/Service/TvComService.php', 'a317425c77e8cdcf2ce1048465dcb0bc', '18.0alpha')
									Duplicate entry 'a317425c77e8cdcf2ce1048465dcb0bc-./vendor_bundled/vendor/kaltura' for key 'PRIMARY'
Solution

This appeared because api-client-library, a library with long paths, was added since Tiki 17, but the actual bug is a mistaken primary key for tiki_secdb. The key only uses the first 100 characters of the filename column, which can cause conflicts between keys for different files.

To solve, the key should use the whole path. By the way, md5_value should not be part of the primary key.

Importance
6
Easy to solve?
5
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6491
Created
Wednesday 06 December, 2017 17:35:01 UTC
by Bernard Sfez / Tiki Specialist
LastModif
Tuesday 25 September, 2018 15:02:29 UTC


Show PHP error messages