RuddyFromPortugal

found out and it’s kinky… the query performed to fetch the category page product id’s is:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (1290) )
AND ( wp_postmeta.meta_key = ‘total_sales’
AND ( ( mt1.meta_key = ‘_visibility’
AND CAST(mt1.meta_value AS CHAR) IN (‘visible’,’catalog’) ) ) )
AND wp_posts.post_type = ‘product’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’)
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC

so in my case the products are not showing because there was not meta_key ‘total_sales’.
creating this meta key on product creation (you can try setting directly on the DB) solved it.

don’t ask me why the heck the category page query needs the total_sales meta…

I am havin the exact same issue.
wp_set_object_terms for category works, the product is listed admin side, the single product view shows the category, everthing is happy… except…
the category list page does not show the product…

I have just started investigating… did you find anything?
Thank you

missing a closing bracket in {“bytes”:5216,”filename”:”woocommerce-sponsor-a-friend-pt_PT.po”,”modified”:”Mar\u00e7o 1, 2016 14:14″,”compiled”:9″
?

Hello Jordy,

sure, and thank you.
ps – been using the plugin alot, it’s a life saving in Latin character countries ??

Hello Jordy,

one of the issues I have found it.
the get_attached_file looks for a post metakey called _wp_attached_file and in some cases such as mine it is missing by some strange reason.

so that explains why these files are not even listed.

example with workaround:

$fullsizepath = get_attached_file( $image->ID );
if ($fullsizepath ==”){
$meta = wp_get_attachment_metadata( $image->ID);
$file = $meta[‘file’];
$uploads = wp_upload_dir();
$fullsizepath = $uploads[‘basedir’] . “/$file”;
}

I still have another issue going on and once I finish it I will get back to you with the pathes required for “tuff” cases like mine ??

forgot to mention there no errors in error_log

Hi Jordy,

thak you and sorry for not providing clear symptoms. here it is:

I got a website from a customer that has 700+ images, a good part with the most incredible filenames, and on my current host those files are not acessible via http, which is a common thing that has happened to me before with other projects. So your plugin in really good in this scenario.

concrete case:
attachment id: 787
URL:https://2013.capituloperfeito.com/wp-content/uploads/2014/01/Francisco-Alves-Ricardo-Trêpa.jpg
Nome do ficheiro: Francisco-Alves-Ricardo-Trêpa.jpg
Ficheiro do tipo: JPG
Dimens?es: 3346 × 2000

so I can see this media in the admin and I can also see it via FTP

In the file renamer I did scan but those files are simply not listed in the issues.
the message no matter how many times I run it is:
There are 109 media files flagged for renaming out of 729 in total.

so I guess it detects the 109 problems but does not list them nor fixes them.

I can provide acess to the server and wordpress install or/and would be glad to contribute to your plugin by debugging into the code if you allow me to. just point me in the right direction

thank you for your help
Rodolfo

hello Computer Shop Online,

bear in mind that the solution is not a copy paste process. you need a certain skill to be changing code or patching plugins.

white screen usually means the changes you have done in the code files were not ok and the they have provided a fatal error. that can be from a simple typo, a bad comment, or the code above is not suited to your version of Virtue theme, a new version may ruin the above approach.

In these cases you should look into your error log file and check the line of code that has the error and go from there on.
check this reference:
https://codex.www.ads-software.com/Debugging_in_WordPress

Rodolfo

Hello all,
had same issue here on Virtue theme.
long story short, the action that the plugin relies is commented on Virtue theme. you can find it simply on your theme \woocommerce\content-product.php
search for //do_action( ‘woocommerce_before_shop_loop_item_title’ );

when you uncomment it your page will look like scrabled eggs, so add the following css – customize it as you wish

.wc-new-badge {
background-color: #2D5C88;
color: #FFFFFF;
padding: 5px 10px;
position: absolute;
right: 0;
top: 0;
}

note – that action is probably commented for a reason. many plugins may actually use it. so it can be a bad idea to uncomment it. or a good one who knows.
what i suggest is that you guys add your own action e.g. woocommerce_before_shop_loop_badge. will will also need to modify the plugin file new-badge.php around line 40 for
add_action( ‘woocommerce_before_shop_loop_badge’, array( $this, ‘woocommerce_show_product_loop_new_badge’ ), 30 );

good luck

Hello n-for-all,

no need, it’s fixed (with the line of code i mentioned.
just decided to write that to help.

thanks,
Rodolfo

i fixed the beekle skin but in the ipad is still crashing.

what i’ve done
– during the moving of the site the skin configuration changed to ‘:http’ (very strange). So maybe it has something to do with moving wordpress indeed.
– Thus I uninstalled the player completely (in jw swttings) then re-installed the plugin completely. did not work, the custom player i’ve created persists (even after the uninstall that is supose to delete DB and files.

So i definitly need your help!
Kind Regards,
Rodolfo

Hi,

sorry i was messing with the instalation.

the link is https://www.fogonaweb.com/o-que-fazemos/

There is one strange issue, i assume it’s related:
when testing in localhost machine, the plugin finds and plays the beekle skin. Now in the server it’s not finding it, i wonder if the moving wordpress script is leaving some files behind ?! all the other plugins are working fine.

Thanks in advance.

Hello,

I’ve been using jw plugin and the fallback on ipad worked well until this latest project using the latest version of wordpress and player. Something strange happens, can you help?
Link is https://fogo.fogonaweb.com/o-que-fazemos/

Thanks
rodolfo

second that. Plugin works great.

The restore method could be improved by:
– option to delete all root files
– copy and start install.php in new server.
This way it would be easier for less experienced noobs like me ??