How to avoid displaying database related error

[khurram4m]

I have a long script to execute and sometime maximum script execution time limit reached right at the moment of "Update query" which cause a detailed error revealing complete sql query, I want to avoid it , I don't want that system displays detailed error How can I avoid this???


   

[Dannymh]

Not much you can do here, however if this script is running regularly I would seriously consider a rewrite of the script to stop you from running into this issue.

What are you doing with it exactly?

Whatever it is it is actually killing mysql or blocking your connection to it

[khurram4m]

Not much you can do here, however if this script is running regularly I would seriously consider a rewrite of the script to stop you from running into this issue.

What are you doing with it exactly?

Whatever it is it is actually killing mysql or blocking your connection to it

Nothing is overkilling mysql, My script has to download message images and finally update moderator log and if there are a lot of images then script execution limit can easily be reached Many host like 000webhost only allow 10 seconds of window

[Dannymh]

You can catch these before they fail.

That is your only real option to try and trap the errors before they display, you could alway check the size or amount of images first and stop the script at xKB OR x image and then reload the script. The same way the recount tasks work.

Other than that you could run this from a task or a cron and that way stop front end users from ever seeing them.

It's about mitigation and preventing errors rather than anything else.

The other method is to use the error hook of the page output hooks and alter the output if an error with db info is found

[dragonexpert]

I believe this actually can be turned off.

ACP->Config->Server & Optimization Settings. Look for Error Type Medium. Set that to Hide Errors & Warnings.