Have a DB that contains 4 tables. 2 of these tables seem to fail over night. The system has been working fine the previous day but when you try to load a relevent page the follwing morning you get the below errors.
Rebooting the sever fixes the problem until the following morning.
Is there some DB logic i need to be made aware of? Is there a connection that is remaining open to the table over night? Is the "Back Up Exec" software causing the problem?
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\sites\intranet\htdocs\new03\site\Contacts\frontpage.php on line 81
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\sites\intranet\htdocs\new03\site\Contacts\frontpage.php on line 138
No Results
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\sites\intranet\htdocs\new03\site\Contacts\frontpage.php on line 141
Daily Table Failure
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Perhaps adding some error handling into your script (using something like mysql_error() would help you get more useful error messages.
Something - connection, db selection, SQL statement - is failing so you need some error handling to find out what.
Mac
Something - connection, db selection, SQL statement - is failing so you need some error handling to find out what.
Mac
New error messages
Cheers Hedge,
i'm sure i've heard of backup software causing problems.
Twigletmac,
thanks again. You keep telling me to do these things and i'm gonna get there one day. In my deffence i have been trawling through my code and trying to make it a bit more robust and error friendly.
It crashed again this morning.
on one table i got
Got error -1 from table handler
and on the other
Got error 28 from table handler.
Will try and locate these errors on the mysql site, but please feel free to state what they are.
Many thanks,
Deddog.
i'm sure i've heard of backup software causing problems.
Twigletmac,
thanks again. You keep telling me to do these things and i'm gonna get there one day. In my deffence i have been trawling through my code and trying to make it a bit more robust and error friendly.
It crashed again this morning.
on one table i got
Got error -1 from table handler
and on the other
Got error 28 from table handler.
Will try and locate these errors on the mysql site, but please feel free to state what they are.
Many thanks,
Deddog.
Hopefull solution
Would seem the problem is to do with disk space.
Have cleared a wad off the HD, so I should hopefully be in the clear.
Have cleared a wad off the HD, so I should hopefully be in the clear.