Christopher Mitchell

Hi Kyle,

The display is now working perfectly.. The only issue i’m now getting is the user level. For some reason or another, when I have the users set to lower than Administrator, they can’t make any favourite posts… It doesn’t make sense. Its as if that level of user isn’t permitted to use it. Any ideas as to why this might be?

Chris

If thats not possible, is there a user level that this works with? As I can’t seem to see it working with a normal subscriber level user, but I can with admin level. Any help?

Is there any way to set this to work with ALL users not just logged in ones?

same problem here. I have no plugin conflict, but the latest release 3.5.8.1 seems to not work with the latest version of WordPress 3.5.1.

resolved

bump

Thanks for that ?? I’ll try looking in there ??

bump

Sorry the code bits weren’t meant to be there.. I removed them and it still doesn’t work.

Here’s the code that works in mySQL in the phpmyadmin:

SELECT * FROM wp_wpsc_submited_form_data
INNER JOIN wp_wpsc_variation_values
ON wp_wpsc_submited_form_data.form_id=wp_wpsc_variation_values.variation_id
WHERE <code>form_id</code> IN ('21','2','3','4','8','17')

It just doesn’t seem to work in the plugin. Any idea why?

Right… i’ve tried to use the JOIN function and it still doesn’t do anything within the plugin (it says no data to show when I try to run the report). The mySQL i’m using is:

SELECT value, name FROM wp_wpsc_submited_form_data
JOIN wp_wpsc_variation_values

I’ve run it in the phpmyadmin and it works to a degree, i need to somehow run a GROUP_CONCAT on the value column from the form_data table does the plugin support that?

Ahh I see.. So I’ll need to use a JOIN to bring in other data.. I’ll give that a try ??

Thanks again for all your help Scott.

bump

Hi Scott, any joy?

Thank you so much for your help Scott ??