Query error (1062) Duplicate entry '6ecc29a511a5a37cb48528c25b287c3ff2c7d0f3' for key 'PRIMARY'
Line: 159
File: /var/www/vhosts/stelledoppie.it/web/include/dbi.inc.php
Executing script: /var/www/vhosts/stelledoppie.it/web/skysafari.php
Query: INSERT INTO sessioni (id,valori,datains) VALUES ('6ecc29a511a5a37cb48528c25b287c3ff2c7d0f3','a:2:{s:11:\"REMOTE_ADDR\";s:13:\"3.144.193.129\";s:5:\"trace\";a:1:{i:0;a:3:{s:4:\"page\";s:14:\"/skysafari.php\";s:4:\"date\";i:1714645163;s:3:\"GET\";a:5:{s:7:\"orderby\";s:12:\"discov#_DESC\";s:6:\"limite\";s:3:\"600\";s:5:\"righe\";s:2:\"50\";s:4:\"type\";s:1:\"4\";s:6:\"azione\";s:19:\"export_to_skysafari\";}}}}',NOW())
Backtrace: Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/stelledoppie.it/web/include/session.inc.php
            [line] => 73
            [function] => dbquery
            [args] => Array
                (
                    [0] => INSERT INTO sessioni (id,valori,datains) VALUES ('6ecc29a511a5a37cb48528c25b287c3ff2c7d0f3','a:2:{s:11:\"REMOTE_ADDR\";s:13:\"3.144.193.129\";s:5:\"trace\";a:1:{i:0;a:3:{s:4:\"page\";s:14:\"/skysafari.php\";s:4:\"date\";i:1714645163;s:3:\"GET\";a:5:{s:7:\"orderby\";s:12:\"discov#_DESC\";s:6:\"limite\";s:3:\"600\";s:5:\"righe\";s:2:\"50\";s:4:\"type\";s:1:\"4\";s:6:\"azione\";s:19:\"export_to_skysafari\";}}}}',NOW())
                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/stelledoppie.it/web/include/webengine.inc.php
            [line] => 49
            [function] => ses_start
            [class] => my_session
            [object] => my_session Object
                (
                    [id] => 6ecc29a511a5a37cb48528c25b287c3ff2c7d0f3
                    [sessid] => SESSID
                    [expire] => 240
                    [newses] => 1
                    [values] => Array
                        (
                            [REMOTE_ADDR] => 3.144.193.129
                            [trace] => Array
                                (
                                    [0] => Array
                                        (
                                            [page] => /skysafari.php
                                            [date] => 1714645163
                                            [GET] => Array
                                                (
                                                    [orderby] => discov#_DESC
                                                    [limite] => 600
                                                    [righe] => 50
                                                    [type] => 4
                                                    [azione] => export_to_skysafari
                                                )

                                        )

                                )

                        )

                )

            [type] => ->
            [args] => Array
                (
                )

        )

    [2] => Array
        (
            [file] => /var/www/vhosts/stelledoppie.it/web/skysafari.php
            [line] => 15
            [args] => Array
                (
                    [0] => /var/www/vhosts/stelledoppie.it/web/include/webengine.inc.php
                )

            [function] => include_once
        )

)

Query error (1054) Unknown column 'discov#' in 'order clause'
Line: 159
File: /var/www/vhosts/stelledoppie.it/web/include/dbi.inc.php
Executing script: /var/www/vhosts/stelledoppie.it/web/skysafari.php
Query: SELECT 
		cat_wds.id,
		REPLACE(cat_wds.name,' ',' ') name,cat_wds.cst cst,cat_wds.SAO,
CONCAT_WS(' ',LEFT(cat_wds.coord_arcsec_2000,2),MID(cat_wds.coord_arcsec_2000,3,2),LPAD(ROUND(MID(cat_wds.coord_arcsec_2000,5,5)),2,'0'),
MID(cat_wds.coord_arcsec_2000,10,3),MID(cat_wds.coord_arcsec_2000,13,2),LPAD(ROUND(MID(cat_wds.coord_arcsec_2000,15,4)),2,'0')
) coord,
		REPLACE(cat_wds.wds_name,' ',' ') wds_name,date_last last,obs,
-- CAST(floor(round(calc_pa,0)) AS UNSIGNED INTEGER) pa,ROUND(calc_sep,1) sep,
pa_last pa,sep_last sep,
ROUND(mag_pri,2) mag1,ROUND(mag_sec,2) mag2,ROUND(calc_delta_mag,2) d_mag,cat_wds.orbit orb
,calc_popolari.ultima_visita,hits FROM calc_popolari LEFT JOIN cat_wds ON calc_popolari.iddoppia = cat_wds.id LEFT JOIN calc_wds_other ON cat_wds.id=calc_wds_other.iddoppia WHERE cat_wds.id IS NOT NULL ORDER BY `discov#` DESC
Backtrace: Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/stelledoppie.it/web/skysafari.php
            [line] => 59
            [function] => dbquery
            [args] => Array
                (
                    [0] => SELECT 
		cat_wds.id,
		REPLACE(cat_wds.name,' ',' ') name,cat_wds.cst cst,cat_wds.SAO,
CONCAT_WS(' ',LEFT(cat_wds.coord_arcsec_2000,2),MID(cat_wds.coord_arcsec_2000,3,2),LPAD(ROUND(MID(cat_wds.coord_arcsec_2000,5,5)),2,'0'),
MID(cat_wds.coord_arcsec_2000,10,3),MID(cat_wds.coord_arcsec_2000,13,2),LPAD(ROUND(MID(cat_wds.coord_arcsec_2000,15,4)),2,'0')
) coord,
		REPLACE(cat_wds.wds_name,' ',' ') wds_name,date_last last,obs,
-- CAST(floor(round(calc_pa,0)) AS UNSIGNED INTEGER) pa,ROUND(calc_sep,1) sep,
pa_last pa,sep_last sep,
ROUND(mag_pri,2) mag1,ROUND(mag_sec,2) mag2,ROUND(calc_delta_mag,2) d_mag,cat_wds.orbit orb
,calc_popolari.ultima_visita,hits FROM calc_popolari LEFT JOIN cat_wds ON calc_popolari.iddoppia = cat_wds.id LEFT JOIN calc_wds_other ON cat_wds.id=calc_wds_other.iddoppia WHERE cat_wds.id IS NOT NULL ORDER BY `discov#` DESC
                    [1] => 1
                )

        )

)