Joomla 3.5 update fails with Timesheet 1.0.1

8 years 5 days ago - 7 years 11 months ago #1 by geoffc
As expected and documented if an attempt is made to upgrade Joomla to 3.5 and Timesheet versions 1.0.0 or 1.0.1 are installed the update will fail when trying to convert the #__users table to utf8mb4.

The solution is to either:
  • Update Timesheet to 1.0.2
  • Remove the database foreign key on the timesheet_users table to the #__users table.
  • If timesheet is still being tested and you do not want any existing data. Uninstall timesheet.
  • If you wish to save the timesheet data, export the timesheet tables. Uninstall the timesheet component..

Once this is done. Either rerun the Joomla update or (preferably) run the 'Manage - Database -fix' to complete the Joomla install.
Then if required reinstall Timesheet 1.0.2 and if necessary re-import the previously exported timesheet data.

Regards
Geoff

Please Log in or Create an account to join the conversation.

Time to create page: 0.144 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries