Maximum execution time

drongo
Posts: 173
Joined: Mon Nov 05, 2012 1:06 pm

Re: Maximum execution time

Post by drongo »

Не чистит
Так и шлет:

Code: Select all

Maximum execution time of 29 seconds exceeded in /home/user/web/domain.com/public/scj/includes/db_modules/mysql.php

Maximum execution time of 29 seconds exceeded in /home/user/web/domain.com/public/scj/includes/prepare.php


Uncaught exception 'Exception' with message 'Mysql error:: 1104 (The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay) (db_link) in query select trader, country, SUM(num) as my_sum from ips group by trader, country. (domain.com) ' in /home/user/web/domain.com/public/scj/includes/db_modules/mysql.php:62
Stack trace:
#0 /home/user/web/domain.com/public/scj/includes/db_modules/mysql.php(75): db_error('select trader, ...', 1104, 'The SELECT woul...', 'db_link')
#1 /home/user/web/domain.com/public/scj/bin/cron.php(0): db_query()
#2 /home/user/web/domain.com/public/scj/bin/cron.php(0): update_trade_traffic_quality()
#3 {main}
  thrown in /home/user/web/domain.com/public/scj/includes/db_modules/mysql.php


Maximum execution time of 29 seconds exceeded in /home/user/web/domain.com/public/scj/bin/cron.php
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Maximum execution time

Post by admin »

Тогда попросите плз админа очистить таблицы ips and out_ips руками
Don't forget to run script update
Post Reply