MySQL data not showing

jhcompute

Hello,

I am new to datatables and using the editor option for a existing MySQL db that I have and have used for other test apps. I used the generator and set it up with a new db, then created that db in phpmyadmn, imported the sql that was generated. Loaded the files that the generator created changed the config.php to reflect the proper mysql login.

It all seems to work, except the initial one that has data shows they same as the test one with no data at all. When you try to add you get a An error has occurred - Please contact the system administrator.

Is there some permissions that need to be set.

I did no modifications to the generated files except the config.php file as instructed.

This is the same for both with and without data.

This is the generated one with no data yet as I can not add any cause the error.

I removed this link.

my php is 5.2.17

Thanks in advance.

allan

> my php is 5.2.17

That's the problem. The Editor PHP libraries require PHP 5.3 or newer. PHP 5.2 is no no longer maintained by the PHP devs, and was end of life years ago. IF you can, I'd suggest upgrading.

Allan

jhcompute

Great. This is a hosting company that I have to get to change. So no permissions or anything else it could be?

Thanks

allan

No - the Editor PHP libraries specifically require 5.3 or newer because they use namespaces and other features of PHP 5.3 to help present a much more friendly API ( http://editor.datatables.net/docs/current/ ).

I do have libraries for 5.2 which I can mail you, and they'll work okay, but they use an old and now unsupported API. They also don't have all of the features of the newer libraries (like the Join class), they aren't documented (other than an install tutorial: http://editor.datatables.net/tutorials/installing-1.1 ) and they won't be updated.

PHP 5.3 (itself now EOL! - the current version is 5.5.0) introduces a lot of great new features into PHP and is well worth the upgrade!

Allan

jhcompute

Allan,

I have it changed to 5.3.26 and I did get the above one working. I need to look at the other one as it was an existing db.

BTW. I am now going to split the php for the server and the html & Java for the mobile app integration for mobile devices.

Do you have a sqlite version for local on the device using the editor. I know you have the server and local storage. So might have a few questions for this one. Afterwards, I will post how we did it for others to use for the local side.

Thanks

allan

> Do you have a sqlite version for local on the device using the editor. I

As in using the HTML5 local database? I did put together an example of that a while back actually. Its basically a bit like this: http://editor.datatables.net/release/DataTables/extras/Editor/examples/localstorage.html . Just a bit more complex.

Allan

jhcompute

Can you share the complex one. So is the CRUD being done with the editor also for sqlite?

Thanks

allan

It is available here: http://www.datatables.net/forums/discussion/12240/sql-integration-for-offline-database/p1 and uses the IndexDB that is available in modern browsers (which itself, I think is a wrapper around SQLite).

Allan