Strange problem with Star Gallery

[rentasite]

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 

Also, once we got the message: Forced Logg out

Thanks in advanced
Spiros

[rentasite]

*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

[datahell]

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.

[rentasite]

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. 

[Ivan Trebješanin]

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.

[rentasite]

Realy, its not smart!!! It has 40 categories

[Ivan Trebješanin]

You may Export/Import tables, it's not so difficult!

[datahell]

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?

[rentasite]

Thanks John.

[rentasite]

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 !?!?!?!?!

[rentasite]

[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

[rentasite]

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`

[rentasite]

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 

[datahell]

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....

[rentasite]

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.