Upgraded 1.4 from 1.3.2 now old (live) store error & new upgrade 4 sql errors

[peanut]

Hi

I'm having some trouble on my live store and need immediate help. I upgraded my store from 1.3.2 to 1.4 as per the instructions here: http://www.prestashop.com/download/guide_MAJ_PS14_en.pdf

My old store is on a separate folder and the new 1.4 is in a separate folder but I suspect the database got modified & now my old store is having problem understanding the new db. Can anyone please help me, as per the instructions this should not be happening, whats the point if we can't test 1.4 when it's messing up live store.

My live 1.3.2 store gives this error:
Table 'droppedpin_99k_store.ps_tax_zone' doesn't exist SELECT `id_tax`, `id_zone` FROM `ps_tax_zone`

The 1.4 update install had these 4 sql errors
(1060) Duplicate column name 'group_reduction'
(1060) Duplicate column name 'ecotax_tax_rate'
(1062) Duplicate entry 'PS_LOCALE_LANGUAGE' for key 2
(1062) Duplicate entry 'PS_LOCALE_COUNTRY' for key 2

Also I can't log into my back office of the 1.4 installation. It keeps redirecting me back to login page.

Please help me figure this out. Thanks.

EDIT: I added another table ps_tax_zone to the database but now I get this error when I access my old store:
Unknown column 'reduction_price' in 'where clause'

SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`,
i.`id_image`, il.`legend`, t.`rate`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_tax` t ON t.`id_tax` = p.`id_tax`
WHERE (`reduction_price` > 0 OR `reduction_percent` > 0)
AND (`reduction_from` = `reduction_to` OR (`reduction_from` <= '2011-03-21 11:03:00' AND `reduction_to` >= '2011-03-21 11:03:00'))
AND p.`active` = 1
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1
)
ORDER BY RAND()