I'm currently running Joomla 2.5.17 and running VM 2.0.18a. I wish to update to the latest VM version.
Note: My server does not allow use of the FTP Layer so they told me to comment out line 220 of the file: libraries/joomla/filesystem/folder.php which is
$obd = ini_get('open_basedir'); They also said I had to comment out line 102 of the file: /libraries/joomla/session/session.php which is
ini_set('session.save_handler', 'files');I tried to update by clicking the update button in the virtumart administration page but it came up with an error. So I tried uploading the zip in the joomla extension manager but I got a different error. So I tried uploading the unzipped folder to tmp/ and installing via the 'Install from directory' but I got the another error. Then I tried following the manual install instructions found here > http://dev.virtuemart.net/projects/virtuemart/wiki/Manual_installationupdate_of_VM2 but when I click "Restore System Defaults" in "Tools & Migrations" as instructed i get the following error and virtuemart admin still says version 2.0.18a.
QuoteJInstaller::install: /[server]/f-web/fc/9b/[website]/public/www/administrator/components/com_virtuemart/install/install_required_data.sql SQL Error DB function failed with error number 1062
Duplicate entry '1' for key 'PRIMARY' SQL=-- -- Dumping data for table `ub1co_virtuemart_customs` -- INSERT INTO `ub1co_virtuemart_customs` ( `virtuemart_custom_id`, `custom_parent_id`, `admin_only`, `custom_title`, `custom_tip`, `custom_value`, `custom_field_desc`, `field_type`, `is_list`, `is_hidden`, `is_cart_attribute`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES (1,0, 0, 'COM_VIRTUEMART_RELATED_PRODUCTS', 'COM_VIRTUEMART_RELATED_PRODUCTS_TIP', '', 'COM_VIRTUEMART_RELATED_PRODUCTS_DESC', 'R', 0, 0, 0, 1, '2011-05-25 21:52:43', 62, '2011-05-25 21:52:43', 62, '0000-00-00 00:00:00', 0), (2,0, 0, 'COM_VIRTUEMART_RELATED_CATEGORIES', 'COM_VIRTUEMART_RELATED_CATEGORIES_TIP', NULL, 'COM_VIRTUEMART_RELATED_CATEGORIES_DESC', 'Z', 0, 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0);
SQL =
--
-- Dumping data for table `#__virtuemart_customs`
--
INSERT INTO `#__virtuemart_customs` ( `virtuemart_custom_id`, `custom_parent_id`, `admin_only`, `custom_title`, `custom_tip`, `custom_value`, `custom_field_desc`, `field_type`, `is_list`, `is_hidden`, `is_cart_attribute`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES
(1,0, 0, 'COM_VIRTUEMART_RELATED_PRODUCTS', 'COM_VIRTUEMART_RELATED_PRODUCTS_TIP', '', 'COM_VIRTUEMART_RELATED_PRODUCTS_DESC', 'R', 0, 0, 0, 1, '2011-05-25 21:52:43', 62, '2011-05-25 21:52:43', 62, '0000-00-00 00:00:00', 0),
(2,0, 0, 'COM_VIRTUEMART_RELATED_CATEGORIES', 'COM_VIRTUEMART_RELATED_CATEGORIES_TIP', NULL, 'COM_VIRTUEMART_RELATED_CATEGORIES_DESC', 'Z', 0, 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0);
Also, somewhere in all this the link to the virtuemart has disappeared from the joomla components menu in the joomla back-end but I can still access it via the url.
Any help would be much appreciated.
Just copy the files manually and use "update to latest tables" We will remove the option which you just used. It is a quite outdated task, the other is just doing the whole thing better.