RSGallery2 Support Forums

I've not been able to install RSG2 to a Joomla 1.0.13 site.


Not sure why this times out, everything on the site is working properly...

Thoughts?

I tried running this query using phpmysqladmin, it runs correctly.

My hunch is there's some transaction open in the database too long, perhaps while unpacking and moving the installer files.  It happened once, long ago, with the JCE Editor mambot.

In that case, I unpacked the files by hand as the files in the installer package were copied directly to the plugin folders.   But that doesn't seem to be the case for RSgallery2.

On the assumption the files are unpacking correctly, I'll try to manually add the component using the backend...

After adding the record to jos_components, I see this in the RSGallery2 Control Panel:


Created these folders, but apparently the table "jos_rsgallery2_config" doesn't exist...

I guess I will just wait for some type of fix, since I don't have time to dig and find all the schema objects that are missing...  :-\

You could try installing RSG2 from directory, and see if skipping the uploading part speeds up the install enough.

Or, since you have the record in the components table already, dump all the rsgallery2 tables.  then run the sql in sql/rsgallery2.sql.  That should put you at a position where you are good to go.

Are you using GoDaddy for hosting?  others have had problems as well.

I'd tried install from directory, and after tripping around figuring out how that feature really works.  It gives the same error.

I am suspicious there's something in the install script hanging on to some resource that should be released.

Yes, I'm using GoDaddy.   But I've not had the problem with other sites on using that service...  Guess I'm just on a slow host, or being throttled, since the MySQL database reports over 1,000,000,000 queries since last October.   Am not sure what parameter to suggest changing, yet.


Anyhow, I've run the queries in the rsgallery2.sql script, and the site seems good to go thus far.

Thanks.

Hello - I am a relative newbie to the coding side of Joomla. I am trying to install RSG2, with GoDaddy on Joomla 1.0.13 plateform and am having the same problem. I have installed template Ja Avain - does the error have anything to the with the template (should I have installed the Ja Avain II?) or is this strictly limited to the database.

This is the string of errors I get:
DB function failed with error number 2013
Lost connection to MySQL server during query SQL=INSERT INTO jos_components VALUES( '', 'RSGallery2', 'option=com_rsgallery2', 0, 0, 'option=com_rsgallery2', 'RSGallery2', 'com_rsgallery2', 0, 'js/ThemeOffice/component.png', 0, '' )
SQL = 

DB function failed with error number 2013
Lost connection to MySQL server during query SQL=INSERT INTO jos_components VALUES( '', 'RSGallery2', 'option=com_rsgallery2', 0, 0, 'option=com_rsgallery2', 'RSGallery2', 'com_rsgallery2', 0, 'js/ThemeOffice/component.png', 0, '' )
SQL =
INSERT INTO jos_components
 VALUES( '', 'RSGallery2', 'option=com_rsgallery2', 0, 0, 'option=com_rsgallery2', 'RSGallery2', 'com_rsgallery2', 0, 'js/ThemeOffice/component.png', 0, '' )

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

Any help deciphering this is much appreciated!

The install is making it as far as unpacking your files on your Joomla! site, then failing cause the database connection timed out, as far as I can tell.

There's no reason for a simple INSERT to time out, so it must be some sort of session transaction timeout hitting GoDaddy users.   I didn't see a MySQL parameter in their list to request an update in a quick scan, so I did the following:

1)  Grab that INSERT INTO ... statement, go to the GoDaddy phpmysqladmin window for your joomla database, and open a SQL window.  Paste in the INSERT statement and run it.      This will enter the component into the Joomla database.

2)  With your FTP client, create the folders "images/rsgallery", "images/rsgallery/display", "images/rsgallery/original" and "images/rsgallery/thumb", mode 755.

3)  Open the "administrator/components/com_rsgallery2/sql/rsgallery.sql" file.    Replace the "#__" statements in each statement with "jos_" (only one underline remains)

4)  Copy each SQL statement into your SQL window and run them.   I did them one at a time.

From there, you should be able to open and manage the component.

Thanks Jon! I also had the same error on GoDaddy but I followed your instructions and voila! RSG2 is up.

I have fixed some bugs that I believe affected this.  Can someone try the latest RSG2 Legacy at http://rsgallery2.net/nightly/ and let me know if this issue is resolved?

Thanks.

Jonah,

I picked up Build 679 a few minutes ago, and I see the same problem.  Tried it twice.


There are other errors on the page refresh after failure, in case these provide a clue.  I

The display is sloppy, but here goes:




Jon

