Title: Database error
Last modified: October 6, 2026

---

# Database error

 *  [Mick](https://wordpress.org/support/users/haarbollen/)
 * (@haarbollen)
 * [2 days, 22 hours ago](https://wordpress.org/support/topic/database-error-435/)
 * Hi
   I’m logging into my page and I’m getting this scary piece of ‘information’
   on top of page when entering the dashboard. Does anyone know what to do – how
   to ‘fix’?[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]`SELECT
   wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.
   post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE
   1=1 AND ( ( wp_postmeta.meta_key = '_alg_wc_pvbur_visible' AND wp_postmeta.meta_value!
   = '' ) OR ( mt1.meta_key = '_alg_wc_pvbur_invisible' AND mt1.meta_value != ''))
   AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP
   BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1`
 * Thanks SO much in advance!!

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [Mick](https://wordpress.org/support/users/haarbollen/)
 * (@haarbollen)
 * [2 days, 22 hours ago](https://wordpress.org/support/topic/database-error-435/#post-19037481)
 * To be added:
   When I try to update any plugin at all, it comes back with this:
 * Update failed: WordPress database error: [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]SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta
   ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.
   ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_alg_wc_pvbur_visible&#
   039; AND wp_postmeta.meta_value != '' ) OR ( mt1.meta_key = '_alg_wc_pvbur_invisible&#
   039; AND mt1.meta_value != '' ) ) AND wp_posts.post_type = 'product&#
   039; AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID 
   ORDER BY wp_posts.post_date DESC LIMIT 0, 1{“success”:true,”data”:{“update”:”
   plugin”,”slug”:”woo-extra-product-options”,”oldVersion”:”Version 3.3.8″,”newVersion”:”
   Version 3.3.9″,”plugin”:”woo-extra-product-options\/woo-extra-product-options.
   php”,”pluginName”:”Extra Product Options For WooCommerce | Custom Product Addons
   and Fields”}}
 *  [oliverwhite2](https://wordpress.org/support/users/oliverwhite2/)
 * (@oliverwhite2)
 * [2 days, 19 hours ago](https://wordpress.org/support/topic/database-error-435/#post-19037667)
 * That error looks like the query is hitting the database row limit rather than
   WordPress itself being completely broken. Since the query is joining with twice,
   the size of the WooCommerce product/meta tables could be part of the problem.
   I’d first check whether the issue started with the Woo Extra Product Options 
   update, then test with that plugin disabled if possible. Checking the database
   size and indexes may also help before changing  globally.
 *  Thread Starter [Mick](https://wordpress.org/support/users/haarbollen/)
 * (@haarbollen)
 * [2 days, 19 hours ago](https://wordpress.org/support/topic/database-error-435/#post-19037669)
 * Thank you Oliver! I will try, as far as I can with my very limited experience–
   but might have to come back on some issues :o)
   Mick
 *  Thread Starter [Mick](https://wordpress.org/support/users/haarbollen/)
 * (@haarbollen)
 * [2 days, 15 hours ago](https://wordpress.org/support/topic/database-error-435/#post-19037891)
 * Update: I hade four plugins ready for update. Tried to disable them one by one
   and check, and it doesn’t seem to have anything to do with plugins.
   Wrote an 
   email to my provider as well, haven’t heard anything yet. Until I do, I’ll let
   it be, perhaps somebody had same experience.

Viewing 4 replies - 1 through 4 (of 4 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-435%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [Mick](https://wordpress.org/support/users/haarbollen/)
 * Last activity: [2 days, 15 hours ago](https://wordpress.org/support/topic/database-error-435/#post-19037891)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics