Editing subscription gives sql error
 

After upgrading to 3.7.4 - 1 I can no longer update peoples subscriptions:

Database error in vBulletin 3.7.4:

Invalid SQL:

DELETE FROM mysql_access
WHERE forumid IN () AND
userid = 2869;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND
userid = 2869' at line 2

The only thing different is I renamed my forums/admin to forums/cpadmin - but I did that 2 versions ago.

did you put forums/cpadmin in the right spot in the config.php?

When you renamed the admin cp, did you change it in your config.php file also?

yes. Other admin pages/functions work.

$config['Misc']['admincpdir'] = 'cpadmin';

Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

Lynne,

I tried what you said, and I get the same error.

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND
userid = 605' at line 2
Error Number : 1064
Request Date : Sunday, December 21st 2008 @ 12:32:03 PM
Error Date : Sunday, December 21st 2008 @ 12:32:03 PM
Script : http:forums/cpadmin/subscriptions.php?do=status
Referrer : htp://www.ddddd.com/forums/cpadmin/subscriptions.php?do=adjust&subscriptionlogid=313

But there is no table called "mysql_access" in the database. That query does not exist in default vbulletin - so where is that query coming from? Try reuploading a new subscriptsion.php page into your admin cp.

mysql is my prefix. Actually its something different, I didnt want to post my real prefix.

there should be a access table right?

I already uploaded the subscriptions.php file before coming here for help.

Thanks for your input.

Koz

** UPDATE **

It only does it when I make a subscription not active.

I believe the SQL statement is invalid "WHERE forumid IN ()" part.

by any chance do you have a hack install to prevent post count to go down?

have same problem and only thing that change in my forums for months was that .

No, nothing like that at all. I may have to revert back to previous version.