Announcement

Collapse
No announcement yet.

Paid subscriptions not expiring

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Paid subscriptions not expiring

    After upgrading from 3.0.7 to 3.5.3, my paid subscriptions no longer expire. For example I have subscriptions whos end-date was January 10th, and yet they're still listed as having 'active' subscriptions.

    Got a database error email, not sure if it's related:

    Invalid SQL:

    DELETE FROM access
    WHERE forumid IN (N AND
    userid = 51416;

    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 = 51416' at line 2
    Error Number : 1064
    Date : Thursday, January 12th 2006 @ 12:00:03 AM
    Script : http://www.talkbass.com/forum/cron.php?&rand=325590
    Referrer : http://www.talkbass.com/forum/forumdisplay.php?f=44
    IP Address : 141.154.xxxxx
    Username : Unregistered
    Classname : vb_database

  • #2
    Ran the task manually and yes it does result in a database error. Hmm.

    Database error in vBulletin 3.5.3:

    Invalid SQL:

    DELETE FROM access
    WHERE forumid IN (N AND
    userid = 842;

    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 = 842' at line 2
    Error Number : 1064
    Date : Thursday, January 12th 2006 @ 11:59:52 AM
    Script : http://www.talkbass.com/forum/adminc...ncron&cronid=7
    Referrer : http://www.talkbass.com/forum/adminc....php?do=modify
    IP Address : 66.xxxxxxxx
    Username : paul
    Classname : vb_database

    Comment


    • #3
      Ok, I dug up the bug for this issue and applied the 'patched file'.

      http://www.vbulletin.com/forum/showt...24#post1032024

      I've triple-checked that the file is uploaded and replaced the old, but I still get the exact same error... Am I going nuts?
      Last edited by kontrabass; Thu 12 Jan '06, 8:46am.

      Comment


      • #4
        I'm wondering where this is coming from:

        WHERE forumid IN (N; ) AND

        To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

        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.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Steve,

          I don't have any hacks/plugins installed on my fresh upgrade yet. It's the same error experienced by this user, who got it to work by deleting a string "N;" from his subscriptions table, forums field:

          http://www.vbulletin.com/forum/showp...2&postcount=34

          Sorry for cross-posting - didn't find the other thread till after I started this one. Feel free to wipe this thread.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X