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

[Danielle]

I can't get the SQL file for this mod to upload, it keeps giving the following error:

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 '"zen_cfg_select_option(array('true', 'false'),"' at line 1
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false'),"]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Does anyone know how to fix this? It's for a 1.3.9g store.

Thanks!

[woodstuff59]

Please ignore. I posted to the wrong thread.

[fireball]

Ive just noticed that my SBA is not working after upgrading to 1.39f
So I downloaded the latest SBA from the downloads area today, and uploaded the files, replacing the necessary core files as instructed. I went to the admin area and when I click on the products with attributes stock via CP, I get a a page with a search box, sync link, but otherwise its empty, with no products showing. However there is an error code...

1054 Unknown column 'sort' in 'order clause'
in:
[select * from products_with_attributes_stock where products_id="52" order by sort ASC;]

Ive inspected the item 52 and it does have attributes associated with it, but like the other products, does not show up in the SBA Admin. Attributes do show up in the (frontend) dropdown of the product page however, but quantity per attribute cannot be adjusted.
As per the instructions, I did no database patching, but what seems to be causing this error?
Sorry if I have missed a previous answer to the issue at hand..I did try search for this error via this site and google...but nothing?

Thanks..Any help/direction appreciated!

[fireball]

Just noticed there was an sql file with the download, altho not mentioned in the instructions. File was update_1_4_10.sql
So, not having anything to lose, and knowing I had not updated the SBA in over a year..I gave it a shot. But nothing. Still have the same condition now as described in my post above.

I really need to get this corrected, as there already have been orders for sizes which are supposed to be out of stock.

Thanks!

[fireball]

OK..guess I will give this one last bump.
I know the help here is all volunteer, but come on now, surely there is something one of you can suggest????

[kuroi]

@fireball

Sounds to me like you jumped to 4.10 or later of the mod without applying the upgrade sql which adds that missing sort column to the products_with_attributes_stock table.

[fireball]

Thanks Kuroi

Well, that may be..I wanted to check the version level, but the core files were over written with the update. I did run the update sql as mentioned above, and it did add one row/table, but I still have the same error.
Because the instructions say no changes needed to your database with a previous 4.x installation, Ive been avoiding running any other sql patch until I got some input.

Thanks again!

[kuroi]

Yes, looks to me like the changelog, but not the instructions have been updated.

There are two parts to the upgrade sql. One adds a row to the config table, which it sounds as though your have done. The other adds a column called "sort" to the products_with_attributes_stock table which your error message is saying hasn't been done.

[fireball]

Thanks Kuroi, I found the problem.
It seems the update_1_4_10.sql was indeed the issue and while I assumed it had ran completely, it had not created the sort table. It did however add the other elements to the database when ran previously, but my remote sql query software, seems to only run single parts of the script, apparently, because I had to highlight the "add sort" part of the query, then run..affected 34 rows. Now it appears that its working now..or at the least, I do not get that error anymore and can see my attributes for items.

THANKS AGAIN for the input!!!

[aszu]

hi, i have quite strange problem. i`ve been using stock by attribute with only one attribute with no problems. but when i add second attribute, ie. size+color, all entries in first categories get doubled, so i have 2 smalls, 2 mediums, etc to choose from, but second dropdown/radio button is empty and i can`t choose anything and there`s nothing displayed...

help:)