Can't update old records with required lookup fields.

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
apirnar
Veteran Member
Posts: 40
Joined: 2013-04-15 17:06

Can't update old records with required lookup fields.

Post by apirnar » 2015-06-11 07:26

This was a problem for image fields in the past now it is a broader problem so I am reporting it again separately.

Table2 has a field defined as required looking up from Table1.
Existing records created and updated fine with previous version of AppGini can no longer be updated.
"Error: You cannot leave this field empty" is given even though fields are not empty.

Changing fields in Table2 to not required and regenerating does not fix problem.
Field rebuild utility and forcing to regenerate field from menu option within AppGini do not fix problem.
Definitions viewed by phpMyAdmin show fields are allowed to be null.

This is a show stopper. I need the previous version 5.31 of AppGni where can I download it please?
This is urgent as the problem was not detected ın the test system and got rolled out to production system now users can't do daily work.

Appgini is great, and great value for money with limited resources, but need to be more stable on such basic mechanisms in major releases I think. Thanks for the great work.

apirnar
Veteran Member
Posts: 40
Joined: 2013-04-15 17:06

Update: Can't update old records with required lookup fields.

Post by apirnar » 2015-06-12 09:06

Further testing shows different behavior on different browser/version combinations.
Error goes away using Chrome on recent PC's but not on Chrome on some older PC's running XP and Vista.
IE seems to work on some where Chrome doesn't.
Suggests a javascipt discrepancy across browsers whereas none existed before.

apirnar
Veteran Member
Posts: 40
Joined: 2013-04-15 17:06

Re: Can't update old records with required lookup fields.

Post by apirnar » 2015-06-20 04:48

Update, and what seems a final solution:

autofill and filtered by lookup fields must be set as not required.
It is also necessary to clear all browser caches and restart each browser.
In some persistent cases it may be required to reinstall a corrupt browser too.

Post Reply