Please make sure to update to WPML 4.3.6 and check our list of Known Issues before reporting

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 7 replies, has 2 voices.

Last updated by Riffaz 1 month, 4 weeks ago.

Assigned support staff: Riffaz.

Author Posts
November 11, 2019 at 3:06 pm #4926123

lauraN-2

Hi,

We're trying to install WPML but the minute we upload it we get the error that the site is getting technical difficulties.

It doesn't matter if we upload the newest version or an older one. Nor if we upload it through the WordPress backend or FTP. The entire website just stops working.

Do you know what might cause this issue?

Thanks!

November 12, 2019 at 6:34 am #4929123

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

Thank you for contacting WPML support.

Please enable the WP Debug mode https://wpml.org/documentation/support/debugging-wpml/ and let me know the errors you are getting.

Regards,
Riffaz.

November 13, 2019 at 12:02 pm #4938657

lauraN-2

We've enabled debug mode and reinstalled the plugin. Here are the errors we got on the website.

WordPress database error: [Table 'lauralisa_bb.bbw_icl_languages' doesn't exist]
SELECT l.code, l.id, english_name, nt.name AS native_name, major, active, default_locale, encode_url, tag, lt.name AS display_name FROM bbw_icl_languages l JOIN bbw_icl_languages_translations nt ON ( nt.language_code = l.code AND nt.display_language_code = l.code ) LEFT OUTER JOIN bbw_icl_languages_translations lt ON l.code=lt.language_code WHERE ( lt.display_language_code = 'nl' OR (lt.display_language_code = 'en' AND NOT EXISTS ( SELECT * FROM bbw_icl_languages_translations ls WHERE ls.language_code = l.code AND ls.display_language_code = 'nl' ) ) ) GROUP BY l.code ORDER BY english_name ASC

WordPress database error: [Table 'lauralisa_bb.bbw_icl_languages' doesn't exist]
SELECT l.code, l.id, english_name, nt.name AS native_name, major, active, default_locale, encode_url, tag, lt.name AS display_name FROM bbw_icl_languages l JOIN bbw_icl_languages_translations nt ON ( nt.language_code = l.code AND nt.display_language_code = l.code ) LEFT OUTER JOIN bbw_icl_languages_translations lt ON l.code=lt.language_code WHERE ( lt.display_language_code = 'nl' OR (lt.display_language_code = 'en' AND NOT EXISTS ( SELECT * FROM bbw_icl_languages_translations ls WHERE ls.language_code = l.code AND ls.display_language_code = 'nl' ) ) ) GROUP BY l.code ORDER BY english_name ASC

WordPress database error: [Table 'lauralisa_bb.bbw_icl_locale_map' doesn't exist]
SELECT code, locale FROM bbw_icl_locale_map

WordPress database error: [Table 'lauralisa_bb.bbw_icl_languages' doesn't exist]
SELECT code, default_locale FROM bbw_icl_languages WHERE code = 'nl'

Fatal error: Uncaught Exception: Table 'lauralisa_bb.bbw_icl_translations' doesn't exist in /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/functions.php:674 Stack trace: #0 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade-functions/upgrade-3.1.9.5.php(3): repair_el_type_collate() #1 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade.php(151): include_once('/home/lauralisa...') #2 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade.php(121): icl_upgrade_version('3.1.9.5') #3 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-includes/class-wp-hook.php(286): icl_plugin_upgrade('') #4 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(NULL, Array) #5 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-includes/plugin.php(465): WP_ in /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/functions.php on line 674

Warning: file_exists(): open_basedir restriction in effect. File(WC_Plugin_Updates.php) is not within the allowed path(s): (/home/lauralisa/:/tmp:/var/tmp:/usr/local/lib/php/:/usr/local/php55/lib/php/) in /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/wp-defender/vendor/hammer/vendor/maxmind-db/reader/autoload.php on line 36
The site is experiencing technical difficulties. Please check your site admin email inbox for instructions.

November 13, 2019 at 1:19 pm #4939441

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

Getting back to work, as you had a previous version of WPML, if you didn't reset it and uninstall it, there may be some old tables and others missing. As you don't longer have the initial version of the plugin you had installed, let's try the following script that will help us.

- Open your functions.php file.
- Add the following code:

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' );

- Save the file and upload it.
- Visit your front end.
- Remove the previous code from your functions.php.

Does the tables were created and those messages disappeared ?

Regards,

November 14, 2019 at 10:21 am #4945421

lauraN-2

Hi,

We've done as you said and tested it but we still get the following error
Fatal error: Uncaught Exception: Table 'lauralisa_bb.bbw_icl_translations' doesn't exist in /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/functions.php:674 Stack trace: #0 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade-functions/upgrade-3.1.9.5.php(3): repair_el_type_collate() #1 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade.php(151): include_once('/home/lauralisa...') #2 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/upgrade.php(121): icl_upgrade_version('3.1.9.5') #3 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-includes/class-wp-hook.php(286): icl_plugin_upgrade('') #4 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(NULL, Array) #5 /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-includes/plugin.php(465): WP_ in /home/lauralisa/domains/lauralisa.nl/public_html/bb/wp-content/plugins/sitepress-multilingual-cms/inc/functions.php on line 674

November 14, 2019 at 11:44 am #4946279

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

This means you are missing some tables in your database which supposed to be created during the installation.

Is this a fresh installation?
If yes, please disable all WPML plugins.
delete them.
delete all the tables that have _ICL_
download fresh copies from https://wpml.org/account/downloads/
Install and activate.

Before doing that make sure your hosting plan meets the requirements : https://wpml.org/home/minimum-requirements/

Let me know how it goes.

Regards,

November 25, 2019 at 12:02 pm #5011741

lauraN-2

WPML has never been installed on this website before, we've used fresh copies as you said. But it doesn't work.

November 25, 2019 at 12:55 pm #5012203

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

Thank you for testing.

Did you remove the ICL tables and try again as explained here? https://wpml.org/forums/topic/wpml-cant-be-installed/#post-4946279

What is the error messages you are seeing if you enable the WP Debug mode now?

Regards,

The topic ‘[Closed] WPML can't be installed’ is closed to new replies.