max_join_size

Interesting as the sizes listed in the original problem are an indication that you had a 64 bit and have now installed the 32 bit packages. The limits that are reduced

Quote:

Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295

The limit 18446744073709551615 is only available in 64 Bit MySQL, the default for 32 bit is the value to which it has reduced ie. 4294967295.

The other problem you have listed above may also be an issue however it seems you may have switched from 64 to 32 bit packages for the MySQL server.