Results 1 to 8 of 8
Like Tree1Likes
  • 1 Post By samcy

Thread: Loading issue - Found the bug please fix asap

  1. #1
    Thread Starter
    cboyack's Avatar
    Join Date
    Dec 2012
    Location
    United States
    Posts
    56
    Thanks
    0
    Thanked 4 Times in 2 Posts

    Loading issue - Found the bug please fix asap

    OK, I have spent countless hours and have finally found the issue causing the main page from loading smoothly. After many, many people looking at me like I'm a dummy I have finally found the problem. First let's start with explaining the problem.

    Problem

    Site main page load times are extremely slow causing a lag in the initial loading of the main page. (Please refer to original post here!)


    Bug that I have found inside classipress (specifically >>/wp-content/themes/classipress/framework/includes/stats.php)

    PHP Code:
    SELECT postcount FROM wp_cp_ad_pop_daily WHERE postnum 5392 AND time '2013-07-31'\G

    Line 168
    :
    .../
    wp-content/themes/classipress/framework/includes/stats.php 
    The slowdown is because the query is not cached and it has to look through millions of rows.

    What I have done is commented out the following code in line 168 of /wp-content/themes/classipress/framework/includes/stats.php

    PHP Code:
    $counter $wpdb->get_var$wpdb->prepare"SELECT postcount FROM $wpdb->app_stats_daily WHERE postnum = %d AND time = %s"$post_id$today_date ) );

        } else { 
    It should look like this

    PHP Code:
    /*$counter = $wpdb->get_var( $wpdb->prepare( "SELECT postcount FROM $wpdb->app_stats_daily WHERE postnum = %d AND time = %s", $post_id, $today_date ) );

        } else {*/ 
    I have also commented out the following code in loop-ad_listing.php in the classipress theme editor towards the bottom

    PHP Code:
     <!--<?php appthemes_after_post_content(); ?>-->
    Also if your running eClassify you will need to also comment out the code in loop-ad_listing.php in eClassify Child Theme as well using the editor.

    PHP Code:
    <!--<div class="additional">
        <?php appthemes_after_post_content(); ?>    
    </div>-->
    Again this has reduced my load time on the main page from 13-30 seconds down to 2-4 seconds after the code fixes. Can you guys please fix this asap?

  2. The Following 2 Users Say Thank You to cboyack For This Useful Post:

    almightyeric (August 9th, 2013), majornickmo (August 2nd, 2013)

  3. #2
    ultra's Avatar
    Join Date
    Sep 2010
    Location
    Canada
    Posts
    63
    Thanks
    2
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #3
    Thread Starter
    cboyack's Avatar
    Join Date
    Dec 2012
    Location
    United States
    Posts
    56
    Thanks
    0
    Thanked 4 Times in 2 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #4
    ultra's Avatar
    Join Date
    Sep 2010
    Location
    Canada
    Posts
    63
    Thanks
    2
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #5
    Thread Starter
    cboyack's Avatar
    Join Date
    Dec 2012
    Location
    United States
    Posts
    56
    Thanks
    0
    Thanked 4 Times in 2 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  7. The Following 2 Users Say Thank You to cboyack For This Useful Post:

    cyjambo (August 3rd, 2013), majornickmo (August 2nd, 2013)

  8. #6
    samcy's Avatar
    Join Date
    Mar 2012
    Location
    Germany
    Posts
    12,098
    Thanks
    121
    Thanked 1,756 Times in 1,442 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    majornickmo likes this.
    Rolf Hassel (Samcy)

  9. #7
    Thread Starter
    cboyack's Avatar
    Join Date
    Dec 2012
    Location
    United States
    Posts
    56
    Thanks
    0
    Thanked 4 Times in 2 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  10. #8
    Junior Member jcss's Avatar
    Join Date
    Oct 2010
    Location
    United Kingdom
    Posts
    41
    Thanks
    2
    Thanked 3 Times in 2 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Images Loading issue while loading page
    By omkarphatak in forum Slider Ultimate
    Replies: 4
    Last Post: February 15th, 2013, 12:08 AM
  2. Install issue - index.php not loading
    By findoutqatar in forum Help Using Vantage (Legacy)
    Replies: 1
    Last Post: September 5th, 2012, 10:50 AM
  3. Getting the Error Whoops page not found - Pls help asap
    By winniebuddy in forum Report ClassiPress Bugs
    Replies: 3
    Last Post: October 15th, 2011, 09:03 PM
  4. Page Not Found Issue
    By augustabiz in forum Report ClassiPress Bugs
    Replies: 2
    Last Post: September 18th, 2011, 10:14 AM
  5. issue loading site
    By spymare in forum Report ClassiPress Bugs
    Replies: 2
    Last Post: August 24th, 2011, 04:57 AM