Grid data xml error. Please help ...

Hi,

Can’t understand to what that related . Error : This page contains the following errors:
error on line 1 at column 82: XML declaration allowed only at the start of the document
Below is a rendering of the page up to the first error.

Grid javascript code :

      var grd     = new Array();
      $app_lng    = document.getElementById( "myLang" ).options[ document.getElementById( "myLang" ).selectedIndex ].value;
      $app_db     = document.getElementById( "myDb" ).options[ document.getElementById( "myDb" ).selectedIndex ].value;

      // grid construction array 
      grd[  0 ] = [];
      grd[  0 ].push( "uzsak" );
      grd[  0 ].push( "ro" );
      grd[  0 ].push( "150" );
      grd[  0 ].push( "#connector_text_filter" );
      grd[  0 ].push( "left" );
      grd[  0 ].push( "connector" );
      grd[  0 ].push( "Užsak.ID" );
      grd[  0 ].push( "Order.ID" );

      grd[  1 ] = [];
      grd[  1 ].push( "telkinys"  );
      grd[  1 ].push( "ed" );
      grd[  1 ].push( "80" );
      grd[  1 ].push( "#connector_text_filter" );
      grd[  1 ].push( "left" );
      grd[  1 ].push( "connector" );
      grd[  1 ].push( "Telkinys" );
      grd[  1 ].push( "Pool" );
      // ... other cols ...
  
      grd[ 31 ] = [];
      grd[ 31 ].push( "pastabos_zs" );
      grd[ 31 ].push( "txt" );
      grd[ 31 ].push( "180" );
      grd[ 31 ].push( "#connector_text_filter" );
      grd[ 31 ].push( "left" );
      grd[ 31 ].push( "connector" );
      grd[ 31 ].push( "Pastabos Zarasu" );
      grd[ 31 ].push( "Notes of Zarasai" );

      grd[ 32 ] = [];
      grd[ 32 ].push( "pok_lap_mod" );
      grd[ 32 ].push( "ed" );
      grd[ 32 ].push( "150" );
      grd[ 32 ].push( "#connector_text_filter" );
      grd[ 32 ].push( "left" );
      grd[ 32 ].push( "connector" );
      grd[ 32 ].push( "Pokav.lapo modelis" );
      grd[ 32 ].push( "Pack.list model" );

      var dgr      = grid_array( "uzsakym" );
      var grd_set  = grid_set( "uzsakym", grd, dgr );
      var slc_fld  = grd_set[ 0 ];
      var u        = 0;
      var mod_col  = 2;
      var kiek_col = 3;
      var ch_ro    = new Array();
      var datw1    = new Array();
      var datw2    = new Array();
      var slc_arr  = slc_fld.split( "," );
      var cQry     = "uzs1.php?fld=" + slc_fld + "&d_b=" + $app_db;

      var toolbar = tabbar.cells( tabbar.getActiveTab() ).attachToolbar();
      toolbar.setIconsPath( "images/" );
      var newOpts =
      Array( Array( 'new1', 'obj', ( $app_lng == 'lt' ? 'Naujas(plius)' : 'New(add)' ) + " - Plus", 'New.png'),
      Array( 'new2', 'obj', ( $app_lng == 'lt' ? 'Pervesti' : 'Transfer' ) , 'Attachment.png' ),
      Array( 'sep1', 'sep', '', '' ),
      Array( 'new3', 'obj', ( $app_lng == 'lt' ? 'Sukirp.lapai' : 'Cutting pages' ), 'Pages.png' ) );
      toolbar.addButtonSelect( "new", 0, "", newOpts, "New.png" );
      toolbar.setItemToolTip( "new", ( $app_lng == 'lt' ? 'Nauji įrašai' : 'New records' ) );

      toolbar.addSeparator("sep2", 1);

      toolbar.addButton( "delete", 2, "", "Delete.png" );
      toolbar.setItemToolTip( "delete", ( $app_lng == 'lt' ? 'Šalinti' : 'Delete' ) + " - Del" );

      // ...  

      var mygrid = tabbar.cells( tabbar.getActiveTab() ).attachGrid();
      mygrid.setImagePath( "codebase/imgs/" );

      mygrid.setColumnIds( slc_fld )
      mygrid.setHeader( grd_set[ 1 ] );
      mygrid.attachHeader( grd_set[ 2 ] );
      mygrid.setColTypes( grd_set[ 3 ] );
      mygrid.setColSorting( grd_set[ 4 ] );
      mygrid.setInitWidths( grd_set[ 5 ] )
      mygrid.setColAlign( grd_set[ 6 ] )
      mygrid.setColumnsVisibility( grd_set[ 7 ] );
      mygrid.setDateFormat( "%Y.%m.%d" );

      mygrid.enableSmartRendering( true, 100 );
      mygrid.init();
      mygrid.load( cQry );

      myDp = new dataProcessor( cQry );
      myDp.init( mygrid );
      //myDp.enableDataNames( true );

      mygrid.enableMultiselect( true );
      mygrid.enableHeaderMenu();
      mygrid.enableColumnMove( true );
      mygrid.enableUndoRedo();
      mygrid.setAwaitedRowHeight( 22 );

