Database cart limit querie error

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[~ Phåråoh ~]

smf v2.0 RC1.2

I added an item which only allows a quantity of 1 to be purchased and started getting this error repeatedly:

Type of error: Database  
http://www.classicwinnebagos.com/forum/index.php?http://www.classicwinnebagos.com/forum/storeipn2.php  
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 'LIMIT 1' at line 4
File: public_html/forum/storeipn2.php
Line: 237  

Code:

StoreDebugLog('Begin query:' . "SELECT
ID_ITEM, ID_CART, ID_MEMBER, date, quantity
FROM {db_prefix}store_CART
WHERE ID_CART = $id_cart LIMIT 1");

$cartResult = $smcFunc['db_query']('', "
SELECT
ID_ITEM, ID_CART, ID_MEMBER, date, quantity
FROM {db_prefix}store_cart
WHERE ID_CART = $id_cart LIMIT 1");
$cartRow = $smcFunc['db_fetch_assoc']($cartResult);
$smcFunc['db_free_result']($cartResult);

Line 273 =  WHERE ID_CART = $id_cart LIMIT 1");


Database queries are waaaaaaay out of my knowledge base... Thanks!

[SMFHacks]

Do you have the shopping cart enabled on your store? Or selling single items only?

[~ Phåråoh ~]

Shopping cart was always enabled.

[SMFHacks]

That item does appear in the shopping cart and you click on add to a cart to checkout correct?


I did a test product with a price of $10 and nothing else changed
"Can have Quantity " is not checked

Is this the exact same settings you have on your item?

[~ Phåråoh ~]

All above conditions are the same.  Other than actual products for sale with on-hand quantities, I have 1 item which is a are download and one which is a subscription.  

I tested both of those items.  All are added to the shopping cart and I know the purchase process works because two subscriptions have been purchased and 2 downloads as well.  The error does not occur during this process.  I cleared the lerror og, went through the point of adding to shopping cart and it generated no errors.

Can have qty is not checked on these items. 

There is one item which has a "low quatity" stock of 1.  I disabled the low stock quantitiy notification, temporarily, just to stop the errors from piling up in my error log, until the syntax of the database querie is reviewed, since that's what the error is explicity indicating as the cause.

[SMFHacks]

The only time you would see errors from
http://www.classicwinnebagos.com/forum/storeipn2.php
Is if a purchase was made.

If you click on that link it may result in errors being generated because no cart id is passed. If the orders are working correctly it would be safe to ignore for now I can later add some code to check for empty card id and not do anything.

[~ Phåråoh ~]

I've been checking the purchases, and no new ones have been made.  Certainly not enough to generate a dozen errors a day.  I'm also wondering if the people trying to, can't for some reason.

This evening, I got 4 store email notifications:

INVALID
 cmd=_notify-validate

It's almost like the thing is deteriorating or something.  I think I'm going to uninstall and re-install the store program.


UPDATE:  Well, that was a bad idea.  Went to uninstall in reverse order of 1.3.4 and got a TON of uninstall errors.  I noticed that the 1.3.3 line in the package manager had [upgrade] next to it.  So, I did that.  Then I saw [upgrade] next to 1.3.4.  The last purchase through the store was on Aug 16th, at which time, all the initial errors were already ocurring.  At least I knew it wasn't preventing sales.  However, this new Email really concerns me.

I did a "real life" purchase and it all went through fine.  So, at least I know that works.  Nonetheless, this is a total nuisance and needs to be dealt with. 

I appreciate your continuing support.  I understand you have a lot of support issues to resolve in order to restore the functionality to other client's accounts.  I will be patient.  I just ask that you not forget about it.

Thanks again.
 

[SMFHacks]

Will check it out this weekend for a fix. Should be simple to change just adding an extra validation check I believe for th cart passed.

[SMFHacks]

Fixed for 1.3.5

[~ Phåråoh ~]

Tested and verified.  Thanks!

Help Support the SMFHacks.com mod making.