ChrisVanBuren

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

Discussion created by ChrisVanBuren on Jan 25, 2012
Latest reply on Jan 27, 2012 by 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

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

Outcomes