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?
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.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.