Website suspended...

[Guest]

My website were suspended by my hosting company this morning. I totally has no idea what it is about. Probably someone can help me. This is what my hosting company said :

 

Dear Kevin,

your account was suspened. Your scripts are using copying to tmp tables. Here is an example:

| 23606 | simply_osc1 | localhost | simply_osc1 | Query | 0 | Copying to tmp table | select distinct p.products_id, pd.products_name from products p, products_description pd where p.pro |

 

We'll unsusupend your account in several minutes but we'd like to ask you to fix the issue as it influences the server negatively.

Thank you.

 

A second reponse from my hosting company :

 

Please update your scripts and upload them to the server. We don't know which script uses DB connection. You should know it better. But if your script will overload our server again, we will suspend your account again.

 

Please someone help me.

Thanks in advance :(

Kevin

[♥Vger]

All scripts in osCommerce use a connection to the database. The responses you've got from your hosts don't really say much about the problem, and are of no real help.

 

Here are a few things to check.

 

In both of your configure.php files, where it says use_pconnect make sure these are set to false.

 

At the bottom of both configure.php files make sure that it says 'mysql' where indicated - thus storing sessions in the database and not in files in a 'tmp' folder.

 

In your osCommerce admin panel under Configuration --> Cache, set Use Cache to false.

 

Vger

[Guest]

Thanks, Vger will check it.

Kevin