TOPIC: Component install issue.. HELP!

I've been looking through the forum, and I've not found anyone else asking about this error.

I'm trying to install JoomlaComment 3.26, with Joomla version 1.5.9

I have enabled Legacy. I tried following the instructions in the Wink file, but no success.

Whenever I try to install the component, it tells me "install component success" but it also shows an error:

* Component Install: DB function failed with error number 2006
MySQL server has gone away SQL=INSERT INTO jos_components VALUES( 0, '!JoomlaComment', 'option=com_comment', 0, 0, 'option=com_comment', '!JoomlaComment', 'com_comment', 0, 'js/ThemeOffice/component.png', 0, '', 1 )
SQL =

INSERT INTO jos_components VALUES( 0, '!JoomlaComment', 'option=com_comment', 0, 0, 'option=com_comment', '!JoomlaComment', 'com_comment', 0, 'js/ThemeOffice/component.png', 0, '', 1 )

* Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering

Does anyone has any idea what this could mean and/or how to fix the issue? Despite it saying install was successful, I do not see any options anywhere in the backend for JoomlaComment

Thanks all.

Do you see the component in backend?

No I do not see the component in the backend. The options aren't listed in the components menu on top, and if I goto the plugin manager, nothing for !JoomlaComments is listed in the Content plugins.

I know I've using version 4.x of Mysql... I'm trying to find what version of Mysql is required, but no luck. Would this cause an issue?

Hm, that is possible. That are normaly SQL statements, nothing fancy, so it should work. Do you have phpmyadmin? You can try to execute the following code directly there:

Thanks. I think that the hosting site lets you use phpmyadmin. I'll get a look and give it a shot.

Thanks!

I have the same problem with Joomla 1.5 / JoomlaComment 4.0 / MySql 5.

Component Install: DB function failed with error number 2006
MySQL server has gone away SQL=INSERT INTO jml_components VALUES( 0, '!JoomlaComment', 'option=com_comment', 0, 0, 'option=com_comment', '!JoomlaComment', 'com_comment', 0, 'js/ThemeOffice/component.png', 0, '', 1 )
SQL =
INSERT INTO jml_components VALUES( 0, '!JoomlaComment', 'option=com_comment', 0, 0, 'option=com_comment', '!JoomlaComment', 'com_comment', 0, 'js/ThemeOffice/component.png', 0, '', 1 )Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jml_modules AS m LEFT JOIN jml_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering

I can execute the code directly in Phpmyadmin, but after that, still nothing.......

Thanx!!

Ok, here is a nice explanation why it happens
www.josephburford.com/2008/06/joomla-err...erver-has-gone-away/

YES!!

I Copied al the files to the tmp directory and installed from there with succes.

Thanx a lot!

I think I'm getting the same type of installation error..where can I find the php.ini and my.cnf files? thanks

John Leake wrote:

I think I'm getting the same type of installation error..where can I find the php.ini and my.cnf files? thanks

I have no idea where the my.cnf file is, but php.ini can be found in your webhost root folder. Usually though, it's only editable for deticated servers - for Shared Hosting plans, you'll have to make a new php.ini file in the same folder as the .PHP file(s) you want to apply them to. Obviously public_html/ is needed, administrator/ would be too - and then you'd probably have to duplicate them a lot of times.

But before you do that, check your webhost control panel to see if you can change anything there. Otherwise, my best recommendation would be to lodge a support ticket with your host company and cite that article, asking them to change your webhost configuration to reflect the same settings on the host - saving you all that php.ini work.

Hey John, if you are on a shared host you most probably can't edit those values. I think that the best thing would be unziping the extension, upload it to the tmp directory and install it from there. This will save you a lot of time, since the server won't need to unzip the file - so you shoul win 10-20 seconds.

Daniel Dimitrov wrote:

Hey John, if you are on a shared host you most probably can't edit those values. I think that the best thing would be unziping the extension, upload it to the tmp directory and install it from there. This will save you a lot of time, since the server won't need to unzip the file - so you shoul win 10-20 seconds.

I tried doing this and get the same problem. I don't have a slow internet connection so I don't know why it still gets timed out.

I tried to install it again today from the tmp directory and it worked this time..

thanks for the advice Daniel!