Elxis CMS Forum

Extensions => Components => Topic started by: rentasite on November 13, 2007, 01:28:17

Title: Strange problem with Star Gallery
Post by: rentasite on November 13, 2007, 01:28:17

Hi,

i have installed Star Gallery, and it was used without any problem till now. We are trying to add a New Category through: Star Gallery / View Categories / Add New

I press NEW and its taking too long to open. It never opens, and instead it gives me the option to download index2.php  :o ::)

Also, once we got the message: Forced Logg out

Thanks in advanced
Spiros
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 13, 2007, 01:44:07

*UPDATE*

I took a look in the Error log, and i see these messages:

1) PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/includes/Core/database.php on line 362

2) PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/includes/Core/database.php on line 340

3) a lot of these messages: PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/administrator/components/com_stargallery/admin.stargallery.php on line 1450
Title: Re: Strange problem with Star Gallery
Post by: datahell on November 13, 2007, 07:56:16
I dont have stargallery installed in the computer I am right now but you should check here:

/administrator/components/com_stargallery/admin.stargallery.php on line 1450

Something goes wrong there and php tries to do something that is not allowed to do it so it halts there forever and dies after 30seconds.
Check StarGallery's configuration.
Check that needed files/folders exist and are writable.
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 13, 2007, 15:44:17

Line 1450:  $path = $name.' » '.$path;

Every folder and every file, is CHMODed as it should be. Its not the 1st installation of Stargallery i have done. And i must say, it was working fine till now.  ???
Title: Re: Strange problem with Star Gallery
Post by: Ivan Trebješanin on November 13, 2007, 16:35:29
I can't give you some sensible advice, but I once did face such a problem, and solved it by simple reinstalling of Star Gallery. Might not be smart, but it worked. ;)
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 13, 2007, 16:49:42

Realy, its not smart!!! It has 40 categories
Title: Re: Strange problem with Star Gallery
Post by: Ivan Trebješanin on November 13, 2007, 17:19:59
You may Export/Import tables, it's not so difficult!
Title: Re: Strange problem with Star Gallery
Post by: datahell on November 13, 2007, 17:46:03
Edit: Check the existing's categories parent category. Open existing categories one by one and re-save them. When finish try to add a new one. Does the problem solved?
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 13, 2007, 17:49:53

Thanks John.
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 14, 2007, 21:22:18
Edit: Check the existing's categories parent category. Open existing categories one by one and re-save them. When finish try to add a new one. Does the problem solved?

No it doesn't solve. Basically i cant even Open the existing categories. It stops for some while, and gives me (again) the option to save index2.php  ???

I checked another installation, and its working Fine, on the same server with the same settings.

** What are the correct CHMOD settings, for all the files/folders related to Star Gallery !?!?!?!?!
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 14, 2007, 21:30:43

[13-Νοέ-2007 16:37:37] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/includes/adodb/adodb.inc.php on line 891

[14-Νοέ-2007 21:15:33] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/includes/adodb/adodb.inc.php on line 892

[14-Νοέ-2007 21:17:02] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/includes/adodb/drivers/adodb-mysql.inc.php on line 592

[14-Νοέ-2007 21:17:53] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /home/blabla/public_html/administrator/components/com_stargallery/admin.stargallery.php on line 1450
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 15, 2007, 02:17:30
NEW UPDATE I tried lots of solutions and checked the problem many times. Now im up to this:

Through phpMyAdmin i see these messages  ??? ::)


Problems with indexes of table `elx_categories`
More than one INDEX key was created for column `section`

Problems with indexes of table `elx_core_acl_aro_groups`

More than one INDEX key was created for column `parent_id`

Problems with indexes of table `elx_core_acl_aro_sections`
More than one UNIQUE key was created for column `value`

More than one INDEX key was created for column `hidden`

Problems with indexes of table `elx_core_acl_groups_aro_map`
PRIMARY and INDEX keys should not both be set for column `group_id`

Problems with indexes of table `elx_messages_cfg`
PRIMARY and INDEX keys should not both be set for column `user_id`
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 15, 2007, 02:48:48

After 2-3 days.... FIXED  through phpMyAdmin.

I deleted the subcategories created by another user, and its fixed. Dont know exactly what was the cause of the problem, but its fixed now  ;D
Title: Re: Strange problem with Star Gallery
Post by: datahell on November 15, 2007, 07:36:53
Edit: Check the existing's categories parent category. Open existing categories one by one and re-save them. When finish try to add a new one. Does the problem solved?


I had told you that the problem was on the parent categories. There is a loop somewhere in StarGallery's code and if you have wrong parent ids, PHP might stack there for a very long time....
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 15, 2007, 11:56:04
Edit: Check the existing's categories parent category. Open existing categories one by one and re-save them. When finish try to add a new one. Does the problem solved?


I had told you that the problem was on the parent categories. There is a loop somewhere in StarGallery's code and if you have wrong parent ids, PHP might stack there for a very long time....

Yeah, but not through the Administration panel.
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 18, 2007, 20:49:12

The problem is here again.

Comment: The problem appears when we try to put a name for a Subcategory that includes a Number (35, 50 exc)  ::) ::) ??? ??? :-\ :-\

Can someone confirm ???
Title: Re: Strange problem with Star Gallery
Post by: rentasite on November 26, 2007, 21:48:00


54 categories in StarGallery and it doesn't want to work properly. It sucks  >:(