Php code :

<?php
require_once( "config.php" );
require( "php/codebase/grid_connector.php" );
require( "php/codebase/db_mysqli.php" );
$slc_fld = $_GET[ 'fld' ];
$slc_db  = $_GET[ 'd_b' ];

function grid_serv_filter( $filter_by )
{
   $num_arr   = array();
   $num_arr[] = "uzs_kiekis";
   $num_arr[] = "prilyg_kiekis";
   $num_arr[] = "kainos_proc";

   $arr_lik   = array();
   $arr_lik[] = "uzsak";
   $arr_lik[] = "telkinys";
   $arr_lik[] = "preke";
   $arr_lik[] = "uzs_spalv";
   $arr_lik[] = "pastabos_ord";
   $arr_lik[] = "zymos";
   $arr_lik[] = "sukirp_lap";
   $arr_lik[] = "plan_modelis";
   $arr_lik[] = "pastabos_buh";
   $arr_lik[] = "pastabos_zs";

   foreach ( $arr_lik as &$value )
   {
      $index = $filter_by->index( $value );
      if ( $index !== false )
      {
         $cVal  = $filter_by->rules[ $index ][ "value" ];
         if ( strlen( $cVal ) > 0 )
         {
            $cVal  = $filter_by->rules[ $index ][ "value" ];
            if ( substr( $cVal, 0, 1 ) == "%" )
               $cVal = substr( $cVal, 1 );
            $filter_by->rules[ $index ][ "operation" ] = " LIKE ";
            $filter_by->rules[ $index ][ "value" ] = $cVal."%";
         }
      }
   }

   foreach ( $num_arr as &$value )
   {
      $index = $filter_by->index( $value );
      if ( $index !== false )
      {
         $cVal = $filter_by->rules[ $index ][ "value" ];
         if ( strlen( $cVal ) > 0 )
         {
            include 'num_oper.php';
            $arr  = num_filter( $cVal );
            if ( count( $arr ) > 0 )
            {
               if ( $arr[ 0 ] !== 'nera' )
                  $filter_by->rules[ $index ][ "value" ]  = $arr[ 0 ];
               $filter_by->rules[ $index ][ "operation" ] = $arr[ 1 ];
               if ( count( $arr ) == 3 )
                  $filter_by->add( $value, $arr[ 2 ], "<=" );
            }
         }
      }   
   }
}

$link    = new mysqli( $myServ, $myUser, $myPasw, $myDb );
if ( $link->connect_errno )
   die( 'Prisijungimo klaida : (' . $link->connect_errno . ') ' . $link->connect_error );
