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] => 3734
[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] => 3734
[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
)
)
