Upgrade 3.02 to 3.04 Error1060 Duplicate column name 'product_price_publish_up'

[bestcons]

The site is on Joomla 3.3.6
This morning I tried to install VM 3.0.4 This failed with the error message: 1060 Duplicate column name 'product_price_publish_up' SQL=ALTER TABLE `j30_virtuemart_product_prices` CHANGE COLUMN `product_price_vdate` `product_price_publish_up` DATETIME NULL DEFAULT NULL AFTER `product_currency`
The system configuration however shows now 3.0.4

[GJC Web Design]

have u tried a "Install or if necessary update tables" in tools?

[bestcons]

I just did. It reports the same Error.

[GJC Web Design]

you need to look at your j30_virtuemart_product_prices table carefully.. has it already got a column product_price_publish_up?
(I assume so)

because it is trying to change column name product_price_vdate to product_price_publish_up

but very strange as product_price_vdate is a column in a VM1.1. prices table...

it comes from the public function update() in administrator\components\com_virtuemart\install\script.virtuemart.php

$this->alterTable('#__virtuemart_product_prices',
            array(
            'product_price_vdate' => '`product_price_publish_up` DATETIME NULL DEFAULT NULL AFTER `product_currency`',
            'product_price_edate' => '`product_price_publish_down` DATETIME NULL DEFAULT NULL AFTER `product_price_publish_up`'
         ));

but runs only if you fail $this->checkIfUpdate()

this is a check for

SELECT count(id) AS idCount FROM `#__virtuemart_adminmenuentries

have you got this table?

[Milbo]

Thank you GJC,
Furthermore it checks if the product_price_vdate is there. So I would just delete the old product_price_vdate column in the table.

[bestcons]

In the database I find the following VM tables:
j25_virtuemart_product_prices, including the columns product_price_publish_up and product_price_vdate, value NULL
j30_virtuemart_product_prices, including the columns product_price_publish_up and product_price_vdate, value NULL
jos30_virtuemart_product_prices, empty
jos_virtuemart_product_prices, empty

[GJC Web Design]

Boy - what a mess - should only be one table j30_virtuemart_product_prices with no product_price_vdate field  (if j30 is your live prefix your working with)

[bestcons]

Cleaned up the mess by deleting the old tables and deleted the product_price_vdate column.
Still the same 1060 error: 1060 Duplicate column name 'product_price_publish_up' SQL=ALTER TABLE `j30_virtuemart_product_prices` CHANGE COLUMN `product_price_vdate` `product_price_publish_up` DATETIME NULL DEFAULT NULL AFTER `product_currency`

[GJC Web Design]

because you've already got both columns in j30_virtuemart_product_prices - you shouldn't !

remove the one without data in it - if both have data remove one or other till it works -- backup obviously

[bestcons]

There is only 1 column with product_prices_publish_up, see attached printscreen.

[GJC Web Design]

then back to this post
http://forum.virtuemart.net/index.php?topic=128001.msg439362#msg439362

[bestcons]

No, I have not. See the attachment for what I have.

[GJC Web Design]

so that table is empty?  I really wonder how your DB got in this mess?

try importing the attached

[bestcons]

MySQL reports: #1062 - Duplicate entry '1' for key 'PRIMARY'

[GJC Web Design]

would you provide more info or I will loose interest -- if that is so then there are entries already in there!