1.6.5 pracowało w środowisku php mniejszym od 5.5. Dla najnowszej wersji zmieniliśmy na php 7.0
Po rozpoczęciu upgrade wyskakuje następujący komunikat:
Type: E_USER_ERROR (256) Message: PATCH APPLY ERROR: Error occured. File: /crm/new/libs/adodb/adodb-errorhandler.inc.php Line: 79 Message: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id))] in EXECUTE("ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)") Array ( [0] => Array ( [file] => /crm/new/libs/adodb/adodb-errorhandler.inc.php [line] => 79 [function] => trigger_error [args] => Array ( [0] => mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id))] in EXECUTE("ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)") [1] => 256 ) ) [1] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1235 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqli [1] => EXECUTE [2] => 1452 [3] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [4] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [5] => [6] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM %s [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 1452 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [error_list] => Array ( [0] => Array ( [errno] => 1452 [sqlstate] => 23000 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) ) ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481991 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [_errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) ) ) [2] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1175 [function] => _Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM%s[fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [genSeqSQL] => create table if not exists %s (id int not null) [genSeqCountSQL] => select count() from %s [genSeq2SQL] => insert into %s values (%s) [dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [oldRaiseFn] => [transOK] => [connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481992 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [errorCode] => [queryID] => [isPersistentConnection] => [evalAll] => [affected] => [logsql] => [transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [3] => Array ( [file] => /crm/new/include/database.php [line] => 213 [function] => Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM %s [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481993 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [_errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( [0] => Array ( ) ) ) ) [4] => Array ( [file] => /crm/new/include/database.php [line] => 378 [function] => call_with_retry [class] => DB [type] => :: [args] => Array ( [0] => Execute [1] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( ) ) ) ) [5] => Array ( [file] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php [line] => 43 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [6] => Array ( [file] => /crm/new/include/patches.php [line] => 461 [args] => Array ( [0] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php ) [function] => include ) ) File: /crm/new/include/patches.php Line=49 error backtrace: [PHP core called function] function called: handle_epesi_error(256, "PATCH APPLY ERROR: Error occured. File: /crm/new/libs/adodb/adodb-errorhandler.inc.php Line: 79 Message: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id))] in EXECUTE(\"ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)\") Array ( [0] => Array ( [file] => /crm/new/libs/adodb/adodb-errorhandler.inc.php [line] => 79 [function] => trigger_error [args] => Array ( [0] => mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id))] in EXECUTE(\"ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)\") [1] => 256 ) ) [1] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1235 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqli [1] => EXECUTE [2] => 1452 [3] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [4] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [5] => [6] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM%s[fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [genSeqSQL] => create table if not exists %s (id int not null) [genSeqCountSQL] => select count() from %s [genSeq2SQL] => insert into %s values (%s) [dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [oldRaiseFn] => [transOK] => [connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 1452 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [error_list] => Array ( [0] => Array ( [errno] => 1452 [sqlstate] => 23000 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) ) ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481991 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [errorCode] => [queryID] => [isPersistentConnection] => [evalAll] => [affected] => [logsql] => [transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) ) ) [2] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1175 [function] => Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM %s [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481992 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [_errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [3] => Array ( [file] => /crm/new/include/database.php [line] => 213 [function] => Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM%s[fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [genSeqSQL] => create table if not exists %s (id int not null) [genSeqCountSQL] => select count() from %s [genSeq2SQL] => insert into %s values (%s) [dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [oldRaiseFn] => [transOK] => [connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481993 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [errorCode] => [queryID] => [isPersistentConnection] => [evalAll] => [affected] => [logsql] => [transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( [0] => Array ( ) ) ) ) [4] => Array ( [file] => /crm/new/include/database.php [line] => 378 [function] => call_with_retry [class] => DB [type] => :: [args] => Array ( [0] => Execute [1] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( ) ) ) ) [5] => Array ( [file] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php [line] => 43 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [6] => Array ( [file] => /crm/new/include/patches.php [line] => 461 [args] => Array ( [0] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php ) [function] => include ) ) ", "/crm/new/include/patches.php", 49, Array (true, Array (#30), Object (Patch), "ERROR", "PATCH APPLY ERROR: Error occured. File: /crm/new/libs/adodb/adodb-errorhandler.inc.php Line: 79 Message: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id))] in EXECUTE(\"ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)\") Array ( [0] => Array ( [file] => /crm/new/libs/adodb/adodb-errorhandler.inc.php [line] => 79 [function] => trigger_error [args] => Array ( [0] => mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id))] in EXECUTE(\"ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)\") [1] => 256 ) ) [1] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1235 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqli [1] => EXECUTE [2] => 1452 [3] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [4] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [5] => [6] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM %s [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 1452 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [error_list] => Array ( [0] => Array ( [errno] => 1452 [sqlstate] => 23000 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) ) ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481991 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [_errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) ) ) [2] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1175 [function] => _Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM%s[fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [genSeqSQL] => create table if not exists %s (id int not null) [genSeqCountSQL] => select count() from %s [genSeq2SQL] => insert into %s values (%s) [dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [oldRaiseFn] => [transOK] => [connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481992 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [errorCode] => [queryID] => [isPersistentConnection] => [evalAll] => [affected] => [logsql] => [transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [3] => Array ( [file] => /crm/new/include/database.php [line] => 213 [function] => Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM %s [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481993 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [_errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( [0] => Array ( ) ) ) ) [4] => Array ( [file] => /crm/new/include/database.php [line] => 378 [function] => call_with_retry [class] => DB [type] => :: [args] => Array ( [0] => Execute [1] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( ) ) ) ) [5] => Array ( [file] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php [line] => 43 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [6] => Array ( [file] => /crm/new/include/patches.php [line] => 461 [args] => Array ( [0] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php ) [function] => include ) ) ")) File: /crm/new/include/patches.php line 49 function called: trigger_error("PATCH APPLY ERROR: Error occured. File: /crm/new/libs/adodb/adodb-errorhandler.inc.php Line: 79 Message: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id))] in EXECUTE(\"ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)\") Array ( [0] => Array ( [file] => /crm/new/libs/adodb/adodb-errorhandler.inc.php [line] => 79 [function] => trigger_error [args] => Array ( [0] => mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id))] in EXECUTE(\"ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id)\") [1] => 256 ) ) [1] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1235 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqli [1] => EXECUTE [2] => 1452 [3] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [4] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [5] => [6] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM%s[fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [genSeqSQL] => create table if not exists %s (id int not null) [genSeqCountSQL] => select count() from %s [genSeq2SQL] => insert into %s values (%s) [dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [oldRaiseFn] => [transOK] => [connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 1452 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [error_list] => Array ( [0] => Array ( [errno] => 1452 [sqlstate] => 23000 [error] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) ) ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481991 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [errorCode] => [queryID] => [isPersistentConnection] => [evalAll] => [affected] => [logsql] => [transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) ) ) [2] => Array ( [file] => /crm/new/libs/adodb/adodb.inc.php [line] => 1175 [function] => Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM %s [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481992 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [_errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT#sql-f42_19a251_ibfk_3FOREIGN KEY (filestorage_id) REFERENCESutils_filestorage_files(id)) [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [3] => Array ( [file] => /crm/new/include/database.php [line] => 213 [function] => Execute [class] => ADOConnection [object] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM%s[fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [genSeqSQL] => create table if not exists %s (id int not null) [genSeqCountSQL] => select count() from %s [genSeq2SQL] => insert into %s values (%s) [dropSeqSQL] => drop table if exists %s [database] => db180160 [host] => localhost [user] => db180160 [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [oldRaiseFn] => [transOK] => [connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.54-38.6-log [server_version] => 50554 [stat] => Uptime: 154837 Threads: 6 Questions: 287481993 Slow queries: 637 Opens: 7510956 Flush tables: 1 Open tables: 81594 Queries per second avg: 1856.675 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1679953 [warning_count] => 0 ) [errorMsg] => Cannot add or update a child row: a foreign key constraint fails (db180160.#sql-f42_19a251, CONSTRAINT #sql-f42_19a251_ibfk_3 FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files (id)) [errorCode] => [queryID] => [isPersistentConnection] => [evalAll] => [affected] => [logsql] => [transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => db180160 ) [type] => -> [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( [0] => Array ( ) ) ) ) [4] => Array ( [file] => /crm/new/include/database.php [line] => 378 [function] => call_with_retry [class] => DB [type] => :: [args] => Array ( [0] => Execute [1] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) [1] => Array ( ) ) ) ) [5] => Array ( [file] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php [line] => 43 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE utils_attachment_file ADD FOREIGN KEY (filestorage_id) REFERENCES utils_filestorage_files(id) ) ) [6] => Array ( [file] => /crm/new/include/patches.php [line] => 461 [args] => Array ( [0] => /crm/new/modules/Utils/Attachment/patches/20150630_filestorage2.php ) [function] => include ) ) ", 256) File: /crm/new/update.php line 683 function called: apply_new(true) File: /crm/new/update.php line 587 function called: perform_update_patches() File: /crm/new/update.php line 311 function called: update_process() File: /crm/new/update.php line 794 function called: run()
