mysql error

[Joey]

Has anyone seen this is in the Logger Status?

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 [1104]

Everything is still working, it would just be nice not to have this error popping out at me. Not sure how or where to fix this??

Joe

[arash]

Hi Joey, this is very interesting, I didn't know about it. Can you send me the full error message (file, line number, etc...) also the stack trace (click on the + sign on the top left corner of the error message).

[fk59]

I got the same error.

Here are details:

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 [1104]
File: /is/htdocs/***/twatch/base/db/Db.php Line: 297

[arash]

This problem was solved in TraceWatch version 0.33. Please upgrade to the latest version.

[fk59]

when .33 comes out?

In downloads is still 0.32....

ciao

[arash]

0.33 has already been publish.
latest downloadable version is 0.332 not 0.32.

[fk59]

uups, my error.

But - i have installed .332

with the error above....

ciao

[fk59]

This problem was solved in TraceWatch version 0.33. Please upgrade to the latest version.

Sry, but last week i wrote, that the problem isnt solved.

Could you please check this again?

thx

[arash]

You're right this problem seems to be different from the one solved in 0.33 update. I'll look into it.

[arash]

This is now fixed in TraceWatch 0.335.
Remember to set $settings[ 'db_mysql_big_selects' ] to true when upgrading to 0.335.