SOLVED Can't Edit Template Due to Failed Joomla Update
-
-
- Bearing Fruit
- Jr. Rocketeer
- Posts: 30
- Thanks: 0
-
I can't edit my Osmosis template from the Template Manager due to fsockopen() error. I am on a LAN that is closed to Internet traffic. There is an attempt to go update.joomla.org but it correctly fails due to no external network connection allowed. How can I get around this so that I can proceed with template edits? I tried to change my php settings to turn off allow_url, but that didn't work.
I'm stuck and would appreciate the help.
-
-
-
- DanG
- Preeminent Rocketeer
- Posts: 36750
- Thanks: 3229
- Custom work done
-
This is probably happening, as Joomla Update requires one of "allow_url_fopen" or "cURL" to be enabled in your PHP settings:
- Admin -> Site -> System Information -> PHP Information -> Core -> allow_url_fopen = OFF
- this means you need cURL to update and your's is probably enabled
- However if you have Admin -> Site -> System Information -> PHP Settings -> Open basedir = NONE
- or
Admin -> Site -> System Information -> PHP Settings -> Safe Mode = OFF then "cURL" won't work
Use allow_url_fopen
This option enables the URL-aware fopen wrappers that enable accessing URL object like files. Default wrappers are provided for the access of remote files using the ftp or http protocol, some extensions like zlib may register additional wrappers. Note: This can only be set in php.ini due to security reasons. Enable and use allow_url_fopen to allow Joomla's One-Click-Update to work properly.
For more information see: PHP Manual: allow_url_fopen and allow_url_includeProper setup will have this: allow_url_fopen = 1
allow_url_include = 0PHP default: allow_url_fopen is enabled
PHP default: allow_url_include is disabled
If allow_url_fopen isn't allowed then use Joomla's "Install from Directory" option.
This option requires that you unpack the archive file in a directory on your server. This is the best method if you have a slow internet connection or you are experiencing timeouts during the update process.- Unpack the archive file in a temporary directory on your local machine.
- Upload all the files in this directory (for example, using FTP) to a temporary directory that is visible to the web server. For example, you can create a sub-directory under the tmp directory in your Joomla root. For this example, let's say the directory on the server is home/myuser/myjoomla/tmp/upgrade250).
- In the Extension Manager: Install screen, enter the full path of the temporary directory (on the server) from step 2 (for example, /home/myuser/myjoomla/tmp/upgrade250).
- Press the Install button.
-
-
-
- Bearing Fruit
- Jr. Rocketeer
- Posts: 30
- Thanks: 0
- Thank you for the response. Because I'm on a closed LAN, I don't need Joomla updates. I just need to edit the template, but I can't because it's trying to update Joomla. Is there a way to bypass the Joomla update process after I select the template, or not have it throw an error, so that I can proceed with template edits?
-
-
-
- DanG
- Preeminent Rocketeer
- Posts: 36750
- Thanks: 3229
- Custom work done
-
Bearing Fruit wrote:
Thank you for the response. Because I'm on a closed LAN, I don't need Joomla updates. I just need to edit the template, but I can't because it's trying to update Joomla. Is there a way to bypass the Joomla update process after I select the template, or not have it throw an error, so that I can proceed with template edits?
Maybe, what version of Joomla x.x.x are you running now?
Try this, go to Admin -> Extend -> Joomla! Update -> Options -> Joomla! Update Configuration -> Update server -> Long Term Support | Short Term Support | Currently configured (no change)
Select "Currently configured (no change)" and Save.
-
-
-
- Bearing Fruit
- Jr. Rocketeer
- Posts: 30
- Thanks: 0
- I've done that before, but no success. I am running Joomla 3.2.4
-
-
-
- DanG
- Preeminent Rocketeer
- Posts: 36750
- Thanks: 3229
- Custom work done
-
Bearing Fruit wrote:
I've done that before, but no success. I am running Joomla 3.2.4
Okay...time to take the gloves OFF
In your PhPMyAdmin or Adminer console, run this query (Your_DB_Prefix stands for your Database prefix):
SELECT * FROM `Your_DB_Prefix_extensions` WHERE `extension_id` = '700' AND `name` LIKE '%files_joomla%'
You should get a hit. In the 'manifest_cahce' column it should say your current Joomla version is 3.2.4.
Next run this query:
UPDATE `Your_DB_Prefix_extensions` SET `extension_id` = '700', `name` = 'files_joomla', `type` = 'file', `element` = 'joomla', `folder` = '', `client_id` = '0', `enabled` = '1', `access` = '1', `protected` = '1', `manifest_cache` = '{\"name\":\"files_joomla\",\"type\":\"file\",\"creationDate\":\"April 2014\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.3.1\",\"description\":\"FILES_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}', `params` = '', `custom_data` = '', `system_data` = '', `checked_out` = '0', `checked_out_time` = '0000-00-00 00:00:00', `ordering` = '0', `state` = '0' WHERE `name` = 'files_joomla' AND `name` = 'files_joomla' COLLATE utf8_bin LIMIT 1;
When Joomla starts up to check the version it will see 3.3.1 and hopefully leave you alone
-
-
-
- Bearing Fruit
- Jr. Rocketeer
- Posts: 30
- Thanks: 0
-
OK, so I went through your instructions, but unfortunately it didn't work. Here are my notes:
Database Update- Error 1253 (42000): Collation 'utf8_bin' is not valid for Character Set 'latin1'
- I didn't think this was a big deal, so I reran the database update script without the collation. Updated with no problems.
- Still shows the Joomla! version is 3.2.4
- Warning: Database is not up to date. Database update version (3.3.1) does not match CMS version (3.2.4)
- After I selected Fix, the manifest_cache 'version' tag was updated to 3.2.4
- I reran the database update script so the 'version' tag is now back to 3.3.1, but I still get the database version mismatch warning.
The link to edit the template is: http://<myjoomlaserver>/administrator/index.php?option=com_gantry&task=template.edit&id=11
Does the template edit task also call the Joomla update check? If I update to 3.3.1 will Gantry still go out to update.joomla.org for update checks? I'm willing to try any other suggestions.
Thanks for your help.
-
-
-
- DanG
- Preeminent Rocketeer
- Posts: 36750
- Thanks: 3229
- Custom work done
-
I'm used to a utf8_general_ci collation but if your running something different than thats fine. Can you try to edit the manifest_cache column data to change it from 3.2.4 to 3.3.1?
When I tried this on my local I had an earlier J3.x.x version and had the alert message to update to J3.3.1. As soon as I changed the data and did a page refresh the alert message went away. - Last Edit: 10 years 9 months ago by DanG.
-
-
-
- Bearing Fruit
- Jr. Rocketeer
- Posts: 30
- Thanks: 0
-
Hi Dan,
I had already run the script to change the manifest_cache column back to 3.3.1. Was your local server connected to the Internet? I can certainly just update to 3.3.1, but I think that Gantry will still go out to the Internet and check for updates. Is there a way to either prevent Gantry from calling update.joomla.org or to have a "success" message come back so that Gantry won't throw the fsockopen() error message?
Thanks again.
-
-
-
- DanG
- Preeminent Rocketeer
- Posts: 36750
- Thanks: 3229
- Custom work done
-
Bearing Fruit wrote:
Hi Dan,
I had already run the script to change the manifest_cache column back to 3.3.1. Was your local server connected to the Internet? I can certainly just update to 3.3.1, but I think that Gantry will still go out to the Internet and check for updates. Is there a way to either prevent Gantry from calling update.joomla.org or to have a "success" message come back so that Gantry won't throw the fsockopen() error message?
Thanks again.
Yes my local server is Online. Also the call to check for Joomla updates is part of the Joomla core. Gantry only checks for its own framework and our product extensions.
-
Time to create page: 0.069 seconds