Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1] 2   Go Down

Author Topic: Unable to create categories  (Read 8398 times)

0 Members and 1 Guest are viewing this topic.

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 67
Unable to create categories
« on: November 21, 2012, 11:14:25 pm »

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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #1 on: November 26, 2012, 02:05:36 pm »

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

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 67
Re: Unable to create categories
« Reply #2 on: November 26, 2012, 06:09:25 pm »

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

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #3 on: November 27, 2012, 09:13:20 am »

PM sent.
Logged

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 67
Re: Unable to create categories
« Reply #4 on: November 27, 2012, 04:46:47 pm »

Thank-you, sent you the info.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #5 on: November 28, 2012, 10:02:53 am »

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

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 67
Re: Unable to create categories
« Reply #6 on: December 01, 2012, 04:50:40 am »

I hope I did this right.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #7 on: December 01, 2012, 08:00:18 am »

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

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 67
Re: Unable to create categories
« Reply #8 on: December 12, 2012, 11:42:57 pm »

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

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #9 on: December 13, 2012, 01:45:51 pm »

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

Veronica

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: se
  • Offline Offline
  • Posts: 106
  • Coppermine 1.5.22
Re: Unable to create categories
« Reply #10 on: December 13, 2012, 02:08:04 pm »

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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #11 on: December 13, 2012, 02:16:34 pm »

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

Veronica

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: se
  • Offline Offline
  • Posts: 106
  • Coppermine 1.5.22
Re: Unable to create categories
« Reply #12 on: December 13, 2012, 02:23:26 pm »

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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #13 on: December 13, 2012, 02:28:38 pm »

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

Veronica

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: se
  • Offline Offline
  • Posts: 106
  • Coppermine 1.5.22
Re: Unable to create categories
« Reply #14 on: December 13, 2012, 02:34:16 pm »

I added  "test" to "General hospital"
Logged

Veronica

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: se
  • Offline Offline
  • Posts: 106
  • Coppermine 1.5.22
Re: Unable to create categories
« Reply #15 on: December 13, 2012, 02:43:06 pm »

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

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #16 on: December 13, 2012, 02:56:22 pm »

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

Veronica

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: se
  • Offline Offline
  • Posts: 106
  • Coppermine 1.5.22
Re: Unable to create categories
« Reply #17 on: December 13, 2012, 03:07:08 pm »

We must wait for her comments on these tests
Logged

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 67
Re: Unable to create categories
« Reply #18 on: December 18, 2012, 02:46:01 am »

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

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Unable to create categories
« Reply #19 on: December 18, 2012, 12:56:03 pm »

I stored the category manager HTML output locally to find the culprit. If I remove
Code: [Select]
<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.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.023 seconds with 20 queries.