5 Replies Latest reply on Jan 27, 2012 2:44 AM by ChrisVanBuren

    MySQL Data Validation Issue - Required Value - changes not propagated?




      Any comments on this would be much appreciated.


      I have a long standing link with a MySQL table on a website. This used to work perfectly (a year ago) but now has a problem even though it would appear that nothing has changed.


      Here's the issue:

      -Certain fields in the MySQL table are required (can be seen in Define Databases). This validation is stopping a script I have from running properly.

      -The web developer involved says he has removed this validation and that "null" values are now acceptable.

      -But nothing has changed in Define Databases and the error persists.


      So it would appear that the changes to the MySQL table have not "propagated" out to FileMaker.


      We have:

      -double checked we are connected to the correct databases.

      -Rebooted the FileMaker Server machine.

      -Rebooted the webs server.


      Any suggestions? THANKS.





      Chris Van Buren


      e: chris@zeropointdata.com

      t: +44 (0)1291 689966




      Abbey Lodge, Tintern, CHEPSTOW, NP16 6SF, UK