Differences

This shows you the differences between two versions of the page.

--- english:installation:update:r403 [2010/11/18 00:16]
Knut Heermann (flip-flop) created
+++ english:installation:update:r403 [2018/06/03 18:09] (current)
@@ Line 1: / Line 1: @@
 {{indexmenu_n>1}}
-====== Update to r403 from < r401 ======
+====== Update to r405 from < r401 ======
-**Update to r403 (V1.4.7) from older versions < r401 (V1.4.6)**
+<del>**Update to r405 (V1.4.7) from older versions < r401 (V1.4.6)**</del>
-Vorgehensweise nach Installation r403 V1.4.7 wenn das Update von einer älteren Version nicht funktioniert:
-Procedure for installation r403 V1.4.7 if the update is not working from a previous version:
+  * Forum: [[http://forum.phpwcms.org/viewtopic.php?p=127567#p127567]] [GER]
-  * Copy script to /template/inc_script/frontend_render/update_403.php.
+<note>**SOLVED since r406 V1.4.7 **- > [[http://www.phpwcms-docu.de/download-dev-versions.phtml|Docu: Download DEV - Version ZIP Format]]</note>
-  * The front end call once
-  * Delete this Script from /frontend_render/  !!
-\\
-**Update 18.11.2010**
-  * Checks if the field &quot;sysvalue_vartype&quot; in the table &quot;phpwcms_sysvalue&quot; exists and creates it if not yet available. //(Since r171 available)// \\ This field has not been used and was made only on new installations to r171. \\ In DB updates, the system is not available!
+&lt;del&gt;**Procedure for installation r405 V1.4.7 if the update is not working from a previous version:**&lt;/del&gt;
+  * Copy this text in the newly created file ##include/inc_lib/revision/r405.php##.
+  * Delete the file ##content/tmp/r405.checked.tmp##, if the update did not work apparently (Error Message "Fatal error: _setConfig failed" in FE).
 \\
-===== frontend_render Script: =====
+<del>**Update 23.11.2010** (Corrected DB update)</del&gt;
-<code php>
-<?php
-/* --------------- &lt; 401 */
-	// check if sysvalue_vartype field exists
+  * Checks if the field "sysvalue_vartype" in the table "phpwcms_sysvalue" exists and creates it if not yet available. //(Since r171 available)// \\ This field has not been used and was made only on new installations to r171. \\ In DB updates, the system is not available!
-	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_vartype'", 'COUNT_SHOW');
-	if(empty($result)) {
-		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD sysvalue_vartype VARCHAR(100) NOT NULL DEFAULT ''", 'ALTER');
+\\
-/* --------------- 401 */
-	$revision = '401';
-	// check if article description field exists
+&lt;code php&gt;
-	$result = _dbQuery(&quot;SHOW COLUMNS FROM &quot;.DB_PREPEND."phpwcms_article LIKE 'article_description'", 'COUNT_SHOW');
+&lt;?php
+/*************************************************************************************
-	if(empty($result)) {
+   Copyright notice
-		$result = _dbQuery(&quot;ALTER TABLE ".DB_PREPEND."phpwcms_article ADD article_description VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
-		@write_textfile(PHPWCMS_TEMP.'r'.$revision.'.checked.tmp', date('Y-d-m H:i:s'));
-	}
+   (c) 2002-2010 Oliver Georgi (oliver@phpwcms.de) // All rights reserved.
+   This script is part of PHPWCMS. The PHPWCMS web content management system is
+   free software; you can redistribute it and/or modify it under the terms of
+   the GNU General Public License as published by the Free Software Foundation;
+   either version 2 of the License, or (at your option) any later version.
+   The GNU General Public License can be found at http://www.gnu.org/copyleft/gpl.html
+   A copy is found in the textfile GPL.txt and important notices to the license
+   from the author is found in LICENSE.txt distributed with these scripts.
+   This script is distributed in the hope that it will be useful, but WITHOUT ANY
+   WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
+   PARTICULAR PURPOSE.  See the GNU General Public License for more details.
-/* ---------------- 403 */
+   This copyright notice MUST APPEAR in all copies of the script!
-	$revision = '403';
+*************************************************************************************/
+// Revision 405 Update Check
+function phpwcms_revision_r405() {
+	$status = true;
+	// do former revision check
+	// r402 required no action, so fallback to r401
+	$r401 = '401';
+	if(phpwcms_revision_check_temp($r401) !== true) {
+		$status = phpwcms_revision_check($r401);
+	}
+	// check if article content tab field exists
 	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_articlecontent LIKE 'acontent_tab'", 'COUNT_SHOW');
@@ Line 73: / Line 86: @@
 	}
-	// upgrade sysvalue fields
+	// upgrade sysvalue fields +KH:24.11.2011 if no field exists
 	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_vartype'");
-	if(isset($result[0]['Type']) && $result[0]['Type'] == 'varchar(100)') {
+	// sysvalue_vartype
+	if(empty($result)) {
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD sysvalue_vartype VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
+	}
+	elseif(isset($result[0]['Type']) && $result[0]['Type'] == 'varchar(100)') {
 		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue CHANGE sysvalue_vartype sysvalue_vartype VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
 	}
+	// sysvalue_value
 	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_value'");
-	if(isset($result[0]['Type']) && $result[0]['Type'] == 'text') {
+	if(empty($result)) {
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD sysvalue_value MEDIUMTEXT NOT NULL DEFAULT ''", 'ALTER');
+	}
+	elseif(isset($result[0]['Type']) && ($result[0]['Type'] == 'text' OR $result[0]['Type'] == 'mediumblob')) {
 		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue CHANGE sysvalue_value sysvalue_value MEDIUMTEXT NOT NULL", 'ALTER');
+	}
+	// sysvalue_lastchange
+	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_lastchange'");
+	if(empty($result)) {
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD sysvalue_lastchange INT(11) NOT NULL DEFAULT 0", 'ALTER');
+	}
+	// sysvalue_group
+	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_group'");
+	if(empty($result)) {
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD sysvalue_group VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD INDEX (sysvalue_group)", 'ALTER');
+	}
+	// sysvalue_status
+	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_status'");
+	if(empty($result)) {
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD sysvalue_status INT(1) NOT NULL DEFAULT 0", 'ALTER');
+		$result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue ADD INDEX (sysvalue_status)", 'ALTER');
 	}
-	@write_textfile(PHPWCMS_TEMP.'r'.$revision.'.checked.tmp', date('Y-d-m H:i:s'));
+	return $status;
+}
 ?>
 </code>
 \\
-<note important>**Not tested!!**</note>
  --- //[[flip-flop@myrealbox.com|Knut Heermann (flip-flop)]] 2010/11/07 19:47//

english/installation/update/r403.1290035812.txt.gz · Last modified: 2018/06/03 18:08 (external edit)

Show page Old revisions