?
avatar richard67
richard67
16 Feb 2016

Steps to reproduce the issue

Create an update container from latest staging (which includes the commits from PR #9131).

You can find my container on http://test5.richard-fath.de/Joomla_3.5.0-beta2-Beta-Update_Package_staging.zip, this one includes also the (still open) PR #9045.

If you use http://test5.richard-fath.de/list_test3.xml as custom URL for the Joomla! Updater it will use my container.

Perform a Joomla! Updating using the Joomla! update component and the patched container.

Expected result

Update works.

Actual result

Update breaks before the 3 new plugins are installed (can be done with discover then).

Database shows errors.

When trying to fix with "Fix" button following SQL error is shown:

Specified key was too long; max key length is 767 bytes SQL=ALTER TABLE #__session MODIFY session_id varchar(400) NOT NULL DEFAULT '';

The fix fails, i.e. the database errors are still shown.

System information (as much as possible)

php: Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux
dbversion: 5.1.73-log
dbcollation: utf8_general_ci
dbconnectioncollation: utf8_general_ci
phpversion: 5.6.15
server: Apache
sapi_name: cgi-fcgi
version: Joomla! 3.5.0-beta2 Beta [ Ember ] 27-January-2017 23:00 GMT
platform: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
useragent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0

avatar richard67 richard67 - open - 16 Feb 2016
avatar richard67 richard67 - change - 16 Feb 2016
Title
PR #9131causes SQL error when updating from 3.4.8
PR #9131 causes SQL error when updating from 3.4.8
avatar richard67 richard67 - change - 16 Feb 2016
Title
PR #9131causes SQL error when updating from 3.4.8
PR #9131 causes SQL error when updating from 3.4.8
avatar richard67
richard67 - comment - 16 Feb 2016

Hmm made a mistake with the category, should have been mysql instead of sql. Can I correct that myself somewhere?


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9132.

avatar roland-d
roland-d - comment - 16 Feb 2016

@richard67 I checked but there is no mysql category, only SQL in this case, so you are fine.

avatar wilsonge
wilsonge - comment - 16 Feb 2016

I just had this reported to me elsewhere. Fixed with fcb6d90 then came across this - so closing this too!

avatar wilsonge wilsonge - close - 16 Feb 2016
avatar wilsonge wilsonge - close - 16 Feb 2016
avatar wilsonge wilsonge - change - 16 Feb 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-02-16 12:05:45
Closed_By wilsonge
avatar wilsonge wilsonge - reference | fcb6d90 - 16 Feb 16
avatar infograf768
infograf768 - comment - 17 Feb 2016

@wilsonge
See comments in fcb6d90

Add a Comment

Login with GitHub to post a comment