[SOLVED] How to Patch vm 1.1 beta 3 to vm RC 3 on J1.5

[lownotes]

Can someone give me a brief explanation of this procedure to update/patch.

I've downloaded the manual install package for j1.5 but having a hard time reading the Readme.txt file.

Thanks,

[Soeren]

a "Hard Time"? Just overwrite all existing files via FTP...

[jenkinhill]

If you already have beta3 installed then you need to over-write the VM files and update the database.

This is how I would do this:

Upload the tar.gz file to the Joomla root on the server and untar it - I use SSH but you could use eXtplorer to upload & untar - or unpack first and use ftp. Note that with eXtplorer if upload_max_filesize in your php.ini is set to 2Mb you will need to increase it - I use 4M.

Then log into phpMyAdmin and run the SQL script, UPDATE-SCRIPT_VM_1.1.0_beta3_to_VM_1.1.0_RC1.sql which is in /administrator/components/com_virtuemart/sql/

[lownotes]

a "Hard Time"? Just overwrite all existing files via FTP...

Yes, hard time reading the Readme.txt file.  Doesn't look like a text file, wraps all funny, looks like it's PHP and some SQL in there.  I wasn't sure if that was as intended, but I thought I'd ask before diving in.

Thanks,

[lownotes]

Then log into phpMyAdmin and run the SQL script, UPDATE-SCRIPT_VM_1.1.0_beta3_to_VM_1.1.0_RC1.sql which is in /administrator/components/com_virtuemart/sql/

Hi Kelvyn,

Thanks for the great instructions.  I was able to unzip the patch files on the server using SSH and overwrite the old files.  However I'm getting the following error when I try to import the SQL file.

Code Select Expand

Error

SQL query:

###
# 08.02.2008 gregdev, Task #1425 - Changing User fields have no effect in frontend Shipping Addresses section
ALTER TABLE `jos_vm_userfield` ADD `shipping` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `registration` ;

MySQL said: Documentation
#1060 - Duplicate column name 'shipping'

Any thoughts on this?

Thanks,

[jenkinhill]

No idea - I don't understand SQL syntax..... But does it work?

[lownotes]

sorry to lag on my reply.

Yes, it seems to work, however, bottom of VM admin panel reports
Your Version
VirtueMart 1.1.0 RC2

I'll try to thrash it around some more and see if I notice anything.

15 mins later---------

The cart and store on frontend seem to work, but I'm having problems with my products on the admin side of things.  Specifically with Products that have child products. 

I can't get to the child products to edit them.  If I click [ Item Information ] next to the parent product in main product listing then I just get a refresh of the main products.  However now the entire category column has changed to "Parent:...." even for products that aren't in that category.

any thoughts.  Am clicking on the correct link to edit child products?  If I look at the fly page I can see the child products, just can't get back to edit them.  I'm pretty sure I could before I did the patch.

--more info--
It seems as if something is broken.  After I click [ Item Information ] next to parent product I don't see the child products.  However, a new menu item appears in left products menu "Return to Parent Product" (even though I'm not looking at child products).  If I click "Return to Parent Product" then I get a "New Product" page. 

Something is obviously broken.

I don't have much invested in the VM install.  Thinking about uninstall VM, trash db and reinstall latest build but would rather  not


Thanks,

[lownotes]

Update:

I've done the following:

*Patch Joomla 1.5.0 to 1.5.2
*FTP VM latest nightly build files
*import UPDATE-SCRIPT_VM_1.1.0_beta3_to_VM_1.1.0_RC1.sql

Situation:
Joomla Front End = 500 Error
Joomla Backend = No problems, VM reports RC3

[lownotes]

Issues are now solved.

Joomla Front End 500 error was due to a permissions issue.