Announcement

Collapse
No announcement yet.

Subscription issues

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

  • Subscription issues

    I have been running my website for over a year and have not had any troubles with my subscription service at all. Then, out of the blue, it's acting VERY odd.

    When users pay their fee via PayPal, some accounts are being upgraded, some are not. And this morning, completelty out of the blue, all memberships have a $2.25 shipping fee applied to them! Nobody, but me, has access to the admin control panel (to my knowledge) so nothing is being changed.

    Another thing I should mention is that when adding a manual subscription, I get the following database error (even though the subscription WILL go through).

    Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 665

    Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 665

    Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 371

    Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 845

    Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 863






    [IMG]http://*******/forum/image.php?type=dberror[/IMG]Database errorThe The ***** database has encountered a problem.Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the ********.com home page, then try to open another page.
    • Click the back button to try another link.
    The ********.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.6.8:
    Invalid SQL:
    SELECT text, languageid, special
    FROM phrase AS phrase
    LEFT JOIN phrasetype USING (fieldname)
    WHERE phrase.fieldname = ''
    AND varname = '' AND languageid IN (-1, 0, 1);
    MySQL Error :
    Error Number :
    Date : Saturday, January 26th 2008 @ 09:19:52 AM
    Script : http://******/forum/admincp/subscriptions.php?do=status
    Referrer :http://*****/forum/admincp/subscriptions.php?do=adjust&userid=2171
    IP Address : 24.89.222.243
    Username : Sherry
    Classname : vB_Database

    Can anyone offer any help or advice? Thanks so much!

  • #2
    This thread has several things you can check.

    There should be no shipping charge since this template has a "no_shipping" parameter:

    Admin CP -> Styles & Templates -> Style Manager -> « » -> Paid Subscriptions Templates -> subscription_payment_paypal

    As for the syntax error you are getting... those kinds of errors are usually caused by custom code. Try disabling your plugins:

    Admin CP -> vBulletin Options -> Plugin/Hook System

    Also run a file check to look for customized files:

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    Comment

    Related Topics

    Collapse

    Working...
    X