Error on message on Install

I have tried up install the new version of ChoroForms after UnInstall of the previous version and received an error message. Could you please provide me with some guidance on solving this problem. Sorry, I am a novice and mostl likely am missing something. BTW, I tried to install three times, with no success. Thank you in advance.

JInstaller::install: SQL Error. DB function failed with error number 2013
Lost connection to MySQL server during query SQL=DROP TABLE IF EXISTS `jos_chrono_contact`;
SQL = 
DROP TABLE IF EXISTS `jos_chrono_contact`;Component Install: SQL Error. DB function failed with error number 2013
Lost connection to MySQL server during query SQL=DROP TABLE IF EXISTS `jos_chrono_contact`;
SQL = 
DROP TABLE IF EXISTS `jos_chrono_contact`;

Hi,

that's because of the mysql max input time, try to change these settings at your server or ask your host to do :

mysql.connect_timeout = 60
max_execution_time 600
memory_limit = 36M
max_input_time from 60 to 120

the problem is that the last release is about 800KB and it takes more time to upload and unpack and for few users this error occurs.

another solution is to extract the package, remove all files under the admin/js/tinymce folder, then pack the package again, install it, then uplad the deleted files to the correct path on server.

Regards

Max

Thanks Max, for the suggestion.

I used the method of removing the admin/js/tinymce folder, zipped and uploaded. Everything seems to have gone well, except...

The Form Wizard is not operational. There is no buttons for new, etc., only Cancel.

Great, the form wizard doesn't need this, you use drag and drop🙂

drag the form elements from the right side to the left side pane.

OK ... thanks for pointing me in the correct direction.

However, I am still having some problems. I will post a few new threds to address the issues I am having,

I'm getting this same error. After reading Max's suggestions, I tried calling GoDaddy where I'm hosting this Joomla installation. I asked them about changing to these settings as suggested:

mysql.connect_timeout = 60
max_execution_time 600
memory_limit = 36M
max_input_time from 60 to 120

And they flat out refused to even consider it, supposedly because it could affect other users. They also said they had no capability to check the load of the database server I'm trying to install to, despite the fact that I've also had slow response times from the Joomla admin panel. Absolutely useless customer support at GoDaddy.

I'm going to attempt to upload the files and try an "Install from Directory" in the Joomla Extension Manager.

Hi froyse,

I'm sorry that this was their reply, but the issue is that the latest versions had a big install file (around 1 Meg) and that makes a problem, its in my todo list to step down the size, its because of the editor files included, about 800KBN alone!

I think your solution may work fine! it will be quicker from the same server!

Regards
Max

Fixed... tryed again on the 3th day... without any problem. Might switch server. Thanks max for thinking with me for a solution.

no problems! thanks for confirming!🙂

Max

I too am on GoDaddy hosting and i'm having the same problem. I just copied everything to the TMP directory and tried to install it with the same error.

EDIT: I tried the 2.5v and it worked. That will work for me for now.

yes, 2.5 will work because the installer size is small, you need to either change the limits above or remake the installer

Max

And i'm back... The RC5 installed fine on my GoDaddy Account. But now i'm installing it on my VPS and its getting error 2006 and the upload takes a while. How/where do I find the info to change my server settings? I've never had any issue on my server, only with GoDaddy. Now its flipped around😟

Hi, in your VPS, did you make a fresh install or you tried to install over the installed one ? the 2 ways should work with RC5 if you have RC4 or above!

Cheers
Max

Hi, in your VPS, did you make a fresh install or you tried to install over the installed one ? the 2 ways should work with RC5 if you have RC4 or above!

Cheers
Max

fresh install. No worky.

Hi,

I think its a server setting some where, Fredrik has posted different suggestions here:
http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=2&t=13985&start=0

but I'm not sure which may be yours, however you have a VPS and should have more control over the PHP config so try to do any of the suggested changes and stop then run the apache service!

Regards
Max

From what I've gathered, the 2006 Error would be MySQL's "Server gone away", usually the result from large queries or too long idle-time. You could try to increase the wait_timeout mysql server variable, although this would involve hacking the installation package to include the proper SQL directive (would be added to chronocontact.xml):

<query>SET wait_timeout=120</query>

Edit: On second thought, that probably won't help, as the query won't be sent until the archive is unpacked and files copied (by then the MySQL server has probably already dropped the connection).

/Fredrik