[Resolved] Image resize issue

[Author]

Posts

[Pete]

Hi there,

We are trying to recreate a Legacy View using Blocks. we need to create a grid like we already have, no issue generally however with Legacy we 'can' control the image size, with a block there is a handy option to add a custom size. See screen shot.

This function has never worked for us, on our Elementor sites and now on a site with the Kadence Theme using Blocks.

We have to use a background image as many are different sizes. We could use a container block with a background image however the image only needs to be 590px wide, yet the image is actually 1600px sometimes larger.

Can I ask, has the function ever worked? The Toolset Facebook group seem to think so.

We have disabled all Plugins and tested again, still it didn't work.
Checked with our server company and all the Toolset conditions are being met.

We have to use a View setup like shown, this because we use URL Parameters in the setup of our site and one View works with many page variations.

Any thoughts would be great.

[Luo Yang]

Hello,

The problem you mentioned above is abnormal, please check these:
1) Make sure your webserver has installed PHP image tools, for example PHP GD library or PHP ImageMagick library, you can check it in the WordPress site health page:
Dashboard-> Tools-> Site Health-> Info, in row "Media Handling", check if your webserver can handle such a big image file.

2) Also check if there is any PHP error in your website:
https://toolset.com/documentation/programmer-reference/debugging-sites-built-with-toolset/#php-debugging
section "PHP Debugging"

[Pete]

Hi there Luo,

Ok checked what you suggested. ImageMagick seems to be there however is this right and as it needs to be?
See attached.

You mentioned - 2) Also check if there is any PHP in your website:

I have no idea what I would be checking for.

[Luo Yang]

Sorry, please check if there is any PHP errors in your website, see the document I mentioned above:
https://toolset.com/documentation/programmer-reference/debugging-sites-built-with-toolset/#php-debugging
section "PHP Debugging"

And make sure you are using the latest version of Toolset plugins, you can download them here:
https://toolset.com/account/downloads/

[Pete]

Hi Luo,

I ran a php report and this came back with a bunch of warnings, these like

09-May-2021 06:44:04] WARNING: child 46 said into stderr: "NOTICE: PHP message: PHP Warning: ignore_user_abort() has been disabled for security reasons in /wordpress/wp-cron.php on line 19"
[09-May-2021 06:44:04] WARNING: child 45 said into stderr: "NOTICE: PHP message: WordPress database error Table 'db8480173223.wp_xmr5x8qh7h_toolset_relationships' doesn't exist for query SELECT "
[09-May-2021 06:44:04] WARNING: child 45 said into stderr: " relationships.id AS id,"
[09-May-2021 06:44:04] WARNING: child 45 said into stderr: " relationships.slug AS slug,"
[09-May-2021 06:44:04] WARNING: child 45 said into stderr: " relationships.display_name_plural AS display_name_plural,"
[09-May-2021 06:44:04] WARNING: child 45 said into stderr: " relationships.display_name_singular AS display_name_singular,"
[09-May-2021 06:44:04] WARNING: child 45 said into stderr: " relationships.driver AS driver,"

Now I thought this was due to a theme issue so reached out to Kadence however they have come back with....

--------

Thank you for reaching out.

There seems to be Toolset database errors. I suggest you reach out to the plugin support to address the issue.

Regards,
Chito

--------

I know nothing about php or databases so can you shine any light on what may be the issue here please?

I can't for some reason upload the php report as an attachment.

[Luo Yang]

According to the debug logs you mentioned above, there is a database table missing in your website database: wp_xmr5x8qh7h_toolset_relationships.

The problem is abnormal, please try these:
1) Backup your website database,
2) Delete Toolset Types plugin, all Toolset Settings are saved in your website database, it is safe to delete plugin files.
3) Install the latest version of Toolset Types plugin manually, you can download it here:
https://toolset.com/account/downloads/
4) Upgrade all Toolset plugins in your website by following our document:
https://toolset.com/faq/how-to-install-and-register-toolset/#automatic-installation-once-you-have-types-plugin-installed

If the problem still persists, please provide a copy of your website database dump file in below private message box, you can put the package files in your own google drive disk, share the link only, I need to test and debug it in my localhost, thanks

[Luo Yang]

I have tried the database dump file in my localhost, there is a mysql error when import it, so it is not valid for debug, and there are some database tables are still using old post type relationships, please try to upgrade your website post type relationship to new version:
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/how-to-migrate-your-site-to-new-post-relationships/

go to the Toolset -> Relationships page and you’ll see the following migration prompt.

If you still need assistance for it, please provide your website credentials in below private message box, I need to export the database dump file from your website, thanks

[Luo Yang]

For the original problem of this thread:
Image resize issue:
I have tried these in your website, open the home page in front-end, click "Search" button, it redirect me to below URL:
hidden link
All images are in correct size 746*520, see my screenshot image-size.JPG

Can you confirm it?

For the MYSQL problem, there are two Toolset database tables are missing in your website, I have tried these:
1) Install the "WP phpMyAdmin" plugin:
https://wordpress.org/plugins/wp-phpmyadmin-extension/

2) Run below SQL to create those two tables:

