During the upgrade from Epesi v1.5.2 to v1.5.6 several errors were encountered during the database update.
Those errors are listed below.
Seems that the underlying script attempted to update column names which were (still) part of an foreign key relationship.
How do I solve this problem ?
Is there a script available to first remove all foreign key relationships and a separate script to rebuild those relationships ?
Regards,
Bert
------------------------------
THE ERROR MESSAGES:
------------------------------
Type: E_USER_ERROR (256)
Message: PATCH APPLY ERROR: Error occured. File: /Library/WebServer/Documents/crm/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 'explooreu_crm.history'] in EXECUTE("ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL") Error occured. File: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/include/patches.php
Line=35
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "PATCH APPLY ERROR: Error occured. File: /Library/WebServer/Documents/crm/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 'explooreu_crm.history'] in EXECUTE(\"ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL\") Error occured. File: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/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\") ", "/Library/WebServer/Documents/crm/include/patches.php", 35, Array (true, "data/patches_log.txt", ???, Array (#19), Object (Patch), "PATCH APPLY ERROR: Error occured. File: /Library/WebServer/Documents/crm/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 'explooreu_crm.history'] in EXECUTE(\"ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL\") Error occured. File: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/include/patches.php
line 35
function called: trigger_error("PATCH APPLY ERROR: Error occured. File: /Library/WebServer/Documents/crm/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 'explooreu_crm.history'] in EXECUTE(\"ALTER TABLE session MODIFY COLUMN name VARCHAR(128) NOT NULL\") Error occured. File: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/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: /Library/WebServer/Documents/crm/update.php
line 2727
function called: apply_new(true)
File: /Library/WebServer/Documents/crm/index.php
line 38
function called: require_once("/Library/WebServer/Documents/crm/update.php")
