Author Topic: [solved; svn version used, tables not updated] Currently can't save products  (Read 2170 times)

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3548
  • using Matomo instead of Google Analytics
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Currently can't save products
« Reply #1 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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3548
  • using Matomo instead of Google Analytics
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Jepp, but already some new committs done, hehe look the log :-)
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/