Browse list empty after a long time

[Andjane]

Hi There

I'm using Nettalk 6.54 Using mySQL DB. (Clarion8)

Webserver.

I have a browse List which works great.  But what i have noticed is if i open that page for the first time the next day it comes up with "No Records" I refresh the browser or open a new browser session then the list is populated.

Any ideas that could cause this ? and how to fix.

The webserver is running as a service and the browse has the following filter.    'MEM:MemberOrDebtor = <39>M<39>'

Thanks In Advance

Regards Andreas

[lkeyser]

Hi Andreas

Check your session timeout value in the nettalk simple object in nettalk webServer procedure.
Settings Tab, Advanced.Tab
I think the default is set to 15 minutes..

You can change this.

Regards
Louis

[Andjane]

Hi Louis

Not sure if it could be that. The browser session has not started yet.

I presume the timeout you talking about is from the time you open that page.

The issue normally arises in the morning when no one has been into that webserver for some time. Seems as if something has gone to sleep. The second time around the browse list gets filled with the data from the database and from then on it is all OK. Just wonder if it could be mysql ?

Thanks

Andreas

[kevin plummer]

> Just wonder if it could be mysql ?

I think so. I recall some posts on this NG about the same issue. Do a search (try MySQL) and see what you can find.

[lanmicro]

I had a similar problem.  What I wound up doing was using a timer to stop the webserver at midnight and using a task scheduler to restart it.  Since then I have not had a problem.  I don't know why it works.

Nothing else I tried worked.  Even pinging the MySQL database every 30 seconds would fail to connect first attempt the next day.