View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
Gary - I've recently seen exactly the same thing, while porting some tables from .dbf files to remote views to a SQL Server database.  I don't recall the details, but I remember seeing "FRMSCK" dialogs (when run as an application), that you could never dismiss...they kept coming back.  Stopping FoxWeb would make them go away.  
 
Here are some sample entries from fwstart.log:  The timestamps correspond to how quickly the dialog comes back after hitting OK, Close, or X.
 
2008/11/12 11:07 Error: 1526 Message: "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'topic_sort', table 'dmps.dbo.topics'; column does not allow nulls. INSERT fails." Program: "WWW_READ.FXP" Line Number: 75 Line: "..." Channel: 1
2008/11/12 11:07 Error: 1924 Message: "FRMSCK is not an object." Program: "WWW_READ.FXP" Line Number: 90 Line: "..." Channel: 1
2008/11/12 11:08 Error: 1526 Message: "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'topic_sort', table 'dmps.dbo.topics'; column does not allow nulls. INSERT fails." Program: "WWW_READ.FXP" Line Number: 75 Line: "..." Channel: 2
2008/11/12 11:08 Error: 1924 Message: "FRMSCK is not an object." Program: "WWW_READ.FXP" Line Number: 90 Line: "..." Channel: 2
2008/11/12 11:09 Error: 1526 Message: "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'topic_sort', table 'dmps.dbo.topics'; column does not allow nulls. INSERT fails." Program: "WWW_READ.FXP" Line Number: 75 Line: "..." Channel: 3
2008/11/12 11:09 Error: 1924 Message: "FRMSCK is not an object." Program: "WWW_READ.FXP" Line Number: 90 Line: "..." Channel: 3
2008/11/12 11:13 Error: 1526 Message: "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'topic_sort', table 'dmps.dbo.topics'; column does not allow nulls. INSERT fails." Program: "WWW_READ.FXP" Line Number: 75 Line: "..." Channel: 5
2008/11/12 11:13 Error: 1924 Message: "FRMSCK is not an object." Program: "WWW_READ.FXP" Line Number: 90 Line: "..." Channel: 5
2008/11/12 11:14 Error: 1526 Message: "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'topic_sort', table 'dmps.dbo.topics'; column does not allow nulls. INSERT fails." Program: "WWW_READ.FXP" Line Number: 75 Line: "..." Channel: 4
2008/11/12 11:14 Error: 1924 Message: "FRMSCK is not an object." Program: "WWW_READ.FXP" Line Number: 90 Line: "..." Channel: 4
 
The fix, of course, was to fix various issues with my ported tables, such as nullable fields and unfulfilled relationships.  When those base problems were resolved, these symptoms went away.
 
This would have been extremely difficult to diagnose while running as a service, I think.
 
Hope this helps,
-dave
 
--
David Hempy
Internet Database Administrator
Kentucky Educational Television
(859)258-7164 - (800)333-9764
Sent by Gary S on 10/30/2008 01:57:50 AM:
Restart channels is checked, Script timeout is 60 secs.
Channel will hang permenantly, util Foxweb is restarted.

Occasionally, after an error, FWStart.log will record:

10/29/2008 01:14:57 Error: 1924 Message: "FRMSCK is not an object." Program: "WWW_READ.FXP" Line Number: 90 Channel: 1

While testing (uncheck Run as service and uncheck Hide windows) the error dialog will continue to pop up no matter how you reply to it.

Gary