RSGallery2 Support Forums
Welcome, Guest. Please login or register.

Login with username, password and session length
  Home    Forum    Help    Search    Login    Register  
*
News : December 04, 2008, 04:04:06 pm
+  RSGallery2 Support Forums
|-+  RSgallery2 support forums
| |-+  RSgallery2 bugs & problems (Moderators: Jonah, Tomislav Ribicic, Daniel Tulp, Ronald Smit)
| | |-+  [GoDaddy install issues] RSG2 1.14.3 on Joomla! 1.0.13 install fails		 Advanced search
  « previous next »
Topic Tools Search this topic
 Pages 1 2
Author
Sticky Topic Topic: [GoDaddy install issues] RSG2 1.14.3 on Joomla! 1.0.13 install fails  (Read 20033 times)
« on: February 21, 2008, 04:21:48 pm »
Jon Offline
Newbie
*
 Posts: 28


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

Code:
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, '' )

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

Thoughts?
« Last Edit: February 22, 2008, 01:06:22 pm by Jonah » Logged
 
Reply #1
« on: February 21, 2008, 07:02:39 pm »
Jon Offline
Newbie
*
 Posts: 28


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...
Logged
 
Reply #2
« on: February 21, 2008, 07:13:46 pm »
Jon Offline
Newbie
*
 Posts: 28


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

Code:
The following settings prevent RSGallery2 from working without errors:

<site>/images/rsgallery/display does NOT exist! Please create this folder and make sure you CHMOD the folder to 0755!

 <site>/images/rsgallery/thumb does NOT exist! Please create this folder and make sure you CHMOD the folder to 0755!

 <site>/images/rsgallery/original does NOT exist! Please create this folder and make sure you CHMOD the folder to 0755!

 <site>/html/images/rsgallery does NOT exist! Please create this folder and make sure you CHMOD the folder to 0755!

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...  Undecided
Logged
 
Reply #3
« on: February 21, 2008, 09:05:48 pm »
Jonah Offline
Administrator
Hero Member
*****
 Posts: 1414


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.
Logged
Due to time constraints, I have taken a step back from RSGallery2.  In the event of an emergency, you will need to PM me.
 
Reply #4
« on: February 22, 2008, 12:06:40 am »
Jon Offline
Newbie
*
 Posts: 28


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.
Logged
 
Reply #5
« on: February 23, 2008, 02:17:33 pm »
melissablevins Offline
Newbie
*
 Posts: 1


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!
Logged
 
Reply #6
« on: February 23, 2008, 03:53:50 pm »
Jon Offline
Newbie
*
 Posts: 28


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.
Logged
 
Reply #7
« on: March 04, 2008, 11:20:07 pm »
starpooh Offline
Newbie
*
 Posts: 1


Thanks Jon! I also had the same error on GoDaddy but I followed your instructions and voila! RSG2 is up.
Logged
 
Reply #8
« on: March 07, 2008, 06:01:47 pm »
Jonah Offline
Administrator
Hero Member
*****
 Posts: 1414


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.
Logged
Due to time constraints, I have taken a step back from RSGallery2.  In the event of an emergency, you will need to PM me.
 
Reply #9
« on: March 11, 2008, 12:16:55 am »
Jon Offline
Newbie
*
 Posts: 28


Jonah,

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

Code:
INSERT INTO jos_components
 VALUES( '', 'RSGallery2', 'option=com_rsgallery2', 0, 0, 'option=com_rsgallery2', 'RSGallery2', 'com_rsgallery2', 0, 'js/ThemeOffice/component.png', 0, '' )

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

The display is sloppy, but here goes:


Code:
Warning: Invalid argument supplied for foreach() in /.../html/includes/joomla.php on line 5240

Warning: Invalid argument supplied for foreach() in /.../html/includes/joomla.php on line 5267

Warning: asort() expects parameter 1 to be array, string given in /.../html/includes/joomla.php on line 5280

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


Jon
Logged
 
Reply #10
« on: March 21, 2008, 11:19:22 am »
Andy Offline
Newbie
*
 Posts: 33


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
Logged
 
Reply #11
« on: March 21, 2008, 12:59:06 pm »
Jon Offline
Newbie
*
 Posts: 28


I just uploaded SVN720 and receive the error:

 Upload component - Failed
XML setup file is not for a "component".
[ Continue ... ]
Logged
 
Reply #12
« on: April 02, 2008, 10:42:14 pm »
Daniel Hargreaves Offline
Newbie
*
 Posts: 1


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
Logged
 
Reply #13
« on: April 02, 2008, 11:30:40 pm »
Jon Offline
Newbie
*
 Posts: 28


Quote from: Daniel Hargreaves on April 02, 2008, 10:42:14 pm
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.
Logged
 
Reply #14
« on: April 16, 2008, 03:34:47 pm »
ryan smith Offline
Newbie
*
 Posts: 1


Quote from: Jon on February 23, 2008, 03:53:50 pm
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.

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?
Logged
 
Print  Pages 1 2
« previous next »
Jump to:  

 
Powered by MySQL Powered by PHP Valid XHTML 1.0! Valid CSS!
 Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC