Questa Query ha dato errore :
" SELECT SA.* , SAF.immagine as fotoprinc,
( SELECT count(SAF.immagine) FROM scheda_auto_foto SAF WHERE SAF.idauto = SA.idauto AND SAF.visibile = '1' AND princ = '0' ) as totfoto,
( SELECT GROUP_CONCAT(SAF.immagine ORDER BY SAF.ordine ASC ) FROM scheda_auto_foto SAF WHERE SAF.idauto = SA.idauto AND SAF.visibile = '1' AND SAF.princ = '0' ) as altreimg,
( SELECT GROUP_CONCAT(SAO.optional ORDER BY SAO.ordine ASC ) FROM scheda_auto_optional SAO WHERE SAO.idauto = SA.idauto ) as optional
FROM scheda_auto SA
LEFT JOIN scheda_auto_foto SAF ON SAF.idauto = SA.idauto AND SAF.princ = '1'
WHERE SA.visibile = '1' AND SA.idstato > 0 AND SA.prezzo > 0 AND SA.tipologia_vendita = 'Usato' ORDER BY SA.prezzo ASC "
Errore:
Disk full (/tmp/#sql_132cfb_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")Array
(
[0] => Array
(
[file] => /var/www/clients/client1/web23/web/php/classi/mysql.inc.php
[line] => 204
[function] => debugquery
[class] => DB
[object] => DB Object
(
[fDb_host] => localhost
[fDb_user] => larinimysql
[fDb_password] => sddmJcTZL@D5
[fDb_name] => dedolarini
[fDb] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1021
[error] => Disk full (/tmp/#sql_132cfb_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
[error_list] => Array
(
[0] => Array
(
[errno] => 1021
[sqlstate] => HY000
[error] => Disk full (/tmp/#sql_132cfb_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
)
)
[field_count] => 45
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.3.37-MariaDB-0ubuntu0.20.04.1
[server_version] => 100337
[sqlstate] => HY000
[protocol_version] => 10
[thread_id] => 6544450
[warning_count] => 0
)
[fResult] =>
[fRow] =>
[fTimeLastQuery] => 1685888611.3014
)
[type] => ->
[args] => Array
(
[0] => SELECT SA.* , SAF.immagine as fotoprinc,
( SELECT count(SAF.immagine) FROM scheda_auto_foto SAF WHERE SAF.idauto = SA.idauto AND SAF.visibile = '1' AND princ = '0' ) as totfoto,
( SELECT GROUP_CONCAT(SAF.immagine ORDER BY SAF.ordine ASC ) FROM scheda_auto_foto SAF WHERE SAF.idauto = SA.idauto AND SAF.visibile = '1' AND SAF.princ = '0' ) as altreimg,
( SELECT GROUP_CONCAT(SAO.optional ORDER BY SAO.ordine ASC ) FROM scheda_auto_optional SAO WHERE SAO.idauto = SA.idauto ) as optional
FROM scheda_auto SA
LEFT JOIN scheda_auto_foto SAF ON SAF.idauto = SA.idauto AND SAF.princ = '1'
WHERE SA.visibile = '1' AND SA.idstato > 0 AND SA.prezzo > 0 AND SA.tipologia_vendita = 'Usato' ORDER BY SA.prezzo ASC
)
)
[1] => Array
(
[file] => /var/www/clients/client1/web23/web/web/template/usato_ajax.inc.php
[line] => 173
[function] => query
[class] => DB
[object] => DB Object
(
[fDb_host] => localhost
[fDb_user] => larinimysql
[fDb_password] => sddmJcTZL@D5
[fDb_name] => dedolarini
[fDb] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1021
[error] => Disk full (/tmp/#sql_132cfb_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
[error_list] => Array
(
[0] => Array
(
[errno] => 1021
[sqlstate] => HY000
[error] => Disk full (/tmp/#sql_132cfb_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
)
)
[field_count] => 45
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.3.37-MariaDB-0ubuntu0.20.04.1
[server_version] => 100337
[sqlstate] => HY000
[protocol_version] => 10
[thread_id] => 6544450
[warning_count] => 0
)
[fResult] =>
[fRow] =>
[fTimeLastQuery] => 1685888611.3014
)
[type] => ->
[args] => Array
(
[0] => SELECT SA.* , SAF.immagine as fotoprinc,
( SELECT count(SAF.immagine) FROM scheda_auto_foto SAF WHERE SAF.idauto = SA.idauto AND SAF.visibile = '1' AND princ = '0' ) as totfoto,
( SELECT GROUP_CONCAT(SAF.immagine ORDER BY SAF.ordine ASC ) FROM scheda_auto_foto SAF WHERE SAF.idauto = SA.idauto AND SAF.visibile = '1' AND SAF.princ = '0' ) as altreimg,
( SELECT GROUP_CONCAT(SAO.optional ORDER BY SAO.ordine ASC ) FROM scheda_auto_optional SAO WHERE SAO.idauto = SA.idauto ) as optional
FROM scheda_auto SA
LEFT JOIN scheda_auto_foto SAF ON SAF.idauto = SA.idauto AND SAF.princ = '1'
WHERE SA.visibile = '1' AND SA.idstato > 0 AND SA.prezzo > 0 AND SA.tipologia_vendita = 'Usato' ORDER BY SA.prezzo ASC
[1] => 0
)
)
[2] => Array
(
[file] => /var/www/clients/client1/web23/web/web/template/usato.inc.php
[line] => 4
[args] => Array
(
[0] => /var/www/clients/client1/web23/web/web/template/usato_ajax.inc.php
)
[function] => include
)
[3] => Array
(
[file] => /var/www/clients/client1/web23/web/web/php/funzioni.inc.php
[line] => 183
[args] => Array
(
[0] => /var/www/clients/client1/web23/web/web/template/usato.inc.php
)
[function] => include
)
[4] => Array
(
[file] => /var/www/clients/client1/web23/web/web/php/funzioni.inc.php
[line] => 232
[function] => testo_con_template
[args] => Array
(
[0] => 104
[1] => ITA
[2] => Array
(
[0] => 104
[idpagina] => 104
[1] => 0
[idgruppo] => 0
[2] => Usato
[nome] => Usato
[3] =>
[testo] =>
[4] =>
[url] =>
[5] =>
[urldove] =>
[6] =>
[anteprima] =>
[7] => 0
[ordine] => 0
[8] => ITA
[lingua] => ITA
[9] => usato
[seo_url] => usato
[10] => Usato
[seo_tit] => Usato
[11] => Usato
[seo_des] => Usato
[12] => Usato
[seo_key] => Usato
[13] => 0
[padre] => 0
[14] => 1
[idmenu] => 1
[15] => 1
[visibile] => 1
[16] => 0
[principale] => 0
[17] => 0
[paginavuota] => 0
[18] => usato
[template] => usato
[19] => null
[parametri] => null
)
)
)
[5] => Array
(
[file] => /var/www/clients/client1/web23/web/web/index.php
[line] => 104
[function] => testo_con_pagine
[args] => Array
(
[0] => 104
[1] => 1
[2] => ITA
[3] => Array
(
[0] => 104
[idpagina] => 104
[1] => 0
[idgruppo] => 0
[2] => Usato
[nome] => Usato
[3] =>
[testo] =>
[4] =>
[url] => https://www.larini.com/ita/usato/
[5] =>
[urldove] =>
[6] =>
[anteprima] =>
[7] => 0
[ordine] => 0
[8] => ITA
[lingua] => ITA
[9] => usato
[seo_url] => usato
[10] => Usato
[seo_tit] => Usato
[11] => Usato
[seo_des] => Usato
[12] => Usato
[seo_key] => Usato
[13] => 0
[padre] => 0
[14] => 1
[idmenu] => 1
[15] => 1
[visibile] => 1
[16] => 0
[principale] => 0
[17] => 0
[paginavuota] => 0
[18] => usato
[template] => usato
[19] => null
[parametri] => null
)
)
)
[6] => Array
(
[file] => /var/www/clients/client1/web23/web/index.php
[line] => 2
[args] => Array
(
[0] => /var/www/clients/client1/web23/web/web/index.php
)
[function] => include
)
)