CREATE TABLE `wp_xmr5x8qh7h_toolset_relationships` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(190) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `driver` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `parent_domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `parent_types` bigint unsigned NOT NULL DEFAULT '0',
  `child_domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `child_types` bigint unsigned NOT NULL DEFAULT '0',
  `intermediary_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `ownership` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'none',
  `cardinality_parent_max` int NOT NULL DEFAULT '-1',
  `cardinality_parent_min` int NOT NULL DEFAULT '0',
  `cardinality_child_min` int NOT NULL DEFAULT '0',
  `cardinality_child_max` int NOT NULL DEFAULT '-1',
  `is_distinct` tinyint(1) NOT NULL DEFAULT '0',
  `scope` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `origin` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_name_parent` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_name_child` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_name_intermediary` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_parent_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_child_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_parent_plural` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_child_plural` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `needs_legacy_support` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `autodelete_intermediary` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `slug` (`slug`),
  KEY `is_active` (`is_active`),
  KEY `needs_legacy_support` (`needs_legacy_support`),
  KEY `parent` (`parent_domain`,`parent_types`),
  KEY `child` (`child_domain`,`child_types`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wp_xmr5x8qh7h_toolset_connected_elements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `element_id` bigint unsigned NOT NULL,
  `domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `wpml_trid` bigint unsigned DEFAULT NULL,
  `lang_code` varchar(7) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  `group_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `element` (`domain`,`element_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

3) remove the "WP phpMyAdmin" plugin

Please test again, check if the problem is fixed, thanks

[Pete]

Hi Luo,

Thank you so far, I'll check ref 1. in a moment however I do not know what you mean ref:

2) Run below SQL to create those two tables:

I have installed WP phpMyAdmin as you suggested and I see this screen.

However what do I do what you say 'Run below SQL to create those two tables:'

Never touched this kind of thing in the past, total novice to this area.

Sorry, I just don;t know what you mean ref this.

[Luo Yang]

You can click the button "Enter Phpmyadmin", then click "SQL" tab, and copy/paste the SQL query I mentioned above, and execute, if you need more assistance for it, please provide the new website credentials in below private message box.

[Pete]

Luo,

I can see a message in my email from you with further instructions and if I still need help to supply you details.

This message is not appearing here. I did as you asked and got the screen below.
Starting to worry I'm causing more issues than solving.

I did supply access details in previous private message.

[Luo Yang]

Do not need to worry about the message you mentioned above, it did not take any effect yet, you just need to click the database name "db8480173223" in the left sidebar, then click "SQL" tab, and execute the SQL query I mentioned above.

And I have checked again in the test site you provided above, those two database tables have already been created, so you don't need to create them again.

As I mentioned above, if you need apply same change in another website, please provide the new website credentials in below private message box.

[Pete]

Hi Luo,

Ok thank you. I removed the plugin based on the point you said...
And I have checked again in the test site you provided above, those two database tables have already been created, so you don't need to create them again.

To confirm this for the dev site: hidden link

I just ran a php error report and this a very small sample of the very long report.

This I guess suggests toolset_relationships' doesn't exist

Am I right this isn't sorted?

[12-May-2021 05:38:28] WARNING: child 907 said into stderr: "NOTICE: PHP message: PHP Warning: ignore_user_abort() has been disabled for security reasons in /wordpress/wp-cron.php on line 19"
176.250.243.201 - 12/May/2021:05:38:27 +0000 "GET fabholcottages.flywheelsites.com/wp-content/uploads/fvm-cache/min/1620663039-css174fd0222d6d1ab9060543ff921bc934688316158d9830c3794a9c3c36ae7.css" 404 /www/index.php 66043712 3145280 2357.339 2048 19.94%
35.246.7.182 - 12/May/2021:05:38:28 +0000 "POST fabholcottages.flywheelsites.com/wp-cron.php?doing_wp_cron=1620797908.5748488903045654296875" 200 /www/.wordpress/wp-cron.php 66043712 3145280 2809.800 2048 7.47%
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: "NOTICE: PHP message: WordPress database error Table 'db8480173223.wp_xmr5x8qh7h_toolset_relationships' doesn't exist for query SELECT "
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.id AS id,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.slug AS slug,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.display_name_plural AS display_name_plural,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.display_name_singular AS display_name_singular,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.driver AS driver,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.parent_domain AS parent_domain,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.child_domain AS child_domain,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.intermediary_type AS intermediary_type,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.ownership AS ownership,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_parent_max AS cardinality_parent_max,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_parent_min AS cardinality_parent_min,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_child_max AS cardinality_child_max,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_child_min AS cardinality_child_min,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.is_distinct AS is_distinct,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.scope AS scope,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.origin AS origin,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.role_name_parent AS role_name_parent,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.role_name_child AS rol..."
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: "NOTICE: PHP message: WordPress database error Table 'db8480173223.wp_xmr5x8qh7h_toolset_relationships' doesn't exist for query SELECT "
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.id AS id,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.slug AS slug,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.display_name_plural AS display_name_plural,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.display_name_singular AS display_name_singular,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.driver AS driver,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.parent_domain AS parent_domain,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.child_domain AS child_domain,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.intermediary_type AS intermediary_type,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.ownership AS ownership,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_parent_max AS cardinality_parent_max,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_parent_min AS cardinality_parent_min,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_child_max AS cardinality_child_max,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.cardinality_child_min AS cardinality_child_min,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.is_distinct AS is_distinct,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.scope AS scope,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.origin AS origin,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.role_name_parent AS role_name_parent,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.role_name_child AS rol..."
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: "NOTICE: PHP message: WordPress database error Table 'db8480173223.wp_xmr5x8qh7h_toolset_relationships' doesn't exist for query SELECT "
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.id AS id,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.slug AS slug,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.display_name_plural AS display_name_plural,"
[12-May-2021 05:38:53] WARNING: child 907 said into stderr: " relationships.display_name_singular AS display_name_singular,"

[Luo Yang]

Please provide the FTP/SFTP access of your test site, I need to check the PHP debug logs in your website, thanks

[Pete]

Hi there Luo,

Again I can see your latest request for FTP access in my emails, but not here in the ticket system.

I can't supply you login info unless secure message????