MySQL error on subscription functions.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • iguanairs
    Member
    • Mar 2004
    • 84
    • 4.2.X

    #31
    Hello,

    Thanks Kirby...I mean Andreas for your fix. I didn't bother with the official fix since someone mentioned they were having problems with it and tried yours. As always, it worked like a charm. (At least for getting rid of the error and allowing me to manually edit users!)

    I will report back next month to let you all know if it keeps everything running smoothly still.
    Last edited by iguanairs; Thu 29 Dec '05, 5:03am.
    Herp Center - Reptile Forums

    Comment

    • iguanairs
      Member
      • Mar 2004
      • 84
      • 4.2.X

      #32
      Hello,

      I reverted the file back to its original state because a new problem seems to have arisen. I had a few subscriptions expire and I editted the user to disable the subscription. Once I did that, they started experiencing problems on the site. The strange thing is that it is JUST the users that I deactivated the subscription on. Everyone else is fine including those with recurring subscriptions.
      Herp Center - Reptile Forums

      Comment

      • Saxon
        New Member
        • Oct 2004
        • 7
        • 3.5.x

        #33
        Is there an official patch for this error which works?

        Comment

        • kontrabass
          Senior Member
          • Jul 2000
          • 302
          • 3.6.x

          #34
          Originally posted by nick_1
          I just want to add that I'm experiencing problems as well. I used the official patch and I get the error below. I'm going to try the earlier suggestions now... In this instance I'm trying to force the subscription job through cronadmin which I assume should work the same.

          Code:
          Database error in vBulletin 3.5.2:
          
          Invalid SQL:
          
                              DELETE FROM access
                              WHERE forumid IN (N;) AND
                                  userid = 835;
          
          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 = 835' at line 2
          Error Number : 1064
          Date         : Thursday, December 29th 2005 @ 11:28:30 AM
          Script       : http://www.site.com/forums/admincp/cronadmin.php?do=runcron&cronid=6
          Referrer     : http://www.site.com/forums/admincp/cronadmin.php?do=modify
          IP Address   : 00.00.00.00
          Username     : 
          Classname    : vb_database
          edit: I don't know where the N; came from but within the table subscription I had a rogue string N; in the forums column. I have removed that and now things seem to work

          Nick
          I also have the same error after applying the 'official patch' and also have a string "N;" in the "forums" field in my "subscription" table. Is this safe to delete? Why is it there? Thanks -

          Comment

          • Saxon
            New Member
            • Oct 2004
            • 7
            • 3.5.x

            #35
            I found another thread/post which fixed this error.

            Someone posted the attached "class_paid_subscription.php" file. I just replaced my version with the attached and it works - no more mysql errors.

            Sorry, can't help you ref the N string.

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #36
              Please note that it is against the license agreement to post and share vB files.
              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

              • Saxon
                New Member
                • Oct 2004
                • 7
                • 3.5.x

                #37
                oops sorry. Didn't realise. Suggest people do a search on the above file name then. Seem to recall it was in a bugs thread.

                Comment

                • kontrabass
                  Senior Member
                  • Jul 2000
                  • 302
                  • 3.6.x

                  #38
                  Some more info, not sure if this is any use: In my old 3.0.7 database, every subscription in my "subscription" table had a "N;" in the "forums" field. Post upgrade, only one of my three subscriptions has the "N;" string. Not sure what this means. I'm tempted to delete is as Nick did, but don't want to mess anything up down the road...

                  Comment

                  • TAK
                    New Member
                    • May 2004
                    • 6

                    #39
                    We seem to be getting this issue too. Replacing the class_paid_subscriptions.php file has not made any difference.

                    Any suggestions?

                    Thanks.

                    Comment

                    • kontrabass
                      Senior Member
                      • Jul 2000
                      • 302
                      • 3.6.x

                      #40
                      I'm hoping I can get a developer to weigh in on if it's ok to delete that "N;" string from the subscription table - that seems to have worked for Nick... Anybody?

                      Comment

                      • kontrabass
                        Senior Member
                        • Jul 2000
                        • 302
                        • 3.6.x

                        #41
                        Bump. I'm two weeks behind on subscription renewal notices and counting

                        Comment

                        • Steve Machol
                          Former Customer Support Manager
                          • Jul 2000
                          • 154488

                          #42
                          If you are running an unhacked 3.5.3, please report this in the 3.5 Bug Tracker here:

                          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

                          • Scott MacVicar
                            Former vBulletin Developer
                            • Dec 2000
                            • 13286

                            #43
                            Just edit the subscription and save it. That should sort it, there appears to be another bug that i'm checking up on.
                            Scott MacVicar

                            My Blog | Twitter

                            Comment

                            • Scott MacVicar
                              Former vBulletin Developer
                              • Dec 2000
                              • 13286

                              #44
                              You can also stop the errors by doing the following.

                              Open class_paid_subscriptions.php
                              look for
                              Code:
                              if (!empty($sub['forums']))
                              replace with
                              Code:
                              if (!empty($sub['forums']) AND $subscription_forums === false)
                              The best method is to simply edit the subscription and save.
                              Scott MacVicar

                              My Blog | Twitter

                              Comment

                              • Scott MacVicar
                                Former vBulletin Developer
                                • Dec 2000
                                • 13286

                                #45
                                File in memebers area has also now been updated.
                                Scott MacVicar

                                My Blog | Twitter

                                Comment

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