$grid = new GridConnector( $link, "MySQLi" );
$grid->dynamic_loading( 100 );
//$grid->enable_log( "temp.log", true );
$slct = new OptionsConnector( $link, "MySQLi" );
$slct->render_sql( "select preke as value, preke as label from prekes where prek_tipas = 'Gaminys' and db = '".$slc_db."' order by preke asc", "", "preke(value),preke(label)" );
$grid->set_options( "preke", $slct );
$grid->event->attach( "beforeFilter", "grid_serv_filter" );
$grid->render_sql( "select ".$slc_fld." from uzsakym where uzsakym.db = '".$slc_db."'", "uzsak", $slc_fld );
//$grid->render_table( "uzsakym", "uzsak", $slc_fld );
?>

XML request :

<?xml version="1.0" encoding="iso-8859-1"?><data><action type='update' sid='' tid=''/></data><?xml version='1.0' encoding='utf-8' ?><rows total_count='39270'><row id='100000'><cell><![CDATA[100000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2626-634]]></cell><cell><![CDATA[21.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[6]]></cell><cell><![CDATA[2011.03.25]]></cell><cell><![CDATA[2011.12]]></cell><cell><![CDATA[2011.05.06]]></cell><cell><![CDATA[2011.18]]></cell><cell><![CDATA[2011.05.06]]></cell><cell><![CDATA[2011.18]]></cell><cell><![CDATA[ALL LT]]></cell><cell><![CDATA[FR/*]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2011.04.06]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[122-785]]></cell><cell><![CDATA[105.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2626785]]></cell></row>
<row id='1000001'><cell><![CDATA[1000001]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[3600-785]]></cell><cell><![CDATA[20.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[8]]></cell><cell><![CDATA[2011.10.21]]></cell><cell><![CDATA[2011.42]]></cell><cell><![CDATA[2011.11.11]]></cell><cell><![CDATA[2011.45]]></cell><cell><![CDATA[2006.01.10]]></cell><cell><![CDATA[2006.02]]></cell><cell><![CDATA[darbo rubai musu]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[3600-785]]></cell><cell><![CDATA[20.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell></row>
<row id='100000A'><cell><![CDATA[100000A]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0250-310]]></cell><cell><![CDATA[6.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[8]]></cell><cell><![CDATA[2011.10.21]]></cell><cell><![CDATA[2011.42]]></cell><cell><![CDATA[2011.11.18]]></cell><cell><![CDATA[2011.46]]></cell><cell><![CDATA[2006.01.10]]></cell><cell><![CDATA[2006.02]]></cell><cell><![CDATA[mod 0249...0250,  0650 pvz  nepokuoti]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0250-310]]></cell><cell><![CDATA[6.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell></row>
<row id='100000B'><cell><![CDATA[100000B]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0352-315]]></cell><cell><![CDATA[10.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2011.10.21]]></cell><cell><![CDATA[2011.42]]></cell><cell><![CDATA[2011.11.18]]></cell><cell><![CDATA[2011.46]]></cell><cell><![CDATA[2006.01.10]]></cell><cell><![CDATA[2006.02]]></cell><cell><![CDATA[mod  0350,  0351,  0352,  0353, 0750 pvz]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0352-315]]></cell><cell><![CDATA[10.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell></row>

... 100 row ...

<coll_options for='2'><item value='00' label='00'></item>
<item value='002-780' label='002-780'></item>
<item value='01' label='01'></item>
<item value='010 REFL.' label='010 REFL.'></item>
<item value='011 REFL.2' label='011 REFL.2'></item>
..
<item value='97-630' label='97-630'></item>
<item value='A' label='A'></item>
<item value='OLD1600-780' label='OLD1600-780'></item>
<item value='OLD2600-785' label='OLD2600-785'></item>
<item value='OLD3600-785' label='OLD3600-785'></item>
<item value='OLD4600-785' label='OLD4600-785'></item>
<item value='OLD6600-780' label='OLD6600-780'></item>
<item value='R1234-820' label='R1234-820'></item>
<item value='R1934-820' label='R1934-820'></item>
<item value='R2234-825' label='R2234-825'></item>
<item value='R3234-825' label='R3234-825'></item>
<item value='R4234-825' label='R4234-825'></item>
<item value='SPEC.' label='SPEC.'></item>
<item value='T' label='T'></item>
<item value='WZPOA' label='WZPOA'></item>
<item value='ZARASAI' label='ZARASAI'></item>
</coll_options><coll_options for='4'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='5'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='6'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='16'><item value='Zarasai'></item>
<item value='Danija'></item>
<item value='F*'></item>
<item value='FR*'></item>
<item value='F/*'></item>
<item value='RF/*'></item>
<item value='MF/*'></item>
<item value='1/2'></item>
<item value='1/M2'></item>
<item value='1+2'></item>
</coll_options><coll_options for='20'><item value='UT'></item>
<item value='BR'></item>
<item value='JD'></item>
<item value='BIG'></item>
<item value='SGR'></item>
<item value='ZR'></item>
<item value=''></item>
<item value='BG'></item>
<item value='FD'></item>
<item value='127645'></item>
<item value='128055'></item>
<item value='129110'></item>
<item value='129944'></item>
<item value='129945'></item>
</coll_options><coll_options for='21'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='22'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='23'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='24'><item value='1'></item>
<item value='0'></item>
</coll_options><coll_options for='25'><item value='1'></item>
<item value='0'></item>
</coll_options><coll_options for='26'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='30'><item value='0'></item>
<item value='1'></item>
</coll_options></rows>

No errors in temp.log :

====================================
Log started, 13/12/2012 06:12:33
====================================
SELECT  preke as value, preke as label FROM prekes WHERE ( prek_tipas = 'Gaminys' and db = 'ut') ORDER BY `preke` ASC

SELECT DISTINCT `svarbus` as value FROM uzsakym
SELECT DISTINCT `specai` as value FROM uzsakym
SELECT DISTINCT `mazi` as value FROM uzsakym
SELECT DISTINCT `kerpa` as value FROM uzsakym
SELECT DISTINCT `subrang` as value FROM uzsakym
SELECT DISTINCT `aud_nuras` as value FROM uzsakym
SELECT DISTINCT `frn_nuras` as value FROM uzsakym
SELECT DISTINCT `invc_nuras` as value FROM uzsakym
SELECT DISTINCT `nav_nuras` as value FROM uzsakym
SELECT DISTINCT `pasel_prad` as value FROM uzsakym
SELECT DISTINCT `pokav_prad` as value FROM uzsakym
SELECT DISTINCT `buh_specas` as value FROM uzsakym
SELECT `uzsak`,`uzsak`,`telkinys`,`preke`,`uzs_kiekis`,`svarbus`,`specai`,`mazi`,`uzs_spalv`,`uzs_data`,`uzs_sav`,`graz_data`,`graz_sav`,`fakt_data`,`fakt_sav`,`pastabos_ord`,`zymos`,`kerpa`,`sukirp_lap`,`etiketes`,`gav_data`,`subrang`,`aud_nuras`,`frn_nuras`,`invc_nuras`,`nav_nuras`,`pasel_prad`,`pokav_prad`,`prilyg_mod`,`prilyg_kiekis`,`pastabos_buh`,`buh_specas`,`pastabos_zs`,`pok_lap_mod` FROM uzsakym LIMIT 0,100

SELECT COUNT(*) as DHX_COUNT  FROM uzsakym
Done in 0.72461700439453s

All was working and now I’m getting this error . Dhtmlx Suite Pro 3.5

Many thanks in advance !

OK , found the reason of error . Simply I downloaded “live update” samples and copied update.php to mine own directory . Base_connector.php have this : require_once(“update.php”); . And it direct to the new update.php in mine own directory . Strange , and base_connector.php and true update.php are in the same dir …

With best regards !