error message when trying to view the Dashboard
Permalink 3 users found helpful
I get the following message when trying to load the Dashboard:
Site Activity
An unexpected error occurred.
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 SQL_MAX_JOIN_SIZE=# if the SELECT is okay] in EXECUTE("select count(pstID) from PageStatistics where uID <> '1' and PageStatistics.timestamp between FROM_UNIXTIME('1347010667') and FROM_UNIXTIME('1347019975') LIMIT 1")
Can anyone help with this?
Site Activity
An unexpected error occurred.
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 SQL_MAX_JOIN_SIZE=# if the SELECT is okay] in EXECUTE("select count(pstID) from PageStatistics where uID <> '1' and PageStatistics.timestamp between FROM_UNIXTIME('1347010667') and FROM_UNIXTIME('1347019975') LIMIT 1")
Can anyone help with this?
Hi, May I help you?
Sounds like you hit your join Limit in mysql.
You have 2 options:
1) Either raise the join limit in your my.cnf (I'm not sure I recommend this one, as I'm betting your dashboard front page has been getting rather slow.)
2) Empty the PageStatistics Table (You will lose all your tracking data for your pages).
Once you do that, I believe you can shut the tracking off to prevent this from happening in the future by unchecking the box that says "Track Pageview Statistics" in the System Settings area of the dashboard.
You have 2 options:
1) Either raise the join limit in your my.cnf (I'm not sure I recommend this one, as I'm betting your dashboard front page has been getting rather slow.)
2) Empty the PageStatistics Table (You will lose all your tracking data for your pages).
Once you do that, I believe you can shut the tracking off to prevent this from happening in the future by unchecking the box that says "Track Pageview Statistics" in the System Settings area of the dashboard.
Thanks very much for that. I'm going to give option 2 a try.
jjdb210 - That fixed it. I need to add some Google Analytics tracking code anyway. Thanks again for your help.
