Hello
With joomla 2.8 and virtuemart 3.06 I have this error message and Items are not added into the basket
SELECT * FROM #__virtuemart_calcs LEFT JOIN #__virtuemart_calc_shoppergroups using(virtuemart_calc_id) LEFT JOIN #__virtuemart_calc_countries using(virtuemart_calc_id) WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2015-02-25 09:14:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2015-02-25 09:14:41" )
AND ( virtuemart_shoppergroup_id = 2 OR virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
AND ( virtuemart_country_id = 204 OR (virtuemart_country_id) IS NULL)
vmdebug $siteLang: fr-FR self::$_jpConfig->lang fr_fr
vmdebug vmTime: time to load config: 0.0034630298614502
vmdebug Start used Ram 10M
vmdebug vmTime: Manufacturers by Cache: 0.0017399787902832
vmdebug Going to set pw fields unrequired
vmdebug Data not found for type BT and name delimiter_billto
vmdebug my Var1:
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
vmdebug $stockhandle none and stock 5 ordered 0
I tried various fixes views on the forum but no solution
Thanks by adVance
JP
the above isn't an error - it is just debug
have you tried with the debug off?
tried with the add to cart popup off?
Yes I have tried with the debug off and the add to cart popup off but I have the same error, no products added in the cart.
In the log I have
2015-02-25 17:56:14 ERROR vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`FROM `jbj1e_virtuemart_customs` AS c LEFT JOIN `*_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (69) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
Seems you just copied the new files and you did not execute the update routine.
Go to the tools and use "update tables", then anything should work again.