Title: [ERROR] Error:SQLSTATE[42000]
Last modified: April 25, 2023

---

# [ERROR] Error:SQLSTATE[42000]

 *  Resolved [White0wl](https://wordpress.org/support/users/white0wl/)
 * (@white0wl)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/error-errorsqlstate42000/)
 * Hi! I am trying to migrate my Joomla page to WordPress site and have some trouble:
 * [ERROR] Error:SQLSTATE[42000] 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
 * My DB is quite big (800MB+), so the plugin giving error. How to fix it?

Viewing 1 replies (of 1 total)

 *  Plugin Author [Kerfred](https://wordpress.org/support/users/kerfred/)
 * (@kerfred)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/error-errorsqlstate42000/#post-16687468)
 * This post may help you: [https://stackoverflow.com/questions/943423/mysql-the-select-would-examine-more-than-max-join-size-rows](https://stackoverflow.com/questions/943423/mysql-the-select-would-examine-more-than-max-join-size-rows)

Viewing 1 replies (of 1 total)

The topic ‘[ERROR] Error:SQLSTATE[42000]’ is closed to new replies.

 * ![](https://ps.w.org/fg-joomla-to-wordpress/assets/icon-256x256.png?rev=975975)
 * [FG Joomla to WordPress](https://wordpress.org/plugins/fg-joomla-to-wordpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/fg-joomla-to-wordpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/fg-joomla-to-wordpress/)
 * [Active Topics](https://wordpress.org/support/plugin/fg-joomla-to-wordpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/fg-joomla-to-wordpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/fg-joomla-to-wordpress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kerfred](https://wordpress.org/support/users/kerfred/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/error-errorsqlstate42000/#post-16687468)
 * Status: resolved