Shopping Cart Not Functioning As Expected

Zen Cart v1.51
Server OS: Linux 2.6.18-348.1.1.el5PAE
PHP Version: 5.3.27 (Zend: 2.3.0)
Database: MySQL 5.0.96-community
HTTP Server: Apache

Greetings,

I'm having a couple of issues with the operation of the shopping cart and I'm hoping someone can point me in the right direction to solve the issues. I do have PHP & Javascript experience but I'm just now leaning the structure of zend card so I don't yet have the overall picture of how everything is tied together.

The first issue is when using Display Multiple Products Qty Box Status and Set Button Location (=3), entering a quantity for any product other than the last one on the screen, results in the message "Your shopping cart is empty". When I enter a quantity in the last item on the product listing screen, it places that product in the cart but it doubles the quality I enter.

When it adds the product to the shopping cart, the Qty is doubled..

If I enter a quantity for any product other than the last one on the list...

I get the "Cart is empty" message.

The 2nd problem I'm having is when using the Display Product Add to Cart Button (=3). This option works, but when I click "Continue Shopping"

I get the message "Sorry, the product was not found."

The problem, in this case, is the URL of the "Continue Shopping" button is incorrect when adding to the cart from the product listing screen.

It is..
index.php?main_page=product_info&cPath=346_348

but it should be..
index.php?main_page=index&cPath=346_348

This problems is independent of the first problem I listed.

Any help would be appreciated.

Thanks for your time.

~Tuxy

Post a url where we can see this live

To prevent your site from being indexed here post it like

www dot zen-cart dot com

Ok, the site is online for the moment...

especiallyabrasives dot com

Thanks Kobra!

More info...

This site was updated from 1.3.x to 1.5.0, then 1.5.1. The site wasn't used very much and in hindsight, I probably should have just did a clean install of V1.5.1 but everything seemed fine untll I ran across these issues with the shopping cart.

I installed a fresh copy of v1.5.1 on another domain (same server), populated with the demo data and all the cart functions worked as expected. Perhaps my best option would be a clean install and restore of the database. I attempted to restore the exported database to the fresh install but had no success. I couldn't get past this error during the import...

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNo1jbEOgjAYhE3Y/qe4B6iNRdHYrSENmvxQbMHB1TgwUBdJ5O0tGm+8fN+d9d55jVKhzMG20VDI
oRSFLtUZUT2HC2sUciOP+/X9OY5THF4z9cHDBQFT2aYTuNqE8xCnN2p3OzObRaG2Nhq75BbUntqF
Ei4sa1upDj+e2DSVxiPS94iy1T8f1lAklQ==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 11
STR:

MySQL: 5.0.96-community
USR OS, AGENT, VER: Linux MOZILLA 5.0
PMA: 4.0.5
PHP VER,OS: 5.3.17 Linux
LANG: en
SQL: 

----END RAW----

SQL query:


MySQL said: Documentation
#1064 - 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 '' at line 1 

Any suggestions on how to proceed, at this point?

Thanks!

Oh well, I have no idea why the import would fail. :(

Anyway, I was able to make a copy of the DB to use in the clean install on another domain. The clean install does work properly with the current database when using "Add selected products to cart" on the product listing page. It also correctly returns to the product listing page.

I'm beginning to think this is an issue with "Display Attributes On Product Listing" mod. Anyone else had issues with that one on V1.5.1?

I'll continue to test and report back my findings. :cool:

Ding Ding!
http://www.zen-cart.com/showthread.php?98641-drop-down-attributes-at-product-listing-page-near-add-to-cart-button&p=753085#post753085

Well, alrighty then.

Attributes On Product Listing V2.0 does work with V1.5.1, for the narrow conditions specified in the README.txt file. The strange cart behavior I was experiencing was attributable to me varying the product listing configuration away from those constants. :blush:

From my initial testing, the above hack (ding ding) does indeed work in V1.5.1, returning the user to the Product Listing Screen, rather than generating the "Sorry, the product was not found" error.

I would actually prefer the behavior achieved in the original version of the Attributes On Product Listing mod but the code is very much outdated and would need updating to be compatible with newer versions of Zen Cart.

So basically what I'm saying is ....nevermind. :smoke: