Page 1 of 1

Add new related record silently fails

PostPosted: Tue Sep 06, 2011 3:33 pm
by ADobkin
I am having a weird situation with one of my tables that I am hoping someone can help with.

When I add a new related record to this table and click save, it simply returns back to the empty new record form. All of the fields that were filled out are blank/lost. I have full PHP error reporting turned on, but there are no errors displayed in the browser or in the server logs. If I go directly to the table and add the record there, it works fine. Adding records through a similar relationship to another table also works fine. I am logged on as an admin, so I don't think it is a permissions issue.

This seems quite mysterious. I have been trying to debug it for a while and cannot come up with any hints so far. Any suggestions on how to determine what is going wrong?

Thanks,
Alan

Re: Add new related record silently fails

PostPosted: Wed Sep 07, 2011 10:14 am
by jonbfl
Alan -

Steve debugged my problem with TranslateQuery by examining the SQL Create Table output for my Master and language specific tables. I had a similar problem - no output, silent failure. (I had an accidental composite index)
viewtopic.php?f=4&t=6246

Perhaps comparing the table structures of the 'working' and 'no-werky' tables will help get to the bottom of the problem.

Good Luck
8)

Re: Add new related record silently fails

PostPosted: Wed Sep 07, 2011 1:05 pm
by ADobkin
Jon,

Thanks for the tip. I actually figured out the problem last night, but haven't had a chance to post an update yet.

I thought about what could be different about this table from the others that were working, since most of them were created with the same initial template. I couldn't find any problems in the table definition, or in the fields.ini or table delegate file. So it had to be something with the relationship.

It turns out that related table definitions must not contain a space. I was not aware of that before. This table was called "Work Orders", so it contained a space. The really weird thing is that I have been using this table for several months without any problem. It loads existing records fine. The only problem is when I attempt to create a new record, which is when it silently fails.

Note that I am not getting a "blank screen", which is a different issue. In this case, the user is just returned back to the new record form after submitting it the first time, but all of the data entered has been blanked out.

I hope this information is useful for someone else. I will go through all of my other relationships now and remove any existing spaces. It would be nice if some check/indication of this problem can be added in a future version of Xataface.

Thanks,
Alan