remository

Revised database manager for Joomla 1.0.15 Download

Description:

This is a fixed version of the database class for Joomla 1.0.15 to deal with a range of problems that can arise with Remository, and possibly with other software.  PLEASE NOTE that this software has been tested on my local PC but has not been used on a live web site - treat it with caution until proven and please report back how well it works for you.

 The issue is that tuning MySQL often involves reducing the timeout for "idle" connections resulting in a situation where you are much more likely to get a "server gone away" error.  It can happen particuarly when Remository attempts to log a download after the file has been sent to the user (it is logical to do this afterwards, otherwise the counts are distorted by failed or abandoned downloads).  If the timeout is set very tight (and there are good reasons for doing this) the problem can arise during the download of a file that is stored in the database.

It is best solved in the CMS because the only other solution is to effectively go round the CMS and recreate the $database object using the configuration.php file (which is no better than modifying the CMS, in principle).  The solution involves retaining the database login credentials within the database class, and using them to reconnect if one of the "gone away" errors occurs.

Submitted By:

Administrator (admin)

Submitted On:

24 Jul 2008

File Size:

9.27 Kb

Downloads:

1000

License:

GNU/GPL

File Version:

1.0.15

File Author:

Martin Brampton based on Joomla

Rating:

Total Votes:0

Be the first to comment! Please sign in or register.