Bonjour,
Voici le contenu de l'erreur :
[31-Aug-2021 09:13:49 UTC] =========== Error ref. bpvlmovp ===========
Exception: Unable to prepare statement: 1, no such column: key in
/customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/KD2/DB/SQLite3.php:375
Stack trace:
#0 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/KD2/DB/SQLite3.php(375):
SQLite3->prepare('SELECT key, val...')
#1 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/KD2/DB/SQLite3.php(471):
KD2\DB\SQLite3->preparedQuery('SELECT key, val...')
#2 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Config.php(104):
KD2\DB\SQLite3->getAssoc('SELECT key, val...')
#3 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Config.php(85):
Garradin\Config->__construct()
#4 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Entities/Accounting/Account.php(531):
Garradin\Config::getInstance()
#5 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Accounting/Accounts.php(210):
Garradin\Entities\Accounting\Account->save()
#6 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Upgrade.php(69):
Garradin\Accounting\Accounts->importCSV('/customers/2/5/...')
#7 /customers/2/5/b/mtgnantes.fr/httpd.www/asso/www/admin/upgrade.php(36):
Garradin\Upgrade::upgrade()
#8 {main}
<errorReport>
{
"errors": [
{
"message": "Unable to prepare statement: 1, no such column:
key",
"errorCode": 0,
"type": "Exception",
"backtrace": [
{
"file": "...\/include\/lib\/KD2\/DB\/SQLite3.php",
"line": 375,
"code": {
"371": "",
"372": "\t\t$this->connect();",
"373": "",
"374": "\t\t$query =
$this->applyTablePrefix($query);",
"375": "\t\t$statement =
$this->db->prepare($query);",
"376": "",
"377": "\t\t$nb =
$statement->paramCount();",
"378": "",
"379": "\t\tif (!empty($args))"
}
},
{
"function": "SQLite3->prepare",
"file": "...\/include\/lib\/KD2\/DB\/SQLite3.php",
"line": 375,
"args": {
"$query": "string(43) \"SELECT key, value FROM
config ORDER BY key;\""
},
"code": {
"371": "",
"372": "\t\t$this->connect();",
"373": "",
"374": "\t\t$query =
$this->applyTablePrefix($query);",
"375": "\t\t$statement =
$this->db->prepare($query);",
"376": "",
"377": "\t\t$nb =
$statement->paramCount();",
"378": "",
"379": "\t\tif (!empty($args))"
}
},
{
"function": "KD2\\DB\\SQLite3->preparedQuery",
"file": "...\/include\/lib\/KD2\/DB\/SQLite3.php",
"line": 471,
"args": {
"$query": "string(43) \"SELECT key, value FROM
config ORDER BY key;\""
},
"code": {
"467": "\t}",
"468": "",
"469": "\tpublic function getAssoc(string
$statement, ...$args): array",
"470": "\t{",
"471": "\t\t$res =
$this->preparedQuery($statement,
...$args);",
"472": "\t\t$out = [];",
"473": "",
"474": "\t\twhile ($row =
$res->fetchArray(\\SQLITE3_NUM))",
"475": "\t\t{"
}
},
{
"function": "KD2\\DB\\SQLite3->getAssoc",
"file": "...\/include\/lib\/Garradin\/Config.php",
"line": 104,
"args": {
"$statement": "string(43) \"SELECT key, value
FROM
config ORDER BY key;\""
},
"code": {
"100": "\t\tparent::__construct();",
"101": "",
"102": "\t\t$db = DB::getInstance();",
"103": "",
"104": "\t\t$config = $db->getAssoc('SELECT
key,
value FROM config ORDER BY key;');",
"105": "",
"106": "\t\tif (empty($config)) {",
"107": "\t\t\treturn;",
"108": "\t\t}"
}
},
{
"function": "Garradin\\Config->__construct",
"file": "...\/include\/lib\/Garradin\/Config.php",
"line": 85,
"code": {
"81": "\tstatic protected $_instance = null;",
"82": "",
"83": "\tstatic public function
getInstance()",
"84": "\t{",
"85": "\t\treturn self::$_instance ?:
self::$_instance = new self;",
"86": "\t}",
"87": "",
"88": "\tstatic public function
deleteInstance()",
"89": "\t{"
}
},
{
"function": "Garradin\\Config::getInstance",
"file":
"...\/include\/lib\/Garradin\/Entities\/Accounting\/Account.php",
"line": 531,
"code": {
"527": "\t}",
"528": "",
"529": "\tpublic function save(): bool",
"530": "\t{",
"531": "\t\t$c = Config::getInstance();",
"532":
"\t\t$c->set('last_chart_change', time());",
"533": "",
"534": "\t\treturn parent::save();",
"535": "\t}"
}
},
{
"function":
"Garradin\\Entities\\Accounting\\Account->save",
"file":
"...\/include\/lib\/Garradin\/Accounting\/Accounts.php",
"line": 210,
"code": {
"206": "",
"207": "\t\t\t\t\t$row['position'] =
$positions[$row['position']];",
"208": "\t\t\t\t\t$row['type'] =
$types[$row['type']];",
"209":
"\t\t\t\t\t$account->importForm($row);",
"210": "\t\t\t\t\t$account->save();",
"211": "\t\t\t\t}",
"212": "\t\t\t\tcatch (ValidationException $e)
{",
"213": "\t\t\t\t\tthrow new
UserException(sprintf('Ligne %d : %s', $line, $e->getMessage()));",
"214": "\t\t\t\t}"
}
},
{
"function":
"Garradin\\Accounting\\Accounts->importCSV",
"file":
"...\/include\/lib\/Garradin\/Upgrade.php",
"line": 69,
"args": {
"$file": "string(35)
\"...\/include\/data\/charts\/fr_2018.csv\""
},
"code": {
"65": "\t\t\t\t$chart->label = 'Plan
comptable
associatif 2018';",
"66": "\t\t\t\t$chart->country =
'FR';",
"67": "\t\t\t\t$chart->code =
'PCA2018';",
"68": "\t\t\t\t$chart->save();",
"69":
"\t\t\t\t$chart->accounts()->importCSV(ROOT .
'\/include\/data\/charts\/fr_2018.csv');",
"70": "\t\t\t}",
"71": "",
"72": "",
"73": "\t\t\tif (version_compare($v,
'1.0.0-rc10',
'<'))"
}
},
{
"function": "Garradin\\Upgrade::upgrade",
"file": "...\/www\/admin\/upgrade.php",
"line": 36,
"code": {
"32": "<\/script>';",
"33": "",
"34": "flush();",
"35": "",
"36": "Upgrade::upgrade();",
"37": "",
"38": "echo '<h2>Mise \u00e0 jour
termin\u00e9e.<\/h2>",
"39": "<p><a
href=\"'.ADMIN_URL.'\">Retour<\/a><\/p>",
"40": ""
}
}
]
}
],
"context": {
"id": "bpvlmovp",
"date": "2021-08-31T09:13:49+00:00",
"os": "Linux",
"language": "PHP 7.4.23",
"environment": "production:1",
"php_sapi": "cgi-fcgi",
"remote_ip": "109.9.166.225",
"http_method": "GET",
"files_sent": "array(0) {\n}",
"rootDirectory": "\/customers\/2\/5\/b\/mtgnantes.fr
\/httpd.www\/asso",
"garradin_data_root": "\/customers\/2\/5\/b\/mtgnantes.fr
\/httpd.www\/asso",
"garradin_version": "1.1.9",
"url": "http:\/\/mtgnantes.fr\/asso\/admin\/upgrade.php"
}
}
</errorReport>
[31-Aug-2021 09:14:06 UTC] =========== Error ref. bpvlmovp ===========
Exception: Unable to prepare statement: 1, no such column: key in
/customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/KD2/DB/SQLite3.php:375
Stack trace:
#0 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/KD2/DB/SQLite3.php(375):
SQLite3->prepare('SELECT key, val...')
#1 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/KD2/DB/SQLite3.php(471):
KD2\DB\SQLite3->preparedQuery('SELECT key, val...')
#2 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Config.php(104):
KD2\DB\SQLite3->getAssoc('SELECT key, val...')
#3 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Config.php(85):
Garradin\Config->__construct()
#4 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Entities/Accounting/Account.php(531):
Garradin\Config::getInstance()
#5 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Accounting/Accounts.php(210):
Garradin\Entities\Accounting\Account->save()
#6 /customers/2/5/b/
mtgnantes.fr/httpd.www/asso/include/lib/Garradin/Upgrade.php(69):
Garradin\Accounting\Accounts->importCSV('/customers/2/5/...')
#7 /customers/2/5/b/mtgnantes.fr/httpd.www/asso/www/admin/upgrade.php(36):
Garradin\Upgrade::upgrade()
#8 {main}
<errorReport>
{
"errors": [
{
"message": "Unable to prepare statement: 1, no such column:
key",
"errorCode": 0,
"type": "Exception",
"backtrace": [
{
"file": "...\/include\/lib\/KD2\/DB\/SQLite3.php",
"line": 375,
"code": {
"371": "",
"372": "\t\t$this->connect();",
"373": "",
"374": "\t\t$query =
$this->applyTablePrefix($query);",
"375": "\t\t$statement =
$this->db->prepare($query);",
"376": "",
"377": "\t\t$nb =
$statement->paramCount();",
"378": "",
"379": "\t\tif (!empty($args))"
}
},
{
"function": "SQLite3->prepare",
"file": "...\/include\/lib\/KD2\/DB\/SQLite3.php",
"line": 375,
"args": {
"$query": "string(43) \"SELECT key, value FROM
config ORDER BY key;\""
},
"code": {
"371": "",
"372": "\t\t$this->connect();",
"373": "",
"374": "\t\t$query =
$this->applyTablePrefix($query);",
"375": "\t\t$statement =
$this->db->prepare($query);",
"376": "",
"377": "\t\t$nb =
$statement->paramCount();",
"378": "",
"379": "\t\tif (!empty($args))"
}
},
{
"function": "KD2\\DB\\SQLite3->preparedQuery",
"file": "...\/include\/lib\/KD2\/DB\/SQLite3.php",
"line": 471,
"args": {
"$query": "string(43) \"SELECT key, value FROM
config ORDER BY key;\""
},
"code": {
"467": "\t}",
"468": "",
"469": "\tpublic function getAssoc(string
$statement, ...$args): array",
"470": "\t{",
"471": "\t\t$res =
$this->preparedQuery($statement,
...$args);",
"472": "\t\t$out = [];",
"473": "",
"474": "\t\twhile ($row =
$res->fetchArray(\\SQLITE3_NUM))",
"475": "\t\t{"
}
},
{
"function": "KD2\\DB\\SQLite3->getAssoc",
"file": "...\/include\/lib\/Garradin\/Config.php",
"line": 104,
"args": {
"$statement": "string(43) \"SELECT key, value
FROM
config ORDER BY key;\""
},
"code": {
"100": "\t\tparent::__construct();",
"101": "",
"102": "\t\t$db = DB::getInstance();",
"103": "",
"104": "\t\t$config = $db->getAssoc('SELECT
key,
value FROM config ORDER BY key;');",
"105": "",
"106": "\t\tif (empty($config)) {",
"107": "\t\t\treturn;",
"108": "\t\t}"
}
},
{
"function": "Garradin\\Config->__construct",
"file": "...\/include\/lib\/Garradin\/Config.php",
"line": 85,
"code": {
"81": "\tstatic protected $_instance = null;",
"82": "",
"83": "\tstatic public function
getInstance()",
"84": "\t{",
"85": "\t\treturn self::$_instance ?:
self::$_instance = new self;",
"86": "\t}",
"87": "",
"88": "\tstatic public function
deleteInstance()",
"89": "\t{"
}
},
{
"function": "Garradin\\Config::getInstance",
"file":
"...\/include\/lib\/Garradin\/Entities\/Accounting\/Account.php",
"line": 531,
"code": {
"527": "\t}",
"528": "",
"529": "\tpublic function save(): bool",
"530": "\t{",
"531": "\t\t$c = Config::getInstance();",
"532":
"\t\t$c->set('last_chart_change', time());",
"533": "",
"534": "\t\treturn parent::save();",
"535": "\t}"
}
},
{
"function":
"Garradin\\Entities\\Accounting\\Account->save",
"file":
"...\/include\/lib\/Garradin\/Accounting\/Accounts.php",
"line": 210,
"code": {
"206": "",
"207": "\t\t\t\t\t$row['position'] =
$positions[$row['position']];",
"208": "\t\t\t\t\t$row['type'] =
$types[$row['type']];",
"209":
"\t\t\t\t\t$account->importForm($row);",
"210": "\t\t\t\t\t$account->save();",
"211": "\t\t\t\t}",
"212": "\t\t\t\tcatch (ValidationException $e)
{",
"213": "\t\t\t\t\tthrow new
UserException(sprintf('Ligne %d : %s', $line, $e->getMessage()));",
"214": "\t\t\t\t}"
}
},
{
"function":
"Garradin\\Accounting\\Accounts->importCSV",
"file":
"...\/include\/lib\/Garradin\/Upgrade.php",
"line": 69,
"args": {
"$file": "string(35)
\"...\/include\/data\/charts\/fr_2018.csv\""
},
"code": {
"65": "\t\t\t\t$chart->label = 'Plan
comptable
associatif 2018';",
"66": "\t\t\t\t$chart->country =
'FR';",
"67": "\t\t\t\t$chart->code =
'PCA2018';",
"68": "\t\t\t\t$chart->save();",
"69":
"\t\t\t\t$chart->accounts()->importCSV(ROOT .
'\/include\/data\/charts\/fr_2018.csv');",
"70": "\t\t\t}",
"71": "",
"72": "",
"73": "\t\t\tif (version_compare($v,
'1.0.0-rc10',
'<'))"
}
},
{
"function": "Garradin\\Upgrade::upgrade",
"file": "...\/www\/admin\/upgrade.php",
"line": 36,
"code": {
"32": "<\/script>';",
"33": "",
"34": "flush();",
"35": "",
"36": "Upgrade::upgrade();",
"37": "",
"38": "echo '<h2>Mise \u00e0 jour
termin\u00e9e.<\/h2>",
"39": "<p><a
href=\"'.ADMIN_URL.'\">Retour<\/a><\/p>",
"40": ""
}
}
]
}
],
"context": {
"id": "bpvlmovp",
"date": "2021-08-31T09:14:06+00:00",
"os": "Linux",
"language": "PHP 7.4.23",
"environment": "production:1",
"php_sapi": "cgi-fcgi",
"remote_ip": "109.9.166.225",
"http_method": "GET",
"files_sent": "array(0) {\n}",
"rootDirectory": "\/customers\/2\/5\/b\/mtgnantes.fr
\/httpd.www\/asso",
"garradin_data_root": "\/customers\/2\/5\/b\/mtgnantes.fr
\/httpd.www\/asso",
"garradin_version": "1.1.9",
"url": "http:\/\/mtgnantes.fr\/asso\/admin\/upgrade.php"
}
}
</errorReport>
Cordialement
*MTG Untap, Nantes, Draw*
*Association MTG Nantes*
Email : asso.mtgnantes@gmail.com
Facebook : facebook.com/MTGNantes/
Le ven. 3 sept. 2021 à 22:43, adresse <adresse@riseup.net> a écrit :
> Salut,
>
> Il faudrait envoyer l'erreur en question, qui se trouve dans le fichier
> error.log avec la référence indiquée :)
>
> --
> . ____
> / ___| Liste d'entraide des utilisateurs de Garradin
> | | _ http://garradin.eu/
> | |_| |
> \____| Désinscription : http://garradin.eu/aide/
>