PDA

View Full Version : Mysql error on install


mv07921
03-06-2007, 08:09 PM
Hi,

I'm getting the following MySql error on a re-install

I can send you a screen grab of the following error as well...

MA DB function failed with error number 2006
MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m WHERE m.published = 1 AND m.position = 'header' AND m.client_id = 1 ORDER BY m.ordering
SQL =

SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'header'
AND m.client_id = 1
ORDER BY m.ordering


Upload component - Failed
SQL Error DB function failed with error number 2013
Lost connection to MySQL server during query SQL=DELETE FROM `jos_components` WHERE `option` = 'com_joomla_lms'
SQL =

DELETE FROM `jos_components` WHERE `option` = 'com_joomla_lms'

MA DB function failed with error number 2006
MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m WHERE m.published = 1 AND m.position = 'debug' AND m.client_id = 1 ORDER BY m.ordering
SQL =

SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'debug'
AND m.client_id = 1
ORDER BY m.ordering

mv07921
03-07-2007, 06:25 AM
So I'm guessing that the uninstall script did not have permission to drop tables. I went in to the MySql database and manually dropped the com_joomla_lms tables and reinstalled without a problem.

Is this an issue with the security level of my web configuration or the uninstall script?

den
03-07-2007, 08:25 AM
1. Errors look like problem in MySQl server. You need to contact your host about this.

2. We don't drop any LMS tables during uninstall. This is doing in order to save all LMS data during installing new LMS version.