Nightly build SVN720 installs now for me using php 4 see other post here
http://rsgallery2.net/component/option,com_smf/Itemid,17/topic,15105.msg38786#msg38786

I just uploaded SVN720 and receive the error:

 Upload component - Failed
XML setup file is not for a "component".
[ Continue ... ]

It took some time poking around and comparing settings, suggestions, etc... the fix for GoDaddy is to increase your MySQL timeout in your PHP.INI (PHP5.INI if you are running PHP 5). Add these lines and rsGallery2 will install.

mysql.connect_timeout = 60
max_execution_time 600
memory_limit = 36M

I tried this using SVN679, since I SVN720 is ill -- see prior post.

But the same errors appear.  You're probably on to something, as it seems the timeouts are mismatched between PHP and MySQL.   GoDaddy wouldn't acknowledge the problem when I called them on it, saying they can't change global parameters.   That makes some sense, but it is still frustrating.

I'm in a GoDaddy / PHP4 funk, and haven't had much time to work on this recently.

I followed this to get my installation up and runningon godaddy (it was a upgrade of a rsgallery2 installation).  I get:
Creating Image directories not Implemented yet.

Down as far as posting images or  resizing thumbnails.  Any ideas?

trying something.
I noticed that the mysql dbases were different between two sites i had. one site was running mysql 4.1 and the other was running 5.0. the 5.0 was working easily.
I will try to update the site to 5.0 and will see if it works.

its not mysql 5.0, still did not work. i will try the other way listed above when i have more time.

I too recieved a similar error I'm not on GoDaddy and I'm not on 1.0.13 but 1.0.15  after deleting the component directory and reinstalling the installation worked but there are a lot of database issues I cannot solve as I am no expert on either php or mysql.

I'm also seeing this problem.  I can install any version up to 1.14 without running into this problem, but 1.14.0 through 1.14.3 produce this error.  Installs okay on my local test server.  Tried making the suggested PHP.INI changes (mysql.connect_timeout = 60, max_execution_time = 600, memory_limit = 36M) in my site's root (which does seem to override the Godaddy globals) but they made no difference.  I'm working with Godaddy on this and will post anything of interest.

My live site is on Godaddy:
PHP built On:  Linux p3slh113.shr.phx3.secureserver.net 2.4.21-53.ELsmp #1 SMP Wed Nov 14 03:54:12 EST 2007 i686 
Database Version:  4.0.27-max-log 
PHP Version:  4.3.11 
Web Server:  Apache 
WebServer to PHP interface:  cgi-fcgi 
Joomla! Version:  Joomla! 1.0.15 Stable [ Daytime ] 22 February 2008 23:00 UTC 

My test server:
PHP built On:  Linux lamp 2.6.20-16-server #2 SMP Sun Sep 23 19:57:25 UTC 2007 i686 
Database Version:  5.0.38-Ubuntu_0ubuntu1.1-log 
PHP Version:  5.2.1 
Web Server:  Apache/2.2.3 (Ubuntu) mod_python/3.2.10 Python/2.5.1 PHP/5.2.1 mod_ssl/2.2.3 OpenSSL/0.9.8c mod_perl/2.0.2 Perl/v5.8.8 
WebServer to PHP interface:  apache2handler 
Joomla! Version:  Joomla! 1.0.15 Stable [ Daytime ] 22 February 2008 23:00 UTC 

UPDATE: GoDaddy says they can't help with application problems, which they've clearly decided is the case here.  I asked them about MySQL settings, since other people on these forums are speculating that the problem is there.  Meanwhile, it seems to me that if I can install any version prior to 1.14.x with no problems, but nothing from 1.14.0 onward installs without this error, something must have changed in 1.14.0 that is causing this.  I think it would be great if an RSGallery2 developer would dig into this a bit to see if maybe a change that appeared in 1.14.0 is causing this and could perhaps be reworked.  Others have speculated that 1.14.0 is making some invalid assumptions about Joomla (i.e. that it's 1.5, not 1.0.x).  Failing that, some specific recommendations regarding settings would be helpful.  Thanks!

UPDATE: Godaddy says there are no MySQL settings that can be set by the user; they are all global.  If it turns out I need to change a MySQL setting to avoid this problem I'll be looking at changing to a different hosting provider.

UPDATE: I seem to have resolved this by making the following changes to my Godaddy root PHP.INI:
mysql.connect_timeout = 120 (previously tried 60)
max_execution_time = 600 (did this earlier to no effect)
memory_limit = 36M (did this earlier to no effect)
max_input_time = 120 (hadn't tried this before)

Not sure what fixed it but I'm happy anyway.