Upgrade 1.5.2 do 1.5.6

woytzek

Podczas próby upgrade do wersji 1.5.6 otrzymuję następujący komunikat:

Type: E_USER_ERROR (256)
Message: PATCH APPLY ERROR: Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1833: Cannot change column 'name': used in a foreign key constraint 'history_ibfk_1' of table 'epesi.history'] in EXECUTE("ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'session_client_ibfk_1'] in EXECUTE("ALTER TABLE session_client MODIFY COLUMN session_name VARCHAR(128) NOT NULL") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'history_ibfk_1'] in EXECUTE("ALTER TABLE history MODIFY COLUMN session_name VARCHAR(128) NOT NULL")
File: C:\Apache2\htdocs\epesi\include\patches.php
Line=35
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "PATCH APPLY ERROR: Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1833: Cannot change column 'name': used in a foreign key constraint 'history_ibfk_1' of table 'epesi.history'] in EXECUTE(\"ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL\") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'session_client_ibfk_1'] in EXECUTE(\"ALTER TABLE session_client MODIFY COLUMN session_name VARCHAR(128) NOT NULL\") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'history_ibfk_1'] in EXECUTE(\"ALTER TABLE history MODIFY COLUMN session_name VARCHAR(128) NOT NULL\") ", "C:\Apache2\htdocs\epesi\include\patches.php", 35, Array (true, "data/patches_log.txt", ???, Array (#3), Object (Patch), "PATCH APPLY ERROR: Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1833: Cannot change column 'name': used in a foreign key constraint 'history_ibfk_1' of table 'epesi.history'] in EXECUTE(\"ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL\") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'session_client_ibfk_1'] in EXECUTE(\"ALTER TABLE session_client MODIFY COLUMN session_name VARCHAR(128) NOT NULL\") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'history_ibfk_1'] in EXECUTE(\"ALTER TABLE history MODIFY COLUMN session_name VARCHAR(128) NOT NULL\") "))

File: C:\Apache2\htdocs\epesi\include\patches.php
line 35
function called: trigger_error("PATCH APPLY ERROR: Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1833: Cannot change column 'name': used in a foreign key constraint 'history_ibfk_1' of table 'epesi.history'] in EXECUTE(\"ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL\") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'session_client_ibfk_1'] in EXECUTE(\"ALTER TABLE session_client MODIFY COLUMN session_name VARCHAR(128) NOT NULL\") Error occured. File: C:\Apache2\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1832: Cannot change column 'session_name': used in a foreign key constraint 'history_ibfk_1'] in EXECUTE(\"ALTER TABLE history MODIFY COLUMN session_name VARCHAR(128) NOT NULL\") ", 256)

File: C:\Apache2\htdocs\epesi\update.php
line 2727
function called: apply_new(true)

File: C:\Apache2\htdocs\epesi\index.php
line 38
function called: require_once("C:\Apache2\htdocs\epesi\update.php")

proszę o podpowiedź co może być przyczyną

p.s. instalacja na Windows Serwer 2008r2, Apache, MySQL

ajb

Zmień zawartość pliku modules/Base/patches/20140210_extend_session_id_length.php
na taką:

<?php

defined("_VALID_ACCESS") || die('Direct access forbidden');

$mysql = (DATABASE_DRIVER=='mysqli' || DATABASE_DRIVER=='mysqlt');

if ($mysql) {

    // remove foregin keys

    foreach (array('history', 'session_client') as $tab) {

        $a = DB::GetRow("SHOW CREATE TABLE $tab");

        if (preg_match('/CONSTRAINT (.+) FOREIGN KEY .*session_name/', $a[1], $m)) {

            DB::Execute("ALTER TABLE $tab DROP FOREIGN KEY " . $m[1]);

        }

    }

}

PatchUtil::db_alter_column('session', 'name', 'C(128) NOTNULL');

PatchUtil::db_alter_column('session_client', 'session_name', 'C(128) NOTNULL');

PatchUtil::db_alter_column('history', 'session_name', 'C(128) NOTNULL');

if ($mysql) {

    DB::Execute('ALTER TABLE history ADD FOREIGN KEY (session_name) REFERENCES session(name)');

    DB::Execute('ALTER TABLE session_client ADD FOREIGN KEY (session_name) REFERENCES session(name)');

}

i uruchom jeszcze raz patche/aktualizacje.

Wiemy o tym błędzie, od jakiegoś czasu, ale nie było opcji na przygotowanie wydania teraz.

Pozdrawiam,
Adam

woytzek

Dziękuję, pomogło 😃

baaltsz

Thanks… removing the foreign key constraints before running the upgrade process worked.
I added the constraints afterwards manually.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge