karen

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 273 total)
  • Author
    Posts
  • in reply to: Slow sql queries #994836
    karen
    Participant

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

    in reply to: Slow sql queries #994785
    karen
    Participant

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

    in reply to: Slow sql queries #994632
    karen
    Participant

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

    in reply to: Slow sql queries #994625
    karen
    Participant

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

    in reply to: Recaptcha not working #994393
    karen
    Participant

    Yes, 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

    in reply to: Slow sql queries #994284
    karen
    Participant

    This reply is private.

    in reply to: Slow sql queries #994091
    karen
    Participant

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

    in reply to: Slow sql queries #994063
    karen
    Participant

    Referral question

    Slow page load time due to SQL query

    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.

    in reply to: Fake Title #990713
    karen
    Participant

    thanks! That seems to have worked.

    karen
    Participant

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

    in reply to: Fake Title #990615
    karen
    Participant

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

    in reply to: The community/add-page no longer exist #990333
    karen
    Participant

    I had to resave my permalinks. That worked for me.

    in reply to: Events calendar pro slowing down site drastically #947712
    karen
    Participant

    I 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

    in reply to: Long running Query #936904
    karen
    Participant

    This reply is private.

    in reply to: timeout when saving recurring events #928431
    karen
    Participant
Viewing 15 posts - 121 through 135 (of 273 total)