This is an old revision of the document!


Update

Update phpwcms (to V1.4.x)

Forum: Update phpwcms

(Written in 06.02.09) Download: - Neueste Version
Docu: - Docu: Installation & Update




If you are not experienced with that, you should do a parallel Installation. ( This install may be tested “calm” without riscing any destroy in the original system because the old Site keeps untouched.)

01. Install into subdirectory

02. Restore existing Database

and copy to a second DB
(phpMyAdmin → http://en.wikipedia.org/wiki/PhpMyAdmin).

- Before downloading you (may) reduce Datasize in flushing the following tables:

  • 1. phpwcms_bad_behavior flush empty
  • 2. phpwcms_cache flush empty
  • 3. phpwcms_formtracking flush empty (if exist) (Left Table phpwcms_bad_behavior → Select View above → select all below → delete. (For each Site of this table: redo (The same on phpwcms_cache, phpwcms_formtracking).
  • 4. Check Tables for errors if necessary rapair / optimize.

- Newer Versions of phpMyAdmn do Exports UTF-8 formated as a matter of principal.

-The new Database is craeted with the resulting collation for the MySQL Connection to phpMyAdmin. Within elder DB's there is a 99% quote that this will be swedish_latin1_ci)

- Import (under default character set of UTF-8) ther former exported Database. On use of ISO Charsets you may use the Editor mentioned below to convert the sql-file. - In die neue DB wird nun die exportierte mit der default Zeichencodierung UTF-8 importiert.

Sql Text - File : Loaded into Editor, select ISO8859-2 as Format and save under a new Filename. The File is ISO transformed now.

<note important> Pre-test a normal Export/Import with same settings for Im- and Export!!</note>.

03. Copy old File conf.inc.php into the new Installation

Copy conf.inc.php from your former phpwcms - Version backup into the new uploaded Files, and adjust with dist.conf.inc.php. Afterwards you have to replace the new Database with collation and charset and subdir in the renewed conf.inc.php

→ Better solution would be to have a Subdomain to call the so renewed system.

04. CHMODS for Files and subdir's

To be found in the docu - system or → Unpack/Upload phpwcms

05. Setup start as -> Update

- Be carefull and check version number (as mentioned in the first points) and start

- Run DB - Updates one by one and watchout for mistakes ( Remenber to scroll the complete output field )
Naturally the point of entrance is to be considered, e.g. the old version is 1.2.8 the update begins also with - 15 _1.2.7-DEV_to_1.2.9.sql).

- 13__1.2.5-DEV_to_1.2.6-DEV.sql (since V1.2.5)
- 14__1.2.6-DEV_to_1.2.7-DEV.sql
- 15__1.2.7-DEV_to_1.2.9.sql
- 16__1.2.9-DEV_to_1.3.0.sql
- 17__1.3.0_to_1.3.2.sql
- 18__1.3.2_to_1.3.3.sql

- 19__1.3.3_to_1.3.4.sql         (since V1.3.3)
- 19__1.3.4_to_1.3.5.sql
- 20__1.3.5_to_1.3.5.1.sql
- 21__1.3.5_to_1.5.sql
- 22__1.4_to_1.5.sql             (since V1.4.x)

→ There might be mistakes within the last update:

- Error: The table phpwcms_categories doesn't exist → ignore, that's a shop-update, you do not have the sop installed yet
- Error: The table phpwcms_log already exists → also ignore, not used in the new form.

05.1 Double indexes in some db-tables

- It can happen, that in the tables double indexes are available.

→ phpMyAdmin start
→ db select
→ table select
→ Step down to the indexes (where you can delete all indexes with “_1 _2_3 etc.” at the end.

(phpMyAdmin should point out that there are two indexes )
Please have a look into all tables.

06. If the shop is not needed

delete the complete path /include/inc_module/mod_shop/ with subdirs

07. Reorganize old content of preversioned subdirs

The content of the Directory /filearchive/ (phpwcms_filestorage) is to be brought into the subdir /filearchive/ of the nwe Version (In case of use of the /picture/ the same here)

- The new directory names

old new
phpwcms_filestorage → filearchive
phpwcms_ftp → upload
phpwcms_template → template

08. Adjust Config-Template File

The old /config/phpwcms/conf.template_default.inc.php has to be adjusted from the new one.

09. Change Default Index-Name: Home

In Case first point of Naviagtaion should be other name than home, change also in /config/phpwcms/conf.indexpage.inc.php

10. Adjust CSS-Data

Reorganize the old CSS data from /template/inc_css/ on your old Site to the new one.

11. Adjust Template

The old changed Tempaltes /template/inc_cntpart/ ought to be adjusted by the new Data.

<note tip>Adjust means: The NEW will be filled with the data of the old ones. </note>

12. Login

Delete Browsercache → login backend (not the index.php), disable tracking code (e.g. google etc.)

13. Disable Trackingcode

Disable in the default ( used) Template

14. Installing the modules

In installations based on older version it can occur that some module database entries are not yet installed, since this didn´t exist at release time.
Each module should be called once under modules, in order to start the Setup.

14.1 Delete the module Setup Directory

<note important>Afterwards the folder /include/inc_module/mod_Modulname/setup/ must be deleted!</note> Only now the module can be used.

15. Delete / Rename Setup Directory

In case the backend lets you in and looks as it should for security reasons you have to rename / delete the setup dir

16. Ongoing, last steps

<note tip> The system should be running. Meanwhile, while runing, there mightbe some patience needed ! Images rerun themselves in their size properties which may take
loger time. On any “timeout” alert, simply rerun the filecentre.</note>

(It is also possible to copy the content of the directory under /content/images/* , nevertheless, if this is not done, the system regenerates them by itself.)


For shure further Adjustments are also needed. Those like <META …> Tags XHTM -able: <meta …. /> etc. Thats playtime and has nothing to do with the update . If you do updates like mentioned above you will have advantage to keep your normal system untouched and proper untill all the update progress has come to its end.

After ending your work you may delete the old system and push the new system at its place, or redirect the domain into the new System <note tip> Be carefull in use of CSS and Template Data to avoid stress in this work !! </note> Maxim 1: Always use own Names for CSS- and Templatefiles, so that “copy” cannot delete them.

Maxim 2: If possible do use different CSS Data for Navigation and Template f.e. frontend01.css, layout01.css, navi01.css


Good work will do: Editor pspad and his FTP-Mode. (Direktly out of the Editor)

From: TotalCommander (chargefree for non-comercials). Alternativ http://www.filezilla.de/ .


Tip: A DIFF is build after TotalCommander

<note tip> With heidisql you can easily import very big DBs also (just did it with an 8MB DB - easy going! </note>

english/installation/update.1251872205.txt.gz · Last modified: 2018/06/03 18:08 (external edit)
www.planmatrix.de www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0