I only reproduced this once when upgrading a site from 2.5 to 3 under php 5.6 and mysql 5.7
After the upgrade which is by default to 3.5.1 (iirc) then there is a fatal error and several files from the 2.5 install are still present. This is the same as reported in #11117
The fix for that was introduced in 3.6 (iirc) #11282 however that obviously doest help if the update is to 3.5.1 and not 3.6
| Labels |
Added:
?
|
||
| Category | ⇒ | com_joomlaupdate |
| Status | New | ⇒ | Discussion |
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-10-02 18:42:00 |
| Closed_By | ⇒ | zero-24 |
The issue is not fixed. It is merely bypassed.
I'm happy to test any code fix that helps here without hacking the menu system or rewrite com_joomlaupdate.
@mbabker @zero-24 Please see this forum topic very similar to issue reported by @brianteeman.
@franz-wohlkoenig Plese re-open temporally for better visibility.
| Status | Closed | ⇒ | Discussion |
| Closed_Date | 2017-10-02 18:42:00 | ⇒ | |
| Closed_By | zero-24 | ⇒ |
| Status | Discussion | ⇒ | New |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ |
Set to "open" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17967
| Status | New | ⇒ | Discussion |
reopened as stated above.
update 2.5.28 to 3.5.1 used to work seamlessly (with the remember me plugin disabled)).
I used to be able to do it on localhost with xampp. Now I use xampp with php7 ... I use wamp. But now I get errors. Could this be a database issue ? because wamp is msql not msqli ?
AFAIK 2.5 isn't PHP 7 compatible so you probably need to be on a 5.6 version to do that upgrade.
Then it's an extension issue because I took the effort to ensure 2.5.28 was PHP 5.6 friendly before issuing the release and closing the branch.
@mbabker
I will rephrase
I used to be able to do it on localhost with xampp. Now I use xampp with php7 ... I use wamp. But now I get errors. Could this be a database issue ? because wamp is msql not msqli ?
When I used xampp with php5 the update 2.5.28 to 3.5.1 used to work seamlessly. I now have xampp with php7 so I now also have wamp to use php5. But the update 2.5.28 to 3.5.1 fails on wamp. I ask again ... Could this be a database issue ? because wamp is msql not msqli ?
No. Both 2.5 and 3.x support both mysql and mysqli as long as the underlying PHP engine dependencies are met. And as of 3.5.0 there is code in the database driver factory to detect if you are running PHP 7 with mysql set as the driver and attempt to auto-convert to mysqli if it is available on your platform, so even that configuration shouldn't be problematic.
@Webdongle #17967 (comment) I tested this case on JAMP (paid alternative to XAMP and similar solutions -there is a free trial) and this is working.
No. PHP 5.6 support was finalized before 2.5.28 was released.
For clarity I tested on:
php 5.6.20
mysql and mysqli extensions loaded but dbtype set to mysql
Client API library version mysqlnd 5.0.11-dev - 20120503
Windows 8.1
Just tested on Uniform server and update ran smoothly.
Brought to login screen
Logged in
Brought to http://localhost/j2528b/administrator/index.php?option=com_joomlaupdate&view=default&layout=complete
Your site has been successfully updated. Your Joomla version is now 3.5.1.
But a message above it
An error has occurred.
Could it be a time out issue ?
Further testing
The update 2.5.28 to 3.5.1 fails with
Database Version 5.7.19
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.31
Web Server Apache/2.4.27 (Win64) PHP/5.6.31
Server: MySQL (127.0.0.1 via TCP/IP)
Server type: MySQL
Server version: 5.7.19 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Apache/2.4.27 (Win64) PHP/5.6.31
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
The update 2.5.28 to 3.5.1 succeeds with
Database Version 5.6.34
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.28
Web Server Apache
Server: Uniform Server (127.0.0.1 via TCP/IP)
Server type: MySQL
Server version: 5.6.34 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Apache
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
A time out issue would be more reliant on PHP configuration settings, not just running different versions. We'd need more of the PHP configuration to consider something timing out, or PHP error logs if there's anything helpful.
It could also be possible (not sure how likely but we can entertain it for a second) that there is an issue with MySQL 5.7 and Joomla 2.5.
@mbabker In the topic I link there is FPA report. See also this topic in both cases there are wired database structure issues.
@mbabker
Update log for 2.5.28 to 3.5.1 update that stuck on /finalising
`#
#
#Date: 2017-10-13 10:29:23 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
#Fields: datetime priority clientip category message
2017-10-13T10:29:23+00:00 INFO ::1 update Finalising installation.
2017-10-13T10:29:24+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__users DROP INDEX usertype;.
2017-10-13T10:29:24+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__session DROP INDEX whosonline;.
2017-10-13T10:29:24+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: DROP TABLE IF EXISTS #__update_categories;.
2017-10-13T10:29:25+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__contact_details DROP imagepos;.
2017-10-13T10:29:25+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content DROP COLUMN title_alias;.
2017-10-13T10:29:25+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content DROP COLUMN sectionid;.
2017-10-13T10:29:25+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content DROP COLUMN mask;.
2017-10-13T10:29:25+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content DROP COLUMN parentid;.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__newsfeeds DROP COLUMN filename;.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__menu DROP COLUMN ordering;.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__session DROP COLUMN usertype;.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__users DROP COLUMN usertype;.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__updates DROP COLUMN categoryid;.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: UPDATE #__extensions SET protected = 0 WHERE name = 'com_search' OR name =.
2017-10-13T10:29:26+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: DELETE FROM #__extensions WHERE extension_id = 800;.
2017-10-13T10:29:28+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__assets ENGINE=InnoDB;.
2017-10-13T10:29:28+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__associations ENGINE=InnoDB;.
2017-10-13T10:29:29+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banners ENGINE=InnoDB;.
2017-10-13T10:29:30+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banner_clients ENGINE=InnoDB;.
2017-10-13T10:29:31+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banner_tracks ENGINE=InnoDB;.
2017-10-13T10:29:32+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__categories ENGINE=InnoDB;.
2017-10-13T10:29:33+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__contact_details ENGINE=InnoDB;.
2017-10-13T10:29:35+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content ENGINE=InnoDB;.
2017-10-13T10:29:36+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content_frontpage ENGINE=InnoDB;.
2017-10-13T10:29:37+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__content_rating ENGINE=InnoDB;.
2017-10-13T10:29:38+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__core_log_searches ENGINE=InnoDB;.
2017-10-13T10:29:40+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__extensions ENGINE=InnoDB;.
2017-10-13T10:29:40+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_filters ENGINE=InnoDB;.
2017-10-13T10:29:42+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links ENGINE=InnoDB;.
2017-10-13T10:29:43+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms0 ENGINE=InnoDB;.
2017-10-13T10:29:44+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms1 ENGINE=InnoDB;.
2017-10-13T10:29:47+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms2 ENGINE=InnoDB;.
2017-10-13T10:29:48+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms3 ENGINE=InnoDB;.
2017-10-13T10:29:50+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms4 ENGINE=InnoDB;.
2017-10-13T10:29:51+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms5 ENGINE=InnoDB;.
2017-10-13T10:29:52+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms6 ENGINE=InnoDB;.
2017-10-13T10:29:53+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms7 ENGINE=InnoDB;.
2017-10-13T10:29:54+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms8 ENGINE=InnoDB;.
2017-10-13T10:29:55+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_terms9 ENGINE=InnoDB;.
2017-10-13T10:29:56+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_termsa ENGINE=InnoDB;.
2017-10-13T10:29:56+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_termsb ENGINE=InnoDB;.
2017-10-13T10:29:57+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_termsc ENGINE=InnoDB;.
2017-10-13T10:29:58+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_termsd ENGINE=InnoDB;.
2017-10-13T10:29:59+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_termse ENGINE=InnoDB;.
2017-10-13T10:30:00+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_links_termsf ENGINE=InnoDB;.
2017-10-13T10:30:01+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_taxonomy ENGINE=InnoDB;.
2017-10-13T10:30:03+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_taxonomy_map ENGINE=InnoDB;.
2017-10-13T10:30:04+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_terms ENGINE=InnoDB;.
2017-10-13T10:30:05+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_terms_common ENGINE=InnoDB;.
2017-10-13T10:30:06+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_types ENGINE=InnoDB;.
2017-10-13T10:30:10+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__languages ENGINE=InnoDB;.
2017-10-13T10:30:13+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__menu ENGINE=InnoDB;.
2017-10-13T10:30:14+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__menu_types ENGINE=InnoDB;.
2017-10-13T10:30:14+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__messages ENGINE=InnoDB;.
2017-10-13T10:30:15+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__messages_cfg ENGINE=InnoDB;.
2017-10-13T10:30:16+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__modules ENGINE=InnoDB;.
2017-10-13T10:30:18+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__modules_menu ENGINE=InnoDB;.
2017-10-13T10:30:19+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__newsfeeds ENGINE=InnoDB;.
2017-10-13T10:30:21+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__overrider ENGINE=InnoDB;.
2017-10-13T10:30:22+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__redirect_links ENGINE=InnoDB;.
2017-10-13T10:30:23+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__schemas ENGINE=InnoDB;.
2017-10-13T10:30:24+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__session ENGINE=InnoDB;.
2017-10-13T10:30:27+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__template_styles ENGINE=InnoDB;.
2017-10-13T10:30:28+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__updates ENGINE=InnoDB;.
2017-10-13T10:30:29+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__update_sites ENGINE=InnoDB;.
2017-10-13T10:30:32+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__update_sites_extensions ENGINE=InnoDB;.
2017-10-13T10:30:34+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__users ENGINE=InnoDB;.
2017-10-13T10:30:36+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__usergroups ENGINE=InnoDB;.
2017-10-13T10:30:38+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__user_notes ENGINE=InnoDB;.
2017-10-13T10:30:38+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__user_profiles ENGINE=InnoDB;.
2017-10-13T10:30:40+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__user_usergroup_map ENGINE=InnoDB;.
2017-10-13T10:30:42+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__viewlevels ENGINE=InnoDB;.
2017-10-13T10:30:46+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__newsfeeds ADD COLUMN description text NOT NULL;.
2017-10-13T10:30:48+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__newsfeeds ADD COLUMN version int(10) unsigned NOT NULL DEFAUL.
2017-10-13T10:30:50+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__newsfeeds ADD COLUMN hits int(10) unsigned NOT NULL DEFAULT '.
2017-10-13T10:30:53+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__newsfeeds ADD COLUMN images text NOT NULL;.
2017-10-13T10:30:57+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__contact_details ADD COLUMN version int(10) unsigned NOT NULL .
2017-10-13T10:31:00+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__contact_details ADD COLUMN hits int(10) unsigned NOT NULL DEF.
2017-10-13T10:31:02+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banners ADD COLUMN created_by int(10) unsigned NOT NULL DEFAU.
2017-10-13T10:31:06+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banners ADD COLUMN created_by_alias varchar(255) NOT NULL DEF.
2017-10-13T10:31:08+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banners ADD COLUMN modified datetime NOT NULL DEFAULT '0000-0.
2017-10-13T10:31:10+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banners ADD COLUMN modified_by int(10) unsigned NOT NULL DEFA.
2017-10-13T10:31:13+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__banners ADD COLUMN version int(10) unsigned NOT NULL DEFAULT .
2017-10-13T10:31:18+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__categories ADD COLUMN version int(10) unsigned NOT NULL DEFAU.
2017-10-13T10:31:18+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: UPDATE #__assets SET name=REPLACE( name, 'com_user.notes.category','com_users.
2017-10-13T10:31:18+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: UPDATE #__categories SET extension=REPLACE( extension, 'com_user.notes.catego.
2017-10-13T10:31:21+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_terms ADD COLUMN language char(3) NOT NULL DEFAULT '';.
2017-10-13T10:31:21+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_tokens ADD COLUMN language char(3) NOT NULL DEFAULT ''.
2017-10-13T10:31:21+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: ALTER TABLE #__finder_tokens_aggregate ADD COLUMN language char(3) NOT NULL .
2017-10-13T10:31:21+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: INSERT INTO #__extensions (name, type, element, folder, client_id, .
2017-10-13T10:31:22+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: INSERT INTO #__template_styles (template, client_id, home, title, par. 2017-10-13T10:31:22+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: UPDATE#__template_stylesSET home = (CASE WHEN (SELECT count FROM (SELECT cou. 2017-10-13T10:31:22+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: UPDATE#__template_stylesSET home = 0 WHERE template = 'bluestork';. 2017-10-13T10:31:22+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: INSERT INTO#__extensions(extension_id,name,type,element,folder. 2017-10-13T10:31:23+00:00 INFO ::1 update Ran query from file 3.0.0. Query text: UPDATE#__update_sitesSET location = 'http://update.joomla.org/language/trans. 2017-10-13T10:31:46+00:00 INFO ::1 update Finalising installation.
@mbabker @wojsmol @brianteeman
Nothing wrong with the updates unless it uses commands that some databases (for whatever reason) wont process. Just tested on a live server FULL SUCCESS in less than 4 minutes.
Shared cheap Hosting
PHP Built On Linux info 3.0 # 1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux
Database Version 5.5.57-0+deb7u1-log
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.31
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.8.1 Stable [ Amani ] 4-October-2017 14:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-11-18 17:50:12 |
| Closed_By | ⇒ | brianteeman |
Thanks. I'm going to take a look into that later thanks.