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.

If you have this rpoblem using only default vB (no modifications active), then follow these instructions:

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Make sure that you rename the adminco directory in the vB software package to the name you are using before uploading.

If this does not solve your problem, then please post the problem on vB.com.

any updates on this?, I'm having the same problem.

Did you read the previous posts?

Turns out its a known issue and there's a patch on vb.com

Cheers

would you care to post link to info?

<a href="http://www.vbulletin.com/forum/project.php?issueid=26761" target="_blank">http://www.vbulletin.com/forum/proje...?issueid=26761</a>

thats the one.