Problems with sorting serverside

Dear sirs

I tried to enable sorting on serverside. He starts but does not sort.
What i have to do?
Code:

Grid[1] = new dhtmlXGridObject('gridbox');
Grid[1].setImagePath("../dhtmlx/Grid/codebase/imgs/");
Grid[1].setHeader("WO<br>Intern,WO<br>UM,KDNR");
Grid[1].attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter");
Grid[1].setInitWidths("60,55,70");
Grid[1].setColAlign("center,center,center");
Grid[1].setColTypes("ro,ro,ro");
Grid[1].setColumnColor("#FFC,#FFC,#FFC");
Grid[1].enableTooltips("false,false,false");
Grid[1].setColSorting("connector,connector,connector");
Grid[1].enableRowsHover(true, 'grid_hover'); 
Grid[1].attachEvent("onXLS", function() {document.getElementById('loading').style.display = 'block';});
Grid[1].attachEvent("onXLE", function() {document.getElementById('loading').style.display = 'none';});
Grid[1].attachEvent("onEditCell", function(stage,rId,cInd,nValue,oValue){ 
   if (stage == 0 && (cInd == 1 || cInd == 3)) { return false; } 
});
Grid[1].setSkin("clear");
Grid[1].enableMultiline(true);
Grid[1].enablePaging(true, 90, 10, "paging", true);
Grid[1].setPagingSkin("toolbar", "dhx_skyblue");
Grid[1].init();
Grid[1].enableHeaderMenu();
Grid[1].splitAt(3);
Grid[1].enableAlterCss("rows_even", "rows_uneven");
Grid[1].load("../dhtmlx/Data/XML/connector.php?id=7&jahr=<?php echo $jahr; ?>");

Thank you in advance

Best regards
Oliver

Unfortunately the issue cannot be reconstructed locally.
Please, provide a demo link where the issue can be reconstructed or a server-side code.

Hello sematik

I wrote you a link to a page as PM.
Here is serverside code too:

<?php
   require('../../Connector/grid_config.php');
   require('../../Connector/grid_connector.php');
   require('../../Connector/convert.php');
   include ('../SQL/config.php');
      
   $user = $_COOKIE["Benutzer"];
   
   $res  = mysql_connect($mysql_host, $mysql_user, $mysql_pasw);
   mysql_select_db($mysql_db);
     
   $grid = new GridConnector($res, "MySQL");

