[Resolved] Uncaught Error: Attempt to assign property “object_id” on bool in

Hi Long,

I got more information from wordpress:
https://wordpress.org/support/topic/utf8mb4_unicode_ci-to-utf8mb4_unicode_520_ci/

I would think the plugin’s source code could be modified to utilize the 520_ci variant. I’m not sure how essential the 520_ci variant is. What’s more essential is that the utf8mb4 charset is used and that all the collations are the same. The importance of 520_ci likely only matters to a few specific languages. Even then, the worst that would happen is alphabetical order of special characters might be incorrect.

The suggested SELECT CONCAT query is supposed to alter the collation of all tables in your DB, so I don’t understand your concern about needing to do so one by one.

Note that not only do tables have assigned collation, the overall DB has a setting and every textual column in every table also has a collation setting. You generally want them all to be the same. I imagine a query similar to the one for tables can be used to alter columns.

Be sure everything is already using utf8mb4 charset (not collation). Do not attempt to change the charset if it’s not already utf8mb4. That kind of change requires the data be re-encoded.

Please make a complete backup of your DB before attempting any sort of change. It’s all too easy to accidentally corrupt things. You need a way to revert back to what you have now.

Has WP Global Cart added their plugin in to your test site? If not I can do that as well.

Hi Long,

My brother came and looked the tables from phpMyAdmin and found that these tables should be changed from your plugin utf8mb4_unicode_ci to utf8mb4_unicode_520_ci if it is okay?

ALTER TABLE sukkianet_wp1.wp_icl_string_positions CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_string_status CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_languages CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translation_downloads CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translation_batches CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translation_status CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_string_packages CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_node CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_string_batches CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_strings CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_content_status CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_cms_nav_cache CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_flags CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translate_job CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_translate_job CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_background_task CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_reminders CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_locale_map CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_core_status CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_languages_translations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_string_translations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_message_status CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sukkianet_wp1.wp_icl_mo_files_domains CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

I just added the WP Global Cart to the test site and I changed all the collations of all tables in phpMyAdmin.
For some reason these 3 tables didn't change from utf8mb4_unicode_ci to utf8mb4_unicode_520_ci:
wp_icl_translate
wp_woocommerce_gpf_google_taxonomy
wp_litespeed_url
The site didn't break and the same problem still exists.
You can send me the private shared info again so I can send the wp-admin and FTP.

I guess you are doing something on the website at the moment? Let me know when you have checked everything. 🙂

Hi Long,

Basel/Xtemos tested your plugin with wordpress default theme 2022 or 2023. I can ask which theme they tested your plugin with if you want?

Btw WP Global Cart plugin coders tested compatibility with your plugin some time ago.
The person was Bigul from your side.
https://onthegosystems.com/team/bigul-malayi/

This was the last messages from WP Global Cart that I got then Rick and Bigul talked together about the plugin codes:
Hi,
We created a test environment, which can be downloaded at hidden link
The mapped domain which would be used is wpml-global-search.ldev

To replicate the issue, go to hidden link and you will notice the products that match the Logo keyword, from 2 different shops. If you go to hidden link and activate the WPML, it will return no returns. That is because the WPML insert into the search MySQL query language arguments, which fails for other sites.

Thank you,
Rick
Support Department
hidden link
contact@wpglobalcart.com