Unable to create categories

[BabeandJamie4Ever]

My co-web and I are having trouble adding categories suddenly. For about 8 months or so now the category manager hasn't loaded on my laptop properly, it would freeze the entire browser each time, chalked it up to being an old XP laptop. Well now this week ever since we moved our site to a new host, my co-web and I both cannot add any categories. I can get the page to load, but in IE and Safari once the page is loaded I cannot scroll and it freezes. in Firefox I can scroll to the bottom but once I get there and click the drop down menu, it starts slowing down completely and Firefox begins seizing up and freezing every two seconds. We've got a bunch of new talents that need their categories added to the site, anyone know how we can fix the category manager so we can access it again?

http://star-kidz.net/imagearchive

[Αndré]

How much categories do you have in total? Ideally I'd like to have a look at it in your gallery. Of course I'd need an administrator account. If you want to give me access to an admin account, I'll send you my contact details.

[BabeandJamie4Ever]

In total we got abut 4300 categories, but we cover a lot of people on the site so only way to stay organized and the gallery not to be one big chaotic mess is to break the gallery down by show/character/actor/project type/project.

We'd be happy to provide access to an admin account, let me know where I can send the info.

[Αndré]

PM sent.

[BabeandJamie4Ever]

Thank-you, sent you the info.

[Αndré]

4300 categories is enormously. However, I get a CPU load of 100% when I try to open the category manager.

Can you please attach a database dump file of the categories table, so I can test with it on my local testbed? Thanks.

[BabeandJamie4Ever]

I hope I did this right.

[Αndré]

Yes. I'll have a look at it next week.

[BabeandJamie4Ever]

Just wanted to check in and see if you had any luck with the categories?

[Αndré]

Thanks for your reminder, I overlooked your reply. Will perform some tests now.

[Veronica]

I have done the test and Coppermine is performing over 8000 database queries to add one new category

SELECT: 4330
UPDATE: 4312

This seems to be a catastrophic design error where you read all the categories one by one first
then doing updates for all the categories also one by one

ie 4000 categories will make 8000 database accesses anything over 50 to 100 accesses is giving you bad performance

I have seen this type of design error in other parts of Coppermine too

[Αndré]

Unfortunately I'm not able to reproduce that issue on my testbed. On your gallery the category manager loads as expected, but from the point it loaded the last category and it loads the "Update/Create category" cell my browser freezes. I'd like to perform some tests on your gallery (as the category manager doesn't work, I think we can edit catmgr.php on your live gallery, but feel free to create a test gallery). You can send the FTP login data to my email address.


Regarding the query amount, how did you get those values and what exactly have you done while that issue occurs? When I open (note, just open) the category manager in my testbed, I have a query count of 16 as per Coppermine's debug output.

[Veronica]

You should look at the function rebuild_tree in functions.inc where the problem is reading categories one by one then updating in a loop

[Αndré]

I guess you moved categories while you noticed that mass of queries? I'm not quite sure what the actual issue is, as the category manager on BabeandJamie4Ever's gallery freezes for me (she also reported it), then it seems that you (Veronica) are able to add new categories?


I still need an answer for

Regarding the query amount, how did you get those values and what exactly have you done while that issue occurs? When I open (note, just open) the category manager in my testbed, I have a query count of 16 as per Coppermine's debug output.

[Veronica]

I added  "test" to "General hospital"

[Veronica]

Freezing is probably because the web hosting has a limit on the number of queries allowed per hour where 8000+ may be above this limit

[Αndré]

I added  "test" to "General hospital"

Thanks, I'm now able to see the huge amount of queries in the debug output. However, I'm quite sure this isn't the issue BabeandJamie4Ever reported. At least it isn't what happens for me in her gallery.

Freezing is probably because the web hosting has a limit on the number of queries allowed per hour where 8000+ may be above this limit

I don't think so. The category manager loads as expected (completely), but the browser consumes all CPU resources from a specific point. I'm able to load the category manager as often as I want.

[Veronica]

We must wait for her comments on these tests

[BabeandJamie4Ever]

Sorry for the late reply, been in and out of the hospital the past bit. Thank-you so much for the responses and looking into this. Andre, I just emailed you the ftp login info.

[Αndré]

I stored the category manager HTML output locally to find the culprit. If I remove

Code Select Expand

<script type="text/javascript" src="http://contentserv.brandaffinity.net/engagement/ice/ice.js?PID=0a7d580ghuvy"></script>
in the HTML head section the category manager doesn't produce a CPU load of 100% but works as expected.

Unfortunately this line seems not to be added by your theme or a plugin, so you have to search for it yourself.