News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

site suspension for Large Query , help needed

Started by Khurram Abbasi, May 16, 2012, 02:29:47 AM

Previous topic - Next topic

Khurram Abbasi

QuoteHello,

We are contacting you because we noticed that the database 'database_com' is generating large queries. This causes issues with both server performance and the disk space. It is against our Terms of Service due to this we have suspended website and CGI functionality of your account. To revoke the suspension, you need to look into this database and take necessary steps.

I have pasted the SMF application is generating queries as show below.
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_log_activity
UPDATE smf_sessions
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_sessions
INSERT INTO smf_log_errors(`id_member`, `log_time`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`)
UPDATE smf_topics
UPDATE smf_log_activity
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_sessions
INSERT INTO smf_log_errors(`id_member`, `log_time`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`)
INSERT INTO smf_log_errors(`id_member`, `log_time`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`)
UPDATE smf_topics
UPDATE smf_log_activity
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_sessions
UPDATE smf_log_activity
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_sessions
UPDATE smf_log_online
INSERT INTO smf_log_errors(`id_member`, `log_time`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`)
UPDATE smf_log_activity
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_ads
UPDATE smf_sessions

If you have any further questions, please update the Support Console.

Sincerely,

Adella Kelly
Support Specialist


i use ipage.com hosting , please tell me what to do with database so that dont suspend my site ,

thanks

live627

That looks like multiple queries?

Ultimate solution: Don't use free hosting.

Khurram Abbasi



Khurram Abbasi

well i am also using unlimited package which cost 35$ a year :P , i also contact with ipage , they are telling me to delete the database , this is my main site , it took year to make this database ,
only for this site i am using their hosting ,
now they reopen the ticket and their specialist will look at this matter in 24 hr , :(

Storman™

Looks like the Ad Management mod is responsible.

Do you have anything in your error log ? Also, do you have the latest version of this mod installed ?

Of course, uninstall the mod and your issue will go away, or maybe post your issue in the mod's topic and see what the author says.

Khurram Abbasi

ok i uninstall Ad Management mod and reinstall again and also post in Ad Management mod support topic , thanks

Khurram Abbasi

QuoteDelma Karl: This query is not getting updated in table 'smf_ads' . Hence generates an error log and gets updated in table 'smf_log_errors'. This results filling up heavy records in the table. At present, the table 'smf_log_errors' has more than 4,50000 of records.
QuoteDelma Karl: Also, We can't check your database for errors or anything. The application may be outdated so some spammers may be there, we can't check your entire forum. Hence, you need to contact your developer about the issue.


this is i told by ipage support , 

Khurram Abbasi

i disable the error log , and now its looks ok to me


admin -> security and moderation -> uncheck enable error logging

Advertisement: