Missing table "user" in examples

Mike Storey

I have downloaded the editor and most of the examples run just fine, but the "Many-to-One" example fails. It would appear that the mysql.sql script does not create or load data into the "User" table. Is there another script I can run to load this data?

mRender

Can you give me an example of your script that is failing? Sometimes this happens no the datatables side where you don't make a call to the correct script itself. There's no way for us to know where to go to help if we can't see your code.

Mike Storey

I'm using the Editor Example for Join Tables One-to-Many. The HTML file is joinArray.html, and I believe it uses the joinArray.php file to provide data. The error message I get when opening this example is "DataTables warning: table id=example - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1" - Other examples work just fine but this php file references tables users and sites, which were not created by the example install script.

mRender

So you'll need to create the tables in your database, or run the install script again and make sure it creates the tables in your database.

Mike Storey

Ok, I found my problem, I had run the script
DataTables/examples/server_side/scripts/mysql.sql
and not
DataTables/extensions/Editor-1.3.3/examples/sql/mysql.sql
all working now, thanks.