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

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

    ChrisVanBuren

      Hi

       

      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.

       

      Cheers,

       

       

      Chris Van Buren

      ---------------------------------------------------------

      e: chris@zeropointdata.com

      t: +44 (0)1291 689966

      www.zeropointdata.com

       

       

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

      ---------------------------------------------------------