DataGrid records cannot be updated and saved

[wyhauyeung]

Hello. Greetings from user in Japan.

Xataface is really a great web application framework.

I have a problem want to ask.

I installed DataGrid (ver 0.2) in my Xataface applications, when I used admin role to login, the grid can be viewed properly without problems.
But when I tried to update records, although the records can be seen modified on the real-time grid screen, after 5 secs the red mark is still there and it turns out that the record cannot be updated..

Anyone knows whats the problems?

Thanks a lot.
Will

[ststoddard]

I have the exact same issue. Can't add rows nor update -- that is, the changes are not committed to the database. The red flag never goes away.

I did the standard install and have the Admin role.

[shannah]

Are there any javascript errors being reported?
If you check your server log, are any PHP errors reported?

The save functionality occurs in the js/DataGrid.js file.

Search for "Ext.Ajax.request" to find the part where the save occurs.
You can do a little debugging by adding an alert after the line:

Code: Select all

success: function(response,options){


so that it says

Code: Select all

success: function(response,options){
    alert(response);
}


This will show you exactly what the server is sending back on a save.

-Steve

[ststoddard]

Thanks for the tips…

I am, however, unable to get anything out of them. Don't know enough about all of this, I think.

I checked the apache and mysql logs, nothing to indicate a php error. Somewhere else I should look? I am hosting this from Ubuntu Linux 7.04.

I also edited DataGrid.js as you recommended, reloaded the page, and tried again. Same issue (of course) but nothing happens… where would I look for the message?

Sorry for the ineffectiveness here…

Steve

[ststoddard]

Just a quick addition, not sure it relates, but I have never been able to get any of the AJAX options to work properly.

[shannah]

I've blocked some time off on my schedule later this morning to look into this issue... hopefully I can have it resolved.

[shannah]

OK.. I have fixed the issue with not saving updates (not sure if this addresses the problem for adding new rows). You can download the fix from SVN:
http://weblite.ca/svn/dataface/modules/ ... ataGrid.js


Just replace your js/DataGrid.js file with this one.


In regards to your comment that no AJAX functions have ever worked for you, this could be caused if you are hosting Dataface at a slightly different domain than your application. E.g. in your index.php file, the 2nd parameter of df_init(), if you have a full URL for your dataface url, and the domain doesn't match your app domain, then AJAX will not work.

Better to use a relative path to xataface.
e.g.
use
df_init(__FILE__, '/path/to/xataface')
instead of
df_init(__FILE__,'http://www.mydomain.com/path/to/xataface');

In the second case, it wouldn't work if you accessed the app under http://mydomain.com, only http://www.mydomain.com.

-Steve

[ststoddard]

mmm… Thanks, but no luck. I downloaded the new file and replaced the old one and still have the same problem.

Also, regarding AJAX, I use a relative path. And I should have qualified my statement: it works, sort of, but is very slow and finicky. Takes sometimes, not others.

Not helping much, am I?

[shannah]

You may need to hit refresh, or clear your temp internet files in order for your browser to pick up the new version.

Which browser, OS, Xataface version, PHP version are you using?

[ststoddard]

I use Safari, usually, but just tried with Firefox and have the same problem still.

If it helps, when I look at the error console in Firefox I get the following errors:

Unknown property 'zoom'. Declaration dropped.
Unknown property '-moz-opacity'. Declaration dropped.
Error in parsing value for 'filter'. Declaration dropped.
The 'charCode' property of a keydown event should not be used. The value is meaningless.
The 'charCode' property of a keyup event should not be used. The value is meaningless.

Lots of them.

I am using PHP 5.2.1, Apache 2.2.3.

[ststoddard]

And am using Xataface 1.2.2.

[shannah]

Any chance you can make your app accessible to me so I can try it out and see if I notice anything?

-Steve

[shannah]

I believe I have found the problem. If you have magic_quotes_gpc enabled on your webserver, Xataface was not properly stripping the slashes that are added to the POST arrays.

If you replace your current config.inc.php file with the one at
http://weblite.ca/svn/dataface/core/tru ... ig.inc.php
it will fix the issue.

This would make sense for why many ajax things were not working correctly for you, as many ajax requests involve posting JSON data which gets garbled when magicquotes adds slashes to quotes.

It is recommended to have magic quotes disabled on your server as it causes nothing but problems ---- however if you have other scripts that have been developed and depend on it, then you may want to be careful in making such a change.

Best regards

Steve

[ststoddard]

That did the trick. I had no reason to have magic quotes on and wasn't even aware of that option. They were set to on by default, apparently.

Thanks!

[shannah]

The fix that I supplied actually causes a problem if magic_quotes_gpc is enabled, as in some cases it causes slashes to be stripped twice. This would probably only be noticeable when uploading files to a blob field.

To properly fix this issue, you need to update the following files to the latest:

http://weblite.ca/svn/dataface/core/tru ... ig.inc.php
http://weblite.ca/svn/dataface/core/tru ... ckForm.php

Description of this change:
HTML_Quickform now detects if slashes have already been stripped before attempting to strip them.