Input Array does not match ?: SELECT t.rub_id,t.rub_lib,t.rub_ordre,t.rub_type,t.rub_info,t.site_id FROM rubrique t WHERE 1=1 AND t.site_id = 10 AND rub_ordre <
Array ( [0] => Array ( [file] => /home/officefrnd/www/modules/contenu/class/Rubrique.class.php [line] => 9 [function] => getList [class] => ObjectModel [object] => Rubrique Object ( [table:protected] => rubrique [fields:protected] => Array ( [0] => rub_id [1] => rub_lib [2] => rub_ordre [3] => rub_type [4] => rub_info [5] => site_id ) [custom_fields:protected] => Array ( ) [fields_values:protected] => Array ( ) [groupby:protected] => Array ( ) [relations:protected] => Array ( ) [db] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => native [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SHOW TABLES [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] => [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 %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => officefrndbddv2 [host] => officefrndbddv2.mysql.db [user] => officefrndbddv2 [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] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => 2 [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.60 [client_version] => 50560 [connect_errno] => 0 [connect_error] => [errno] => 1064 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [error_list] => Array ( [0] => Array ( [errno] => 1064 [sqlstate] => 42000 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ) ) [field_count] => 1 [host_info] => officefrndbddv2.mysql.db via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.43-34 [server_version] => 80043 [stat] => Uptime: 332006 Threads: 7 Questions: 250102513 Slow queries: 23 Opens: 6245772 Flush tables: 4 Open tables: 4000 Queries per second avg: 753.307 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 3265218 [warning_count] => 0 ) [_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => officefrndbddv2 ) ) [type] => -> [args] => Array ( [0] => Array ( [t.site_id = ?] => [rub_ordre < ?] => 10 ) [1] => rub_ordre ASC [2] => ) ) [1] => Array ( [file] => /home/officefrnd/www/modules/commun/header.php [line] => 5 [function] => getList [class] => Rubrique [object] => Rubrique Object ( [table:protected] => rubrique [fields:protected] => Array ( [0] => rub_id [1] => rub_lib [2] => rub_ordre [3] => rub_type [4] => rub_info [5] => site_id ) [custom_fields:protected] => Array ( ) [fields_values:protected] => Array ( ) [groupby:protected] => Array ( ) [relations:protected] => Array ( ) [db] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => native [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SHOW TABLES [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] => [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 %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => officefrndbddv2 [host] => officefrndbddv2.mysql.db [user] => officefrndbddv2 [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] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => 2 [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.60 [client_version] => 50560 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => officefrndbddv2.mysql.db via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.43-34 [server_version] => 80043 [stat] => Uptime: 332006 Threads: 7 Questions: 250102514 Slow queries: 23 Opens: 6245772 Flush tables: 4 Open tables: 4000 Queries per second avg: 753.307 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 3265218 [warning_count] => 0 ) [_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => officefrndbddv2 ) ) [type] => -> [args] => Array ( [0] => Array ( [t.site_id = ?] => [rub_ordre < ?] => 10 ) [1] => rub_ordre ASC ) ) [2] => Array ( [file] => /home/officefrnd/www/index.php [line] => 51 [args] => Array ( [0] => /home/officefrnd/www/modules/commun/header.php ) [function] => include ) ) Input Array does not match ?: SELECT t.pg_id,t.rub_id,t.cat_id,t.usr_id,t.pg_titre,t.pg_chapo,t.pg_contenu,t.pg_info,t.pg_ordre,t.pg_statut,t.pg_photo,t.pg_date_crea,t.pg_date_affiche,t.pg_mot1,t.pg_mot2,t.pg_mot3,r.rub_id,r.rub_lib,u.usr_nom,u.usr_prenom FROM page t LEFT JOIN rubrique r ON r.rub_id = t.rub_id LEFT JOIN user u ON u.usr_id = t.usr_id WHERE 1=1 AND pg_statut = 1 AND r.site_id =
Array ( [0] => Array ( [file] => /home/officefrnd/www/modules/contenu/class/Page.class.php [line] => 33 [function] => getList [class] => ObjectModel [object] => Page Object ( [table:protected] => page [fields:protected] => Array ( [0] => pg_id [1] => rub_id [2] => cat_id [3] => usr_id [4] => pg_titre [5] => pg_chapo [6] => pg_contenu [7] => pg_info [8] => pg_ordre [9] => pg_statut [10] => pg_photo [11] => pg_date_crea [12] => pg_date_affiche [13] => pg_mot1 [14] => pg_mot2 [15] => pg_mot3 ) [relations:protected] => Array ( [0] => Array ( [table] => rubrique [alias] => r [identifier] => rub_id [fields] => Array ( [0] => rub_id [1] => rub_lib ) ) [1] => Array ( [table] => user [alias] => u [identifier] => usr_id [fields] => Array ( [0] => usr_nom [1] => usr_prenom ) ) ) [custom_fields:protected] => Array ( ) [fields_values:protected] => Array ( ) [groupby:protected] => Array ( ) [db] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => native [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SHOW TABLES [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] => [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 %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => officefrndbddv2 [host] => officefrndbddv2.mysql.db [user] => officefrndbddv2 [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] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => 2 [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.60 [client_version] => 50560 [connect_errno] => 0 [connect_error] => [errno] => 1064 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [error_list] => Array ( [0] => Array ( [errno] => 1064 [sqlstate] => 42000 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ) ) [field_count] => 1 [host_info] => officefrndbddv2.mysql.db via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.43-34 [server_version] => 80043 [stat] => Uptime: 332006 Threads: 7 Questions: 250102516 Slow queries: 23 Opens: 6245772 Flush tables: 4 Open tables: 4000 Queries per second avg: 753.307 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 3265218 [warning_count] => 0 ) [_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => officefrndbddv2 ) ) [type] => -> [args] => Array ( [0] => Array ( [pg_statut = ?] => 1 [r.site_id = ?] => [r.rub_id NOT IN (16, 18, 19)] => ) [1] => rub_ordre ASC, pg_ordre ASC [2] => ) ) [1] => Array ( [file] => /home/officefrnd/www/modules/commun/search.php [line] => 77 [function] => getList [class] => Page [object] => Page Object ( [table:protected] => page [fields:protected] => Array ( [0] => pg_id [1] => rub_id [2] => cat_id [3] => usr_id [4] => pg_titre [5] => pg_chapo [6] => pg_contenu [7] => pg_info [8] => pg_ordre [9] => pg_statut [10] => pg_photo [11] => pg_date_crea [12] => pg_date_affiche [13] => pg_mot1 [14] => pg_mot2 [15] => pg_mot3 ) [relations:protected] => Array ( [0] => Array ( [table] => rubrique [alias] => r [identifier] => rub_id [fields] => Array ( [0] => rub_id [1] => rub_lib ) ) [1] => Array ( [table] => user [alias] => u [identifier] => usr_id [fields] => Array ( [0] => usr_nom [1] => usr_prenom ) ) ) [custom_fields:protected] => Array ( ) [fields_values:protected] => Array ( ) [groupby:protected] => Array ( ) [db] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => native [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SHOW TABLES [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] => [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 %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => officefrndbddv2 [host] => officefrndbddv2.mysql.db [user] => officefrndbddv2 [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] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => 2 [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.60 [client_version] => 50560 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => officefrndbddv2.mysql.db via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.43-34 [server_version] => 80043 [stat] => Uptime: 332006 Threads: 7 Questions: 250102517 Slow queries: 23 Opens: 6245772 Flush tables: 4 Open tables: 4000 Queries per second avg: 753.307 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 3265218 [warning_count] => 0 ) [_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => officefrndbddv2 ) ) [type] => -> [args] => Array ( [0] => Array ( [pg_statut = ?] => 1 [r.site_id = ?] => [r.rub_id NOT IN (16, 18, 19)] => ) [1] => rub_ordre ASC, pg_ordre ASC ) ) [2] => Array ( [file] => /home/officefrnd/www/modules/commun/search.php [line] => 12 [function] => map [args] => Array ( ) ) [3] => Array ( [file] => /home/officefrnd/www/index.php [line] => 56 [args] => Array ( [0] => /home/officefrnd/www/modules/commun/search.php ) [function] => include ) )
Rejoignez-nous sur linkedin