error: 1054 - Unknown column 'ld.product_name'

[StevieSNL]

Hi

I have update virtuemart 3.0.9 to 3.0.10.
I runned the update sql tables button but still no difference. The shop is running only the dutch language.
I'm getting an error on the searchfield of Virtuemart:

Unknown column 'ld.product_name' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `dh4bl_virtuemart_products` as p INNER JOIN `dh4bl_virtuemart_products_nl_nl` as l using (`virtuemart_product_id`) LEFT JOIN `dh4bl_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `dh4bl_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` WHERE ((`ld`.product_name LIKE "%amsterdam%") 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`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY product_name ASC LIMIT 0, 24

Can anyone help?

[GJC Web Design]

hmmm .. and did u search?


http://forum.virtuemart.net/index.php?topic=131550.msg453861#msg453861

[StevieSNL]

Yes i did, But i don´t have any xxx_en_gb tables in my sql, only the nl_NL so have no example to deal with.
Also i did a new install on a other website with the 3.0.10 and all the nl_NL tables are the same.

[GJC Web Design]

afaik because there is the much requested "fallback" lang option every VM install should have en-GB tables.. other langs are then added.. en can be switched off

[Milbo]

set NL as your language in vm.

[StevieSNL]

I have changed the module search, I used the mod_virtuemart_search which not workt, but now i use mod_search and there is no problem without any change of the virtuemart system