Update nach r403 von < r401

Update nach r403 (V1.4.7) von älteren Versionen < r401 (V1.4.6)

Vorgehensweise nach Installation r403 V1.4.7 wenn das Update von einer älteren Version nicht funktioniert:

• Script nach /template/inc_script/frontend_render/update_403.php kopieren.
• Das Frontend einmal aufrufen
• Diese Script aus /frontend_render/ löschen !!

<?php
 
/* --------------- 401 */
    $revision = '401';
    // check if article description field exists
    $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'));
    }
 
 
 
 
 
/* ---------------- 403 */
    $revision = '403';
 
    $result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_articlecontent LIKE 'acontent_tab'", 'COUNT_SHOW');
 
    if(empty($result)) {
        $result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_articlecontent ADD acontent_tab VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
    }
 
    // check if new structure level class field exists
    $result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_articlecat LIKE 'acat_class'", 'COUNT_SHOW');
 
    if(empty($result)) {
        $result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_articlecat ADD acat_class VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
    }
 
    // check if new structure level keywords field exists
    $result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_articlecat LIKE 'acat_keywords'", 'COUNT_SHOW');
 
    if(empty($result)) {
        $result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_articlecat ADD acat_keywords VARCHAR(255) NOT NULL DEFAULT ''", 'ALTER');
    }
 
    // upgrade sysvalue fields
    $result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_vartype'");
    if(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');
    }
    $result = _dbQuery("SHOW COLUMNS FROM ".DB_PREPEND."phpwcms_sysvalue LIKE 'sysvalue_value'");
    if(isset($result[0]['Type']) && $result[0]['Type'] == 'text') {
        $result = _dbQuery("ALTER TABLE ".DB_PREPEND."phpwcms_sysvalue CHANGE sysvalue_value sysvalue_value MEDIUMTEXT NOT NULL", 'ALTER');
    }
 
    @write_textfile(PHPWCMS_TEMP.'r'.$revision.'.checked.tmp', date('Y-d-m H:i:s'));
 
?>

<note important>Nicht getestet!!</note>

— Knut Heermann (flip-flop) 2010/11/07 19:47