4 Replies Latest reply on Dec 6, 2012 12:34 PM by ZoXo

    FileMaker file layouts are all GONE   WTF!!!!!

    ZoXo

      Summary

      FileMaker file layouts are all GONE   WTF!!!!!

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Mac OS 10.6.8

      Description of the issue

      FileMaker file hosted on a FileMaker 12 server.  Without warning ALL LAYOUTS ARE GONE!!!!

      HOW THE F DOES THIS HAPPEN?????

      In trying to figure out how this happened, I made a new file and tried to delete all the layouts and it always leaves 1 layout, but in this case they were ALL deleted, so I am now more than 100 percent sure that this was not an accidental deletion of the layouts.

      Steps to reproduce the problem

      I don't know of anyone who would want to reproduce this problem.

      Expected result

      Layouts don't get deleted

      Actual result

      ALL Layouts are gone.

      Exact text of any error message(s) that appear

      none

      Configuration information

      Hosted by a 3rd party on a FileMaker 12 server

      Workaround

      go to last backup

        • 1. Re: FileMaker file layouts are all GONE   WTF!!!!!
          philmodjunk

               How did you determine that all layouts are Gone?

               Did you open manage | Layouts and check that way?

               Layouts can be hidden from the user and layouts with certain designs can appear to be blank depending on found set and sort order so I can't help wondering if that might be the case here.

               It's also possible to have a two file system where one file contains the layouts and the other contains the data.

          • 2. Re: FileMaker file layouts are all GONE   WTF!!!!!
            ZoXo

                 I determined that when I watched it happen and when I went to manage layouts they were all gone.  As I said manually deleting them will ALWAYS leave 1 layout intact, so I know for a fact that is not what happened, plus every user that was connected was in the room with me and none of them have access to the layouts anyways.

            • 3. Re: FileMaker file layouts are all GONE   WTF!!!!!
              philmodjunk

                   What do you get if you run a recover on this file?

              • 4. Re: FileMaker file layouts are all GONE   WTF!!!!!
                ZoXo

                     Recovery stated it rebuilt the file and found no errors.  It did rebuild all the layouts and put them in alphabetical order and all at root level, folders included.  (Makes me wonder if the layout number was used somewhere if it would pick up the new order?-hmmm.. I should try it.)

                     So this is a case of pure file corruption, undetected by an act of recovery.  This then begs the question, if recovery states no errors were detected,

                     exactly where did all the layouts go?

                      

                      

                     2012-12-06 14:22:01.110 -0600 db no layouts.fmp12 0 Recover built a new database without detecting any problems. The new database is safe to use, though you should monitor the results carefully and make sure to keep up-to-date backups of your databases.
                     2012-12-06 14:22:01.111 -0600 db no layouts.fmp12 0 Note: Recover only checks the data blocks of the file and generates a new file from that data.  The Consistency Check checks all blocks of the file, and may find more problems in the original file than Recover does.
                     2012-12-06 14:22:01.111 -0600 db no layouts.fmp12 0 File blocks: scanned and rebuilt 12743 block(s), dropped 0 invalid data block(s)
                     2012-12-06 14:22:01.112 -0600 db no layouts.fmp12 0 Schema: scanned fields and tables; no problems found
                     2012-12-06 14:22:01.112 -0600 db no layouts.fmp12 0 Structure: scanned; 0 item(s) modified
                     2012-12-06 14:22:01.113 -0600 db no layouts.fmp12 0 File size after recovery is 51048448 bytes
                     2012-12-06 14:22:01.114 -0600 db no layouts.fmp12 0 *** Completed recovery to 'db no layouts Recovered.fmp12'
                     2012-12-06 14:31:22.613 -0600 db no layouts.fmp12 0 *** Started consistency check, total of 12807 block(s) to check
                     2012-12-06 14:31:23.571 -0600 db no layouts.fmp12 0 *** Completed consistency check, checked 12807 block(s)