Hello to all,
I'm new to the forum but it is already several years that use VM without any problem.
I've noticed two problems since I upgraded VM from 3.0.9 to 3.0.10
Foreword I use joomla version 3.4.4. and PHP version 5.5.29
The first problem, the most important, is when a customer puts a product in the cart and then goes in the cart page to place your order, when he clicks on the "buy now" back on the same page instead of going on the confirmation page order. Taking control I noticed that if he goes on any other page on the site and then return in the cart (like magic) is already on the page of "order confirmation" and the only way he can go on to finish the order.
Let me know if I need to do some updating particularly to avoid this problem.
The second problem, however is in the form "search". The problem came always after upgrading VM to 3.0.10. If I try to find the product gives me an error page saying:
Oops!
1054 - Unknown column 'ld.product_name' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `jos_virtuemart_products` as p INNER JOIN `jos_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jos_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ((`ld`.product_name LIKE "%pny80fp%" OR `l`.product_name LIKE "%pny80fp%" OR `p`.product_sku LIKE "%pny80fp%" OR `ld`.product_s_desc LIKE "%pny80fp%" OR `l`.product_s_desc LIKE "%pny80fp%" OR `ld`.product_desc LIKE "%pny80fp%" OR `l`.product_desc LIKE "%pny80fp%" OR `category_name` LIKE "%pny80fp%" OR `category_description` LIKE "%pny80fp%" OR `mf_name` LIKE "%pny80fp%" OR `product_price` LIKE "%pny80fp%") AND ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0") AND ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0") AND ( `ps`.`virtuemart_shoppergroup_id`= "2" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering`,`product_name` ASC LIMIT 0, 88
You may not be able to visit this page because of:
• an out-of-date bookmark/favourite
• a search engine that has an out-of-date listing for this site
• a mistyped address
• you have no access to this page
• The requested resource was not found
• An error has occurred while processing your request.
Please try one of the following pages:
• Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below:
Unknown column 'ld.product_name' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `jos_virtuemart_products` as p INNER JOIN `jos_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jos_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ((`ld`.product_name LIKE "%pny80fp%" OR `l`.product_name LIKE "%pny80fp%" OR `p`.product_sku LIKE "%pny80fp%" OR `ld`.product_s_desc LIKE "%pny80fp%" OR `l`.product_s_desc LIKE "%pny80fp%" OR `ld`.product_desc LIKE "%pny80fp%" OR `l`.product_desc LIKE "%pny80fp%" OR `category_name` LIKE "%pny80fp%" OR `category_description` LIKE "%pny80fp%" OR `mf_name` LIKE "%pny80fp%" OR `product_price` LIKE "%pny80fp%") AND ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0") AND ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0") AND ( `ps`.`virtuemart_shoppergroup_id`= "2" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering`,`product_name` ASC LIMIT 0, 88
Before the update was all right ...
I hope someone knows how to help me solve these problems.
Thank you
Roberto
Do use multilanguage? did you tried with the standard template?
there is not table alias 'ld' in this query, sound like a table that stuffed with data along with table 'l'
SELECT SQL_CALC_FOUND_ROWS
p.`virtuemart_product_id`
FROM
`j25_virtuemart_products` AS p
INNER JOIN `j25_virtuemart_products_en_gb` AS l USING (`virtuemart_product_id`)
LEFT JOIN `j25_virtuemart_product_shoppergroups` AS ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `j25_virtuemart_product_categories` AS pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `j25_virtuemart_categories_en_gb` AS cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `j25_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `j25_virtuemart_manufacturers_en_gb` AS m ON m.`virtuemart_manufacturer_id` = `j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `j25_virtuemart_product_prices` AS pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE
(
(
`ld`.product_name LIKE "%pny80fp%"
OR `l`.product_name LIKE "%pny80fp%"
OR `p`.product_sku LIKE "%pny80fp%"
OR `ld`.product_s_desc LIKE "%pny80fp%"
OR `l`.product_s_desc LIKE "%pny80fp%"
OR `ld`.product_desc LIKE "%pny80fp%"
OR `l`.product_desc LIKE "%pny80fp%"
OR `category_name` LIKE "%pny80fp%"
OR `category_description` LIKE "%pny80fp%"
OR `mf_name` LIKE "%pny80fp%"
OR `product_price` LIKE "%pny80fp%"
)
AND (
(
p.`product_parent_id` = "0"
AND `pc`.`virtuemart_category_id` > "0"
)
OR p.`product_parent_id` > "0"
)
AND (
(
p.`product_parent_id` > "0"
AND `pc`.`virtuemart_category_id` > "0"
)
OR p.`product_parent_id` = "0"
)
AND (
`ps`.`virtuemart_shoppergroup_id` = "2"
OR `ps`.`virtuemart_shoppergroup_id` IS NULL
)
AND p.`published` = "1"
)
GROUP BY
p.`virtuemart_product_id`
ORDER BY
`pc`.`ordering`,
`product_name` ASC
LIMIT 0,
88
and did u search the forum?
http://forum.virtuemart.net/index.php?topic=131550
http://forum.virtuemart.net/index.php?topic=131613