SmartCJ Support Forum

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