Ordina
Tipologia vendita
Marca
Modello
Anno immatricolazione
Alimentazione
Tutte le auto
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
        )

)