Joomla! Discussion Forums

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) :



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

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?

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.

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

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;

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

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..)

You might want to add:

Copy custom templates

Also copying /images directory from your "old joomla" is preferrable.

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

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

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

Yes.


Files can be overwritten before or after


It is not expected at this stage that the database would have to be updated, but if it is, yes.

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

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

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.

@dchapiesky

http://forum.joomla.org/index.php/board ... html 

edit: Going for a fresh install

Does this table exist?

edit: Nevermind, going for a fresh install.