if($_GET['id'] == "7") { 
   $disponent = new OptionsConnector($res);
   $disponent->render_sql("SELECT id AS value, ma_nachname AS label FROM sk_mitarbeiter WHERE (ma_job = 3 OR ma_job = 99) and ma_x = 0 ORDER BY label ASC","id","id(value),label(label)");
   
   $techniker = new OptionsConnector($res);
   $techniker->render_sql("SELECT id AS value, ma_nachname AS label FROM sk_mitarbeiter WHERE (ma_job = 4 OR ma_job = 99) and ma_x = 0 ORDER BY label ASC","id","id(value),label(label)");
   
   $abt = new OptionsConnector($res);
   $abt->render_sql("SELECT id AS value, abteilung AS label FROM sk_abteilung","id","id(value),label(label)");
   
   $kst = new OptionsConnector($res);
   $kst->render_sql("SELECT id AS value, sub_name AS label FROM sk_subunternehmer","id","id(value),label(label)");
   
   $abbruch = new OptionsConnector($res);
   $abbruch->render_sql("SELECT id AS value, abbruch_text AS label FROM sk_abbruch ORDER BY id ASC","id","id(value),label(label)");
   
   $storno = new OptionsConnector($res);
   $storno->render_sql("SELECT id AS value, storno_text AS label FROM sk_storno ORDER BY id ASC","id","id(value),label(label)");
   
   $foti = new OptionsConnector($res);
   $foti->render_sql("SELECT id AS value, ft_bez AS label FROM sk_folgeticket","id","id(value),label(label)");
   
   $gebiet = new OptionsConnector($res);
   $gebiet->render_sql("SELECT id AS value, sub_lager AS label FROM sk_subunternehmer","id","id(value),label(label)");
   
   $janein = new OptionsConnector($res);
   $janein->render_sql("SELECT jn_id AS value, jn_text AS label FROM sk_janein","jn_id","jn_id(value),label(label)");
   
   $grid->dynamic_loading(90);
   $grid->set_encoding("iso-8859-1");
   $grid->set_options("gesl_techniker", $techniker);
   $grid->set_options("gesl_disponent", $disponent);
   $grid->set_options("wo_stat", $janein);
   $grid->set_options("wartung", $janein);
   $grid->set_options("wo_abt", $abt);
   $grid->set_options("kst", $kst);
   $grid->set_options("wo_gebiet", $gebiet);
   $grid->set_options("abbruch_id", $abbruch);
   $grid->set_options("storno_id", $storno);
   $grid->set_options("storno2_id", $storno);
   $grid->set_options("folgeticket_id", $foti);
   $grid->attach->event("beforeFilter","custom_filter");
   $grid->render_sql("SELECT gesl_wonr, wonr_um, kdnr, Concat(LPAD(DayOfMonth(excel_date),2,'0'),'.',LPAD(Month(excel_date),2,'0'),'.',Year(excel_date),' ',LPAD(Hour(excel_date),2,'0'),':',LPAD(Minute(excel_date),2,'0')) AS 'excel_date', wo_typ, wo_abt, wo_stat, CASE wo_gebiet WHEN 0 THEN '' ELSE wo_gebiet END AS wo_gebiet, CASE gesl_techniker WHEN 0 THEN '' ELSE gesl_techniker END AS gesl_techniker, CASE gesl_disponent WHEN 0 THEN '' ELSE gesl_disponent END AS gesl_disponent, Concat(LPAD(DayOfMonth(gesl_termin),2,'0'),'.',LPAD(Month(gesl_termin),2,'0'),'.',Year(gesl_termin),' ',LPAD(Hour(gesl_termin),2,'0'),':',LPAD(Minute(gesl_termin),2,'0')) AS 'gesl_termin', Concat(LPAD(DayOfMonth(wo_start),2,'0'),'.',LPAD(Month(wo_start),2,'0'),'.',Year(wo_start),' ',LPAD(Hour(wo_start),2,'0'),':',LPAD(Minute(wo_start),2,'0')) AS 'wo_start', Concat(LPAD(DayOfMonth(wo_ende),2,'0'),'.',LPAD(Month(wo_ende),2,'0'),'.',Year(wo_ende),' ',LPAD(Hour(wo_ende),2,'0'),':',LPAD(Minute(wo_ende),2,'0')) AS 'wo_ende', Concat(LPAD(DayOfMonth(wo_done),2,'0'),'.',LPAD(Month(wo_done),2,'0'),'.',Year(wo_done),' ',LPAD(Hour(wo_done),2,'0'),':',LPAD(Minute(wo_done),2,'0')) AS 'wo_done', kw, CASE kst WHEN 0 THEN '' ELSE kst END AS kst, CASE abbruch_id WHEN 0 THEN '' ELSE abbruch_id END AS abbruch_id, CASE storno_id WHEN 0 THEN '' ELSE storno_id END AS storno_id, CASE storno2_id WHEN 0 THEN '' ELSE storno2_id END AS storno2_id, CASE folgeticket_id WHEN 0 THEN '' ELSE folgeticket_id END AS folgeticket_id, anlnr_intern, wartung, gesl_spin_gemeldet, gesl_spin_summe, adr_up, CONCAT(substring(kd_vorname,1,1),'. ',kd_nachname) AS name, kd_strasse, kd_hsnr, kd_hsnr_zus, kd_plz, kd_ort, gesl_arbeiten, gesl_memo, gesl_abbruch FROM sk_gesamtliste AS A INNER JOIN sk_auftraege AS B ON A.gesl_wonr = B.wonr_intern INNER JOIN sk_kundenstamm AS C ON A.gesl_kdnr = C.id WHERE B.gesamtliste = 1 AND YEAR(upload_date) = ".$_GET['jahr']." ORDER BY gesl_wonr DESC","gesl_id","gesl_wonr, wonr_um, kdnr, excel_date, wo_typ, wo_abt, wo_stat, wo_gebiet, gesl_techniker, gesl_disponent, gesl_termin, wo_start, wo_ende, wo_done, kw, kst, abbruch_id, storno_id, storno2_id, folgeticket_id, anlnr_intern, wartung, gesl_spin_gemeldet, gesl_spin_summe, adr_up, name, kd_strasse, kd_hsnr, kd_hsnr_zus, kd_plz, kd_ort, gesl_arbeiten, gesl_memo, gesl_abbruch");   
}

?>

Thank you