DataTables Editor Internal Server Error

DataTables Editor Internal Server Error

icwebicweb Posts: 3Questions: 0Answers: 0
edited February 2013 in Editor
Hi,

I've uploaded the dataTables editor and it runs the page with a AJAX error. MySQL is working fine on the site with PHP. The live page with the error is here http://messy-monkeys.com/DataTables-1.9.4/extras/Editor-1.2.3-Trial/examples/

and in Chrome I get the following error message....

GET http://messy-monkeys.com/DataTables-1.9.4/extras/Editor-1.2.3-Trial/examples/php/browsers.php?_=1360676062335 500 (Internal Server Error)

Any pointers would be much appreciated.
Ian

Replies

  • allanallan Posts: 63,534Questions: 1Answers: 10,475 Site admin
    What does your server error log say the error is?

    Allan
  • icwebicweb Posts: 3Questions: 0Answers: 0
    The error logs reports....
    [Wed Feb 13 12:23:30 2013] [warn] mod_fcgid: stderr: PHP Parse error: syntax error, unexpected T_STRING, expecting T_CONSTANT_ENCAPSED_STRING or '(' in /home/linweb13/m/messy-monkeys.com/user/htdocs/DataTables-1.9.4/extras/Editor-1.2.3-Trial/examples/php/browsers.php on line 12

    Interestingly I've uploaded the data editor examples to a different server and it all works fine, so there must be something in the configuration of the server that is causing the problem. Maybe it's a permissions or parsing thing? I'm running PHP Version 5.2.17.
  • allanallan Posts: 63,534Questions: 1Answers: 10,475 Site admin
    > I'm running PHP Version 5.2.17.

    That's the problem. The Editor PHP libraries require PHP 5.3 or newer ( http://editor.datatables.net/docs/current/ ). The libraries make use of closures and other features that are only available in 5.3+ to present as clean as possible an API.

    Are you able to update to a new version of PHP? 5.2 is no longer a supported version by the PHP folks.

    Allan
  • icwebicweb Posts: 3Questions: 0Answers: 0
    thanks for the reply Allan. I'll investigate upgrading the php. It's not my server so will need to ask.
    cheers
  • allanallan Posts: 63,534Questions: 1Answers: 10,475 Site admin
    I do have PHP libraries from Editor 1.0/1.1 which are compatible with PHP 5.2 if you need, but if it is possible to upgrade PHP I'd recommend doing that. The new libraries are much more capable (supporting Joins for example). If you can't upgrade, PM me your e-mail address and I'll zip the old libraries up and send them over.

    Allan
  • whitbaconwhitbacon Posts: 40Questions: 2Answers: 0
    Did anything come of this as I am having the same t string issue
  • allanallan Posts: 63,534Questions: 1Answers: 10,475 Site admin
    Is it the same problem that you have an old version of PHP?

    The PHP libraries that Editor 1.2 require PHP 5.3 or newer, as they use a number of the more modern features of PHP to present a clean API. It is worth noting that PHP 5.2 is no longer being maintained but the PHP developers, so upgrading is encouraged.

    I can send you the old libraries I have if you really can't upgrade, but PHP 5.3 and newer really is a huge amount better than 5.2-.

    Allan
  • hvillerohvillero Posts: 1Questions: 0Answers: 0
    Hi Allan, I'm having the same issue I have PHP 5.2 and the hosting on my company is having issues upgrading to PHP 5.3, could you please send me the old libraries or please let me know when I can download them.. Thank you for your help,

    hvillero
  • allanallan Posts: 63,534Questions: 1Answers: 10,475 Site admin
    They are now available here: http://editor.datatables.net/release/php_5-2_libs.zip .

    As I say, they are not longer maintained, nor are they supported. They also don't have as many features. Install instructions are here: http://editor.datatables.net/tutorials/installing-1.1 .

    Allan
This discussion has been closed.