SMFHacks.com

SMF Classifieds => Support => Topic started by: kerbob on October 13, 2013, 12:21:03 pm

Title: DB error when using "Save paypal address for future use"
Post by: kerbob on October 13, 2013, 12:21:03 pm
Just installed Classified hack and am trying to put it through the testing phases.  When I check the box "Save paypal address for future use", I get the following error (my site is http://www.westknoxrc.com):

Database 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 ''class_storepaypal','john@paypal.com')' at line 4
File: /home4/bobrekus/public_html/Sources/classifieds2.php
Line: 4517

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.5, while your database is at version 2.0.4. The above error might possibly go away if you execute the latest version of upgrade.php.

When I do not check that box, everything is ok.  I did upgrade SMF correctly, so I would imagine my database is fine.
Title: Re: DB error when using "Save paypal address for future use"
Post by: SMFHacks on October 13, 2013, 12:33:37 pm
Copy this updated file to your Sources folder and let me know if it helps.
Title: Re: DB error when using "Save paypal address for future use"
Post by: orville on October 30, 2013, 08:27:58 pm
I have the same thing going on. Did the fix work for you?
I am updated to 2.0.6
Title: Re: DB error when using "Save paypal address for future use"
Post by: SMFHacks on October 30, 2013, 08:29:32 pm
Does my above fix help? For the classifieds
Title: Re: DB error when using "Save paypal address for future use"
Post by: orville on October 30, 2013, 08:36:41 pm
Quote from: SMFHacks on October 30, 2013, 08:29:32 pm
Does my above fix help? For the classifieds

Testing now
Title: Re: DB error when using "Save paypal address for future use"
Post by: orville on October 30, 2013, 08:46:56 pm
Works like a champ. Stop and get yourself a cookie!
Title: Re: DB error when using "Save paypal address for future use"
Post by: SMFHacks on October 30, 2013, 09:04:51 pm
Good to know adding the patch to the current release.
Title: Re: DB error when using "Save paypal address for future use"
Post by: Lucy11 on December 22, 2013, 02:45:19 pm
Quote from: SMFHacks on October 13, 2013, 12:33:37 pm
Copy this updated file to your Sources folder and let me know if it helps.

I am having the same problem.  I tried the fix above but still isn't working.  Anything else you can think of that I may be overlooking?
Title: Re: DB error when using "Save paypal address for future use"
Post by: SMFHacks on December 23, 2013, 05:09:47 pm
What SMF version are you using and the latest classifieds version?