Please let us know a few additional details about your system:
- Version of VFP (including service pack)
- Version of FoxWeb
Also, please verify that any error causes FoxWeb channels to hang. Simply create a new script with the following code in it:
<%MyVar = SomeNonExistentVar%> |
The above script should generate a VFP error# 12 (Variable 'SOMENONEXISTENTVAR' is not found).
Another thing to check is whether you get a pop up window when the problem occurs. If you are running FoxWeb as a service you would not be seeing these windows, but you can temporarily disable the Run as Service option (and restart FoxWeb) to test for this. If you do see a pop up window, or some other visual indication that there's a problem with the channel, please make a screen shot and send it to us.
FoxWeb Support Team support@foxweb.com email |
Sent by Dan Divens on 09/20/2004 12:51:20 PM:
Any error that is written to the error log hangs the channel indefinately.
Channel has to be killed and restarted manually.
Settings:
Script timeout - 120 seconds
Session timeout - 3 minutes
Total channels - 5 (we're running dual AMD processors and a gig of ram)
Thanks
Dan
Sent by Dan Divens on 09/20/2004 09:59:19 AM:
Hi-
We've been using successfully since 1996 - we love your program and currently run about 70 large database websites on a single Win2003 box. We just upgraded to your newest version of FoxWeb, and are having troubles with the channels hanging and not recovering.
Whenever we get this error, the channel does not recover - we are working on fixing the bad clause, but is there a way for the channels to recover from this in the meantime? (I'm having to monitor and kill channels in real time):
Error #: |
|
1807 |
Message: |
|
SQL: GROUP BY clause is missing or invalid. |
Program: |
|
d:\cn\hs\*private*\edithomes.fxp |
Line #: |
|
561 |
Line: |
|
SELECT DISTINCT Clients.Client_ID, Clients.PASSWORD, Clients.Company, Clients.Full_Name FROM cClientPath + "clients" GROUP BY Clients.Client_ID ORDER BY Clients.Company WHERE Client_id = nOperator_ID INTO CURSOR AllClients |