cant delete plans

Hi Tuan,

I have a problem with all of my websites that use Membership pro.

When you go to delete a plan we get the following error (as its looking at articles for some reason)
Please can you tell me which template this is in so i can correct the code in all of my sites?

Thanks
Jim

An error has occurred.
1146 Table 'cl19-h4all.pf1_osmembership_articles' doesn't exist SQL=DELETE FROM pf1_osmembership_articles WHERE plan_id IN (11)

I have found the code in administrator/components/com_osmembership/models/plan.php

where it says
$db = $this->getDbo();
$query = $db->getQuery(true);
$query->delete('#__osmembership_articles')
->where('plan_id IN ('.implode(',', $cid).')');

i have changed 'articles' to 'renewrates'

is this correct?

Hi Jim

You can delete that whole command blocks. I don't know why you have that error as the table #__osmembership_articles is supported to be created when you install the extension.

Maybe it is not created for some reasons and that's the reason causing the error

Regards,

Tuan

Hi Tuan,

I don't have #__osmembership_articles in any of my installations.

Shall i create it ? Not sure what the table is for?

Jim

Hi Jim

The table is only used if you are using the plugin "OS Membership - Articles restriction settings" to restrict access to Joomla articles for subscribers.

The syntax for creating table is CREATE TABLE IF NOT EXISTS `#__osmembership_articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plan_id` int(11) DEFAULT NULL,
`article_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 ;

Not sure why it was not created on your site. You can re-create it so that you won't have to modify code

Regards,

Tuan

Perfect, thanks Tuan

No problem Jim. Happy to assist.

Tuan