4 Replies Latest reply on Dec 15, 2009 4:24 AM by RolandT

    Instant webpublishing: internal error message

    RolandT

      Summary

      Instant webpublishing: internal error message

      Description of the issue

       Hello, We are running a database for a at least a year now, and notting changed (except data).For two weeks we sometimes get a error message when we want to login to IWP page of the database. When a couple people are logged in the error message appears.It happend that i got a internal error message and a other person could still work in it. When he logout he got the the same internal error. We have to reset the publishing engine on the server to get it working again. It also happens that while working in the database the internal error appears. When i am with one or two people login, it is working. When more people are logged in the probleme occurs After the first couple times i also noticed that scripts which use the function evaluate did not work anymore. I rebuild the script so that the function evaluate is not used anymore. But we styill had the problem of the internal error. We tried: - rebuild the databases- create a clone of the rebuild databases- imported the data of the rebuild tables in the clone result: same error - installed fmserver on a diverent Mac. Running the databases Result: Same internal error - installed fmserver 10 (latest) on the diverent mac. Result: same internal error  

        • 1. Re: Instant webpublishing: internal error message
          philmodjunk
             Hmm, have you tried running a recover operation on the file to see if it reports any problems?
          • 2. Re: Instant webpublishing: internal error message
            RolandT
              

            Yes. Where i said i rebuild the database i mean recover. I recovered the databases with no errors. Ather the recovering i made a clone and imported the recovered data. (To be extra save)

             

            The database is also used with filemaker pro client with no errors. The Instant WebPublishing gifs the internat error.

             

            • 3. Re: Instant webpublishing: internal error message
              TSGal

              RolandT:

               

              Thank you for your posts.

               

              The Recover command will try to fix a FileMaker database file.  It is NOT a complete solution.  Since you are still getting the error message, it is possible that FileMaker could not fully fix the file.

               

              Since this worked for more than a year, and since it doesn't work on two different machines with FileMaker Server installed, I would find an older backup, clone it, and import the data from the recovered file, and then use the older file in place of the recovered file.

               

              Please keep me updated with any progress.

               

              TSGal

              FileMaker, Inc.

              • 4. Re: Instant webpublishing: internal error message
                RolandT
                  

                Thanks for your reply. I did as you said: clone a old backup (6 month ago) en recovered the databases again. Imported the recovered data.

                 

                But unfortunately we still have the error message when a couple of people log in the iwp: internal error.

                 

                Are there any tools for better logs?

                 

                I found the 500 error in the log (see below) Is it possible that PHP is the problem?:

                217.118.162.245 - - [07/Dec/2009:17:49:23 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.245 - - [07/Dec/2009:17:49:50 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/res/iwp_home.html HTTP/1.1" 200 6275

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/cgi?-dblinks HTTP/1.1" 200 628

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/cgi?-getstrings HTTP/1.1" 302 -

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/res/eng/strings.js HTTP/1.1" 200 5553

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/res/images/iwp_banner.gif HTTP/1.1" 200 12955

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/res/iwp_home.css HTTP/1.1" 200 1638

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/res/images/iwp_home.gif HTTP/1.1" 200 868

                217.118.162.244 - - [07/Dec/2009:17:54:31 +0100] "GET /fmi/iwp/res/images/iwp_logo.gif HTTP/1.1" 200 1207

                217.118.162.244 - - [07/Dec/2009:17:54:32 +0100] "GET /fmi/iwp/res/images/iwp_db.gif HTTP/1.1" 200 1185

                217.118.162.244 - - [07/Dec/2009:17:54:57 +0100] "GET /fmi/iwp/cgi?-db=Guru&-startsession HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:02 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:03 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:06 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:13 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:14 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:19 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:20 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                217.118.162.244 - - [07/Dec/2009:17:55:21 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240

                85.144.112.201 - - [07/Dec/2009:17:55:26 +0100] "GET / HTTP/1.1" 304 -

                85.144.112.201 - - [07/Dec/2009:17:55:27 +0100] "GET /fmi/iwp/cgi?-db=Guru&-startsession HTTP/1.1" 500 9240

                85.144.112.201 - - [07/Dec/2009:17:55:30 +0100] "GET /fmi/iwp/cgi?-open HTTP/1.1" 500 9240 

                 

                Any solutions anyone?