VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: jjk on October 13, 2011, 23:57:28 PM

Title: [solved; svn version used, tables not updated] Currently can't save products
Post by: jjk on October 13, 2011, 23:57:28 PM
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'

Title: Re: Currently can't save products
Post by: Milbo on October 14, 2011, 00:21:22 AM
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.
Title: Re: [solved; svn version used, tables not updated] Currently can't save products
Post by: jjk on October 14, 2011, 00:37:41 AM
I did click on the "Install tables or if necessary update them" button in 'Tools & Migraton' 15 Minutes before starting this post...:-)
Title: Re: [solved; svn version used, tables not updated] Currently can't save products
Post by: Milbo on October 14, 2011, 02:38:14 AM
Jepp, but already some new committs done, hehe look the log :-)