hi - I am having problems. It appears that there was a time out on my upgrade. I now get an error as follows. I have tried changing my patches 20140210_extend_session_id_length.php as worked for me in an earlier topic.
would be grateful for some assistance
Thanks
Type: E_USER_ERROR (256)
Message: PATCH APPLY ERROR: Error occured. File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE("ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY") Array ( [0] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php [line] => 77 [function] => trigger_error [args] => Array ( [0] => mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE("ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY") [1] => 256 ) ) [1] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1074 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqlt [1] => EXECUTE [2] => 1075 [3] => Incorrect table definition; there can be only one auto column and it must be defined as a key [4] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [5] => [6] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) ) ) [2] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1049 [function] => _Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [3] => Array ( [function] => Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [4] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/database.php [line] => 344 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [1] => Execute ) [1] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) ) [5] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php [line] => 21 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY ) ) [6] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/patches.php [line] => 460 [args] => Array ( [0] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php ) [function] => include ) )
File: /home/bdwmcom1/public_html/1extranet/DBase/include/patches.php
Line=50
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "PATCH APPLY ERROR: Error occured. File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE(\"ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY\") Array ( [0] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php [line] => 77 [function] => trigger_error [args] => Array ( [0] => mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE(\"ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY\") [1] => 256 ) ) [1] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1074 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqlt [1] => EXECUTE [2] => 1075 [3] => Incorrect table definition; there can be only one auto column and it must be defined as a key [4] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [5] => [6] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) ) ) [2] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1049 [function] => _Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [3] => Array ( [function] => Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [4] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/database.php [line] => 344 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [1] => Execute ) [1] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) ) [5] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php [line] => 21 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY ) ) [6] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/patches.php [line] => 460 [args] => Array ( [0] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php ) [function] => include ) ) ", "/home/bdwmcom1/public_html/1extranet/DBase/include/patches.php", 50, Array (true, Array (#14), Object (Patch), "ERROR", "PATCH APPLY ERROR: Error occured. File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE(\"ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY\") Array ( [0] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php [line] => 77 [function] => trigger_error [args] => Array ( [0] => mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE(\"ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY\") [1] => 256 ) ) [1] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1074 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqlt [1] => EXECUTE [2] => 1075 [3] => Incorrect table definition; there can be only one auto column and it must be defined as a key [4] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [5] => [6] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) ) ) [2] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1049 [function] => _Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [3] => Array ( [function] => Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [4] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/database.php [line] => 344 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [1] => Execute ) [1] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) ) [5] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php [line] => 21 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY ) ) [6] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/patches.php [line] => 460 [args] => Array ( [0] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php ) [function] => include ) ) "))
File: /home/bdwmcom1/public_html/1extranet/DBase/include/patches.php
line 50
function called: trigger_error("PATCH APPLY ERROR: Error occured. File: /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php Line: 77 Message: mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE(\"ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY\") Array ( [0] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb-errorhandler.inc.php [line] => 77 [function] => trigger_error [args] => Array ( [0] => mysqlt error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE(\"ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY\") [1] => 256 ) ) [1] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1074 [function] => ADODB_Error_Handler [args] => Array ( [0] => mysqlt [1] => EXECUTE [2] => 1075 [3] => Incorrect table definition; there can be only one auto column and it must be defined as a key [4] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [5] => [6] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) ) ) [2] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/libs/adodb/adodb.inc.php [line] => 1049 [function] => _Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [3] => Array ( [function] => Execute [class] => ADOConnection [object] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [type] => -> [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) [4] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/database.php [line] => 344 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => ADODB_mysqlt Object ( [databaseType] => mysqlt [ansiOuter] => 1 [hasTransactions] => 1 [autoRollback] => 1 [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=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() [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [charSet] => [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => bdwmcom1_BD1 [host] => localhost [user] => bdwmcom1_alan [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => ADODB_Error_Handler [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #19 [_errorMsg] => Incorrect table definition; there can be only one auto column and it must be defined as a key [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => bdwmcom1_BD1 ) [1] => Execute ) [1] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY [1] => ) ) ) [5] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php [line] => 21 [function] => Execute [class] => DB [type] => :: [args] => Array ( [0] => ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY ) ) [6] => Array ( [file] => /home/bdwmcom1/public_html/1extranet/DBase/include/patches.php [line] => 460 [args] => Array ( [0] => /home/bdwmcom1/public_html/1extranet/DBase/modules/Utils/RecordBrowser/patches/add_id_keys.php ) [function] => include ) ) ", 256)
File: /home/bdwmcom1/public_html/1extranet/DBase/update.php
line 173
function called: apply_new(true)
File: /home/bdwmcom1/public_html/1extranet/DBase/update.php
line 105
function called: perform_update_patches()
File: /home/bdwmcom1/public_html/1extranet/DBase/update.php
line 22
function called: update_process()
File: /home/bdwmcom1/public_html/1extranet/DBase/update.php
line 283
function called: run()
[color=#aaaaaa:1g3zhf7t][size=85:1g3zhf7t]// Edit: Please use code tags... ajb[/size:1g3zhf7t][/color:1g3zhf7t]