Differences

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

--- deutsch:installation:update:r403 [2010/11/18 00:10]
Knut Heermann (flip-flop)
+++ deutsch:installation:update:r403 [2018/06/03 18:09] (current)
@@ Line 1: / Line 1: @@
 {{indexmenu_n>1}}
-====== Update nach r403 von < r401 ======
+====== Update nach r405 von < r401 ======
-**Update nach r403 (V1.4.7) von älteren Versionen < r401 (V1.4.6)**
+<del>**Update nach r405 (V1.4.7) von älteren Versionen < r401 (V1.4.6)**</del>
-Vorgehensweise nach Installation r403 V1.4.7 wenn das Update von einer älteren Version nicht funktioniert:
+  * Forum: [[http://forum.phpwcms.org/viewtopic.php?p=127567#p127567]]
+<note> **Problem gelöst** seit der Version r406 V1.4.7 -> [[http://www.phpwcms-docu.de/download-dev-versionen.phtml|DOCU: Download DEV - Versionen im ZIP Format]]</note>
+<del>**Vorgehensweise nach Installation r405 V1.4.7 wenn das Update von einer älteren Version nicht funktioniert: **</del>
-  * Script nach /template/inc_script/frontend_render/update_403.php kopieren.
+  * Diesen Text in die neu anzulegende Datei ##include/inc_lib/revision/r405.php## kopieren.
-  * Das Frontend einmal aufrufen
+  * Die Datei ##content/tmp/r405.checked.tmp## löschen, wenn das Update scheinbar nicht funktioniert hat (Fehlermeldung "Fatal error: _setConfig failed" in FE).
-  * Diese Script aus /frontend_render/ löschen !!
 \\
-**Update 18.11.2010**
+<del>**Update 23.11.2010** (Korrigiertes DB-Update)</del>
   * Prüft ob das Feld "sysvalue_vartype" in der Tabelle "phpwcms_sysvalue" existiert und erzeugt es wenn noch nicht vorhanden. //(Seit r171 vorhanden)// \\ Dieses Feld wurde bisher nicht verwendet und nur bei Neuinstallationen nach r171 erzeugt. \\ In DB-Updates ist die Anlage nicht vorhanden!
@@ Line 20: / Line 24: @@
 \\
-===== Frontendrender Script: =====
 <code php>
 <?php
-/* --------------- < 401 */
+/*************************************************************************************
+   Copyright notice
-	// check if sysvalue_vartype field exists
+   (c) 2002-2010 Oliver Georgi (oliver@phpwcms.de) // All rights reserved.
-	$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');
+   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.
-/* --------------- 401 */
+   This script is distributed in the hope that it will be useful, but WITHOUT ANY
-	$revision = '401';
+   WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
+   PARTICULAR PURPOSE.  See the GNU General Public License for more details.
-	// check if article description field exists
+   This copyright notice MUST APPEAR in all copies of the script!
-	$result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_article LIKE 'article_description'", 'COUNT_SHOW');
+*************************************************************************************/
-	if(empty($result)) {
-		$result = _dbQuery("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'));
-	}
+// Revision 405 Update Check
+function phpwcms_revision_r405() {
-/* ---------------- 403 */
+	$status = true;
-	$revision = '403';
+	// 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 72: / Line 83: @@
 	}
-	// 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>**Nicht getestet!!**</note>
  --- //[[flip-flop@myrealbox.com|Knut Heermann (flip-flop)]] 2010/11/07 19:47//

deutsch/installation/update/r403.1290035446.txt.gz · Last modified: 2018/06/03 18:07 (external edit)

Show page Old revisions