IE8 problem - Server Side Processing DataTable

IE8 problem - Server Side Processing DataTable

pakypaky Posts: 106Questions: 0Answers: 0
edited October 2009 in Bug reports
Hi, my table load external data with 'sAjaxSource' option, in Firefox3.5.3 work fine, in IE8 instead popup alert message with 'Warning - added data does not match know number of columns' !

this is my rable structure:
[code]




Cognome
Nome
Qualifica
E-mail
Telefono
Actions





Edit all
Delete all
Approve all
Reject all
 






 
 
 
 
 
 
 



[/code]

and this javascript:
[code]
$(document).ready(function() {
$('#box-table-a').dataTable( {
"bProcessing": true,
"bServerSide": true, "sAjaxSource": "includes/tab.dipendenti/server_processing_table_dipendenti.php",
//salva nei cookies le scelte
"bStateSave": true,
"bJQueryUI": false,
"sPaginationType": "full_numbers",
"oLanguage":
{
"sLengthMenu": "Mostra _MENU_ righe per pagina",
"sZeroRecords": "Nessun risultato",
"sSearch":"Trova dipendente",
"sInfo": "Dal _START_^ al _END_^ su un totale di _TOTAL_ dipendenti",
"sInfoEmtpy": "0 to 0 of 0 dipendenti",
"sInfoFiltered": "( su _MAX_ totali)"
}

});
});
[/code]

thanks

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Hi paky,

    Could you provide a sample of your JSON which is causing the problem as well, and also, ideally a link showing this problem, as I'm having problems reproducing it in my example which you noted in the other thread that you were having problems with as well.

    Regards,
    Allan
  • RRStoyanovRRStoyanov Posts: 12Questions: 0Answers: 0
    I had some problem with IE8, but it was my fault. I indeed had wrong count of returned columns
  • pakypaky Posts: 106Questions: 0Answers: 0
    edited October 2009
    for allan :
    my table have 7 column (in first one checkbox, in the last many )

    (from firebug console)
    {"sEcho": 1, "iTotalRecords": 99, "iTotalDisplayRecords": 99, "aaData": [ ["","AXXXX","PRUXXZA","fisioterapista","-","-","",],["","AXXXX","ORXXXXO","infermiere","-","-","",],["","AXXXXNO","YYYY","","-","-","",],["","ZZZZ","ZZZZ2","","-","-","",],["","NAME","ROSSELLA","","-","-","",],["","XXXXXX","BIAZIO","","-","-","",],["","ZZZZZ","ZZZZZANTONIO","fisioterapista","-","-","",],["","XCC","CCDDD","operatore","-","-","",],["","CCC","CCCC","amministrativo","-","-","",],["","XXX","XXXXX","operatore","-","-","",]] }


    sorry for lenght .....

    bye
  • pakypaky Posts: 106Questions: 0Answers: 0
    Add one comment ... in another my case of json decode/encode I must use Striplslashes() php func for a correct final format ... may be this case ?

    (sorry for my english very very poor) :)

    paky
  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Hi paky,

    Your English is absolutely fine! No worries there...

    The problem is that your JSON is invalid. You have a trailing comma right at the end of the output you pasted "",]] }". IE will (correctly) reject this, while Firefox (wrongly) will not. If you just remove that it should start working. Also worth running your JSON through http://www.jsonlint.com which is useful for debugging JSON issues.

    Regards,
    Allan
  • pakypaky Posts: 106Questions: 0Answers: 0
    g.r.e.a.t allan now ie8 works fine ... my json invalid by a comma !!!! :)

    thanks
This discussion has been closed.