(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
- Description
I've updated trunk in a server, and I got these error messages after upgrading the database with console.php command:
Copy to clipboardroot@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+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- 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