Moi,
Otinpa sitten urakaksi muuttaa Joomla1.5.x+VM 1.1.9 -> Joomla 2.5.x+VM 2.0.0 .
JUpgradella sai joomlan ihan riittävän hyvin päivitettyä, mutta tuo Virtuemart tuottaa ongelmia.
Asensin VirtueMart 2.0.0(Stable) ja tein päivityksen
www.youtube.com/watch?v=W5utvww9DLQ mukaan.
Kaikki muu meni hyvin mutta en saa noita ostos(order) tietoja päivittymään uuteen versioon.
virtuemart_migraatio kirjoitti:
vmError: port Orders db error FUNCTION XXXXXXXX.ISNULL does not exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `j17_vm_orders` as `o` LEFT OUTER JOIN `j17_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `j17_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,7600
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2` FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE ISNULL (o2.order_number) LIMIT 0,7600
toi XXXXXXXX tossa yllä on tietokannan nimi.
Miten saan kyseiset tiedot päivittymään uuteen VirtueMart versioon ?