vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   paid_subscription Database Error (https://vborg.vbsupport.ru/showthread.php?t=196241)

Aadil 11-14-2008 06:10 AM
paid_subscription Database Error
 
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

Code:
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 [DATE]1226660057[/DATE] at [TIME]1226660057[/TIME] ---------------

Please help someone?

abmm 12-18-2008 06:46 PM
I'm receiving the same errors/problems with the Paid Subscription Database.

*Using vBulletin Version 3.7.4

Marco van Herwaarden 12-19-2008 12:40 PM
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 12-22-2008 06:45 PM
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...

Code:
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 12-23-2008 09:45 AM
Please open a support ticket.

Jakeman 12-23-2008 09:48 PM
This appears to be a bug:

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

smacklan 12-24-2008 12:52 AM
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 12-24-2008 08:56 AM
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 12-24-2008 12:54 PM
Quote:
Originally Posted by Marco van Herwaarden (Post 1692716)
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 12-24-2008 01:06 PM
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.


All times are GMT. The time now is 02:48 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01080 seconds
  • Memory Usage 1,748KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete