MySQL database problems

11 years 2 months ago - 11 years 2 months ago #1 by geoffc
We were informed by a user of database problems being encountered on their system which prevented the users from being able to change their passwords after installation of the Macrotone Password Control Plugin.

The error they were seeing was similar to the following:

"PROCEDURE joomla2_updcontroltable does not exist SQL=CALL joomla2_updcontroltable (64,"2012-12-25 11:01:14","2012-12-25 11:01:15","385e8e9bf8ddd84ae2f7aff9f50be797:PYU9syupeZPQT8CxOe58KIxdy8IvDOg4",1)"

The error indicates that the procedure #__updcontroltable does not exist. Since this was a fresh installation this was puzzling since the procedure in created upon the install yet no errors were seen upon the installation.

When an attempt was made to uninstall the plugin the following error was seen:

JInstaller: :Install: Error SQL DB function failed with error number 1548
Cannot load from mysql.proc. The table is probably corrupted SQL=DROP PROCEDURE IF EXISTS joomla2_updcontroltable;
SQL =
DROP PROCEDURE IF EXISTS #__updcontroltable;

This error provides a clue to what we think is going on. It looks very much as if the base MySQL tables themselves are corrupt. This would explain why the procedure was not installed (although we are surprised no error was seen on installation of the plugin).

Fortunately the plugin does provide an option to use a PHP routine instead. What was not so handy was the fact the the plugin PHP routine was seeing a database error which was not being reported (creating a blank white screen) due to a variable not being defined. This latter error has been corrected in the latest Password Control System Plugin version 0.0.6 which has just been released, so at least a valid eror message should now be visible.

This in the second case of a corrupt MySQL database we have received within the past month. We suspect that the problem is caused by 'system providers' not being on top of their game, and all we can really do is refer the users to their system provider to resolve their database corruption. It is not a problem per-se with the plugin itself, as it is only accessing the MySQL base tables to install itself, using standard Joomla routines. We do not know if it was the same provider in both reported cases. It does however illustrate the need to have a good service provider who looks after their systems correctly especially if they do not permit their customers control over the underlying database.

Regards
Geoff

Please Log in or Create an account to join the conversation.

Time to create page: 0.129 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries