Joomla!
http://forum.joomla.org/

Upgrading RC1 to RC2. Some precautions.
http://forum.joomla.org/viewtopic.php?f=430&t=208210		 Page 1 of 1
Author:  infograf768 [ Sun Sep 02, 2007 10:55 am ]
Post subject:  Upgrading RC1 to RC2. Some precautions.
Upgrade is compulsory as some vulnerabilities are corrected.

Please note:

1. Overwrite existing files through ftp or if on server through CPanel by decompressing the archive.

2. 141 files presents in RC1 are no more in RC2.
10 only could be concerned by vulnerabilities (does not mean they are) :

Quote:
administrator/components/com_media/admin.media.html.php   
administrator/components/com_media/admin.media.popup.php 
administrator/components/com_media/controller.php 
administrator/components/com_media/toolbar.media.html.php
administrator/components/com_media/toolbar.media.php
administrator/modules/templates/modules.php
components/com_search/views/search/view.php
libraries/joomla/application/search.php
modules/templates/modules.php
templates/beez/html/com_user/lostpass/default.php


Better delete them by ftp than be sorry.  ;)

3. Do not forget to import in your database the diff.sql as there are some changes in the database.
../installation/sql/mysql/diff.sql
Author:  webrp [ Sun Sep 02, 2007 4:33 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
infograf768 wrote:
3. Do not forget to import in your database the diff.sql as there are some changes in the database.
../installation/sql/mysql/diff.sql


Hi, I will import my database from RC1 to RC2 yes. But this diff.sql must be a different thing... (?)
Could you give me more details?
Author:  infograf768 [ Sun Sep 02, 2007 4:48 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
If you keep your old database —which is what one is supposed to do when the RC1 Joomla site is operational and the reason of this sticky—, you have to import through PHPMyadmin the diff.sql as these are new in RC2.
If you install a brand new RC2 and thus create a new db in which you import some of your old db, the precautions above are unnecessary and the diff.sql too.
Author:  dchapiesky [ Sun Sep 02, 2007 10:52 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
During installation we are given the option of installing test data or running a migration script - could not the diff.sql be added as an option at this point?

The code which detects no configuration.php and runs the install system could check a file to see what the schema version number is (do we have a schema version #...) and then offer to apply diff.sql...

- Daniel
Author:  Woodhead [ Mon Sep 03, 2007 3:08 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
Be aware that the diff.sql needs to be modified if you are using other prefixes than the standard jos_
Simply replace the 2 places with red below with your prefix.

CREATE TABLE  `jos_core_acl_aro_map` (
  `acl_id` int(11) NOT NULL default '0',
  `section_value` varchar(230) NOT NULL default '0',
  `value` varchar(100) NOT NULL,
  PRIMARY KEY  (`acl_id`,`section_value`,`value`)
) TYPE=MyISAM CHARACTER SET `utf8`;

-- 29-July-2007 --
-- Fixes large object in session data

ALTER TABLE `jos_session`
  MODIFY COLUMN `data` LONGTEXT;
Author:  noworyz [ Wed Sep 05, 2007 7:59 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
would it work to rename current joomla directory. Upload new RC2 files to the original directory name.  Copy the config file from old install to the new RC2 directory and then go from there?  This would eliminate all the unnecessary files.

Sorry if this is a stupid question.

Thanks
Author:  dchapiesky [ Thu Sep 06, 2007 1:50 am ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
1) Backup...
    a) rename current joomla dir (effectively backing up all code)
        i) some may say this is overkill - other forum articles state that files can be left behind which are now security holes..
    b) login to MySQL and backup the database with whatever manner you enjoy
        i) JoomlaPack or one of the SQL backup extensions do this nicely from the admin page
2) upload latest nightly build of RC2(3,4,...N[Infinity-1])
3) Copy the config file from old
4) Delete the installation directory in the new
5) Check the changelog.php to see if schema has changed since last time you installed/updated
    i) if it did then *** Login to your MySQL database and apply diff.sql ***

