Try:
UPDATE `jos_cbsubs_subscriptions` SET `expiry_date` = 2010-09-30 23:59:59 WHERE `user_id` = [user_id];

Or:
UPDATE `jos_cbsubs_subscriptions` SET `expiry_date` = '2010-09-30 23:59:59' WHERE `user_id` = [user_id];

Not sure why you're trying to use a database function for a static date. Not all functions work outside of phpmyadmin and not all variables for a function work outside of phpmyadmin... some functions work entirely different outside of phpymadmin as well. This could be such a case.

Working fine on multiple test installs. Looks like something wrong with your site. Are you accessing your site with www.? The error shows no www. this could be an issue with rewriting URLs via htaccess or your web host panel.

This is only happening with the SQL Actions plugin, correct? With it removed you're able to save plans perfectly fine once again? If so do any other plugins exhibit any of the same issues?

This error generally happens due to security or permissions. Check that your folder permissions are correct and check with your host if mod_security is throwing any errors.

No folder should be 777 permissions, 755 at most, but even 755 isn't entirely necessary. I believe 644 should be acceptable in most cases, but use 755 if your host permits it. Check plugin folder permissions, community builder component permissions, etc...

Post edited by: krileon, at: 2009/10/08 14:40