Memory limit
-
Добрый день!
Плагин не удалось протестировать, работа выходит за пределы допустимой нагрузки хостера.
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home/bush8383/newsneakers.ru/wp-includes/wp-db.php on line 1775При отключении этого участка кода:
private function get_products( $backorders ) { global $wpdb; return $wpdb->get_results( "SELECT p.ID, p.post_title AS name, p.post_content AS description, m1.meta_value AS vendorCode, p.post_excerpt AS sales_notes, m3.meta_value AS stock, m0.meta_value AS options FROM $wpdb->posts p INNER JOIN $wpdb->postmeta m0 ON p.ID = m0.post_id AND m0.meta_key = '_product_attributes' INNER JOIN $wpdb->postmeta m1 ON p.ID = m1.post_id AND m1.meta_key = '_sku' INNER JOIN $wpdb->postmeta m2 ON p.ID = m2.post_id AND m2.meta_key = '_visibility' INNER JOIN $wpdb->postmeta m3 ON p.ID = m3.post_id AND m3.meta_key = '_stock_status' INNER JOIN $wpdb->postmeta m4 ON p.ID = m4.post_id AND m4.meta_key = '_backorders' WHERE p.post_type = 'product' AND p.post_status = 'publish' AND p.post_password = '' AND m2.meta_value != 'hidden' " . ( $backorders == 'no' ? "AND m3.meta_value = 'instock'" : "" ) . " AND (m3.meta_value != 'outofstock' OR m4.meta_value = 'yes') ORDER BY p.ID DESC" ); }
Ошибка пропадает. Возможно, сделаете запрос к БД более лёгким или будете делать выборку по 1 000 элементов, к примеру?
Спасибо.
Viewing 7 replies - 1 through 7 (of 7 total)
Viewing 7 replies - 1 through 7 (of 7 total)
- The topic ‘Memory limit’ is closed to new replies.