Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[lemuria]

I have a hypothesis however, about your problem. What version of MySQL are you running?

It's 5.0.18, on Dreamhost.

It would be great to hear any ideas, I'm stuck on this one! If this problem is unrelated to the add-on and there's a better forum for it, please let me know.

[kuroi]

It's 5.0.18, on Dreamhost.

It would be great to hear any ideas, I'm stuck on this one! If this problem is unrelated to the add-on and there's a better forum for it, please let me know.

I suspected that you would say something like this. I believe that the specific insert that is failing starts in line 242 of the admin/attributes_controller.php script. The comment immediately above this line says "TODO: MySQL5", suggesting that this insert may need tweaking for MySQL5 compatibility. That said, I've not seen this problem in my MySQL5 environments (and I have dozens).

Are you seeing this on a clean database? Or on a copy of your client's database? If the latter, has your client's database been upgraded from 1.2? If so, could you post a copy of the product_attributes table schema?

[saddlebred]

Hi,
I downloaded the 4.3 version that is currently in the downloads section. I ran the sql patch and uploaded the files. I went to admin and logged in. I could not find the catalog->products with attributes link. I went back to make sure that all files had downloaded. Well, I noticed that admin/includes/boxes/extra_boxes/products_with_attributes_catalog_dhtml.php had not been uploaded to my server. So, I went to my local folder and noticed that the file was actually named products_with_attributes_catalog_dhtml.ph and not products_with_attributes_catalog_dhtml.php . I'm assuming that this has something to do with the length of the file name, but I'm not sure how to fix it. Does anyone know how I can correct this?
Thanks,
Melissa
http://store.equineshop.biz

[saddlebred]

After further analysis, there are other filnames that have bee shortened as well. In my local environment, I'm using Windows XP.
If anyone could help me figure this out, I'd really appreciate it.
Melissa
http://store.equineshop.biz

[kuroi]

After further analysis, there are other filnames that have bee shortened as well. In my local environment, I'm using Windows XP.
If anyone could help me figure this out, I'd really appreciate it.
Melissa
http://store.equineshop.biz

Windows XP has a full path name limit of 255 characters. Are your Zen Cart files buried deep in a directory structure? If so, I'd recommend moving them closer to your hard disk's root directory.

[saddlebred]

Thanks that helps a lot. Now things seem to be working right.
Thanks,
Melissa
http://store.equineshop.biz

[saddlebred]

Ooops! I spoke too soon I am getting the following error when I access http://store.equineshop.biz .
Parse error: syntax error, unexpected '*' in /home/xxxxxxxxxxxxx/public_html/store/includes/functions/functions_lookups.php
on line 174
Any ideas?
Thanks,
Melissa
http://store.equineshop.biz

[saddlebred]

Here is the offending line of code. It actually appears to be on line 175.
function zen_get_products_stock($products_id, $attributes = '') {
I'm not very familiar with php, so am not sure how to fix it.
Thanks,
Melissa
http://store.equineshop.biz

[kuroi]

Here is the offending line of code. It actually appears to be on line 175.
function zen_get_products_stock($products_id, $attributes = '') {
I'm not very familiar with php, so am not sure how to fix it.
Thanks,
Melissa
http://store.equineshop.biz

You appear to have been unlucky and downloaded version 4.3 for during the rather brief period when it was the latest version. That honour is now held by version 4.3.1 which contains the fix to the specific problem that you have raised. However you don't need to download the new version , just deleting the contents of line 162 in the file you reference above will fix the problem.

[saddlebred]

Okay, I've got that fixed. Things seem to be working as expected, accept that the remaining stock doesn't work on products with attributes. I have it set to show the remaining stock in the shopping cart if the customer added more than what is availble. For products without attributes, the amount shows up, but for products without attributes, the number doesn't.
Melissa
http://store.equineshop.biz