NAVIGATION
This shows you the differences between two versions of the page.
english:installation:update [2009/09/02 08:17] Knut Heermann (flip-flop) |
english:installation:update [2018/06/03 18:09] (current) |
||
---|---|---|---|
Line 4: | Line 4: | ||
- | **Update phpwcms (to V1.4.x)** | + | **Update phpwcms (to V1.5.x)** |
Forum: [[http://forum.phpwcms.org/viewtopic.php?p=109508#p109508|Update phpwcms]] | Forum: [[http://forum.phpwcms.org/viewtopic.php?p=109508#p109508|Update phpwcms]] | ||
- | (Written in 06.02.09) \\ | + | (Written in 14.01.11) \\ |
- | Download: - [[http://jgbm.de/checkout.phtml|Neueste Version]]\\ | + | |
+ | <del>Download: - [[http://www.phpwcms-docu.de/download-dev-versionen.phtml|Newest version]]</del>\\ | ||
+ | Download: - [[http://code.google.com/p/phpwcms/downloads/list|Newest version]]\\ | ||
+ | Download: - [[http://www.phpwcms.de/download/phpwcms-nightly.zip|Nightly Build]]\\ | ||
+ | |||
+ | Changelog: [[http://code.google.com/p/phpwcms/wiki/Changelog|phpwcms Changelog]] | ||
Docu: - [[http://www.phpwcms-docu.de/installation_en.phtml|Docu: Installation & Update]] | Docu: - [[http://www.phpwcms-docu.de/installation_en.phtml|Docu: Installation & Update]] | ||
---- | ---- | ||
Line 15: | Line 21: | ||
\\ | \\ | ||
- | 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.) | + | If you are not experienced with that, you should do a parallel Installation. ( This install may be tested "calm" without risc of destroying anything in your running system because the old Site will remain untouched.) |
===== 01. Install into subdirectory ===== | ===== 01. Install into subdirectory ===== | ||
+ | |||
+ | Install the latest version. | ||
+ | |||
+ | \\ | ||
+ | |||
+ | |||
+ | ===== 01.a Find my current version ===== | ||
+ | |||
+ | |||
+ | In old versions you have an entry in include/inc_lib/default.inc.php at the end of the file called: \\ | ||
+ | <file>$phpwcms["version"] = Version No.</file> | ||
+ | |||
+ | In newer versions there is an entry in include/inc_lib/default.inc.php around line 135 called: \\ | ||
+ | <file> | ||
+ | $phpwcms["release"] = Release No. | ||
+ | $phpwcms["release_date"] = Release date | ||
+ | </file> | ||
+ | |||
+ | In brand new versions there is an entry in include/inc_lib/default.inc.php around line 245 called: \\ | ||
+ | <file> | ||
+ | $phpwcms["release"] = Release No. | ||
+ | $phpwcms["release_date"] = Release date | ||
+ | $phpwcms["revision"] = Revision | ||
+ | </file> | ||
+ | |||
+ | \\ | ||
+ | |||
===== 02. Restore existing Database ===== | ===== 02. Restore existing Database ===== | ||
Line 23: | Line 56: | ||
(phpMyAdmin -> [[http://en.wikipedia.org/wiki/PhpMyAdmin]]). | (phpMyAdmin -> [[http://en.wikipedia.org/wiki/PhpMyAdmin]]). | ||
- | - Before downloading you (may) reduce Datasize in flushing the following tables: | + | - Before downloading you should reduce Datasize in flushing the following tables: |
- | * 1. phpwcms_bad_behavior flush empty | + | * 1. phpwcms_bad_behavior flush (=empty) |
- | * 2. phpwcms_cache 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). | + | * 3. phpwcms_formtracking flush (=empty) (if exist) (Left Table phpwcms_bad_behavior -> Select View above -> select all below -> delete. (For each screen page of this table: redo (The same goes for phpwcms_cache, phpwcms_formtracking). |
- | * 4. Check Tables for errors if necessary rapair / optimize. | + | * 4. phpwcms_log_seo flush (=empty) (if exist) (see above). |
- | - Newer Versions of phpMyAdmn do Exports UTF-8 formated as a matter of principal. | + | * 5. Check Tables for errors, if necessary repair / optimize. |
- | -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) | + | - Newer Versions of phpMyAdmn do exports as UTF-8 formatted by default. |
- | - 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. | + | -The new Database is created with the resulting collation for the MySQL Connection. Older DB's will certainly end up with swedish_latin1_ci) |
- | - In die neue DB wird nun die exportierte mit der default Zeichencodierung UTF-8 importiert. | + | |
+ | - Import (default character set: UTF-8) the formerly exported Database. When using ISO Charsets you may use the Editor mentioned below to convert the sql-file. | ||
+ | - The exported DB will be imported into the newly created DB resulting in a UTF-8 encoding. | ||
-- Sql Text - File : Loaded into Editor, select ##ISO8859-2## as Format and save under a new Filename. The File is ISO transformed now. | -- Sql Text - File : Loaded into Editor, select ##ISO8859-2## as Format and save under a new Filename. The File is ISO transformed now. | ||
Line 53: | Line 88: | ||
===== 05. Setup start as -> Update ===== | ===== 05. Setup start as -> Update ===== | ||
+ | |||
+ | ==== PHP- and DB version ==== | ||
+ | |||
+ | - Running MyDomain/setup/setup.php you will see, which "2. PHP version" - and which "3. MySQL version" are installed on the server. The PHP version should be at least 5, the MySQL version as well. \\ | ||
+ | The MySQL version must be still entered into the file conf.inc.php. | ||
+ | |||
+ | If the setting for example is displayed: \\ | ||
+ | 3. MySQL version: **5.0.51a** | ||
+ | |||
+ | please enter in the file conf.inc.php following MySQL version: | ||
+ | <code php> | ||
+ | $phpwcms['db_version'] = 50510; | ||
+ | </code> | ||
+ | |||
+ | \\ | ||
+ | |||
+ | |||
+ | ===== ===== | ||
+ | |||
+ | <note important> | ||
+ | **Since v1.4.5 R401 we need no manual database update.** | ||
+ | |||
+ | --> Continue with step [[english/installation/update#double_indexes_in_some_db-tables|05.1 Double indexes in some db-tables]] | ||
+ | </note> | ||
+ | |||
+ | |||
+ | |||
- Be carefull and check version number (as mentioned in the first points) and start | - Be carefull and check version number (as mentioned in the first points) and start | ||
+ | |||
+ | <note important> | ||
+ | **All db-updates must be processed in the right order !!!** \\ | ||
+ | // The leading numbering is determined, please do not get irritated by the instructions ..._X.Y_to_X.Z.sql. // | ||
+ | </note> | ||
- Run DB - Updates one by one and watchout for mistakes ( Remenber to scroll the complete output field ) \\ | - Run DB - Updates one by one and watchout for mistakes ( Remenber to scroll the complete output field ) \\ |