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

[bigbadboy]

Using 1.3.8a and latest SbA and have a small error.

Admin > catalog > products with attributes stock
Click > 'Add quantity for product variant'
Size (only attribute) - 'All'
Quantity - Any number

Hit 'Submit'

I then get this error:
att: 41|42|43|44|45|46

Warning: Cannot modify header information - headers already sent by (output started at /home/path/to/products_with_attributes_stock.php:193) in /home/path/to/admin/includes/functions/general.php on line 21

Line 193 - echo "att: $attributes<bR>\n";
Line 21 - header('Location: ' . $url);

I thought maybe the R in bR was wrong (line break?) but changing it made no difference.

Thing is, although this error occurs hitting back button and accessing 'Admin > catalog > products with attributes stock' again shows the options updated correctly.

Other than that everything works perfect.

Any suggestions to get rid of the error before I show to the client?

[bigbadboy]

Just as an update ...
I think the error might be caused by the fact that I have an attribute:
'Size: Select Size:' <- This attribute is read only but still gets assigned a stock level.

Just a thought.

[kuroi]

Using 1.3.8a and latest SbA and have a small error.

Admin > catalog > products with attributes stock
Click > 'Add quantity for product variant'
Size (only attribute) - 'All'
Quantity - Any number

Hit 'Submit'

I then get this error:
att: 41|42|43|44|45|46

Warning: Cannot modify header information - headers already sent by (output started at /home/path/to/products_with_attributes_stock.php:193) in /home/path/to/admin/includes/functions/general.php on line 21

Answered a little earlier in this thread.

[bigbadboy]

thanks kuroi I missed that reply.

[kuroi]

thanks kuroi I missed that reply.

Easy to do given the length of the thread. I find that searching via Google on error messages is a quick way of cutting through the tons of info to finding answers when there are error messages.

The trick is to identify information that is specific to the problem, but not your setup. In this case the following search string would take you there very quickly

site:zen-cart.com products_with_attributes_stock.php:193

[InternetKev]

I was hoping there was a simple solution to what I hope is a simple problem.

1. "Stock by Attribute" module is installed and working fine on a Zen-Cart clothing store site.
2. We'd like it if a products out-of-stock options were not displayed on the product page -- we'd like the customer to not see a temporarily out of stock option listed.

I believe the option stock check would happen during the option array formation.

Any suggestions would be very appreciated!

[kuroi]

I am trying to do my first custom adon and when I import in the mysql file into phpmyadmin it is naming the table using the database name (c-Panel), not just zen_ and therefore I am getting this error.

1146 Table 'sabrina_zc1.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="7"]

It's absolutely normal for the database name to be used as well as the table name, otherwise your MySQL server would be unable to differentiate between Zen Carts on the same server.

The problem would be either than your configure files point to a non-existent database (which seems unlikely) or that you didn't edit your database prefix into the installation SQL before running it as per the installation instructions, so that the table has been created with the wrong name. You will be able to see and correct this via phpMyAdmin.

[cheemeiw]

I'm working with Zen Cart version 1.3.9f and have the first add-on of StockByAttributes_WITH-Table-Filter1.6 installed for that version. Then I got this error below and have tried to change the sql file following your forum reco but it is not working, I believe I might have made some mistakes here. I’ve searched high and low and for days but couldn’t figure this out.


Error:
1146 Table 'babynkid_zenc375.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id = 1 and stock_attributes="1"]
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.



Changes made on sql file highlighted in red:
CREATE TABLE zen_products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity FLOAT NOT NULL ,
PRIMARY KEY ( `stock_id` )
);

INSERT INTO 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'),"
);
/****************************Additional Databse command BELOW ********************************************************
michael mcinally <[email protected]>
heavily modified version BELOW to allow inserting "ALL" attributes at once
also should probably run this SQL command as well:
******************************************************************************** *****/
ALTER TABLE `zen_products_with_attributes_stock` ADD UNIQUE `products_id_stock_attributes` (`products_id`, `stock_attributes`);

Appreciate very much on your help