error after update 2.0.24 to 2.0.24c

[Jamel001]

error after update 2.0.24 to 2.0.24c

I have this error message but just with Firefox.

In Microsoft- and Chromexplorer everything works fine

vmError: getNeighborProducts Unknown column 'mf_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `ecvm2_virtuemart_products` as `p` JOIN `ecvm2_virtuemart_products_de_de` as `l` using (`virtuemart_product_id`) JOIN `ecvm2_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `ecvm2_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 21 and `l`.`slug` < "die-wunderland-designer" AND ( psgr.`virtuemart_shoppergroup_id`= "4" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY mf_name DESC LIMIT 0,1

As soon I disable the navigation button everything is fine - But I like to use the navigation button 

I already stored my db - in vm config  and tried the product.php.txt but it wont help

Any idea

Joomla 2.0.16

[Jamel001]

and when stored the DB i get this message



        alterTable DROP ecvm2_virtuemart_ratings.i_virtuemart_product_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `ecvm2_virtuemart_ratings` DROP INDEX `i_virtuemart_product_id`
        alterTable DROP ecvm2_virtuemart_ratings.i_virtuemart_product_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `ecvm2_virtuemart_ratings` DROP INDEX `i_virtuemart_product_id`
        alterKey ADD INDEX i_virtuemart_product_id: Duplicate key name 'i_virtuemart_product_id' SQL=ALTER TABLE `ecvm2_virtuemart_ratings` ADD UNIQUE KEY `i_virtuemart_product_id` (`virtuemart_product_id`,`virtuemart_rating_id`)
        alterTable DROP ecvm2_virtuemart_vmusers.i_virtuemart_user_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `ecvm2_virtuemart_vmusers` DROP INDEX `i_virtuemart_user_id`
        alterTable DROP ecvm2_virtuemart_vmusers.i_virtuemart_user_id :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `ecvm2_virtuemart_vmusers` DROP INDEX `i_virtuemart_user_id`
        alterKey ADD INDEX i_virtuemart_user_id: Duplicate key name 'i_virtuemart_user_id' SQL=ALTER TABLE `ecvm2_virtuemart_vmusers` ADD UNIQUE KEY `i_virtuemart_user_id` (`virtuemart_user_id`,`virtuemart_vendor_id`)
        Database updated

Jamel

[Jamel001]

I solved one problem.

I exchanged the product.php with a older one and it works at least that I can use the navigation button without an error message

But still I have “*** like milbo called it ***” miracle with Incorrect table definition when I store the DB

Does nobody has a idea ??


*** http://forum.virtuemart.net/index.php?topic=94906.msg311271#msg311271 ***

Regards Jamel