Warning / Error message on making test plan Active

Hi There,

I have just put through a further test plan via my recurring GoCardless Payment plugin which I had externally developed beyond your own, which didn't work with GC's recurring feature.

I have gone to turn this dummy subscription from 'Pending' to 'Active' and upon the save of this subscription, I got the following message.

Error
Table 'name-removed-for-this-post.j3_osmembership_field_value' doesn't exist SQL=SELECT f.name, v.field_value FROM j3_osmembership_field_value AS v INNER JOIN j3_osmembership_fields AS f ON (f.id = v.field_id) WHERE ISNULL(f.field_mapping) AND v.subscriber_id = 70

Any guidance or advice you can offer in this matter, would be much appreciated.

Regards,

Incidentally, the actual changes were saved as it then generated an Membership ID for that test user, or an invoice ID for e.g. but I'm unsure why this message is happening?

Hi Robert

It seems this is a custom plugin someone added to your site as the SQL commands look strange to me

Also, could you please check your database to see whether there is a table called j3_osmembership_field_value? Maybe someone hardcode the table name and it doesn't exist on your new site anymore?

Tuan

Tuan,

Very weird as checking my site's database, there is no table I can find with the name j3_osmembership_field_value, only aaaa_osmembership_field_value (aaaa is replacing my removed for this post section)

I've also done a search for exact phrase in phpmyadmin on the database, looking for j3_osmembership_field_value and it returns 0 results.

id=70 which is mentioned in the error message, I've checked my OS Membership Pro component>subscribers list and it matches with the test one I out through, that gave me the error message mentioned above.

Regards,