Title: danfox's Replies | WordPress.org

---

# danfox

  [  ](https://wordpress.org/support/users/danfox/)

 *   [Profile](https://wordpress.org/support/users/danfox/)
 *   [Topics Started](https://wordpress.org/support/users/danfox/topics/)
 *   [Replies Created](https://wordpress.org/support/users/danfox/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/danfox/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/danfox/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/danfox/engagements/)
 *   [Favorites](https://wordpress.org/support/users/danfox/favorites/)

 Search replies:

## Forum Replies Created

Viewing 14 replies - 1 through 14 (of 14 total)

 *   Forum: [Themes and Templates](https://wordpress.org/support/forum/themes-and-templates/)
   
   In reply to: [[Storefront] Accordion not working](https://wordpress.org/support/?post_type=topic&p=14807900)
 *  Thread Starter [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [4 years, 9 months ago](https://wordpress.org/support/?post_type=topic&p=14807900#post-14807938)
 * please delete this post… it is working
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Custom Post Type Attachment] Plugin doesn’t display its window](https://wordpress.org/support/topic/plugin-doesnt-display-its-window/)
 *  Thread Starter [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/plugin-doesnt-display-its-window/#post-12552819)
 * It worked only after I set the number of pdf I wanted why don’t you put 1 as 
   default in the select field?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Mass Messaging in BuddyPress] Mass Messaging not working](https://wordpress.org/support/topic/mass-messaging-not-working/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/mass-messaging-not-working/#post-12376995)
 * I have the same problem, and it is related to the ajax loading of the tabs. If
   you reload the page you can see the mass message form…
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Advanced AJAX Product Filters] WordPress database error](https://wordpress.org/support/topic/wordpress-database-error-135/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-135/#post-11488959)
 * there are 3 errors in the file `woocommerce-ajax-filters/includes/addons/woocommerce-
   variation.php` from line 95 to 105.
    Change from:
 *     ```
       SELECT wp_posts.id as id, COALESCE(stock_table_init.out_of_stock_init1, "0") as out_of_stock_init
               FROM wp_posts
               LEFT JOIN (
                   SELECT %1$s.id as id, "1" as out_of_stock_init1
                   FROM %1$s
                   ' . apply_filters('brAAPFcompat_WCvariation_out_of_stock_where', 'WHERE %1$s.id IN
                   (
                       SELECT object_id FROM %3$s
                       WHERE term_taxonomy_id IN ( '.$outofstock.' )
                   ) ') . '
               ) as stock_table_init on wp_posts.id = stock_table_init.id
       ```
   
 * to:
 *     ```
       SELECT '.$wpdb->posts.'.id as id, COALESCE(stock_table_init.out_of_stock_init1, "0") as out_of_stock_init
               FROM '.$wpdb->posts.'
               LEFT JOIN (
                   SELECT %1$s.id as id, "1" as out_of_stock_init1
                   FROM %1$s
                   ' . apply_filters('brAAPFcompat_WCvariation_out_of_stock_where', 'WHERE %1$s.id IN
                   (
                       SELECT object_id FROM %3$s
                       WHERE term_taxonomy_id IN ( '.$outofstock.' )
                   ) ') . '
               ) as stock_table_init on '.$wpdb->posts.'.id = stock_table_init.id
       ```
   
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Advanced AJAX Product Filters] WordPress database error](https://wordpress.org/support/topic/wordpress-database-error-135/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-135/#post-11488912)
 * I have the same problem after the last update…
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[YITH WooCommerce Wishlist] Problems on the wishlist page just by adding a product to the list](https://wordpress.org/support/topic/problems-on-the-wishlist-page-just-by-adding-a-product-to-the-list/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/problems-on-the-wishlist-page-just-by-adding-a-product-to-the-list/#post-8861924)
 * [@amandanoronha](https://wordpress.org/support/users/amandanoronha/)
 * the modification in my previous post was for the logged users wishlist.
    For 
   the not logged users use this modification:
 * In the same file of above:
    wp-content/plugins/yith-woocommerce-wishlist/includes/
   class.yith-wcwl.php find the recurrence of:
 * `$existing_products = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb-
   >posts} AS p LEFT JOIN {$wpdb->postmeta} AS pm ON p.ID = pm.post_id WHERE post_type
   = %s AND post_status = %s AND pm.meta_key = %s AND pm.meta_value = %s", array('
   product', 'publish', '_visibility', 'visible' ) ) );`
 * and change it to:
 * `$existing_products = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb-
   >posts} AS p LEFT JOIN {$wpdb->postmeta} AS pm ON p.ID = pm.post_id WHERE post_type
   = %s AND post_status = %s", array( 'product', 'publish' ) ) );`
    -  This reply was modified 9 years, 3 months ago by [danfox](https://wordpress.org/support/users/danfox/).
    -  This reply was modified 9 years, 3 months ago by [danfox](https://wordpress.org/support/users/danfox/).
    -  This reply was modified 9 years, 3 months ago by [danfox](https://wordpress.org/support/users/danfox/).
    -  This reply was modified 9 years, 3 months ago by [danfox](https://wordpress.org/support/users/danfox/).
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[YITH WooCommerce Wishlist] Problems on the wishlist page just by adding a product to the list](https://wordpress.org/support/topic/problems-on-the-wishlist-page-just-by-adding-a-product-to-the-list/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/problems-on-the-wishlist-page-just-by-adding-a-product-to-the-list/#post-8839291)
 * try to modify the query at line 554 of wp-content/plugins/yith-woocommerce-wishlist/
   includes/class.yith-wcwl.php
 * **FIND**
 *     ```
        $sql = "SELECT *
                FROM <code>{$wpdb->yith_wcwl_items}</code> AS i
                LEFT JOIN {$wpdb->yith_wcwl_wishlists} AS l ON l.<code>ID</code> = i.<code>wishlist_id</code>
                INNER JOIN {$wpdb->posts} AS p ON p.ID = i.prod_id
                INNER JOIN {$wpdb->postmeta} AS pm ON pm.post_id = p.ID
                WHERE 1 AND p.post_type = %s AND p.post_status = %s AND pm.meta_key = %s AND pm.meta_value = %s";
       ```
   
 * **CHANGE TO**
 *     ```
       $sql = "SELECT *
                FROM <code>{$wpdb->yith_wcwl_items}</code> AS i
                LEFT JOIN {$wpdb->yith_wcwl_wishlists} AS l ON l.<code>ID</code> = i.<code>wishlist_id</code>
                INNER JOIN {$wpdb->posts} AS p ON p.ID = i.prod_id
                INNER JOIN {$wpdb->postmeta} AS pm ON pm.post_id = p.ID
                WHERE 1 AND p.post_type = %s AND p.post_status = %s ";
       ```
   
 * **AND after that change this array**
 *     ```
       $sql_args = array(
          'product',
          'publish'//,
          // '_visibility',
          // 'visible'
       );
       ```
   
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[YITH WooCommerce Wishlist] wishlist empty and not adding products](https://wordpress.org/support/topic/wishlist-empty-and-not-adding-products/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/wishlist-empty-and-not-adding-products/#post-8839237)
 * I found that the problem is in this query:
 *     ```
       //                $sql = "SELECT *
       //                        FROM <code>{$wpdb->yith_wcwl_items}</code> AS i
       //                        LEFT JOIN {$wpdb->yith_wcwl_wishlists} AS l ON l.<code>ID</code> = i.<code>wishlist_id</code>
       //                        INNER JOIN {$wpdb->posts} AS p ON p.ID = i.prod_id
       //                        INNER JOIN {$wpdb->postmeta} AS pm ON pm.post_id = p.ID
       //                        WHERE 1 AND p.post_type = %s AND p.post_status = %s AND pm.meta_key = %s AND pm.meta_value = %s";
                       $sql = "SELECT *
                               FROM <code>{$wpdb->yith_wcwl_items}</code> AS i
                               LEFT JOIN {$wpdb->yith_wcwl_wishlists} AS l ON l.<code>ID</code> = i.<code>wishlist_id</code>
                               INNER JOIN {$wpdb->posts} AS p ON p.ID = i.prod_id
                               INNER JOIN {$wpdb->postmeta} AS pm ON pm.post_id = p.ID
                               WHERE 1 AND p.post_type = %s AND p.post_status = %s ";
       ```
   
 * check it for that join that doesn’t give any result…
    -  This reply was modified 9 years, 3 months ago by [danfox](https://wordpress.org/support/users/danfox/).
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[YITH WooCommerce Wishlist] wishlist empty and not adding products](https://wordpress.org/support/topic/wishlist-empty-and-not-adding-products/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/wishlist-empty-and-not-adding-products/#post-8839108)
 * I have the same problem, I tried the solution with the var_dump but it doesn’t
   give me any result. I have disabled the cache and cleaned all the cached files
   but nothing…
    -  This reply was modified 9 years, 3 months ago by [danfox](https://wordpress.org/support/users/danfox/).
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Flow-Flow Social Feed Stream] Stream not updating (solution on flowflow site not working)](https://wordpress.org/support/topic/stream-not-updating-solution-on-flowflow-site-not-working/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/stream-not-updating-solution-on-flowflow-site-not-working/#post-7582202)
 * I have the same issue, post update from facebook are not updating since the 28th
   of June…
    I followed the same steps (with WP Control) of BillyHoller but I didn’t
   get any result. Am I missing something?
 * Regards
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Plugin – 403 forbidden to load .js file by server?](https://wordpress.org/support/topic/plugin-403-forbidden-to-load-js-file-by-server/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/plugin-403-forbidden-to-load-js-file-by-server/#post-5478039)
 * I get the same error after upgrading at 4.1.1
    Any solution?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Owl Carousel] How to make: when i click on thumb it open in lightbox?](https://wordpress.org/support/topic/how-to-make-when-i-click-on-thumb-it-open-in-lightbox/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/how-to-make-when-i-click-on-thumb-it-open-in-lightbox/#post-5491110)
 * Can you share the solution?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Advanced Post List] Shortcode Doesn't Work in Sidebar](https://wordpress.org/support/topic/shortcode-doesnt-work-in-sidebar/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/shortcode-doesnt-work-in-sidebar/#post-4859526)
 * Post list doesn’t work for me with 0.3b8.
    Nothing appears in the sidebar.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Get Post List With Thumbnails] Blank row at bottom of table on widget?](https://wordpress.org/support/topic/blank-row-at-bottom-of-table-on-widget/)
 *  [danfox](https://wordpress.org/support/users/danfox/)
 * (@danfox)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/blank-row-at-bottom-of-table-on-widget/#post-4259934)
 * Hi there.
    The problem is in get_post_list_with_thumbs.php at line 548 change:
 *     ```
       $htmlcod .= '<tr><td><table cellspacing="0" cellpadding="0"><tr>';
       	if($prevflg):
       		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_pvlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_p.'\')"><</a></td>';
               endif;
       		if($nextflg):
       		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_nxlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_n.'\')">></a></td>';
               endif;
       		$htmlcod .= '</tr></table></td></tr>';
       		$htmlcod .= "</table></div>";
       	if($ech):
           	echo $htmlcod;
       	else:
       		return $htmlcod;
       	endif;
       ```
   
 * to:
 *     ```
       if($prevflg):
       		$htmlcod .= '<tr><td><table cellspacing="0" cellpadding="0"><tr>';
   
       		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_pvlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_p.'\')"><</a></td>';
               endif;
       		if($nextflg):
       		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_nxlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_n.'\')">></a></td>';
               endif;
       		$htmlcod .= '</tr></table></td></tr>';
       		$htmlcod .= "</table></div>";
       	if($ech):
           	echo $htmlcod;
       	else:
       		return $htmlcod;
       	endif;
       ```
   
 * …and the empty <tr> will go away…

Viewing 14 replies - 1 through 14 (of 14 total)