Return to previous page

Fatal Php Error caused by the Swatch plugin

This topic has 5 replies, 2 voices, and was last updated 1 years, 1 months ago ago by Rose Tyler

jimmy

Participant

November 13, 2023 at 15:25

Hi,

I got an error every time I tried to open a product editing page, for example: https://www.peilishop.com/wp-admin/post.php?post=61679&action=edit, below the error message:

Line 2349
Message Uncaught TypeError: mysqli::real_connect(): Argument #5 ($port) must be of type ?int, string given in /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wpdb.php:2349 Stack trace: #0 [internal function]: mysqli->real_connect() #1 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wpdb.php(2349): mysqli_query() #2 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wpdb.php(2263): wpdb->_do_query() #3 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wpdb.php(3107): wpdb->query() #4 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-admin/includes/template.php(720): wpdb->get_col() #5 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-admin/includes/meta-boxes.php(825): meta_form() #6 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-admin/includes/template.php(1456): post_custom_meta_box() #7 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-admin/edit-form-advanced.php(714): do_meta_boxes() #8 /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-admin/post.php(206): require(‘/home/612627.cl…’) #9 {main} thrown
File /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wpdb.php

When I contacted Cloudway, they replied that this plugin “st-woo-swatches” is causing the crash:

[0x00007f3d47c15500] get_available_variation() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-content/plugins/woocommerce/includes/class-wc-product-variable.php:326
[0x00007f3d47c15430] get_available_variations() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-content/plugins/et-core-plugin/packages/st-woo-swatches/public/partials/class-st-woo-shop.php:64
[0x00007f3d47c15140] loop_swatch() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wp-hook.php:324
[0x00007f3d47c15060] apply_filters() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wp-hook.php:348
[0x00007f3d47c14ff0] do_action() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/plugin.php:517
[0x00007f3d47c14f00] do_action() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-content/plugins/et-core-plugin/packages/st-woo-swatches/public/partials/class-st-woo-shop.php:44
[0x00007f3d47c14ea0] {closure}() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wp-hook.php:324
[0x00007f3d47c14dc0] apply_filters() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/class-wp-hook.php:348
[0x00007f3d47c14d50] do_action() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-includes/plugin.php:517
[0x00007f3d47c14c70] do_action() /home/612627.cloudwaysapps.com/eerwjyhrug/public_html/wp-content/themes/xstore/woocommerce/content-product.php:783

Since I’ve never installed this plugin, I am not sure whether this plugin is built into your theme, please let me know if you can fix it. Currently, I am running on the latest PHP 8.2

Thanks,
Jimmy

#373621 Copied Theme version: 9.2.3 WooCommerce version: 8.2.1

4 Answers

Rose Tyler

Support staff

November 13, 2023 at 15:34

Hello, Jimmy,

Thank you for reaching out to us with your concern.

Please provide the URL of any product that can’t be edited, temporary wp-admin and FTP access, so we can take a closer look.

To provide wp-admin access, you can create a new user account with administrator role via the Dashboard, and provide us with the username and password via the Private Content area.
To create FTP access (FTP host, FTP username, FTP password, FTP port, FTP encryption) , please contact your hosting provider for assistance.

Kind Regards,
8theme team

#373625 Copied

jimmy

Participant

November 14, 2023 at 00:35

Here is the credential for the wp admin and SFTP

Please contact administrator
for this information.

#373658 Copied

Rose Tyler

Support staff

November 15, 2023 at 08:28

Hello, Jimmy,

We wish to inform you that your inquiry has been forwarded to another specialist for a more detailed review.
Please be patient and do not change access.

Kind Regards,
8theme team

#373802 Copied

Rose Tyler

Support staff

November 15, 2023 at 18:04

Hello, Jimmy,

1 / Please downgrade the PHP version to 8.0.

2/ Ask your hosting provider to increase the Maximum execution time (we added a screenshot of the fatal error into the Private Content area).

3/ Disable all 3rd-party plugins and check how the edit works then.

Kind Regards,
8theme team

Please contact administrator
for this information.

#373845 Copied
Tagged: best selling woocommerce themes, fix swatch plugin error, php error solution, swatch plugin php error, troubleshoot woocommerce php error, woocommerce themes fatal error
Viewing 5 results - 1 through 5 (of 5 total)