Results 1 to 2 of 2

Thread: URGENT HELP NEEDED - Large SQL Querie Causing my website to timeout

  1. September 12th, 2013 #1
    stevenr999
    stevenr999 is offline
    Thread Starter
    Senior Member stevenr999's Avatar
    Join Date
    Apr 2012
    Location
    United Kingdom
    Posts
    124
    Thanks
    7
    Thanked 2 Times in 2 Posts

    URGENT HELP NEEDED - Large SQL Querie Causing my website to timeout

    Upon loading my index.php a query is being built which contains thousand upon thousands of conditions within an SQL query, this query is no so large it is causing my website to timeout. Is there an update to the theme that limits the size of the query built? The query contains conditions such as 'obalerts-51da9e5cd61d8-265|jobalerts-51daa0d917476-266|jobalerts-51daf4b68061a-269|jobalerts-51dbe09a9e94f-271|jobalerts-51dbf3d52a087-273|jobalerts-51dc002388788-275|jobalerts-51dc8d435f0a8-277|jobalerts-523072fd4e3d1-826)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:41:\"[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";}', 'yes') ON DUPLICATE KEY UPDATE'"

    There must be someone else that has hit this limit, hopefully someone can provide a line of code that will limit the query size.

    Many thanks in advance

    Steven
    Reply With Quote Reply With Quote
  2. September 13th, 2013 #2
    jomarkosabel
    jomarkosabel is offline
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    41,006
    Thanks
    170
    Thanked 3,409 Times in 3,280 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.
    Reply With Quote Reply With Quote
« adding a general application to the site, but also saving | jobroller subcategories does not appear on side bar »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. URGENT custom-post-type-helper.php causing Internal Server Error
    By margas in forum Report Vantage Bugs (Legacy)
    Replies: 10
    Last Post: July 2nd, 2013, 07:18 AM
  2. URGENT help needed please
    By droopy in forum Help Using ClassiPress
    Replies: 10
    Last Post: May 26th, 2013, 07:31 AM
  3. Samcy Classipress as a plugin or part of large website
    By mszatkowski in forum ClassiPress General Discussion
    Replies: 1
    Last Post: February 20th, 2013, 05:55 PM
  4. Urgent Help Needed Authors Page Gurus Needed $20 In It For Who Mods
    By chriswareham in forum ClassiPress General Discussion
    Replies: 3
    Last Post: July 9th, 2012, 02:36 PM
  5. Urgent Help needed
    By darrynlewis in forum Report JobRoller Bugs
    Replies: 2
    Last Post: October 5th, 2011, 10:02 AM