Can't update

[Zke]

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

Code Select Expand

$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

Code Select Expand

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.

JInstaller::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.

[Milbo]

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.