Input array has 2 params, does not match query: 'SELECT t.pg_id,t.site_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,c.cat_id,c.cat_lib,u.usr_nom,u.usr_prenom FROM page t LEFT JOIN rubrique r ON r.rub_id = t.rub_id LEFT JOIN categorie c ON c.cat_id = t.cat_id LEFT JOIN user u ON u.usr_id = t.usr_id WHERE 1=1 AND t.site_id = ? AND pg_statut = ? AND r.rub_id = ? AND pg_ordre > 1 ORDER BY pg_ordre ASC '
Array ( [0] => Array ( [file] => /var/www/vhosts/www.locataireavecaquitanis.fr/modules/contenu/page.php [line] => 59 [function] => getList [class] => ObjectModel [object] => Page Object ( [table:protected] => page [fields:protected] => Array ( [0] => pg_id [1] => site_id [2] => rub_id [3] => cat_id [4] => usr_id [5] => pg_titre [6] => pg_chapo [7] => pg_contenu [8] => pg_info [9] => pg_ordre [10] => pg_statut [11] => pg_photo [12] => pg_date_crea [13] => pg_date_affiche [14] => pg_mot1 [15] => pg_mot2 [16] => 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] => categorie [alias] => c [identifier] => cat_id [fields] => Array ( [0] => cat_id [1] => cat_lib ) ) [2] => 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] => 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 ( ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [ssl_key] => [ssl_cert] => [ssl_ca] => [ssl_capath] => [ssl_cipher] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 23 [host_info] => 10.11.179.5 via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.32 [server_version] => 80032 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 42845 [warning_count] => 0 ) [usePreparedStatement:ADODB_mysqli:private] => 1 [useLastInsertStatement:ADODB_mysqli:private] => [usingBoundVariables:ADODB_mysqli:private] => 1 [statementAffectedRows:ADODB_mysqli:private] => -1 [isSelectStatement:ADODB_mysqli:private] => 1 [_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] => locataire [dsnType] => [host] => 10.11.179.5 [user] => locataire [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [leftBracket] => [ [rightBracket] => ] [charSet] => utf8 [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] =>   [emptyTimeStamp] =>   [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [memCacheOptions] => Array ( ) [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] => [_errorMsg] => [_errorCode] => 0 [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [customActualTypes] => Array ( ) [customMetaTypes] => Array ( ) [databaseName] => locataire ) ) [type] => -> [args] => Array ( [0] => Array ( [t.site_id = ?] => 1 [pg_statut = ?] => 1 [r.rub_id = ?] => [pg_ordre > 1] => ) [1] => pg_ordre ASC ) ) [1] => Array ( [file] => /var/www/vhosts/www.locataireavecaquitanis.fr/modules/contenu/page.php [line] => 15 [function] => viewPage [args] => Array ( ) ) [2] => Array ( [file] => /var/www/vhosts/www.locataireavecaquitanis.fr/index.php [line] => 72 [args] => Array ( [0] => /var/www/vhosts/www.locataireavecaquitanis.fr/modules/contenu/page.php ) [function] => include ) ) Input array has 1 params, does not match query: 'SELECT t.res_id,t.elt_id,t.elt_type,t.res_ordre,t.res_titre,t.res_contenu,t.res_mime FROM ressource t WHERE 1=1 AND elt_id = ? AND elt_type = ? ORDER BY res_ordre ASC '
Array ( [0] => Array ( [file] => /var/www/vhosts/www.locataireavecaquitanis.fr/modules/contenu/page.php [line] => 66 [function] => getList [class] => ObjectModel [object] => Ressource Object ( [table:protected] => ressource [fields:protected] => Array ( [0] => res_id [1] => elt_id [2] => elt_type [3] => res_ordre [4] => res_titre [5] => res_contenu [6] => res_mime ) [custom_fields:protected] => Array ( ) [fields_values:protected] => Array ( ) [groupby:protected] => Array ( ) [relations:protected] => Array ( ) [db] => 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 ( ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [ssl_key] => [ssl_cert] => [ssl_ca] => [ssl_capath] => [ssl_cipher] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 7 [host_info] => 10.11.179.5 via TCP/IP [info] => [insert_id] => 0 [server_info] => 8.0.32 [server_version] => 80032 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 42845 [warning_count] => 0 ) [usePreparedStatement:ADODB_mysqli:private] => 1 [useLastInsertStatement:ADODB_mysqli:private] => [usingBoundVariables:ADODB_mysqli:private] => 1 [statementAffectedRows:ADODB_mysqli:private] => -1 [isSelectStatement:ADODB_mysqli:private] => 1 [_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] => locataire [dsnType] => [host] => 10.11.179.5 [user] => locataire [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [leftBracket] => [ [rightBracket] => ] [charSet] => utf8 [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] =>   [emptyTimeStamp] =>   [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [memCacheOptions] => Array ( ) [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] => [_errorMsg] => [_errorCode] => 0 [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [customActualTypes] => Array ( ) [customMetaTypes] => Array ( ) [databaseName] => locataire ) ) [type] => -> [args] => Array ( [0] => Array ( [elt_id = ?] => [elt_type = ?] => illusListe ) [1] => res_ordre ASC ) ) [1] => Array ( [file] => /var/www/vhosts/www.locataireavecaquitanis.fr/modules/contenu/page.php [line] => 15 [function] => viewPage [args] => Array ( ) ) [2] => Array ( [file] => /var/www/vhosts/www.locataireavecaquitanis.fr/index.php [line] => 72 [args] => Array ( [0] => /var/www/vhosts/www.locataireavecaquitanis.fr/modules/contenu/page.php ) [function] => include ) )