Replies

• javismiles Posts: 205Questions: 38Answers: 3

  March 2014

  i managed to debug it with firebug and solve it , we can close this, thank you :)
• allan Posts: 63,691Questions: 1Answers: 10,500 Site admin

  March 2014

  For anyone else who reads this, the error message basically means what it says - the returned data is not valid JSON. Which typically means that there is an error message in the data, which will indicate what the issue is. This tech note can be used to determine what the error is: http://next.datatables.net/manual/tech-notes/1
  
  @javismiles - What was the error?
  
  Allan
• javismiles Posts: 205Questions: 38Answers: 3

  March 2014

  Thank you dear Allan,
  in the end i used Google Chrome Debugger to easily see the ajax errors being returned,
  that way its very easy to find out what's wrong,
  in my case there were two big issues that i feel you should alert people more clearly about
  
  1) The default primary key is always assumed to be ID, in one of my tables was USERID, this broke it all, so i had to set default to USERID and then it worked
  // $this->pkey( $pkey );
  $this->pkey( "userid" );
  
  2) DATES fields, timeZone not set in PHP, i had to set it to make it work
  in files format and validate of editor
  like this:
  namespace DataTables\Editor;
  date_default_timezone_set('America/Los_Angeles');
  same in both files
  
  Im a developer and i know how hard is to cover all cases in auto generating tools so i totally understand its not possible to explain all these little details in any case
• allan Posts: 63,691Questions: 1Answers: 10,500 Site admin

  March 2014

  > 1) The default primary key is always assumed to be ID, in one of my tables was USERID, this broke it al
  
  Agreed! I did actually have a pkey field in the original version of generator, and then simplified it... I'm going to put it back in.
  
  > 2) DATES fields, timeZone not set in PHP, i had to set it to make it work
  
  I might put that in an FAQ, but it is a fairly generic PHP issue. I'll see if it comes up again (at which point it will become an FAQ :-) ).
  
  Thanks for the feedback!
  
  Allan