Loading...
 
Skip to main content

(A blocker if confirmed) errors in trunk database upgrade through console.php keys too long and invalid default value

Status
Pending
Subject
(A blocker if confirmed) errors in trunk database upgrade through console.php keys too long and invalid default value
Version
19.x
Category
  • Error
  • Release Blocker
Feature
Console / Command Line
Installer (profiles, upgrades and server-related issues)
Resolution status
Please retest
Submitted by
Xavier de Pedro
Lastmod by
Xavier de Pedro, Marc Laporte, luci
Rating
(0)
Description

I've updated trunk in a server, and I got these error messages after upgrading the database with console.php command:

Copy to clipboard
root@server:/var/www/tikitrunk# php console.php d:u --site=mysite.example.com PHP Warning: The requested theme's CSS file could not be read. Falling back to default theme. in /var/www/tikitrunk/lib/setup/theme.php on line 100 PHP Stack trace: PHP 1. {main}() /var/www/tikitrunk/console.php:0 PHP 2. require_once() /var/www/tikitrunk/console.php:59 PHP 3. require_once() /var/www/tikitrunk/tiki-setup.php:150 PHP 4. trigger_error() /var/www/tikitrunk/lib/setup/theme.php:100 Update completed. Installed: 20111231_change_datetime_defaults_to_null_tiki Installed: 20180609_change_log_column_type_tiki Installed: 20180705_fix_calendaritem_tracker_attributes_tiki Installed: 20180706_remove_menu_reports_tiki Installed: 20180803_semaphore_value_tiki Installed: 20180815_merge_topic_read_perm_tiki Installed: 20180918_remove_poweredby_module_tiki Installed: 20180923_convert_collation_to_utf8mb4_tiki Queries executed successfully: 277 Error in unknown patch script ALTER TABLE index_5a6715b9e9160 convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE index_pref_en convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE metrics_metric convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE metrics_tab convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE tiki_acct_journal convert to character set DEFAULT COLLATE DEFAULT Invalid default value for 'journalDate' Error in unknown patch script ALTER TABLE tiki_acct_stack convert to character set DEFAULT COLLATE DEFAULT Invalid default value for 'stackDate' Error in unknown patch script ALTER TABLE tiki_banning convert to character set DEFAULT COLLATE DEFAULT Invalid default value for 'date_to' Error in unknown patch script ALTER TABLE tiki_comments convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE tiki_links convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE tiki_object_attributes convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE tiki_profile_symbols convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE tiki_secdb convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes Error in unknown patch script ALTER TABLE users_objectpermissions convert to character set DEFAULT COLLATE DEFAULT Specified key was too long; max key length is 1000 bytes
Importance
8
Easy to solve?
5
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6807
Created
Monday 24 September, 2018 12:47:19 UTC
by Xavier de Pedro
LastModif
Saturday 27 October, 2018 16:52:51 UTC


Show PHP error messages