Warning: mysqli::query(): (HY000/1): Can't create/write to file '/tmp/#sql-temptable-1-4a47c18-4255a.MAI' (Errcode: 28 "No space left on device") in /app/etaamb/classes/connector.class.php on line 100
QUERY ERROR
**********
SQL: select SQL_CACHE
docs.numac as numac,
docs.anonymise as anon,
titles.raw as title_raw,
titles.pure as title_pure,
source_fr as source,
type_fr as type,
docs.chrono_id as chrono_id,
docs.senate_id as senate_id,
docs.senate_leg as senate_leg,
docs.chamber_id as chamber_id,
docs.chamber_leg as chamber_leg,
DATE_FORMAT(pub_date, '%Y%m%d') as pub_date,
DATE_FORMAT(prom_date, '%Y%m%d') as prom_date
FROM `docs`
join titles on docs.numac = titles.numac
join sources on docs.source = sources.id
join types on docs.type = types.id where docs.numac in (1997002238, 1997021409, 1997022191, 1997022376, 1997022506, 1997022561, 1997022562, 1997022616, 1997022740, 1997022805, 1997022806, 1997022807, 1997022839, 1997022863, 1997022864, 1997022872, 1997022917, 1997022994, 1997029415, 1998009722, 1998021087, 1998022012, 1998022014, 1998022031, 1998022075, 1998022154, 1998022429, 1998022487, 1998022532, 1998022565, 1998022566, 1998022567, 1998022661, 1998022678, 1998022750, 1998022751, 1998022759, 1998022860, 1998022861, 1999011467, 1999021319, 1999022009, 1999022010, 1999022011, 1999022012, 1999022013, 1999022131, 1999022132, 1999022177, 1999022235, 1999022237, 1999022270, 1999022337, 1999022496, 1999022500, 1999022523, 1999022524, 1999022650, 1999022681, 1999022684, 1999022702, 1999022726, 1999022760, 1999022761, 1999022762, 1999022796, 1999022797, 1999022798, 1999022918, 1999024036, 1999024037, 1999024074, 1999024121, 1999024122, 1999033088, 2000003481, 2000003530, 2000011098, 2000011391, 2000011392, 2000016161, 2000016162, 2000022010, 2000022045, 2000022085, 2000022108, 2000022248, 2000022274, 2000022307, 2000022337, 2000022383, 2000022472, 2000022506, 2000022530, 2000022578, 2000022581, 2000022582, 2000022624, 2000022649, 2000022655, 2000022682, 2000022683, 2000022690, 2000022733, 2000022768, 2000022769, 2000022770, 2000022807, 2000022813, 2000022830, 2000022831, 2000022844, 2000022858, 2000022865, 2000022902, 2000022905, 2001003354, 2001022010, 2001022011, 2001022012, 2001022023, 2001022026, 2001022040, 2001022060, 2001022070, 2001022071, 2001022084, 2001022097, 2001022098, 2001022135, 2001022136, 2001022157, 2001022161, 2001022190, 2001022259, 2001022263, 2001022295, 2001022300, 2001022420, 2001022422, 2001022495, 2001022496, 2001022550, 2001022579, 2001022610, 2001022627, 2001022628, 2001022629, 2001022643, 2001022647, 2001022666, 2001022667, 2001022668, 2001022693, 2001022774, 2001022812, 2001022854, 2001022875, 2001022939, 2001022995, 2001029528, 2002011255, 2002011256, 2002011293, 2002022004, 2002022124, 2002022135, 2002022136, 2002022139, 2002022178, 2002022214, 2002022215, 2002022216, 2002022217, 2002022287, 2002022293, 2002022305, 2002022306, 2002022424, 2002022455, 2002022456, 2002022457, 2002022509, 2002022533, 2002022552, 2002022597, 2002022638, 2002022639, 2002022686, 2002022690, 2002022710, 2002022711, 2002022712, 2002022713, 2002022782, 2002022795, 2002022816, 2002022858, 2002022869, 2002022870, 2002022880, 2002022889, 2002022915, 2002023006, 2002023094, 2003003399, 2003009088, 2003022114, 2003022138, 2003022139, 2003022208, 2003022209, 2003022220, 2003022328, 2003022417, 2003022431, 2003022483, 2003022553, 2003022554, 2003022650, 2003022681, 2003022721, 2003022731, 2003022761, 2003022775, 2003022785, 2003022786, 2003022864, 2003022906, 2003022961, 2003023051, 2003023054, 2003023086, 2003023114, 2003200648, 2004002049, 2004022124, 2004022125, 2004022130, 2004022203, 2004022295, 2004022298, 2004022318, 2004022341, 2004022373, 2004022506, 2004022580, 2004022621, 2004022627, 2004022628, 2004022704, 2004022875, 2004022960, 2004022961, 2004022962, 2004022963, 2004023002, 2004035537, 2004200018, 2005022126, 2005022132, 2005022133, 2005022154, 2005022189, 2005022203, 2005022237, 2005022249, 2005022392, 2005022444, 2005022532, 2005022734, 2005022755, 2005022756, 2005022781, 2005022866, 2005022868, 2005023047, 2005023050, 2005023056, 2006022123, 2006022212, 2006022213, 2006022244, 2006022256, 2006022289, 2006022297, 2006022338, 2006022353, 2006022369, 2006022448, 2006022507, 2006022594, 2006022682, 2006022701, 2006022793, 2006022806, 2006022888, 2006022945, 2006023153, 2006023173, 2006023231, 2006023265, 2006023281, 2006023298, 2007011370, 2007021149, 2007022010, 2007022210, 2007022273, 2007022320, 2007022478, 2007022662, 2007023174, 2007023330, 2007023568, 2008018233, 2008018258, 2008018261, 2008018276, 2008018308, 2008018324, 2008018325, 2008018374, 2008018385, 2008018389, 2008018398, 2008018406, 2008022023, 2008022037, 2008022054, 2008022090, 2008022185, 2008022190, 2008022301, 2008022539, 2008024014, 2008024015, 2008024016, 2008024199, 2008024203, 2008202687, 2009018014, 2009018019, 2009018019, 2009018028, 2009018030, 2009018031, 2009018036, 2009018100, 2009018104, 2009018105, 2009018116, 2009018117, 2009018151, 2009018152, 2009018188, 2009018190, 2009018199, 2009018200, 2009018228, 2009018244, 2009018286, 2009018304, 2009018307, 2009018314, 2009018330, 2009018340, 2009018344, 2009018345, 2009018357, 2009018422, 2009018424, 2009018466, 2009018472, 2009018491, 2009018499, 2009018536, 2009018537, 2009022624, 2009022625, 2009024403, 2009024465, 2009205405, 2010011136, 2010018024, 2010018041, 2010018081, 2010018087, 2010018120, 2010018123, 2010018142, 2010018150, 2010018165, 2010018169, 2010018170, 2010018177, 2010018182, 2010018213, 2010018284, 2010018303, 2010018332, 2010018371, 2010018376, 2010018397, 2010018398, 2010018408, 2010018420, 2010018426, 2010022049, 2010022291, 2010202994, 2010202994, 2010203069, 2010203069, 2011011015, 2011011016, 2011018019, 2011018019, 2011018023, 2011018023, 2011018050, 2011018050, 2011018075, 2011018075, 2011018080, 2011018114, 2011018114, 2011018123, 2011018123, 2011018153, 2011018153, 2011018181, 2011018181, 2011018235, 2011018235, 2011018262, 2011018262, 2011018318, 2011018318, 2011018344, 2011018344, 2011018380, 2011018380, 2011018381, 2011018381, 2011018397, 2011018412, 2011018412, 2012018003, 2012018003, 2012018007, 2012018007, 2012018022, 2012018022, 2012018030, 2012018030, 2012018058, 2012018058, 2012018068, 2012018068, 2012018069, 2012018069, 2012018170, 2012018170, 2012018324, 2012018324, 2012018326, 2012018326, 2012018348, 2012018348, 2012018352, 2012018352, 2012018369, 2012018369, 2012018406, 2012018406, 2012018430, 2012018430, 2012018437, 2012018437, 2012018460, 2012018460, 2012018482, 2012018482, 2012024282, 2012024282, 2012031159, 2012031159, 2012035464, 2012201681, 2012201681, 2012206774, 2012206774, 2013000101, 2013011190, 2013011295, 2013011333, 2013011333, 2013011334, 2013011334, 2013018014, 2013018014, 2013018016, 2013018016, 2013018022, 2013018022, 2013018133, 2013018133, 2013018180, 2013018180, 2013018198, 2013018198, 2013018222, 2013018222, 2013018231, 2013018231, 2013018270, 2013018270, 2013018278, 2013018290, 2013018290, 2013018293, 2013018293, 2013018351, 2013018351, 2013018353, 2013018353, 2013018391, 2013018395, 2013018395, 2013018410, 2013018410, 2013018431, 2013018431, 2013018460, 2013018460, 2013018480, 2013018480, 2013018506, 2013018506, 2013022328, 2013022328, 2013022603, 2013022603, 2013024113, 2013024422, 2013029130, 2013204390, 2014011019, 2014011019, 2014011217, 2014011217, 2014011283, 2014011298, 2014011411, 2014011411, 2014018088, 2014018088, 2014018098, 2014018098, 2014018141, 2014018141, 2014018157, 2014018157, 2014018158, 2014018158, 2014018178, 2014018178, 2014018179, 2014018179, 2014018206, 2014018206, 2014018224, 2014018241, 2014018241, 2014018250, 2014018250, 2014018266, 2014018266, 2014018410, 2014018410, 2014018457, 2014018457, 2014022066, 2014022066, 2014022288, 2014022292, 2014024066, 2014024066, 2014024167, 2014024209, 2014024209, 2014203009, 2014203890, 2014205149, 2014205149, 2015018017, 2015018017, 2015018037, 2015018037, 2015018059, 2015018059, 2015018065, 2015018077, 2015018077, 2015018093, 2015018093, 2015018125, 2015018125, 2015018152, 2015018152, 2015018193, 2015018193, 2015018194, 2015018194, 2015018203, 2015018205, 2015018205, 2015018297, 2015018297, 2015018383, 2015018383, 2015018397, 2015018397, 2015018416, 2015018416, 2015022186, 2015022186, 2015024189, 2015029010, 2015202775, 2015202775, 2015203128, 2015204322, 2016011122, 2016018006, 2016018006, 2016018080, 2016018080, 2016018107, 2016018129, 2016018129, 2016018174, 2016018174, 2016018210, 2016018210, 2016018226, 2016018226, 2016018227, 2016018227, 2016018342, 2016018412, 2016018412, 2016018425, 2016018425, 2016024135, 2016024152, 2016024298, 2016201718, 2017011674, 2017011674, 2017011813, 2017011813, 2017011857, 2017011857, 2017012146, 2017012462, 2017012462, 2017012492, 2017012492, 2017012708, 2017012708, 2017013752, 2017020076, 2017020076, 2017020432, 2017020432, 2017030157, 2017031231, 2017031695, 2017031695, 2017031845, 2017031845, 2017031999, 2017031999, 2017032187, 2017032187, 2017032188, 2017032188, 2017032189, 2017032189, 2017040576, 2017040576, 2017040861, 2017040861, 2017205098, 2017207062, 2017207062, 2018010506, 2018010896, 2018011345, 2018011345, 2018011346, 2018011346, 2018011595, 2018011595, 2018011663, 2018011663, 2018011855, 2018011855, 2018012426, 2018012426, 2018012699, 2018012699, 2018012700, 2018012700, 2018012828, 2018012840, 2018012840, 2018013287, 2018013287, 2018013315, 2018013315, 2018013465, 2018013465, 2018013508, 2018013508, 2018014172, 2018014172, 2018014518, 2018014518, 2018014699, 2018015267, 2018015267, 2018015469, 2018015469, 2018015472, 2018015472, 2018030697, 2018030697, 2018030924, 2018031458, 2018031458, 2018031520, 2018032297, 2018032297, 2018032298, 2018032298, 2018040170, 2018040170, 2019010138, 2019010138, 2019010674, 2019010674, 2019011071, 2019011071, 2019012142, 2019012142, 2019012217, 2019012217, 2019012757, 2019012757, 2019013190, 2019013190, 2019013203, 2019013203, 2019015364, 2019015364, 2019015771, 2019015771, 2019015893, 2019015893, 2019030048, 2019030048, 2019030334, 2019030423, 2019030423, 2019030478, 2019030478, 2019040138, 2019040138, 2019040423, 2019040423, 2019040870, 2019041885, 2019041885, 2019042574, 2019042574, 2019042972, 2019042972, 2019203449, 2019203449, 2019203993, 2019203993, 2019205046, 2019205046, 2020015440, 2020015440, 2020015663, 2020015663, 2020016196, 2020016196, 2020020147, 2020020147, 2020020642, 2020020642, 2020020786, 2020020786, 2020030359, 2020030359, 2020031082, 2020031082, 2020031222, 2020031222, 2020031223, 2020031223, 2020031519, 2020031519, 2020031520, 2020031520, 2020031582, 2020040006, 2020040006, 2020040171, 2020040171, 2020040448, 2020040448, 2020040686, 2020040686, 2020040747, 2020040747, 2020040773, 2020040773, 2020041033, 2020041033, 2020041557, 2020041557, 2020041569, 2020041569, 2020041939, 2020041939, 2020042225, 2020042225, 2020043770, 2020043770, 2020043948, 2020043948, 2020044069, 2020044069, 2020044633, 2020044633, 2020202638, 2020202638, 2020203548, 2020203548, 2020204087, 2020204087, 2020205675, 2020205675, 2021020334, 2021020334, 2021020589, 2021020589, 2021021176, 2021021176, 2021022603, 2021022604, 2021022605, 2021022606, 2021022720, 2021022720, 2021022761, 2021022761, 2021030071, 2021030933, 2021030933, 2021030981, 2021030981, 2021031027, 2021031027, 2021031223, 2021031223, 2021031373, 2021031373, 2021031996, 2021032380, 2021032380, 2021032678, 2021032678, 2021032731, 2021032731, 2021032776, 2021032776, 2021033298, 2021033298, 2021033299, 2021033299, 2021033399, 2021033399, 2021040103, 2021040103, 2021040609, 2021040846, 2021040846, 2021040993, 2021040993, 2021041114, 2021041342, 2021041342, 2021041524, 2021041524, 2021041996, 2021041996, 2021042204, 2021042976, 2021042976, 2021043498, 2021043530, 2021043530, 2021043531, 2021043531, 2021043539, 2021043539, 2021043578, 2021043578, 2021203014, 2021203014, 2021203412, 2022015077, 2022015077, 2022015097, 2022015097, 2022015123, 2022015123, 2022020527, 2022020527, 2022020639, 2022020639, 2022020640, 2022020640, 2022030813, 2022030813, 2022030887, 2022030887, 2022031969, 2022031969, 2022032171, 2022032231, 2022032231, 2022032373, 2022032373, 2022032378, 2022032378, 2022032523, 2022032523, 2022032794, 2022032794, 2022032880, 2022032880, 2022033242, 2022033242, 2022033599, 2022033599, 2022033876, 2022033876, 2022034738, 2022034738, 2022034767, 2022034767, 2022041002, 2022041002, 2022041755, 2022041755, 2022041788, 2022041788, 2022042154, 2022042154, 2022042451, 2022042451, 2022042757, 2022043170, 2022043170, 2022043208, 2022043208, 2022044059, 2022044059, 2023015361, 2023015361, 2023030421, 2023030421, 2023030422, 2023030422, 2023030728, 2023030728, 2023030733, 2023030733, 2023040619, 2023040619, 2023040620, 2023040620, 2023040621, 2023040621, 2023040622, 2023040622, 2023040623, 2023040623, 2023040624, 2023040624, 2023040722, 2023040722, 2023041015, 2023041015, 2023041226, 2023041226, 2023041270, 2023041270, 2023041371, 2023041371, 2023041668, 2023041668, 2023042040, 2023042040, 2023042171, 2023042171, 2023042547, 2023042547, 2023042716, 2023042716, 2023042867, 2023042867, 2023043077, 2023043077, 2023043471, 2023043662, 2023043662, 2023043670, 2023043670, 2023043768, 2023043768, 2023043803, 2023043803, 2023043809, 2023043809, 2023043821, 2023043821, 2023043822, 2023043822, 2023043843, 2023043858, 2023043858, 2023043868, 2023043868, 2023044057, 2023044057, 2023044060, 2023044060, 2023044061, 2023044061, 2023044230, 2023044230, 2023045111, 2023045111, 2023045112, 2023045112, 2023045282, 2023045282, 2023045367, 2023045367, 2023045415, 2023045415, 2023045416, 2023045416, 2023045417, 2023045417, 2023045550, 2023045550, 2023047069, 2023047069, 2023047474, 2023047474, 2023047613, 2023047613, 2023047697, 2023047697, 2023047699, 2023047699, 2023047702, 2023047702, 2023047724, 2023047724, 2023047886, 2023047886, 2023048148, 2023048148, 2023048271, 2023048271, 2023048415, 2023048415, 2023048416, 2023048416, 2023048461, 2023048461, 2023048706, 2023048706, 2024000628, 2024000628, 2024001021, 2024001021, 2024001343, 2024001343, 2024001917, 2024001917, 2024002184, 2024002263, 2024002263, 2024003117, 2024003117, 2024003138, 2024003138, 2024003513, 2024004195, 2024004195, 2024004567, 2024004567, 2024004627, 2024004627, 2024004669, 2024004669, 2024004884, 2024004884, 2024005087, 2024005502, 2024005502, 2024006269, 2024006269, 2024006454, 2024006454, 2024006531, 2024006531, 2024007260, 2024007260, 2024007353, 2024007353, 2024007412, 2024007412, 2024007413, 2024007413, 2024007540, 2024007546, 2024007546, 2024007870, 2024007870, 2024007871, 2024007871, 2024008240, 2024008240, 2024008247, 2024008247, 2024008248, 2024008248, 2024008249, 2024008249, 2024008472, 2024008472, 2024008607, 2024008607, 2024009219, 2024009219, 2024009398, 2024009398, 2024009399, 2024009399, 2024009687, 2024009687, 2024009944, 2024009944, 2024009945, 2024009945, 2024010096, 2024010096, 2024010778, 2024010778, 2024010779, 2024010779, 2024010781, 2024010781, 2024010782, 2024010782, 2024011444, 2024011444, 2024011570, 2024011829, 2024011829, 2025000773, 2025000773, 2025001562, 2025001630, 2025001630, 2025001701, 2025001701, 2025001841, 2025001841, 2025001857, 2025001857, 2025001948, 2025001948, 2025002050, 2025002050, 2025002253, 2025002253) and titles.ln = 'fr' order by types.ord ASC
ERROR: Can't create/write to file '/tmp/#sql-temptable-1-4a47c18-4255a.MAI' (Errcode: 28 "No space left on device")
Fatal error: Uncaught Exception: 15424 in /app/etaamb/classes/connector.class.php:110
Stack trace:
#0 /app/etaamb/classes/collection.class.php(245): connector_class->query()
#1 /app/etaamb/classes/numac.class.php(893): collection_class->docsMeta()
#2 /app/etaamb/classes/numac.class.php(829): numac->reverseDocs_List()
#3 /app/etaamb/classes/numac.class.php(267): numac->reverseDocs()
#4 /app/etaamb/index.php(230): numac->main()
#5 {main}
thrown in /app/etaamb/classes/connector.class.php on line 110