Génération de reçu => 500
L'URL /receipt/:id
donne l'erreur suivante :
Internal Server Error
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dons.nom' in 'field list'
[app/Perso.php:442] DB\SQL->query('SELECT dons.datec, dons.somme, dons.nom as pseudo, users.nom, users.adresse, users.codepostal, users.ville FROM dons INNER JOIN users ON users.id=dons.user_id WHERE users.id=13421 AND dons.status IN (1,4,102) AND dons.id=36098;')
[vendor/bcosca/fatfree/lib/base.php:1500] Base->call('Perso->receipt',array(Base::__set_state(array('hive'=>array('HEADERS'=>array('Authorization'=>'','Host'=>'soutien.laquadrature.net','User-Agent'=>'Mozilla/5.0 (X11; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','Accept'=>'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8','Accept-Language'=>'fr-FR','Accept-Encoding'=>'gzip, deflate, br','Referer'=>'https://soutien.laquadrature.net/perso','Cookie'=>'MON_COOKIE; PHPSESSID=MON_SID','Dnt'=>'1','Connection'=>'keep-alive','Upgrade-Insecure-Requests'=>'1'),'AGENT'=>'Mozilla/5.0 (X11; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','AJAX'=>false,'ALIAS'=>'recu','ALIASES'=>array('home'=>'/','bonus'=>'/@hash','what'=>'/what','who'=>'/who','why'=>'/why','faq'=>'/faq','merci'=>'/merci','material'=>'/material','donate'=>'/donate','cb'=>'/cb','perso'=>'/perso','login'=>'/login','logout'=>'/perso/logout','cancel'=>'/cancel/@id','infos'=>'/infos','add_contrepartie'=>'/add/contrepartie','adresses'=>'/perso/adresses','recu'=>'/receipt/@id','admin'=>'/admin','add_support'=>'/admin/support/add','edit_support'=>'/admin/support/edit/@id','modify_support'=>'/admin/support/edit','admin_accounts'=>'/admin/accounts','counterparts'=>'/admin/counterparts','export'=>'/counterparts/admin/export','edit_counterpart'=>'/admin/counterparts/edit/@id','modify_counterpart'=>'/admin/counterparts/edit','cbs'=>'/admin/cbs','export_cbs'=>'/admin/cbs/export','users'=>'/admin/users','add_user'=>'/admin/users/add','user_info'=>'/admin/users/@id','modify_user'=>'/admin/users/@id','adresse'=>'/admin/adresses','counterparts_dashboard'=>'/admin/counterparts_dashboard','banque'=>'/admin/banque','stats'=>'/admin/stats'),'AUTOLOAD'=>'app/','BASE'=>'','BITMASK'=>2,'BODY'=>'','CACHE'=>false,'CASELESS'=>true,'CONFIG'=>NULL,'CORS'=>array('headers'=>'','origin'=>false,'credentials'=>false,'expose'=>false,'ttl'=>0),'DEBUG'=>3,'DIACRITICS'=>array(),'DNSBL'=>'','EMOJI'=>array(),'ENCODING'=>'UTF-8','ERROR'=>NULL,'ESCAPE'=>true,'EXCEPTION'=>PDOException::__set_state(array('errorInfo'=>array('42S22',1054,'Unknown column 'dons.nom' in 'field list''))),'EXEMPT'=>NULL,'FALLBACK'=>'en','FRAGMENT'=>'','HALT'=>true,'HIGHLIGHT'=>true,'HOST'=>'soutien.laquadrature.net','IP'=>'MON_IP','JAR'=>array('expire'=>0,'path'=>'/','domain'=>'soutien.laquadrature.net','secure'=>true,'httponly'=>true),'LANGUAGE'=>'en','LOCALES'=>'./','LOGS'=>'./','ONERROR'=>NULL,'ONREROUTE'=>NULL,'PACKAGE'=>'Fat-Free Framework','PARAMS'=>array(0=>'/receipt/36098','id'=>'36098'),'PATH'=>'/receipt/36098','PATTERN'=>'/receipt/@id','PLUGINS'=>'/srv/soutien/soutien/vendor/bcosca/fatfree/lib/','PORT'=>'443','PREFIX'=>NULL,'PREMAP'=>'','QUERY'=>'','QUIET'=>false,'RAW'=>false,'REALM'=>'https://soutien.laquadrature.net/receipt/36098','RESPONSE'=>'','ROOT'=>'/srv/soutien/soutien','ROUTES'=>array('/why'=>array(3=>array('GET'=>array('Campaign->why',0,0,'why'))),'/who'=>array(3=>array('GET'=>array('Campaign->who',0,0,'who'))),'/what'=>array(3=>array('GET'=>array('Campaign->what',0,0,'what'))),'/receipt/@id'=>array(3=>array('GET'=>array('Perso->receipt',0,0,'recu'))),'/perso/logout'=>array(3=>array('GET'=>array('Perso->logout',0,0,'logout'),'POST'=>array('Perso->logout',0,0,'logout'))),'/perso/adresses'=>array(3=>array('POST'=>array('Perso->adresses',0,0,'adresses'))),'/perso'=>array(3=>array('GET'=>array('Perso->show',0,0,'perso'),'POST'=>array('Perso->show',0,0,'perso'))),'/merci'=>array(3=>array('GET'=>array('Campaign->merci',0,0,'merci'))),'/material'=>array(3=>array('GET'=>array('Campaign->material',0,0,'material'))),'/login'=>array(3=>array('POST'=>array('Perso->login',0,0,'login'),'GET'=>array('Perso->login',0,0,'login'))),'/infos'=>array(3=>array('POST'=>array('Perso->infos',0,0,'infos'))),'/faq'=>array(3=>array('GET'=>array('Campaign->faq',0,0,'faq'))),'/donate'=>array(3=>array('POST'=>array('Campaign->donate',0,0,'donate'))),'/cron/piplome/@id'=>array(3=>array('GET'=>array('Cron->piplome',0,0,NULL))),'/cron/@action'=>array(3=>array('GET'=>array('Cron->@action',0,0,NULL))),'/counterparts/admin/export'=>array(3=>array('POST'=>array('Admin->counterparts',0,0,'export'))),'/cb'=>array(3=>array('POST'=>array('Bank->cb',0,0,'cb'))),'/cancel/@id'=>array(3=>array('GET'=>array('Perso->cancel',0,0,'cancel'),'POST'=>array('Perso->cancel',0,0,'cancel'))),'/admin/users/add'=>array(3=>array('POST'=>array('Admin->user',0,0,'add_user'))),'/admin/users/@id'=>array(3=>array('GET'=>array('Admin->user',0,0,'user_info'),'POST'=>array('Admin->user',0,0,'modify_user'))),'/admin/users'=>array(3=>array('GET'=>array('Admin->users',0,0,'users'),'POST'=>array('Admin->users',0,0,'users'))),'/admin/support/edit/@id'=>array(3=>array('GET'=>array('Admin->support',0,0,'edit_support'))),'/admin/support/edit'=>array(3=>array('POST'=>array('Admin->support',0,0,'modify_support'))),'/admin/support/add'=>array(3=>array('GET'=>array('Admin->support',0,0,'add_support'))),'/admin/stats'=>array(3=>array('GET'=>array('Admin->stats',0,0,'stats'))),'/admin/counterparts_dashboard'=>array(3=>array('GET'=>array('Admin->counterparts_dashboard',0,0,'counterparts_dashboard'))),'/admin/counterparts/edit/@id'=>array(3=>array('GET'=>array('Admin->counterpart',0,0,'edit_counterpart'))),'/admin/counterparts/edit'=>array(3=>array('POST'=>array('Admin->counterpart',0,0,'modify_counterpart'))),'/admin/counterparts'=>array(3=>array('GET'=>array('Admin->counterparts',0,0,'counterparts'),'POST'=>array('Admin->counterparts',0,0,'counterparts'))),'/admin/cbs/export'=>array(3=>array('POST'=>array('Admin->cbs',0,0,'export_cbs'))),'/admin/cbs'=>array(3=>array('GET'=>array('Admin->cbs',0,0,'cbs'),'POST'=>array('Admin->cbs',0,0,'cbs'))),'/admin/banque'=>array(3=>array('GET'=>array('Admin->banque',0,0,'banque'),'POST'=>array('Admin->banque',0,0,'banque'))),'/admin/adresses'=>array(3=>array('POST'=>array('Admin->adresse',0,0,'adresse'))),'/admin/accounts'=>array(3=>array('GET'=>array('Admin->accounts',0,0,'admin_accounts'),'POST'=>array('Admin->accounts',0,0,'admin_accounts'))),'/admin'=>array(3=>array('GET'=>array('Admin->show',0,0,'admin'),'POST'=>array('Admin->show',0,0,'admin'))),'/add/contrepartie'=>array(3=>array('POST'=>array('Perso->add_contrepartie',0,0,'add_contrepartie'))),'/@hash'=>array(3=>array('GET'=>array('Campaign->bonus',0,0,'bonus'))),'/'=>array(3=>array('GET'=>array('Campaign->show',0,0,'home'),'POST'=>array('Campaign->show',0,0,'home')))),'SCHEME'=>'https','SERIALIZER'=>'php','TEMP'=>'tmp/','TIME'=>1479206340.1602981,'TZ'=>'Europe/Berlin','UI'=>'templates/','UNLOAD'=>NULL,'UPLOADS'=>'./','URI'=>'/receipt/36098','VERB'=>'GET','VERSION'=>'3.5.1-Release','XFRAME'=>'SAMEORIGIN','GET'=>array(),'POST'=>array(),'COOKIE'=>array('SESS98c0b685fd61d59c8fbf306b3321c732'=>'jl9nbsbdmmm55ne772fuh4djk6','PHPSESSID'=>'MON_SID'),'REQUEST'=>array(),'SESSION'=>array('csrf'=>'1qzb1gyeg04jw.1vvu1vx9bu6o0','errors'=>array(),'id'=>'13421','email'=>NULL,'user'=>true,'msg'=>'Informations personnelles modifiées.'),'FILES'=>array(),'SERVER'=>array('REDIRECT_HTTPS'=>'on','REDIRECT_SSL_TLS_SNI'=>'soutien.laquadrature.net','REDIRECT_STATUS'=>'200','HTTP_AUTHORIZATION'=>'','HTTPS'=>'on','SSL_TLS_SNI'=>'soutien.laquadrature.net','HTTP_HOST'=>'soutien.laquadrature.net','HTTP_USER_AGENT'=>'Mozilla/5.0 (X11; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','HTTP_ACCEPT'=>'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8','HTTP_ACCEPT_LANGUAGE'=>'fr-FR','HTTP_ACCEPT_ENCODING'=>'gzip, deflate, br','HTTP_REFERER'=>'https://soutien.laquadrature.net/perso','HTTP_COOKIE'=>'MON_COOKIE; PHPSESSID=MON_SID','HTTP_DNT'=>'1','HTTP_CONNECTION'=>'keep-alive','HTTP_UPGRADE_INSECURE_REQUESTS'=>'1','PATH'=>'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin','SERVER_SIGNATURE'=>'<address>Apache/2.4.10 (Debian) Server at soutien.laquadrature.net Port 443</address>
','SERVER_SOFTWARE'=>'Apache/2.4.10 (Debian)','SERVER_NAME'=>'soutien.laquadrature.net','SERVER_ADDR'=>'2a00:99a0:0:1000::4','SERVER_PORT'=>'443','REMOTE_ADDR'=>'MON_IP','DOCUMENT_ROOT'=>'/srv/soutien/soutien','REQUEST_SCHEME'=>'https','CONTEXT_PREFIX'=>'','CONTEXT_DOCUMENT_ROOT'=>'/srv/soutien/soutien/','SERVER_ADMIN'=>'[no address given]','SCRIPT_FILENAME'=>'/srv/soutien/soutien/index.php','REMOTE_PORT'=>'32898','REDIRECT_URL'=>'/receipt/36098','GATEWAY_INTERFACE'=>'CGI/1.1','SERVER_PROTOCOL'=>'HTTP/1.1','REQUEST_METHOD'=>'GET','QUERY_STRING'=>'','REQUEST_URI'=>'/receipt/36098','SCRIPT_NAME'=>'/index.php','PHP_SELF'=>'/index.php','REQUEST_TIME_FLOAT'=>1479206340.1570001,'REQUEST_TIME'=>1479206340),'ENV'=>array(),'languages'=>array('ES'=>array('apoyar','es_ES','es'),'FR'=>array('soutien','fr_FR','fr'),'EN'=>array('support','en_US','en')),'lang'=>'fr_FR','lang_short'=>'fr','DB'=>DBSQL::__set_state(array()),'CSRF'=>'1qzb1gyeg04jw.1vvu1vx9bu6o0','mail'=>array('from'=>'contact@laquadrature.net','fromName'=>'La Quadrature du Net'),'atailles'=>array(7=>'Coupe Femme, Taille L',6=>'Coupe Femme, Taille M',5=>'Coupe Femme, Taille S',8=>'Coupe Femme, Taille XL',10=>'Coupe Femme, Taille XXL',3=>'Coupe Homme, Taille L',2=>'Coupe Homme, Taille M',1=>'Coupe Homme, Taille S',4=>'Coupe Homme, Taille XL',9=>'Coupe Homme, Taille XXL')),'init'=>array('HEADERS'=>array('Authorization'=>'','Host'=>'soutien.laquadrature.net','User-Agent'=>'Mozilla/5.0 (X11; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','Accept'=>'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8','Accept-Language'=>'fr-FR','Accept-Encoding'=>'gzip, deflate, br','Referer'=>'https://soutien.laquadrature.net/perso','Cookie'=>'MON_COOKIE; PHPSESSID=MON_SID','Dnt'=>'1','Connection'=>'keep-alive','Upgrade-Insecure-Requests'=>'1'),'AGENT'=>'Mozilla/5.0 (X11; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','AJAX'=>false,'ALIAS'=>NULL,'ALIASES'=>array(),'AUTOLOAD'=>'./','BASE'=>'','BITMASK'=>2,'BODY'=>NULL,'CACHE'=>false,'CASELESS'=>true,'CONFIG'=>NULL,'CORS'=>array('headers'=>'','origin'=>false,'credentials'=>false,'expose'=>false,'ttl'=>0),'DEBUG'=>0,'DIACRITICS'=>array(),'DNSBL'=>'','EMOJI'=>array(),'ENCODING'=>'UTF-8','ERROR'=>NULL,'ESCAPE'=>true,'EXCEPTION'=>NULL,'EXEMPT'=>NULL,'FALLBACK'=>'en','FRAGMENT'=>'','HALT'=>true,'HIGHLIGHT'=>true,'HOST'=>'soutien.laquadrature.net','IP'=>'MON_IP','JAR'=>array('expire'=>0,'path'=>'/','domain'=>'soutien.laquadrature.net','secure'=>true,'httponly'=>true),'LANGUAGE'=>'fr-FR,fr,en','LOCALES'=>'./','LOGS'=>'./','ONERROR'=>NULL,'ONREROUTE'=>NULL,'PACKAGE'=>'Fat-Free Framework','PARAMS'=>array(),'PATH'=>'/receipt/36098','PATTERN'=>NULL,'PLUGINS'=>'/srv/soutien/soutien/vendor/bcosca/fatfree/lib/','PORT'=>'443','PREFIX'=>NULL,'PREMAP'=>'','QUERY'=>'','QUIET'=>false,'RAW'=>false,'REALM'=>'https://soutien.laquadrature.net/receipt/36098','RESPONSE'=>'','ROOT'=>'/srv/soutien/soutien','ROUTES'=>array(),'SCHEME'=>'https','SERIALIZER'=>'php','TEMP'=>'tmp/','TIME'=>1479206340.1602981,'TZ'=>'Europe/Berlin','UI'=>'./','UNLOAD'=>NULL,'UPLOADS'=>'./','URI'=>'/receipt/36098','VERB'=>'GET','VERSION'=>'3.5.1-Release','XFRAME'=>'SAMEORIGIN','GET'=>array(),'POST'=>array(),'COOKIE'=>array(),'REQUEST'=>array(),'SESSION'=>array(),'FILES'=>array(),'SERVER'=>array('REDIRECT_HTTPS'=>'on','REDIRECT_SSL_TLS_SNI'=>'soutien.laquadrature.net','REDIRECT_STATUS'=>'200','HTTP_AUTHORIZATION'=>'','HTTPS'=>'on','SSL_TLS_SNI'=>'soutien.laquadrature.net','HTTP_HOST'=>'soutien.laquadrature.net','HTTP_USER_AGENT'=>'Mozilla/5.0 (X11; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','HTTP_ACCEPT'=>'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8','HTTP_ACCEPT_LANGUAGE'=>'fr-FR','HTTP_ACCEPT_ENCODING'=>'gzip, deflate, br','HTTP_REFERER'=>'https://soutien.laquadrature.net/perso','HTTP_COOKIE'=>'MON_COOKIE; PHPSESSID=MON_SID','HTTP_DNT'=>'1','HTTP_CONNECTION'=>'keep-alive','HTTP_UPGRADE_INSECURE_REQUESTS'=>'1','PATH'=>'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin','SERVER_SIGNATURE'=>'<address>Apache/2.4.10 (Debian) Server at soutien.laquadrature.net Port 443</address>
','SERVER_SOFTWARE'=>'Apache/2.4.10 (Debian)','SERVER_NAME'=>'soutien.laquadrature.net','SERVER_ADDR'=>'2a00:99a0:0:1000::4','SERVER_PORT'=>'443','REMOTE_ADDR'=>'MON_IP','DOCUMENT_ROOT'=>'/srv/soutien/soutien','REQUEST_SCHEME'=>'https','CONTEXT_PREFIX'=>'','CONTEXT_DOCUMENT_ROOT'=>'/srv/soutien/soutien/','SERVER_ADMIN'=>'[no address given]','SCRIPT_FILENAME'=>'/srv/soutien/soutien/index.php','REMOTE_PORT'=>'32898','REDIRECT_URL'=>'/receipt/36098','GATEWAY_INTERFACE'=>'CGI/1.1','SERVER_PROTOCOL'=>'HTTP/1.1','REQUEST_METHOD'=>'GET','QUERY_STRING'=>'','REQUEST_URI'=>'/receipt/36098','SCRIPT_NAME'=>'/index.php','PHP_SELF'=>'/index.php','REQUEST_TIME_FLOAT'=>1479206340.1570001,'REQUEST_TIME'=>1479206340),'ENV'=>array()),'languages'=>array('en'),'fallback'=>'en')),array(0=>'/receipt/36098','id'=>'36098')),'beforeroute,afterroute')
[index.php:17] Base->run()