DataTables

Allan,

Here are the contents of the browser (Firefox) console:

[13:46:34.686] Expected declaration but found '*'. Skipped to next declaration. @

http://localhost/DataTablesEditor/DataTables-1.9.2/media/css/jquery.dataTables.css:16
[13:46:34.687]

Unknown property '-moz-border-radius'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/media/css/jquery.dataTables.css:151
[13:46:34.689]

Expected declaration but found '*'. Skipped to next declaration. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/TableTools/media/css/TableTools.css:44
[13:46:34.689] Unknown property '-moz-border-radius'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/TableTools/media/css/TableTools.css:49
[13:46:34.689] Unknown property '-moz-box-shadow'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/TableTools/media/css/TableTools.css:55
[13:46:34.689] Error in parsing value for 'background'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/TableTools/media/css/TableTools.css:62
[13:46:34.689] Error in parsing value for 'filter'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/TableTools/media/css/TableTools.css:67
[13:46:34.691] Expected declaration but found '*'. Skipped to next declaration. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:131
[13:46:34.691] Unknown property '-moz-border-radius'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:150
[13:46:34.691] Unknown property '-moz-box-shadow'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:156
[13:46:34.691] Error in parsing value for 'background'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:163
[13:46:34.691] Error in parsing value for 'filter'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:168
[13:46:34.692] Expected declaration but found '#position'. Skipped to next declaration. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:235
[13:46:34.692] Expected declaration but found '#top'. Skipped to next declaration. @

http://localhost/DataTablesEditor/DataTables-1.9.2/extras/Editor-1.1.0-Trial/media/css/dataTables.edito

r.css:236
[13:46:34.847] Unknown property '-moz-border-radius'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/examples/examples_support/syntax/css/shCore.css:27
[13:46:34.847] Unknown property 'box-sizing'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/examples/examples_support/syntax/css/shCore.css:46
[13:46:34.848] Error in parsing value for 'min-height'. Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/examples/examples_support/syntax/css/shCore.css:52
[13:46:34.849] Expected color but found 'none'. Error in parsing value for 'background-color'.

Declaration dropped. @

http://localhost/DataTablesEditor/DataTables-1.9.2/examples/examples_support/syntax/css/shCore.css:346
[13:46:34.849] Expected declaration but found '*'. Skipped to next declaration. @

http://localhost/DataTablesEditor/DataTables-1.9.2/examples/examples_support/syntax/css/shCore.css:365

I believe I've set up the database properly. Here is the dp.php file:

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');


/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Database user / pass
*/
$sql_details = array(
"user" => "root",
"pass" => "rootpwd",
"host" => "localhost",
"db" => "datatableseditor"
);


// This is included for the development and deploy environment used on the DataTables
// server. You can delete this block - it just includes my own user/pass without making
// them public!
if ( is_file($_SERVER['DOCUMENT_ROOT']."/datatables/pdo.php") ) {
include( $_SERVER['DOCUMENT_ROOT']."/datatables/pdo.php" );
}
// /End development include


/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Database connection
*/

/* PDO connection */
/*
$db = new PDO(
"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
$sql_details['user'],
$sql_details['pass'],
array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
)
);
*/

/* mysql_* connection */

if ( ! $db = mysql_pconnect( $sql_details['host'], $sql_details['user'], $sql_details['pass'] ) ) {
header( $_SERVER['SERVER_PROTOCOL'] .' 500 Internal Server Error' );
die( 'Could not open connection to server' );
}

if ( ! mysql_select_db( $sql_details['db'], $db ) ) {
header( $_SERVER['SERVER_PROTOCOL'] .' 500 Internal Server Error' );
die( 'Could not select database' );
}



/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Include DTEditor class
*/

// Include the DTEditor class that belongs with this connection type
//include( dirname(__FILE__)."/DTEditor.mysql.pdo.class.php" );
//include( dirname(__FILE__)."/DTEditor.postgres.pdo.class.php" );
include( dirname(__FILE__)."/DTEditor.mysql.class.php" );

I've never used Firebug before but managed to install it. I don't know what "XHR" means, but this is
what I see in the console:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">;
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="content-type">
<link href="http://www.datatables.net/favicon.ico"; type="image/ico" rel="shortcut icon">
<title>DataTables Editor example</title>
<style type="text/css">
<script src="../../../media/js/jquery.js" charset="utf-8" type="text/javascript">
<script src="../../../media/js/jquery.dataTables.js" charset="utf-8" type="text/javascript">
<script src="../../TableTools/media/js/TableTools.js" charset="utf-8" type="text/javascript">
<script src="../media/js/dataTables.editor.js" charset="utf-8" type="text/javascript">
<script id="init-code" charset="utf-8" type="text/javascript">
</head>
<body id="dt_example">
<div id="container">
<div class="DTED_Lightbox_Background" style="display: none;"></div>
<div class="DTED_Lightbox_Wrapper">
</body>
</html>

I'm running this inside Netbeans, and Netbeans shows an error on every CSS entry that starts with an
"*", saying it's an "unexpected symbol". These correspond to the entries shown from the Firefox
console shown in my previous post.

Dan

HI Dan,

This video on Ajax debugging with Firebug will help: www.youtube.com/watch?v=W4jXAaEMp2M . Basically we need to know what is being returned from the server.

every CSS entry that starts with an "*", saying it's an "unexpected symbol"

The star hack is for IE6 ( http://en.wikipedia.org/wiki/CSS_filter#Star_hack ). It introduces invalid CSS which everything else ignores, but that's the cost of IE6 support here.

Allan

That video didn't get through with the post. Can you send the URL?

I've edited my post so the URL is in plain text now. It was the first hit on google when I searched for "firebug ajax tutorial".

I'm guessing that "XHR" means "XmlHttpRequest".

Yes :-). The files show the source for the page, but we are interested in the JSON that is being returned from the server here.

My interpretation of that Wikipedia page regarding the star-hack is that everything should work fine despite the fact that I'm getting those error messages. Is this correct?

Correct - that has nothing to do with the JSON loading issue you are seeing. For that, as I say, you really need to know what the XHR is getting back from the server.

Allan

That sounds like it! Yes that helps at lot.

So basically your server is returning a 500 error because it can't find the function mysql_pconnect ( http://php.net/manual/en/function.mysql-pconnect.php ). That is the method that is being used to connect to your MySQL database (assuming you have one), but it sounds like your PHP install doesn't have the mysql_* functions compiled in (you can confirm with phpinfo).

Does it have the MySQL PDO driver built in - you could use that instead?

Allan

the instructions said that Apache would not support PhP versions later that 5.2

This server that datatables.net is on is using Apache with PHP 5.3 :-). PHP 5.4 is perfectly compatible with Apache as well.

After some rather extensive research, I've come to the conclusion that the only way to run the recent versions of PhP is on Windows with IIS. Do you agree with this?

Not really no. Apache for Windows is excellent. Have a look at the WAMP distribution: http://www.wampserver.com/en/ . Apache 2.2/2.4 and PHP 5.3/5.4 available.

Allan

Fantastic. Do let me know if you have any questions about it.

Allan

@Osiris - I'm not sure sure I understand? This conversation is two months old now. Are you having a similar problem but with Apache 2.4?

Allan