paid_subscription Database Error

[Aadil]

Hey I noticed today I had some subscriptions that expired on the 11th of this month and weren't demoted.. So I tried to do it manually and I got this database error

Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/includes/class_paid_subscription.php on line 560

Warning: implode() [function.implode]: Invalid arguments passed in [path]/includes/class_paid_subscription.php on line 560
Database Error Database error
The WrestlingBay database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.wrestlingbay.com home page, then try to open another page.
* Click the Back button to try another link.

The www.*********.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

-----------

Database error in vBulletin 3.7.4:

Invalid SQL:

DELETE FROM access
WHERE forumid IN () AND
userid = 5136;

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 = 5136' at line 2
Error Number : 1064
Request Date : Friday, November 14th 2008 @ 01:13:42 AM
Error Date : Friday, November 14th 2008 @ 01:13:42 AM
Script : http://www.************.com/admincp/subscriptions.php?do=status
Referrer : http://www.*******.com/admincp/subscriptions.php?do=adjust&subscriptionlogid=85
IP Address : ************
Username : *****
Classname : vB_Database
MySQL Version : 4.1.10-standard

Please help as I need paid subscriptions up..

I have tried disabling plugins nothing is causing it..

Im currently on vBulletin? Version 3.7.4 as said in the error!!

--------------- Added 1226660057 at 1226660057 ---------------

Please help someone?

[abmm]

I'm receiving the same errors/problems with the Paid Subscription Database.

*Using vBulletin Version 3.7.4

[Marco van Herwaarden]

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.

[abmm]

I tried both methods above to fix the problem and both failed.

Still getting this error message after disabling hooks, reinstalling the files, repairing tables, etc...


Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]\includes\class_paid_subscription.php on line 560

Warning: implode() [function.implode]: Bad arguments. in [path]\includes\class_paid_subscription.php on line 560
Database Error Database error
*****
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the ***** home page, then try to open another page.
* Click the Back button to try another link.

The ***** forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

"
Database error in vBulletin 3.7.4:

Invalid SQL:

DELETE FROM access
WHERE forumid IN () AND
userid = 166;

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 = 166' at line 2
Error Number : 1064
Request Date : Monday, December 22nd 2008 @ 02:47:30 PM
Error Date : Monday, December 22nd 2008 @ 02:47:30 PM
Script : http://*****/*****/admincp/subscriptions.php?do=status
Referrer : http://*****/*****/admincp/subscriptions.php?do=adjust&subscriptionlogid=369
Classname : vB_Database
MySQL Version : 5.0.67-community-nt
"



Any other suggestions would be appreciated!!

[Marco van Herwaarden]

Please open a support ticket.

[Jakeman]

This appears to be a bug:

http://www.vbulletin.com/forum/project.php?issueid=26761

[smacklan]

Yes, and obviously not one taken too seriously that is costing us users money...pisses me off they haven't fixed whatever they screwed up that caused this. :mad:

[Marco van Herwaarden]

If you read the bug report, then you will see that a fix (patch) is provided and that it will be solved in the next version that wil be released. So i don't understand your remark, not why you feel the need to vent it at both the bug tracker and here?

[smacklan]

If you read the bug report, then you will see that a fix (patch) is provided and that it will be solved in the next version that wil be released. So i don't understand your remark, not why you feel the need to vent it at both the bug tracker and here?
If you'll read the bug tracker you'll see the patch is for 3.8 (which isn't even stable yet!). I feel the need to vent because it's costing me money...hello!!! It's continuing to give people access to something on my site they no longer have paid for. This isn't some stupid social networking feature bug or something but a serious freaking issue.

[Marco van Herwaarden]

I can not comment on the version, but i have the feeling you misinterpret that. But it is useless to come complain on vB.org about that. If you think a patch is not correct (or not for the correct version) you should address this on vB.com.

[smacklan]

I'll take a closer look and sorry for venting at you, I know it's not your fault it's just frustrating.

*Edit* - I manually applied the changes to the effected file and it did correct my problem. Sorry for being an *** towards you Marco!