PeoplesGeek

Hi again @zmejias

I will close this as resolved since I see the plugin working correctly on your site and I am sure it will have been a simple CSS change which you have been able to do.

Cheers,

Brian

Hi Andrew,

Thanks for asking about PG Simple Affiliate shop.

The plugin does not do any direct management of your affiliate program at this time. The focus on the shop is being simple to get started with advertising affiliate products on your website.

You would need to copy each of the links and images for the products you want to promote into the plugin.

Most affiliate programs allow you to earn commission by sending the visitor to their site via a special link with your code – if they purchase from the vendor’s shopping cart then you receive a commission from them. With this in mind, I don’t see how you would achieve this by keeping the visitor on your site as they would not do the purchase and you would not be paid by the vendor.
The plugin does not provide shopping cart functionality for this reason.

You may find it useful to read these articles on affiliate marketing vs regular selling from your site and the installation of this plugin.
Install and configure pg simple affiliate shop
What is Affiliate Marketing

The plugin will allow you to display the products you are promoting as banner adds, by category, and as individual items in posts and pages. All while managing the details of the product (link and price etc) in one central place.

If you have any other specific questions then feel free to let me know,

Cheers,

Brian

• This reply was modified 4 years, 8 months ago by PeoplesGeek.

Hi again @zmejias,

I looked at this page https://oscarpenas.com/profile/ and saw that you are using the PG Context Sidebar here and that the background looks correct.

Was it a CSS issue and how did you resolve your problem so that others can learn too.

If the problem is resolved then please let me know,

Cheers,

Brian

Hi @zmejias,

Thanks for the feedback on PG Context Sidebar.
It sounds like a CSS issue which I am sure we can get to the bottom of – your site looks very impressive and it would help me if you can let me know the exact page or pages the issue is occurring on.

Cheers,

Brian (your People’s Geek)

Hahaha,

Great update John, I appreciate the extra detail and can also identify with the “too many tabs and not enough coffee” situation.

Cheers,

Brian

Hi John @healthysolutions4living ,

I am glad that this resolved itself – I would be very surprised if the plugin suddenly decided to randomly change URL’s that you had entered – it is more likely that there was some unexpected interaction between your other plugins or theme on your site.

I would have been slow in being able to respond to you with the amount of information there as I would need more information to start investigating.
I will put together my own article on writing up a problem to make it easier for the support person to understand and get to the bottom of it quickly.

In the meantime here are a couple of good articles that I have selected as part of my research (and I will also use my own experience from having to write tickets)

• https://mediatemple.net/blog/web-development-tech/writing-good-support-requests/
• https://chrislema.com/how-to-write-a-support-request/
• https://support.upviral.com/support/solutions/articles/4000139552-how-to-write-the-perfect-support-ticket-that-gets-results-fast-
• https://blog.cimcloud.com/blog/how-to-write-a-great-support-ticket

Have a browse through and if you think there is anything that would make it easier for people who are new to WordPress and Plugins then email me directly.

Many thanks for letting me know so quickly that the issue resolved itself – they are my favourite ones.

Regards,

Brian

Hi John, @healthysolutions4living ,

Thank you for letting me know about this although there isn’t anything that I know of that I can do inside the plugin.

You might also want to reach out to your theme developer as they might be able to assist you. The theme controls how content is displayed on the front end.

I don’t think you will get much joy with the Trac ticket that you have raised because technically a webpage is designed to remove any extra whitespace. The recommended way of doing this would be to use your theme CSS to make the bullets embed properly on your site.

You might try using ‘non-breaking spaces’ but you may have trouble inserting them and they are more likely to cause you formatting issues later on.

I can’t assist you with theme CSS as free support but if you get really stuck let me know and perhaps we can work something out.

Good luck and I will watch the ticket in Trac,

Cheers,

Brian

Hi John, @healthysolutions4living

I have been able to reproduce the waning using the compatibility plugin and it is a warning only which is good (ie not an ‘error’ in PHP terms)

I will still make the adjustment to the plugin with the next release so that this does not cause anyone else concern.

I will update this ticket when the new release is released (shortly).

Cheers and thanks for raising it with me,

Brian (PeoplesGeek)

Hi John @healthysolutions4living ,

Thank you for sharing the additional link with the background. I suspect that this is similar to the issue you raised with a search plugin and will contact Rank Math to find out how we can add the description field to their algorithm.

Cheers,

Brian ( @peoplesgeek )

Hi John,

Nice to see you again and I hope you are keeping well.

I have visited the page you suggested and can’t see any error or warning messages (which is good for your visitors). If they are appearing elsewhere then we will get to the bottom of this.

As per our email conversation: if you could let me know the exact PHP error you are seeing, and where it appears, that would help. I am due to release an updated version of the plugin and PHP compatibility with the latest versions is on the list.

I am reading between the lines that you are using a compatibility checker and guess it is https://www.ads-software.com/plugins/php-compatibility-checker/ so I will install that and have a look to see if I can reproduce the issue.

[ Signature deleted ]

• This reply was modified 4 years, 11 months ago by Jan Dembowski.

Hi Colleen,

