Errors after 1.36 to 1.37: Error 1109 & Other in Cart

[bettysue]

Hi,

Out of 4 upgrades from 1.36 to 1.37, so far this site has given me the first errors.

The first one when you try to search from the sidebox results in the message:

1109 Unknown table 'p' in field list
in:
[select count(p.products_id) as total ]

I tried searching in the developer tool in admin however there are a LOT of returns on p.product_id and zero returns on the whole expression.

The other error shows up if you put something in the cart, then go to the shopping cart, this message appears above the cart:
-----------------
Please update your order ...
Product Name: VEHICLE SECURITY SYSTEM ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0

Here you can also edit your item quantities, delete items and estimate your shipping charges
------------------

Checking stock is turned off, along with the other stock settings.

Any hints pointing me in the right direction would be greatly appreciated, as I have no clue where to start on these.

betty

[Ajeh]

Note: this does not look good:
You ordered a total of: 1 Min: 0 Units: 0

Products should have at least a Minimum of 1 and a Unit of 1 unless you are working in decimals ...

[bettysue]

Note: this does not look good:
You ordered a total of: 1 Min: 0 Units: 0

Products should have at least a Minimum of 1 and a Unit of 1 unless you are working in decimals ...

In that products settings in Admin:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units:1
Product Qty Min/Unit Mix: xYes No

Products Quantity: 14


betty

[Ajeh]

Where exactly are you when you get that error?

I am guessing you are Adding to the Cart ... but from what page?

A URL might help to see what is going on ...

[bettysue]

Where exactly are you when you get that error?

I am guessing you are Adding to the Cart ... but from what page?

A URL might help to see what is going on ...

Hi Ajeh,

You get the message after you put something in the cart and then go to the cart (cart box bottom right side box)

http://www.jacksbargainbin.com/index.php?main_page=

If you need to poke around in Admin, let me know and I will pm you a log-in.

The error 1109 comes up if you search for something.

betty

[Ajeh]

All of your products read: Minimum 0 Units 0

This is going to cause issues as you cannot add 0 to the cart and you cannot add in units of 0 to the cart ...

Check your products table via phpMyAdmin ... what values are in the fields:
products_quantity_order_min
products_quantity_order_units

They should all be at least 1 unless you are working in decimals on your quantities ...

[bettysue]

I checked the products in Admin as soon as I noticed the error, and they are set like the example I gave a couple of posts ago:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units:1

However upon you suggestion, I checked the db and despite the settings in Admin, some of the products that say Product Qty. Minimum: 1 in admin, have 0 in the db.

Something must have burped during upgrade. I tried one of the items that has a 1 in the db and there was no error message in the cart.

Thank You! Error #1 resolved. Thank You Ajeh!!

Now...about the other error.......

betty

[Ajeh]

There is still something wrong with the bulk of your products ...

Browse the products table in phpMyAdmin ...

Sort on the field:
products_quantity_order_min

Notice how many have 0 for the value?

Sort on the field:
products_quantity_order_units

Notice how many have 0 for the value?

These are wrong ...

They all need to be changed to 1

If you do not see these as 0 in the products table ... then something is really moofed up in either your database or your website as that is what they read on the bulk of your products in the All Products or New Products etc. listings as well as on the product _info pages ...

[bettysue]

Hi Ajeh,

I see the fields you are referring to and you're right (of course) and in both the majority of then are set to 0. I'm going to fix them using EP.

Strangely enough, it was only the products that had been originally entered using EP that went wackie during the upgrade. I've upgraded a total of five stores so far to v1.37 and this is the first one that burped. While all of them have EP installed, this is the only one that had actually used it to enter most of it's inventory.

However it wasn't me that did the EP product entry, so I can't know for sure if there was an existing glitch just waiting to happen. The only thing I do know is pre-upgrade it was working fine. I guess I should also post what happened on the EP Pro boards as well.

Any idea if this could be what is also causing the 1109 error?

betty

[Ajeh]

Switch to Classic does the error go away on the search?