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

Quote:

---

Originally Posted by xfourninetwox

Hey guys, there are 101 and one pages in response to this thread so I can't page through all these to find my answer. I am trying to add the SQL patch (I guess?) and can't figure out what is going wrong. I'm trying to upload but keep getting this error:

Error Failed: 4
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Warning Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.

I'm using ZC v1.5.1 if that helps...

---

What SQL patch? Where did you try to use the patch? (Tools->install sql patches or phpmyadmin?)

There is a search feature, to the thread, doesn't require reading 101 plus one pages. May have ZC 1.5.1, but what version of this software are you trying to use? We aren't at your computer/site to be able to see this information, it must be provided. Please help us help you.

Quote:

---

Originally Posted by mc12345678

What SQL patch? Where did you try to use the patch? (Tools->install sql patches or phpmyadmin?)

There is a search feature, to the thread, doesn't require reading 101 plus one pages. May have ZC 1.5.1, but what version of this software are you trying to use? We aren't at your computer/site to be able to see this information, it must be provided. Please help us help you.

---

I tried to install via Admin/Tools/Install SQL Patch. Which is where I came up with the error message. I just downloaded the "latest version" of the plug-in. I believe it was 1.5.3.

I overwrote all of the other files through my FTP program manually, but when it comes to the SQL patches any other time in the past I have used the admin area to upload and haven't run into any problems. Today I came up with the above error message and am not certain what to do.

Quote:

---

Originally Posted by xfourninetwox

I tried to install via Admin/Tools/Install SQL Patch. Which is where I came up with the error message. I just downloaded the "latest version" of the plug-in. I believe it was 1.5.3.

I overwrote all of the other files through my FTP program manually, but when it comes to the SQL patches any other time in the past I have used the admin area to upload and haven't run into any problems. Today I came up with the above error message and am not certain what to do.

---

So, again what sql patch are/were you trying to run, because the installation of this version of SBA (1.5.3) does not have a SQL patch to be run per se.. Installation is through the use of the admin program stock_by_attr_install.php...

I guess that is what I'm confused about. I thought that running that would be unnecessary if I was trying to add things manually. I guess what I need to know is what do I need to do, or select at admin/stock_by_attr_install.php if I've already manually overwritten the php files? Would it be the Full DB Install, or something else in MYPHP or Install SQL Patch?

Quote:

---

Originally Posted by xfourninetwox

I guess that is what I'm confused about. I thought that running that would be unnecessary if I was trying to add things manually. I guess what I need to know is what do I need to do, or select at admin/stock_by_attr_install.php if I've already manually overwritten the php files? Would it be the Full DB Install, or something else in MYPHP or Install SQL Patch?

---

Installation has been made about as easy as it could be possible, copy the files over to the server, then open the stock_by_attr_install.php file. As for which option(s) to choose from there, I would suggest reading the page, evaluating your current systems condition (ie, maybe need the upgrade, though based on your initial post it looks like the SBA of any version isn't in your store's database at this time.) so more than likely would want the full install.. Again though, instructions are provided when going to that address. Please take a moment to read through them, and identify how they could be improved if there is still a question.

Quote:

---

Originally Posted by mc12345678

Installation has been made about as easy as it could be possible, copy the files over to the server, then open the stock_by_attr_install.php file. As for which option(s) to choose from there, I would suggest reading the page, evaluating your current systems condition (ie, maybe need the upgrade, though based on your initial post it looks like the SBA of any version isn't in your store's database at this time.) so more than likely would want the full install.. Again though, instructions are provided when going to that address. Please take a moment to read through them, and identify how they could be improved if there is still a question.

---

The installation went over with no errors, however the first thing I noticed under the "How To Use Stock Attributes" is you should be able to visit "Catalog / Products with Attributes Stock". I don't see that option in my admin area?

Quote:

---

Originally Posted by xfourninetwox

The installation went over with no errors, however the first thing I noticed under the "How To Use Stock Attributes" is you should be able to visit "Catalog / Products with Attributes Stock". I don't see that option in my admin area?

---

Didn't have it after the installation either? Navigate around to at least one other link before viewing the Catalog menu to see if there is an option somewhere in the menu that has at least Product with Attributes Stock in it's button title?

Still having issues?

Yeah, I noticed the new options for SBA under Configuration / Stock, but nothing else. I even tried doing the additional optional SQL patch, because I already have products with attributes, but I'm not seeing anything. Is there something that possibly needs to be overwritten in more than one place, like for example if a "/YOUR_Template/" section didn't pick up?

Quote:

---

Originally Posted by xfourninetwox

Yeah, I noticed the new options for SBA under Configuration / Stock, but nothing else. I even tried doing the additional optional SQL patch, because I already have products with attributes, but I'm not seeing anything. Is there something that possibly needs to be overwritten in more than one place, like for example if a "/YOUR_Template/" section didn't pick up?

---

A standard install ought to provide the Products With Attributes Stock (aka SBA) menu option to the catalog menu dropdown.

Perhaps need to remove it through the same install script option... Might suggest running the removal at least twice, then do the full install...

There are some YOUR_TEMPLATE related files where the files within need to be placed in the directory of the current template; however, the admin side is not affected by the YOUR_TEMPLATE aspect provided the files in the admin directory have been brought into the renamed admin directory.

Hi,
I installed a version of zc 1.5.4 and the SBA version 1.5.4 I downloaded from https://github.com/potteryhouse

Not sure if someone got this combination working. I am a little confused about the dynamic drop downs that are supposed to be implemented in this version of SBA, I don't get a "Enable Dynamic Dropdowns" in Admin.

The variants seem to work, only that I get multiple shows of the second attribute name:
i.e. I have two sizes 34 and 35 and three colours. Black, White, Red

On the product page I get size 34 and 35 on top, but the colours show up multiple (one colour for each size) Am I doing something wrong or is this just not working yet?

thanks, ed


Attachment 15140