Forum Replies Created
-
AuthorPosts
-
karen
ParticipantHere is what the host site says: It would appear I am stuck in the middle.
In regards to the 503 error you’re seeing are caused by a plugin you’re using; this plugin is making incredibly inefficient database queries and those queries in conjuction with the sheer volume of Events you’re trying to make is causing the execution time for this particular action to skyrocket. Even if we do increase execution, it’s unlikely that the query would complete in any reasonable amount of time. We recommend that you delete them in small batches until the number is significantly smaller. I was able to delete 20 at a time in my testing.
karen
ParticipantHI George.
Sorry, by Vulnerablity, I meant that Somehow the program was able to insert 16,000 duplicate events. I consider that a bug.2. I meant no such thing. I meant that SQL overloads when trying to delete more than 20 events at a time, presumably because of the Query that it is running is too long. I have php memory configured to 256m.
thankskaren
Participantthanks George.
#1 overloads my server.
I will try #2 and let you know.
#3 will be costly and the question still remains.. how did this happen?
there is a vulnerability somewhere.
k.karen
ParticipantGeorge, While that may be true, I still need to get rid of the 16,000 events. I am having to do that 20 entries at a time which will take me over 13 hours of constant work if I do it with the GUI. Either you can provide me with a query that I can run or a name of a consultant who is willing to run this query to save me over 14 hours of work. thanks.
karen
ParticipantYes, I did have another recaptcha script running but had already removed it and it made no difference. But perhaps the page is cached although I would not no how to UN-CACHE it. Since it does not exist. I will remove the keys, save it. and maybe put the keys back in see if that helps. thanks
karen
ParticipantThis reply is private.
karen
ParticipantI still have 16,000 entries that I need to delete. I have no idea where they came from. I cannot delete 20 at a time and if I try to do more I get the dreaded “GURU meditation” . Can you help me delete these errant entries?
karen
ParticipantReferral question
and yeah.. there are over 29,000 entries .. half of which I did not do. many are recurring but this one is interesting.
I have one entry which has created 16,882 events for one recurring event until November 5, 2015. How can that be?
How do I clean it up? it overloads the server when I try to delete it.karen
Participantthanks! That seems to have worked.
July 27, 2015 at 12:02 pm in reply to: Sub-Categories not showing up properly in Community Events frontend columns #990655karen
Participantyeah, you are right. My theme converts the categories to a table apparently, where as 2015 is a pulldown list (accordion style). Changing to the Tribe Event style sheet does not seem to help either.
karen
Participanthmm. I added the CSS and it did not take. Fake Title is still there. I will have to update my test site to revert to 2014 theme. Stay tuned.
How do I send you a screenshot?karen
ParticipantI had to resave my permalinks. That worked for me.
karen
ParticipantI am also having issues with recurring events. they never did save properly. I am on a VPS, with 1gig RAM, 4 gig burstable. For some reason my past events were not deleting as they should and my SQL server came to a halt at about 5000 events. I am now down to 1600 by manually deleting all of the past events and many that had never really saved right in the first place for some reason we have never quite nailed down. Things are much better. currenty I am only saving 4 months in advance and 2 months in the past, but I am not convinced that they are deleting the past events. Is this a cron or something? Anyway, I don’t mean to hijack this ticket, just an FYI and to follow this thread. thanks
karen
ParticipantThis reply is private.
karen
ParticipantHere is the other thread:
-
AuthorPosts
