IE8 problem - Server Side Processing DataTable

paky

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

allan

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

RRStoyanov

I had some problem with IE8, but it was my fault. I indeed had wrong count of returned columns

paky

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

paky

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

allan

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

paky

g.r.e.a.t allan now ie8 works fine ... my json invalid by a comma !!!! :)

thanks