Best way to update/upgrade

Pieter · Post by **Pieter** » Sun 29. Aug 2004, 16:21

Well, actually the title says it all.
When I update my current version (22-06-2004), how should I proceed? Should I just upload all files and thus overwrite old versions by new ones or is there a better way?
Also, I noticed that in this case there are no notable changes in the database, but what if there are? How will such changes affect the contents of the database?
Thanks in advance for all the advice.

Pappnase · Post by **Pappnase** » Sun 29. Aug 2004, 16:26

hello

backup all files and database.

then upload all edit the conf.inc.php nad run the upgrade.php.

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 03:46

Wow...ok, after much trial and error I was able to upgrade my installation to the new August 2004 release and was able to preserve my site layout and content. Thank God for site backups!! If my host had no backup system I would have been screwed casue my first upgrade attempt was a complete flop.

So far the only thing I noticed that does NOT work is the root structure, I think it was formerly called "website start" or something like that. When I try to eidt that structure, the data does not save and I get no errors either. I am trying to name it "Home".

Anybody know what is wrong? I did run the upgrade.php to modify my database.

Thanks!
-Ray

P.s. Big thanks and props to Oliver!!!!

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 16:19

After a little more investigating I have found that the data for this structure is succesfully being saved to the file conf.indexpage.inc.php. Why is it not being read by the backend and frontend?

I suspect that I corrupted this upgrade somehow, but everything else seems to be working ok.

-Ray

DeXXus · Post by **DeXXus** » Wed 1. Sep 2004, 17:50

rescamilla wrote:I suspect that I corrupted this upgrade somehow, but everything else seems to be working ok.

-Ray

Does your database have the field "acat_name" as type "text" in table "phpwcms_articlecat" ?

From "phpwcms_update_older.sql":

Code: Select all

ALTER TABLE `phpwcms_articlecat` CHANGE `acat_name` `acat_name` TEXT NOT NULL;

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 18:23

Dexxus,
Yes, my database has that entry and configuration.

Every entry from the Site Structure is saved into the database EXCEPT the root name, from what I have gathered, the root structure name and details are saved into conf.indexpage.inc.php.

After the upgrade from 2004-06-08 to 2004-08-27, the root structure name is blank (it used to be called website start). I am trying to name it to "Home". The information is saved into the conf.indexpage.inc.php file, but is not read into the backend Site Structure.

The reason why I am trying to do this is because after installing the upgrade I have lost the "Home" link in my breadcrumb trail. I am assuming that the root structure needs to be named Home if I want this back.

-Ray

DeXXus · Post by **DeXXus** » Wed 1. Sep 2004, 18:26

Did you run all the .SQL upgrades?
phpwcms_1.1-RC4_13-08-004.sql
phpwcms_1.1-RC4_25-08-004.sql

You say the "conf.indexpage.inc.php" looks like this???

Code: Select all

<?php

$indexpage['acat_name']		= 'Home';
$indexpage['acat_info']		= '';
$indexpage['acat_alias']	= 'index';
$indexpage['acat_aktiv']	= 1;
$indexpage['acat_public']	= 1;
$indexpage['acat_template']	= 0;
$indexpage['acat_hidden']	= 0;
$indexpage['acat_ssl']		= 0;
$indexpage['acat_regonly']	= 0;
$indexpage['acat_topcount']	= 5;
$indexpage['acat_redirect']	= '';
$indexpage['acat_order']	= 1;


?>

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 18:33

Here is my conf.indexpage.inc.php file:

Code: Select all

<?php
$indexpage['acat_name']		= 'Home';
$indexpage['acat_info']		= '';
$indexpage['acat_alias']	= '';
$indexpage['acat_aktiv']	= 1;
$indexpage['acat_public']	= 1;
$indexpage['acat_template']	= 1;
$indexpage['acat_hidden']	= 0;
$indexpage['acat_ssl']		= 0;
$indexpage['acat_regonly']	= 0;
$indexpage['acat_topcount']	= 0;
$indexpage['acat_redirect']	= '';
$indexpage['acat_order']	= 0;
?>

Yes, after overwriting my old installation with the new release files I ran upgrade.php and applied these two sql changes:
phpwcms_1.1-RC4_13-08-004.sql
phpwcms_1.1-RC4_25-08-004.sql

DeXXus · Post by **DeXXus** » Wed 1. Sep 2004, 18:35

That may be a result of changes you tried -or- there ~was~ an FTP upload problem. Use the contents I posted (the default from the archive). There were also a few additions to "config.inc.php" but they are not related to this.

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 18:45

Tried it no go.
This is weird. Let me ask you this, after the upgrade and from the backend are you able to rename the root structure?
-Ray

DeXXus · Post by **DeXXus** » Wed 1. Sep 2004, 18:53

Yes...

Admin->Site Structure->Edit Structure Level->category title:->Send Category Data

You DO have status: visible and public ???

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 18:56

Well....I am lost.

but will kepp plugging away at it.
-Ray

DeXXus · Post by **DeXXus** » Wed 1. Sep 2004, 18:58

Admin->Site Structure->Edit Structure Level->category title:->Send Category Data

You ~DO~ have status: visible and public, right ???

(reposted... In case I -edited- after you posted)

rescamilla · Post by **rescamilla** » Wed 1. Sep 2004, 19:03

I just did another server overwrite with the new installation files and wallah, it is working.
I think the issue was a bad FTP write of SOME file, like you had mentioned earlier.
I got timeouts with CuteFTP and Filezilla when trying to upgrade yesterday, so this probably contributed.
Thanks for the effort dexxus.
-Ray

DeXXus · Post by **DeXXus** » Wed 1. Sep 2004, 19:05