cancel
Showing results for 
Search instead for 
Did you mean: 

Add Timestamp to attributes

SOLVED

Add Timestamp to attributes

Hello,

 

I want to add a timestamp to attributes, so i can find out when a value für an attributes was created.

 

I tried to just add a column in the database table "catalog_product_entity_varchar" but only got an error because there were too many columns in the table:

Cardinality violation: 1222 The used SELECT statements have a different number of columns

 

I'm using CE 1.9.

 

Thank you for your help

2 REPLIES

Re: Add Timestamp to attributes

Hi Aurur

 

Can you tell how to column in database table using code or direst create column into database.

Re: Add Timestamp to attributes

Hi Magikvishal,

 

I tried both. 

 

But I found a solution:

the problem wasn't that i added a column to "catalog_product_entity_varchar" but that i didn't add the column to the 4 other attribute-value tables.

After i added the column to the following tables via install script it worked perfectly:

catalog_product_entity_varchar

catalog_product_entity_text

catalog_product_entity_datetime

catalog_product_entity_decimal

catalog_product_entity_int

 

Thank you for looking into it.