It is nice to see you again and I hope you are keeping well.
There is currently a way to manually adjust the order of products overall and I think the idea of sort options is something that I should be able to include as a new feature.

In the interim, you will find a ‘Product Reorder’ menu under the main ‘Shop’ menu where you will be able to drag and drop products into a different order. It is not currently possible to have a different order under different categories but you should be able to get an overall alphabetic order with a little juggling.

I will look at adding a ‘sort’ option into the shortcode settings that would allow you to to do some options – I expect ‘alpha’ and ‘cost’ would be the most logical (ascending and descending) but if you have other thoughts please let me know.

[ Signature deleted ]

• This reply was modified 4 years, 11 months ago by Jan Dembowski.

Hi @markfromminn ,

Thank you for letting me know that you have resolved the issue and that I’m in the clear – haha.

I was sure it was not related to PG Simple Affiliate Shop and had started to prepare some links for you to investigate further.

I am very glad that you have been able to get to the bottom of it.
In your initial comment, you said you downloaded the plugins form the ‘marketplace’? Is this the repository or some other place where they are offering the plugins because the only place you should be able to get PG Simple Affiliate shop is the main WordPress repository and I am worried if someone is offering it elsewhere (and could tamper with it)

[ Signature deleted ]

• This reply was modified 4 years, 11 months ago by Jan Dembowski.

Hi Ajay ( @ajay ),

A little more info from my investigation – if I turn seamless mode off then the Join filter is called and that part works but now the % in the earlier SQL for my WHERE clause is replaced by a long random number (it changes with each execution)

AND (  ((wpsas_posts.post_title LIKE '{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}dog{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}') OR (wpsas_posts.post_content LIKE '{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}dog{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}'))  OR (wpsas_posts.post_title LIKE '{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}dog{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}') OR (wpsas_posts.post_content LIKE '{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}dog{724817873c7ae117f2f65b1b11626fcd674ea0f5dbd11449827a753577203245}')  )  AND (wpsas_posts.post_status = 'publish' OR wpsas_posts.post_status = 'inherit') AND wpsas_posts.post_type IN ('post', 'page', 'pgeek_sas') 
	AND ( wpsas_postmeta.meta_key = '_pgeek_sas_description' AND wpsas_postmeta.meta_value LIKE '%dog%' )

Seamless has to be on for the join to work but that causes the where clause to fail ??
Any ideas?

NB: I had a typo from other testing in my previous post wpsas_postmeta.meta_key = '_pgeek_sas_description' and not wpsas_postmeta.meta_value

Thanks, Brian

• This reply was modified 5 years, 4 months ago by PeoplesGeek.
• This reply was modified 5 years, 4 months ago by PeoplesGeek.

Hi Ajay ( @ajay ),

Sorry but I am pulling my hair out a bit and any advice would be appreciated.

My code is below but it seems that the filter for ‘bsearch_posts_join’ is not being called and therefore the join clause is not getting populated. In the error log I see a “Got Here Where” but not a “Got Here Join” and the error log also shows a DB error because of the missing join (when I add the join in manually and run the resulting query directly in phpMyAdmin it returns the expected result.

WordPress database error Unknown column 'wpsas_postmeta.meta_value' in 'where clause' for query SELECT SQL_CALC_FOUND_ROWS  wpsas_posts.*,  wpsas_posts.ID as ID, 0 AS score  FROM wpsas_posts  WHERE 1=1  AND (  ((wpsas_posts.post_title LIKE '%dog%') OR (wpsas_posts.post_content LIKE '%dog%'))  OR (wpsas_posts.post_title LIKE '%dog%') OR (wpsas_posts.post_content LIKE '%dog%')  )  AND (wpsas_posts.post_status = 'publish' OR wpsas_posts.post_status = 'inherit') AND wpsas_posts.post_type IN ('post', 'page', 'pgeek_sas') 
	AND ( wpsas_postmeta.meta_value = '_pgeek_sas_description' AND wpsas_postmeta.meta_value LIKE '%dog%' )

<?php

/**
 * Joins the Post Meta table. Filters bsearch_posts_join.
 *
 * @param string $join
 * @return string
 */
function filter_pg_bsearch_posts_join( $join ) {
	global $wpdb;
	error_log("Got here Join ");
	
	return $join . "
	INNER JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id)
	";
}
add_filter( 'bsearch_posts_join', 'filter_pg_bsearch_posts_join' );

/**
 * Filters bsearch_posts_where.
 *
 * @param string $join
 * @return string
 */
function filter_pg_bsearch_posts_where( $where, $search_term ) {
	global $wpdb;
	error_log("Got here Where ");
	return $where . "
	AND ( $wpdb->postmeta.meta_value = '_pgeek_sas_description' AND $wpdb->postmeta.meta_value LIKE '%{$search_term}%' )
	";
	
}
add_filter( 'bsearch_posts_where', 'filter_pg_bsearch_posts_where' ,10 , 2);

Can you think of any reason (eg a combination of plugin setting options) that might cause this?

Many Thanks,

Brian

Thank you,

I will try this out and let you know of the results Ajay ( @ajay )

[ Signature deleted ]

• This reply was modified 4 years, 11 months ago by Jan Dembowski.