That seems to be the way to go... (anyone looking over my shoulder - please correct me - cause this is what i do..)
Author:  ohc [ Thu Sep 06, 2007 5:19 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
You might want to add:

Copy custom templates
Author:  k2aho [ Sat Sep 08, 2007 10:22 am ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
Also copying /images directory from your "old joomla" is preferrable.
Author:  wildorchid [ Sun Sep 09, 2007 6:43 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
infograf768 wrote:

1. Overwrite existing files through ftp or if on server through CPanel by decompressing the archive.

3. Do not forget to import in your database the diff.sql as there are some changes in the database.
../installation/sql/mysql/diff.sql


Hello,

This is what I have done. Uploaded Joomla1.5RC2 by FTP and used cPanel decompression. I've run dif.sql with phpMyAdmin.

When I try to access the website or admin I receive the following error:

Fatal error: Cannot redeclare class jtext in /home/rainbow/public_html/libraries/joomla/i18n/language.php on line 27

Anybody knows what could have caused this?
Thanks
Author:  dchapiesky [ Mon Sep 10, 2007 6:49 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
k2aho & ohc: I get the DeeDeeDee award.. thanks for pointing those out... I feel like an idiot....

wildorchid: try to follow the instructions for removing all joomla code first... as listed above... as for your language.php problem - check your logs to see if you have permissions to overwrite the libraries directory... and as always - get the latest nightly build - check changelog.php to see if this problem with i18n has been addressed...  Daniel
Author:  andybezara [ Wed Sep 12, 2007 10:46 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
Let me understand

I am using Cpanel. I have to go to Mysql database. At the end of this page, I click on phpMyAdmin. After,  I click on import option and I browse on my pc (1.5 RC2) for diff.sql and that is it?

If so, do I have after overwrite the new files?

It would be nice if anybody (an expert) can write a process for upgrade.

What about with new versions: 1.5 stable... would it be the same procedure?

Thanks for help... this is a black hole for me.

Andy
Author:  infograf768 [ Thu Sep 13, 2007 6:39 am ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
andybezara wrote:
I am using Cpanel. I have to go to Mysql database. At the end of this page, I click on phpMyAdmin. After,  I click on import option and I browse on my pc (1.5 RC2) for diff.sql and that is it?

Yes.

Quote:
If so, do I have after overwrite the new files?

Files can be overwritten before or after

Quote:
What about with new versions: 1.5 stable... would it be the same procedure?

It is not expected at this stage that the database would have to be updated, but if it is, yes.
Author:  prairiehome [ Thu Sep 13, 2007 9:26 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
Hello Joomla Friends,

What is the procedure for importing diff.sql directly from the Unix or Linux prompt when web access through phpMyAdmin is not an option?

Best Regards,
PrairieHome
Author:  dchapiesky [ Sun Sep 16, 2007 12:28 am ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
If your shell is running on the same linux host with the mySQL server then you should be able to run the admin program "mysql" directly... do not confuse this with "mysqld" which is the actual database daemon process.

go to http://www.mysql.org/doc/refman/4.1/en/invoking-programs.html learn more about mysql administration.  Be sure to check which version you are running so that you can use the appropriate documentation.

Daniel
Author:  dchapiesky [ Sun Sep 16, 2007 12:36 am ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
infrograf:  With talk of versioning and access control lists being in the future of J!... do you know who should this should be suggested to?

By making diff.sql as part of the install/upgrade process automatically, it closes a loophole in the process.  I offer my services to do the coding but I do not have an SVN login nor am I part of a development team... I would like to be though.  Any advice you can give would be appreciated. Daniel.
Author:  infograf768 [ Sun Sep 16, 2007 7:45 am ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
@dchapiesky

http://forum.joomla.org/index.php/board ... html  :)
Author:  harner [ Mon Sep 17, 2007 4:24 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
edit: Going for a fresh install
Author:  JohnKachinski [ Mon Sep 17, 2007 4:59 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
Does this table exist?
Author:  harner [ Mon Sep 17, 2007 5:06 pm ]
Post subject:  Re: Upgrading RC1 to RC2. Some precautions.
edit: Nevermind, going for a fresh install.
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/