icl_string_packages' doesn't exist

This thread is resolved. Here is a description of the problem and solution.

Problem:

I get the error icl_string_packages' doesn't exist, if I turn on the debug.

Solution:

1. Export the structure of the table from another website.

2. Change the prefix of the table name if it is different.

3. Import it to the site where this table is missing.

You can use this MYSQL code. You should save this code in a file that ends with .sql and then you should import it into your DB. Or you can implement it as an SQL command.

-- Table structure for table `wp_icl_string_packages`
--
 
CREATE TABLE IF NOT EXISTS `wp_icl_string_packages` (
  `ID` bigint(20) unsigned NOT NULL,
  `kind_slug` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `kind` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `title` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `edit_link` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `view_link` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `word_count` varchar(2000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `wp_icl_string_packages`
--
ALTER TABLE `wp_icl_string_packages`
  ADD PRIMARY KEY (`ID`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `wp_icl_string_packages`
--
ALTER TABLE `wp_icl_string_packages`
  MODIFY `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT;

**** Important! Please make a backup of your DB) before you proceed with those steps****

100% of people find this useful.

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.

This topic contains 9 replies, has 4 voices.

Last updated by Iggy 4 years, 9 months ago.

Assisted by: Itamar.

Author	Posts
June 27, 2019 at 10:59 am #4099385
oliverG-5	Hi, i get the error icl_string_packages' doesn't exist, if I turn on the debug. "WordPress database error: [Table 'db00095111.rkwcorp2018_icl_string_packages' doesn't exist] SELECT CONCAT(kind_slug, '-', name) FROM rkwcorp2018_icl_string_packages" Maybe the problem is, that I installed string translation before wpml. I tried all approaches, that I found in the forum here. I uninstalled WPML completly and I used the button on the troubleshooting page. Nothing helped. Is it possible, that you give me a sql command that creates the missing tables? Thanks in advance. Oliver
June 27, 2019 at 11:59 am #4099839
Andrés Supporter Languages: English (English ) Spanish (Español ) French (Français ) Timezone: Europe/Paris (GMT+02:00)	Hello Oliver, Welcome to WPML support forum. As you haven't started translating your content, please go to - WPML > Support. - Troubleshooting. - Reset. x I am about to reset all translation and language data. x Reset and deactivate WPML Best regards, Andrés
June 27, 2019 at 12:04 pm #4099927
oliverG-5	Hi Andrés, I already did this, but it didn't help. And the problem is, that we already started with translations so I can't do it again.
June 27, 2019 at 1:02 pm #4100105
Andrés Supporter Languages: English (English ) Spanish (Español ) French (Français ) Timezone: Europe/Paris (GMT+02:00)	In that case, let's try the following: 1. Para asegurarnos que WPML funcione correctamente, ¿podrías incrementar la Memory Limit y WP Memory Limit a 512M? Si puedes suministrar más recursos, sería ideal. Tus valores actuales son: - MemoryLimit 512M - WP Memory Limit 256M https://wpml.org/home/minimum-requirements/ Edita tu archivo wp-config.php y agrega la siguiente línea: define('WP_MEMORY_LIMIT', '512M'); Muchas veces estos ajustes son bloqueados directamente desde la administración de tu hosting. En ese caso te recomiendo que los contactes directamente y si puedes pedir valores superiores a 128M, sería recomendable. Nota: 128M es el mínimo necesario para WPML sin otros plugins y con un tema por defecto de WordPress. 2. Add this code into your functions.php file: function wpmlsupp_1891_fix_missing_icl_tables() { if( function_exists( 'icl_sitepress_activate' ) ) icl_sitepress_activate(); } add_action( 'wp_footer', 'wpmlsupp_1891_fix_missing_icl_tables' ); - Visit your front-end. - Remove the previous code. Does it help?
June 27, 2019 at 2:19 pm #4100747
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+03:00)	Hi there. Andres asked me to continue with this ticket. So here is what you can do to recreate the _icl_string_packages table. 1. Export the structure of the table from another website. 2. Change the prefix of the table name if it is different. 3. Import it to the site where this table is missing. For your convenience here an export of the structure of this table from my test site. You can use this MYSQL code. You should save this code in a file that ends with .sql and then you should import it into your DB. Or you can implement it as an SQL command. -- -- Table structure for table `wp_icl_string_packages` -- CREATE TABLE IF NOT EXISTS `wp_icl_string_packages` ( `ID` bigint(20) unsigned NOT NULL, `kind_slug` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL, `kind` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL, `name` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL, `title` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL, `edit_link` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `view_link` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_id` int(11) DEFAULT NULL, `word_count` varchar(2000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `wp_icl_string_packages` -- ALTER TABLE `wp_icl_string_packages` ADD PRIMARY KEY (`ID`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `wp_icl_string_packages` -- ALTER TABLE `wp_icl_string_packages` MODIFY `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT; Please remember to change the prefix of the table to the prefix of your DB in case it is different. Please let me know if you have any questions about this issue. Best Regards, Itamar.
June 27, 2019 at 2:24 pm #4100795
oliverG-5	I'm a little afraid, but I'll try it now. I'll create a backup first. I'll let you know, if it worked. Thanks a lot.
June 27, 2019 at 2:34 pm #4100883
oliverG-5	It worked, thank you, thank you 🙂
June 27, 2019 at 2:39 pm #4100907
Itamar Supporter Languages: English (English ) Hebrew (עברית ) Timezone: Asia/Jerusalem (GMT+03:00)	Great, I'm glad that it is solved now! Good luck with your web projects 🙂 Itamar.
July 17, 2019 at 9:14 am #4227985
Iggy	Hmmm, another solution that helped me was to install WPML another plugin called "WPML Translation Management", activate and deactivate.

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.