Mandatory information about my setup:
Have I read the related troubleshooter articles above before posting (which pages?)? https://www.akeebabackup.com/documentation/troubleshooter/abinstallation.html
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.9
PHP version: 5.3.18
MySQL version: 5.5.28
Host: zen.co.uk
Akeeba Backup version which took the backup: 3.6.12
Kickstart version used to extract the backup: 3.6.0
Description of my issue:
I restored a site from a development area to it's live area, and I have multiple issues appearing on the live site that you might be able to guide me on.
The first issue noticed was that the Joomla Media manager failed to upload images, although it was possible to delete images.
The failure displays 2 warnings on an otherwise blank screen:
Warning: mysql_fetch_row() expects parameter 1 to be a resource, boolean given in /.../public_html/libraries/joomla/database/mysql.php on line 683
Warning: mysql_fetch_row() expects parameter 1 to be a resource, boolean given in /.../public_html/libraries/joomla/database/mysql.php on line 726
Both refer to methods refer to loading a result-set row into memory and then releasing said result-set row.
After failing to find a solution, and noting that the media manager bundled with K2 is working fine I considered reinstalling the Joomla Core (2.5.9).
Before doing this I wanted to backup and upgrade Akeeba Backup and Admin Tools currently running versions 3.6.12 and 2.4.4 respectively.
While the components continue to work I am unable to upgrade Admin Tools either via Live Update or the Extension Manager. A 403 error screen appears:
Forbidden
You don't have permission to access /administrator/index.php?option=com_admintools&view=liveupdate&task=install on this server
In addition when I take the site into 'Emergancy Offline' mode I get locked out of the administration area of the site until I manually replace the .htaccess file via FTP.
These sets of issue are not occurring on the development site, I have upgraded Admin Tools successfully and the original issue of the media manager is not occurring here. Both sites are within the same cpanel.
I think the above issues could be related. These issues seem like a permission problem from the restoration of the site. I have run the fix permission feature on Admin tools (files 644, directories 755), but this did not solve the upgrade issue, and the log and tmp directors are correctly configured for the live site.
If you could suggest a likely cause or course of action I would be very grateful.
I could at this stage remove the apparently corrupted live site and restore again from the development area, which could be a good course of action?
Thank you for your time.
Doug