Skip Navigation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
12:00 – 20:00 12:00 – 20:00 12:00 – 20:00 12:00 – 20:00 12:00 – 20:00 - -
- - - - - - -

Supporter timezone: Asia/Karachi (GMT+05:00)

This topic contains 1 replies, has 2 voices.

Last updated by Noman 9 months, 2 weeks ago.

Assisted by: Noman.

Author Posts
August 18, 2024 at 8:43 am

benF-16

Background of the issue:
I am trying to install a plugin but I have a plugin conflict. I encountered multiple WordPress database errors and deprecated notices. Here is the error log: WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages' doesn't exist] SELECT l.code, m.locale, l.default_locale FROM wp_icl_languages AS l LEFT JOIN wp_icl_locale_map AS m ON m.code = l.code. Deprecated: Return type of StripeUtilCaseInsensitiveArray::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/CaseInsensitiveArray.php on line 44. Deprecated: Return type of StripeUtilCaseInsensitiveArray::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/CaseInsensitiveArray.php on line 57. Deprecated: Return type of StripeUtilCaseInsensitiveArray::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/CaseInsensitiveArray.php on line 34. Deprecated: Return type of StripeUtilCaseInsensitiveArray::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/CaseInsensitiveArray.php on line 51. Deprecated: Return type of StripeUtilCaseInsensitiveArray::count() should either be compatible with Countable::count(): int, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/CaseInsensitiveArray.php on line 24. Deprecated: Return type of StripeUtilCaseInsensitiveArray::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/CaseInsensitiveArray.php on line 29. Deprecated: Return type of StripeUtilSet::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Util/Set.php on line 40. Deprecated: Return type of StripeStripeObject::offsetExists($k) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/StripeObject.php on line 202. Deprecated: Return type of StripeStripeObject::offsetGet($k) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/StripeObject.php on line 212. Deprecated: Return type of StripeStripeObject::offsetSet($k, $v) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/StripeObject.php on line 197. Deprecated: Return type of StripeStripeObject::offsetUnset($k) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/StripeObject.php on line 207. Deprecated: Return type of StripeStripeObject::count() should either be compatible with Countable::count(): int, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/StripeObject.php on line 218. Deprecated: Return type of StripeStripeObject::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/StripeObject.php on line 422. Deprecated: Return type of StripeCollection::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/lib/stripe-php/lib/Collection.php on line 119. Deprecated: Creation of dynamic property CPSWCompatibilityApple_Pay::$secret_key is deprecated in /home/customer/www/fridja.com/public_html/wp-content/plugins/checkout-plugins-stripe-woo/compatibility/apple-pay.php on line 64. Deprecated: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated in /home/customer/www/fridja.com/public_html/wp-content/plugins/js_composer/include/autoload/vc-pages/automapper.php on line 29. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_languages`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages_translations' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_languages_translations`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages_translations' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_languages_translations`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages_translations' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_languages_translations`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages_translations' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_languages_translations`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_languages_translations' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_languages_translations`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_flags' doesn't exist] SHOW FULL COLUMNS FROM `wp_icl_flags`. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_strings' doesn't exist] SELECT * FROM wp_icl_strings WHERE context = 'Widgets' AND name LIKE 'widget body - %'. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_strings' doesn't exist] SELECT * FROM wp_icl_strings WHERE context = 'Widgets' AND name LIKE 'widget title - %'. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_strings' doesn't exist] ALTER TABLE `wp_icl_strings` ADD INDEX `language_context` ( `context` , `language` ). WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_translate' doesn't exist] ALTER TABLE `wp_icl_translate` CHANGE field_data field_data longtext NOT NULL. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_translate' doesn't exist] ALTER TABLE `wp_icl_translate` CHANGE field_data_translated field_data_translated longtext NOT NULL. WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_translations' doesn't exist] ALTER TABLE `wp_icl_translations` ADD KEY `id_type_language` ( `element_id`, `element_type`, `language_code`). WordPress database error: [Table 'dbtncgcpp9mv4t.wp_icl_translations' doesn't exist] ALTER TABLE `wp_icl_translations` CHANGE `element_type` `element_type` VARCHAR( 36 ) NOT NULL DEFAULT 'post_post' COLLATE 'latin1_swedish_ci'. Fatal error: Uncaught Exception: Table 'dbtncgcpp9mv4t.wp_icl_translations' doesn't exist in /home/customer/www/fridja.com/public_html/wp-content/plugins/sitepress-multilingual-cms/inc/functions.php:698 Stack trace: #0 /home/customer/www/fridja.com/public_html/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade-functions/upgrade-3.1.9.5.php(3): repair_el_type_collate() #1 /home/customer/www/fridja.com/public_html/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade.php(181): include_once('/home/customer/...') #2 /home/customer/www/fridja.com/public_html/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade.php(147): icl_upgrade_version('3.1.9.5') #3 /home/customer/www/fridja.com/public_html/wp-includes/class-wp-hook.php(324): icl_plugin_upgrade('') #4 /home/customer/www/fridja.com/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) #5 /home/customer/www/fridja.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #6 /home/customer/www/fridja.com/public_html/wp-settings.php(555): do_action('plugins_loaded') #7 /home/customer/www/fridja.com/public_html/wp-config.php(83): require_once('/home/customer/...') #8 /home/customer/www/fridja.com/public_html/wp-load.php(50): require_once('/home/customer/...') #9 /home/customer/www/fridja.com/public_html/wp-admin/admin.php(34): require_once('/home/customer/...') #10 /home/customer/www/fridja.com/public_html/wp-admin/plugins.php(10): require_once('/home/customer/...') #11 {main} thrown in /home/customer/www/fridja.com/public_html/wp-content/plugins/sitepress-multilingual-cms/inc/functions.php on line 698. There has been a critical error on this website. Please check your site admin email inbox for instructions.

Symptoms:
I encountered multiple WordPress database errors and deprecated notices. The errors indicate that several tables in the database do not exist, and there are multiple deprecated notices related to the Stripe plugin.

Questions:
How can I resolve the WordPress database errors?
How can I fix the deprecated notices related to the Stripe plugin?

August 18, 2024 at 10:00 am
August 18, 2024 at 10:00 am #16081043

Noman
WPML Supporter since 06/2016

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

I was not receiving a reply in chat so I moved the chat into a forum ticket for follow up. I’ve followed the below steps:

1. Installed/activated the WP PhpMyAdmin plugin on your site.
2. Went to the *_options database table and deleted/renamed the ‘icl_sitepress_settings’ entry. This caused WPML to start over with the setup.
3. Installed the WPML plugins and it works correctly.

I’ve set French as a secondary language to complete the WPML setup wizard, you can change it from the WPML >> Languages page if you want.

Please let me know if this resolves the issue or if you need further assistance with this issue I’ll be more than happy to help.

Thank you for your cooperation

The topic ‘[Closed] WordPress database error – please help’ is closed to new replies.