[solved; svn version used, tables not updated] Currently can't save products

Started by jjk, October 13, 2011, 23:57:28 PM

Previous topic - Next topic

jjk

J1.7.1/VM2 SVN revision 4384
For some reason I currently can't save a product. An example from VM Debug:

     vmdebug Problem in store TableProducts Unknown column 'product_params' in 'field list' SQL=UPDATE `jos_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='AFACertainStyle',`product_name`='A Certain Style',`slug`='a-certain-style',`product_s_desc`='Alfa Romeo 2900',`product_desc`='
        Eine Kombination von klassischen Linien, Schönheit und Stil, die alle Blicke auf sich zieht - ein Alfa Romeo 2900 aus dem Jahr 1938.
        \r\n
        Limitierte Auflage:
        \r\n
        \r\n
            \r\n
            300 Exemplare, signiert und numeriert vom Künstler
            \r\n\r\n
        ',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2011-10-13',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='piece',`product_packaging`='0',`product_params`='min_order_level=s:1:\"0\";|max_order_level=s:1:\"0\";|',`intnotes`='',`metadesc`='',`metakey`='',`metarobot`='',`metaauthor`='',`layout`='default',`published`='1',`product_order_levels`='0,0',`hits`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2011-10-13 21:42:27',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='964'

------------------------------------------------

        TableProducts: :store failed
        Unknown column 'product_params' in 'field list' SQL=UPDATE `jos_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='AFACertainStyle',`product_name`='A Certain Style',`slug`='a-certain-style',`product_s_desc`='Alfa Romeo 2900',`product_desc`='
        Eine Kombination von klassischen Linien, Schönheit und Stil, die alle Blicke auf sich zieht - ein Alfa Romeo 2900 aus dem Jahr 1938.
        \r\n
        Limitierte Auflage:
        \r\n
        \r\n
            \r\n
            300 Exemplare, signiert und numeriert vom Künstler
            \r\n\r\n
        ',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2011-10-13',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='piece',`product_packaging`='0',`product_params`='min_order_level=s:1:\"0\";|max_order_level=s:1:\"0\";|',`intnotes`='',`metadesc`='',`metakey`='',`metarobot`='',`metaauthor`='',`layout`='default',`published`='1',`product_order_levels`='0,0',`hits`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2011-10-13 21:42:27',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='964'

Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Milbo

http://forum.virtuemart.net/index.php?topic=85643.0

update your tables :-) at best do that everyday and everytime you have suddenly a strange error.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jjk

I did click on the "Install tables or if necessary update them" button in 'Tools & Migraton' 15 Minutes before starting this post...:-)
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/