Weird issue with product types

Dunno if this is the right place for this, but I ran to a odd issue with product types.

I have the basic product types in my shop and have not ever touched them.

For some reason 11 products in my database have had their product type id set to 0 (zero) and there is no product type with an id of 0 in the database... the first product type is "general" with id 1.

I noticed this as I could not edit the products in admin, as it just kept giving me a "page not found" or that require() function could not open a file (because the product type directory could not be found)

I have not touched the products in question in a long time, but they have worked just fine in the past.

How can the product type change without touching them, and why only 11 products of the 166 products change?

Are you using something other than Zen Cart to add products to the Database?

To fix them change the 0 to 1 directly in the database using phpMyAdmin.

Kim:

Are you using something other than Zen Cart to add products to the Database?

To fix them change the 0 to 1 directly in the database using phpMyAdmin.

I have used easy populate something like 6 months ago, but the products were fine after that.

I did an UPDATE query to the database to set the product types back... I was just wondering how this could have happened...

someone SQL injecting me :shocking:

Well maybe not :smile:

Since my last post, again 3 products have had their product types set to 0.

Fixed with:

mysql> update zen_products set products_type=1 where products_type=0;
Query OK, 3 rows affected (0.05 sec)
Rows matched: 3  Changed: 3  Warnings: 0

This time 1 of the products was the same as before, but 2 were different and such products that I had not touched since the last occurance of this "malfunction"

Since the last time, all I have done is updated stock numbers of some products, added few new products and moved a few products to new categorys. :blink:

Just wondering... is there a way to log all admin side queries?

this way I could go through the log and see where the products type gets changed...

Since my last post, 6 products has had their product types set to 0 !!!!!!!

Again the products seem "random", and non of them had been edited etc...!

This is really starting to be annoying as the products do not work correctly if the type is 0 !!

Again... since my last post, 6 products have been set to type 0

mysql> select products_id,products_type,products_quantity from zen_products where products_type=0;
+-------------+---------------+-------------------+
| products_id | products_type | products_quantity |
+-------------+---------------+-------------------+
|          53 |             0 |                 0 | 
|         206 |             0 |                 5 | 
|          74 |             0 |                10 | 
|         137 |             0 |                 6 | 
|         192 |             0 |                 3 | 
+-------------+---------------+-------------------+

Is there any builtin log-all-queries thingy in zencart... it slows things down but with it I could see where this happens!

Hi Pasi,

I have had this same problem a couple of times too, and in my case it seems to be related to editing a product while the cPath is not set (or maybe also when it's value is invalid?).

Normally, when you edit a product using your Zen Cart admin, the url looks like this for example:

admin/product.php?page=1&product_type=1&cPath=90&pID=681&action=new_product

But when cPath is missing, like this:

admin/product.php?page=1&product_type=1&pID=681&action=new_productand the product is updated, the product_type is set to 0.

I haven't had time yet to look into it further and do more testing, hopefully I will have time later today or tomorrow.

I think I spoke to soon! It probably was the product_type itself that was not set.

paulm:

I think I spoke to soon! It probably was the product_type itself that was not set.

Yes, this was the problem... one link in a custom report didn't have the products_type set and after "updating" the product the type was set to 0...

I think the default behaviour should be to leave the type setting alone and not just assume it's always passed to the product edit page.

In my case the absent product_type link was caused by a bug in a script I wrote myself (admin notes advanced).

Thus the absent product_type was converted by Zen Cart to an int value of 0, and then passed to the database.

pasi:

I think the default behaviour should be to leave the type setting alone and not just assume it's always passed to the product edit page.Indeed. And also a check if the products_type exists, before storing it's value to the database, would be nice :smile: