Internal server error
-
my checkout page is just spinning, using chrome and the developer tools i get this message
jquery.js?ver=1.12.3:4 POST https://domainname/wp-admin/admin-ajax.php?action=update_shipping_method 500 (Internal Server Error)
wp config has
these define(‘WP_MEMORY_LIMIT’,’356M’);
define(‘WP_MAX_MEMORY_LIMIT’,’512M’);
and php settings are the samereloaded wp and woocomerce, and eway gateway(woo version) plugin and no other plugins
but checkout will not show shipping costs or allow checkout, just sits tehre spinning, screenshot is hereAlos getting errors in the error log that refer to memory issues like this, not sure if they are related.
‘[30-May-2016 19:14:52 UTC] PHP Warning: mysqli_query(): (HY000/2008): MySQL client ran out of memory in /home/username/public_html/wp-includes/wp-db.php on line 1811’
Can anyone help
thanks
ian
-
Have you asked your host about “MySQL client ran out of memory”?
Also need you to share your report from https://ww.wp.xz.cn/support/topic/before-posting-gather-the-following-details?replies=1 and see if there are other errors logged after enabling WP_DEBUG https://ww.wp.xz.cn/support/topic/how-to-debug-issues-after-updates?replies=1
hello
i deleted a heap of unneeded database tables and unneeded folders, still getting the memory errors. The webhost says that it is not a mysql memory issue but a wordpress woocommerce issue.
–Upon checking, your files are consuming too much php memory. You need to get rid of unwanted files or get a developer to optimise your website or files and design it to use less memory.
–It doesn’t really matter if you are using the beta or the standard wordpress. Problem relies with how the files and memory are used.===============
website is https://OZWOOL.NET
‘`
### WordPress Environment ###Home URL: http://ozwool.net
Site URL: http://ozwool.net
WC Version: 2.5.5
Log Directory Writable: ✔
WP Version: 4.5.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: ✔
Language: en_AU### Server Environment ###
Server Info: Apache/2.2.24 (Unix) mod_ssl/2.2.24 OpenSSL/1.0.0-fips mod_bwlimited/1.4 mod_perl/2.0.6 Perl/v5.10.1
PHP Version: 5.5.11
PHP Post Max Size: 16 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
SUHOSIN Installed: –
MySQL Version: 5.5.48
Max Upload Size: 8 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔### Database ###
WC Database Version: 2.5.5
:
woocommerce_sessions: ✔
woocommerce_api_keys: ✔
woocommerce_attribute_taxonomies: ✔
woocommerce_termmeta: ✔
woocommerce_downloadable_product_permissions: ✔
woocommerce_order_items: ✔
woocommerce_order_itemmeta: ✔
woocommerce_tax_rates: ✔
woocommerce_tax_rate_locations: ✔### Active Plugins (7) ###
Contact Form 7: by Takayuki Miyoshi – 4.4.2
Responsive Column Widgets: by Michael Uno (miunosoft) – 1.2.5
Woocommerce Shipping Calculator On Product Page: by Magerips – 1.2
Widget CSS Classes: by C.M. Kendrick – 1.3.0
Booster for WooCommerce: by Algoritmika Ltd – 2.5.1
WooCommerce: by WooThemes – 2.5.5
WooThemes Helper: by WooThemes – 1.6.2### Settings ###
Force SSL: ✔
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2### API ###
API Enabled: ✔
API Version: 3.1.0### WC Pages ###
Shop Base: #151 – /shop/
Basket: #4474 – /cart-2/
Checkout: #4475 – /checkout-2/
My Account: #4476 – /my-account-2/### Taxonomies ###
Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)### Theme ###
Name: Sommerce
Version: 3.0.7
Author URL: http://yithemes.com/
Child Theme: ✕ – If you’re modifying WooCommerce on a parent theme you didn’t build personally
then we recommend using a child theme. See: How to create a child themeWooCommerce Support: ✔
### Templates ###
Overrides: sommerce/woocommerce/archive-product.php
sommerce/woocommerce/cart/cart-shipping.php
sommerce/woocommerce/cart/cart.php
sommerce/woocommerce/cart/cross-sells.php
sommerce/woocommerce/content-product.php
sommerce/woocommerce/content-product_cat.php
sommerce/woocommerce/content-single-product.php
sommerce/woocommerce/global/breadcrumb.php
sommerce/woocommerce/global/form-login.php
sommerce/woocommerce/global/sidebar.php
sommerce/woocommerce/global/wrapper-end.php
sommerce/woocommerce/global/wrapper-start.php
sommerce/woocommerce/loop/add-to-cart.php
sommerce/woocommerce/loop/no-products-found.php
sommerce/woocommerce/loop/pagination.php
sommerce/woocommerce/loop/price.php
sommerce/woocommerce/loop/sale-flash.php
sommerce/woocommerce/single-product/add-to-cart/external.php
sommerce/woocommerce/single-product/add-to-cart/grouped.php
sommerce/woocommerce/single-product/add-to-cart/simple.php
sommerce/woocommerce/single-product/add-to-cart/variable.php
sommerce/woocommerce/single-product/meta.php
sommerce/woocommerce/single-product/price.php
sommerce/woocommerce/single-product/product-image.php
sommerce/woocommerce/single-product/product-thumbnails.php
sommerce/woocommerce/single-product/related.php
sommerce/woocommerce/single-product/review.php
sommerce/woocommerce/single-product/sale-flash.php
sommerce/woocommerce/single-product/share.php
sommerce/woocommerce/single-product/short-description.php
sommerce/woocommerce/single-product/tabs/description.php
sommerce/woocommerce/single-product/tabs/tabs.php
sommerce/woocommerce/single-product/up-sells.php
sommerce/woocommerce/single-product-reviews.php
sommerce/woocommerce/single-product.php
sommerce/woocommerce/taxonomy-product_cat.php
sommerce/woocommerce/taxonomy-product_tag.php`’
recent debug log details
‘[30-May-2016 20:21:51 UTC] PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 139476 bytes) in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1775
[30-May-2016 20:21:56 UTC] PHP Fatal error: Out of memory (allocated 2883584) (tried to allocate 869223 bytes) in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1775
[30-May-2016 20:22:16 UTC] WordPress database error Duplicate key name ‘attribute_name’ for query ALTER TABLE ozshop_woocommerce_attribute_taxonomies ADD KEY attribute_name (attribute_name(191)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:16 UTC] WordPress database error Duplicate key name ‘meta_key’ for query ALTER TABLE ozshop_woocommerce_termmeta ADD KEY meta_key (meta_key(191)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:17 UTC] WordPress database error Duplicate key name ‘download_order_key_product’ for query ALTER TABLE ozshop_woocommerce_downloadable_product_permissions ADD KEY download_order_key_product (product_id,order_id,order_key(191),download_id) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:17 UTC] WordPress database error Duplicate key name ‘meta_key’ for query ALTER TABLE ozshop_woocommerce_order_itemmeta ADD KEY meta_key (meta_key(191)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:17 UTC] WordPress database error Duplicate key name ‘tax_rate_country’ for query ALTER TABLE ozshop_woocommerce_tax_rates ADD KEY tax_rate_country (tax_rate_country(191)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:17 UTC] WordPress database error Duplicate key name ‘tax_rate_state’ for query ALTER TABLE ozshop_woocommerce_tax_rates ADD KEY tax_rate_state (tax_rate_state(191)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:17 UTC] WordPress database error Duplicate key name ‘tax_rate_class’ for query ALTER TABLE ozshop_woocommerce_tax_rates ADD KEY tax_rate_class (tax_rate_class(191)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:22:17 UTC] WordPress database error Duplicate key name ‘location_type_code’ for query ALTER TABLE ozshop_woocommerce_tax_rate_locations ADD KEY location_type_code (location_type(40),location_code(90)) made by activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[30-May-2016 20:24:08 UTC] PHP Fatal error: Out of memory (allocated 112721920) (tried to allocate 410111 bytes) in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1775
[30-May-2016 20:24:08 UTC] PHP Fatal error: Out of memory (allocated 140247040) (tried to allocate 12288 bytes) in /home/ozwooln/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 851
[30-May-2016 20:25:25 UTC] PHP Notice: woocommerce_items_in_cart cookie cannot be set – headers already sent by /home/ozwooln/public_html/wp-includes/formatting.php on line 4512 in /home/ozwooln/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 502
[30-May-2016 20:25:25 UTC] PHP Notice: woocommerce_cart_hash cookie cannot be set – headers already sent by /home/ozwooln/public_html/wp-includes/formatting.php on line 4512 in /home/ozwooln/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 502
[30-May-2016 20:25:25 UTC] PHP Notice: wp_woocommerce_session_9f52231ac160727df48fb95d131ff3c0 cookie cannot be set – headers already sent by /home/ozwooln/public_html/wp-includes/formatting.php on line 4512 in /home/ozwooln/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 502
[30-May-2016 20:26:41 UTC] PHP Fatal error: Out of memory (allocated 59768832) (tried to allocate 362105 bytes) in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1775
[30-May-2016 20:26:41 UTC] PHP Fatal error: Out of memory (allocated 76808192) (tried to allocate 362105 bytes) in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1775
[30-May-2016 20:27:07 UTC] PHP Warning: mysqli_query(): (HY000/2008): MySQL client ran out of memory in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1811
[30-May-2016 20:27:07 UTC] PHP Warning: mysqli_query(): (HY000/2008): MySQL client ran out of memory in /home/ozwooln/public_html/wp-includes/wp-db.php on line 1811′I have never seen MYSQL run out of memory before, very few results on google for that too https://www.google.co.uk/?ion=1&espv=2#q=%22MySQL+client+ran+out+of+memory%22+woocommerce
What are you doing on the site when it occurs?
The topic ‘Internal server error’ is closed to new replies.
