(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
- Installer (profiles, upgrades and server-related issues)
Console / Command Line - Resolution status
- Please retest
- Submitted by
- Xavier de Pedro
- Lastmod by
- Xavier de Pedro, Marc Laporte, luciash d' being 🧙
- Rating
- Description
I've updated trunk in a server, and I got these error messages after upgrading the database with console.php command:
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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 6807
- Created
- Monday 24 September, 2018 12:47:19 GMT-0000
by Xavier de Pedro - LastModif
- Saturday 27 October, 2018 16:52:51 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- fresh opening of tiki home page tiki-index (I removed a warning) is it OK
- Tracker with field type "Numeric" won't
- tiki 25.1 Database 'xxxx'. Unable to connect to database (when 25.0 will connect)
- Kanban plugin; the Swimlane field throw an error if using a category field type
- Kanban plugin: Error if the fields Description and Swimlane are empty
;){kind=link}
;){kind=link}