Downloads And Product Attributes

[RyanH]

CREATE TABLE `products_attributes` (

`products_attributes_id` int(11) NOT NULL auto_increment,

`products_id` int(11) NOT NULL,

`options_id` int(11) NOT NULL,

`options_values_id` int(11) NOT NULL,

`options_values_price` decimal(15,4) NOT NULL,

`price_prefix` char(1) NOT NULL,

PRIMARY KEY (`products_attributes_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

Table structure shown above fails the following query.

 

1366 - Incorrect integer value: '' for column 'products_attributes_id' at row 1

 

insert into products_attributes values ('', '28', '1', '1', '', '+')

 

[TEP STOP]

 

I've tried going from strict to traditional MySQL settings, didn't work. Tried using phpMyAdmin to change `products_attributes_id` to allow NULL values as it wouldn't hurt with auto_increment, phpMyAdmin says it completed the change successfully but nothing changes, as the structure shows above. Also tried adding a default value, still phpMyAdmin says it was successful but no change is made.

 

ANY and ALL ideas are welcome.

 

This is a Windows box with PHP5 and Helm control panel. We have root access to the box, so MySQL/PHP settings can be changed if necessary.

 

Thanks in advance!

[RyanH]

SOLVED

 

Remove strict modes from MySQL.