Hello,

I purchased breezing forms and have tried installing via you instructions provided with the com_breezingforms_165.zip and am getting the attached error.

Are you able to advise me.

PS I don't have access to php.ini file is there another workaround?

Thank you in advance

Mozzie

Hi,

this is a limitation of your host. Please ask the administrators of your server to raise mysql's max allowed package option significantly.

You might get these kind of problems for any bigger extensions. (like phocagallery or community builder)

I just purchased today and when installing Breezeforms I received the same error



* Component Install: DB function failed with error number 2006
MySQL server has gone away SQL=INSERT INTO jos_components VALUES( 0, 'BreezingForms', 'option=com_facileforms', 0, 0, 'option=com_facileforms', 'BreezingForms', 'com_facileforms', 0, 'js/ThemeOffice/component.png', 0, 'ff_com_page=1\nff_com_align=1\n', 1 )
SQL =

INSERT INTO jos_components VALUES( 0, 'BreezingForms', 'option=com_facileforms', 0, 0, 'option=com_facileforms', 'BreezingForms', 'com_facileforms', 0, 'js/ThemeOffice/component.png', 0, 'ff_com_page=1\nff_com_align=1\n', 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

Message

What exactly needs to be increased by the host? Could you be very specific so I know what to tell my host, which is 1and1?

Thanks,

Steve

I had a similar error and after a few hours finally figured out how to get BreezingForms Component to install. For me it had to do with directory permissions and the use of FTP by Joomla!. I don't think this has anything at all to do with MySQL, I think it is a major issue with how Joomla! uses FTP to place files on the server it resides on in order to get around permission issues on the server.

I only installed the component, if you need to install the plugin and module you'll need to figure out which directories will need permission changes (see below). In any case here's what I did for the component :

Enable FTP = No
Copy the configuration.php file from your server to your local hard drive and change ftp_enable and then upload it back to your server.
var $ftp_enable = '0';

This will turn off the ftp placement of components, plugins, images, pdfs, etc.

Set Permissions on Directories to 777
For the following directories use your ftp client to set the permissions to 777. Before doing so check the current settings, they are usually 755 and make a note of it :
/components/
/administrator/components/

Upload the un-zipped package
Upload via your ftp client the un-zipped package, e.g., com_breezingforms_171, to the following folder :
/tmp/com_breezingforms_171

Install from the Server
Install the component, but specify the location as being on the server in the /tmp/com_breezingforms_171/

Joomla! will complain about a few files and directories; don't worry.

Install the Language Files Manually
Use your ftp client to upload the appropriate language folders/files to your site :
public = /components/language/
admin = /administrator/language/

Set Permissions on Directories to 755
Using your FTP client set the permissions on the following directories back to 755 or what your noticed earlier. You should not leave them at 777.
/components/
/administrator/components/

Enable FTP = Yes
Copy the configuration.php file from your server to your local hard drive and change ftp_enable and then upload it back to your server.
var $ftp_enable = '1';

This will turn on the ftp placement of components, plugins, images, pdfs, etc.

Finish the Install
Go to the menu Components:BreezingForms:Configuration.
Click on Package Installer.
Select Install package from file on server.
If you want the sample forms install samples.english.xml
Then install the standard js library stdlib.english.xml

Another method I tired was to install the component manually; this requires no directory permission changes for the install and I prefer this method. There is a downside that can be overcome, which I will explain at the end of this post.

Upload the Files Manually
For this "fix" you extract the BreeszingForms component locally and upload it manually to the correct folders on the server.

/administrator/components/com_breezingforms/
admin
captchas
images
joomfish
legacyclasses
libraries
mailtpl
packages
pdftpl
sql
admin.breezingforms.php
breezingforms.xml
classloader.php
index.html
install.secimage.php
toolbar.facileforms.php
uninstall.secimage.php

/administrator/language
upload the appropriate languages from the component's /language/admin/

/components/com_breezingforms
downloadtpl
images
libraries
themes
uploads
breezingforms.php
facileforms.class.php
facileforms.config.php
facileforms.js
facileforms.process.php
facileforms.xml.php
index.html
markdown.php

/language
upload the appropriate languages from the component's /language/public/

Install the BreezingForms Menus
Using phpMyAdim you can run the following SQL against your Joomla! database, replace the ### with your Joomla! database's prefix and remove the ids.



Install the BreezingForms Standard Script Library
Go to the menu Components : BreezingForms : Configuration.
Click on Package Installer.
Select Install package from file on server.
At the end of the path make sure the file points to stdlib.english.xml

(Optionally) Add the BreezingForms Sample Library
Go to the menu Components : BreezingForms : Configuration.
Click on Package Installer.
Select Install package from file on server.
At the end of the path make sure the file points to samples.english.xml

Add the MM Functions
Go to Extensions : Install/Uninstall.
Browse to the plg_mmfuncs.zip file on your local computer.
Click on Upload & Install.
Go to Extensions : Plugin Manager.
Find MMFuncs in the list and enable it.

Downside & Workaround for it
The only downside I found was that Breezing Forms does not seem to use the FTP Client details in the site's Global Configuration settings to save packages you create, so you get the following message when creating a package *** ABUSE WARNING ***.

The work around is to temporarily set the permissions of the directory /administrator/components/com_breezingforms/packages to 777. Create the package and then change the directory permissions back to what they were, usually 755.

I looked into this further and noticed that the mkPackage() function in the config.class.php was using fopen to save the created packages. I updated the method so that it uses the JFile::write() method instead and this resolved the issue. I'll submit my changes to crosstec and let them proof my code for a possible update.