search

ProjectNami / projectnami

WordPress powered by Microsoft SQL Server
http://projectnami.org
Other
270 stars 138 forks source link

Yoast SEO translations errors #245

Open PHuhn opened 7 years ago

PHuhn commented 7 years ago

I am trying to activate Yoast SEO plug-in and I am getting the following error message:

Warning: preg_replace(): Compilation failed: missing ) at offset 246 in C:\inetpub\WPress005\wp-includes\translations.php on line 1473 Warning: preg_replace(): Compilation failed: missing ) at offset 247 in C:\inetpub\WPress005\wp-includes\translations.php on line 1473 Warning: preg_replace(): Compilation failed: missing ) at offset 247 in C:\inetpub\WPress005\wp-includes\translations.php on line 1473

I just updated to the latest version of 1.6.2 Nami, so I am 4.8.2 WordPress.

patrickebates commented 7 years ago

Let me get the latest version and try to activate it on a test server. May be a bit before I have the opportunity. We've done extensive work before to support Yoast SEO, so I'm curious what may have changed.

PHuhn commented 7 years ago

Hi Patrick: FYI, Yoast has updated the plug-in. I installed a new Nami site and with the updated Yoast SEO, I get the following:

The plugin generated 519 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

So with a fresh install and new version of Yoast, I get something different.

PHuhn commented 7 years ago

Hi Patrick: I turned on debugging and deactivated Yoast SEO and at the top of the form the following:

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot create, drop, enable, or disable more than one constraint, column, index, or trigger named 'wp_bpspro_mscan_mscan_id' in this context. Duplicate names are not allowed. Code - 8168] CREATE TABLE wp_bpspro_mscan ( mscan_id bigint NOT NULL IDENTITY(1,1), mscan_status NVARCHAR(8) NOT NULL default '', mscan_type NVARCHAR(16) NOT NULL default '', mscan_path NVARCHAR(MAX) NOT NULL, mscan_pattern NVARCHAR(MAX) NOT NULL, mscan_skipped NVARCHAR(7) NOT NULL default '', mscan_ignored NVARCHAR(6) NOT NULL default '', mscan_db_table NVARCHAR(64) NOT NULL default '', mscan_db_column NVARCHAR(64) NOT NULL default '', mscan_db_pkid NVARCHAR(MAX) NOT NULL, mscan_time datetime NOT NULL default getdate(), CONSTRAINT [wp_bpspro_mscan_mscan_id] PRIMARY KEY CLUSTERED (mscan_id) WITH (IGNORE_DUP_KEY = OFF), CONSTRAINT [wp_bpspro_mscan_mscan_id] UNIQUE NONCLUSTERED (mscan_id) );

When I activated it the following appears:

[[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot create, drop, enable, or disable more than one constraint, column, index, or trigger named 'wp_bpspro_mscan_mscan_id' in this context. Duplicate names are not allowed. Code - 8168] CREATE TABLE wp_bpspro_mscan ( mscan_id bigint NOT NULL IDENTITY(1,1), mscan_status NVARCHAR(8) NOT NULL default '', mscan_type NVARCHAR(16) NOT NULL default '', mscan_path NVARCHAR(MAX) NOT NULL, mscan_pattern NVARCHAR(MAX) NOT NULL, mscan_skipped NVARCHAR(7) NOT NULL default '', mscan_ignored NVARCHAR(6) NOT NULL default '', mscan_db_table NVARCHAR(64) NOT NULL default '', mscan_db_column NVARCHAR(64) NOT NULL default '', mscan_db_pkid NVARCHAR(MAX) NOT NULL, mscan_time datetime NOT NULL default getdate(), CONSTRAINT [wp_bpspro_mscan_mscan_id] PRIMARY KEY CLUSTERED (mscan_id) WITH (IGNORE_DUP_KEY = OFF), CONSTRAINT [wp_bpspro_mscan_mscan_id] UNIQUE NONCLUSTERED (mscan_id) );

Hope this helps.

dahousecat commented 6 years ago

I'm getting the same error. Here is a full stack trace in case it helps:

wp plugin activate wordpress-seo
PHP Warning:  preg_replace(): Compilation failed: missing ) at offset 246 in /vagrant/dist/wp-includes/translations.php on line 1483
PHP Stack trace:
PHP   1. {main}() /usr/local/bin/wp:0
PHP   2. include() /usr/local/bin/wp:4
PHP   3. include() phar:///usr/local/bin/wp/php/boot-phar.php:11
PHP   4. WP_CLI\bootstrap() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php:23
PHP   5. WP_CLI\Bootstrap\LaunchRunner->process() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/bootstrap.php:74
PHP   6. WP_CLI\Runner->start() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Bootstrap/LaunchRunner.php:23
PHP   7. WP_CLI\Runner->_run_command_and_exit() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:1113
PHP   8. WP_CLI\Runner->run_command() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:388
PHP   9. WP_CLI\Dispatcher\Subcommand->invoke() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:365
PHP  10. call_user_func:{phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425
PHP  11. WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425
PHP  12. call_user_func:{phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89
PHP  13. Plugin_Command->activate() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89
PHP  14. activate_plugin() phar:///usr/local/bin/wp/vendor/wp-cli/extension-command/src/Plugin_Command.php:313
PHP  15. do_action() /vagrant/dist/wp-admin/includes/plugin.php:586
PHP  16. WP_Hook->do_action() /vagrant/dist/wp-includes/plugin.php:453
PHP  17. WP_Hook->apply_filters() /vagrant/dist/wp-includes/class-wp-hook.php:310
PHP  18. wpseo_activate() /vagrant/dist/wp-includes/class-wp-hook.php:286
PHP  19. _wpseo_activate() /vagrant/dist/wp-content/plugins/wordpress-seo/wp-seo-main.php:94
PHP  20. WPSEO_Link_Notifier->manage_notification() /vagrant/dist/wp-content/plugins/wordpress-seo/wp-seo-main.php:186
PHP  21. WPSEO_Link_Notifier->requires_notification() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:46
PHP  22. WPSEO_Link_Query::has_unprocessed_posts() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:125
PHP  23. wpdb->get_var() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-query.php:42
PHP  24. SQL_Translations->translate() /vagrant/dist/wp-includes/wp-db.php:2395
PHP  25. SQL_Translations->translate_incompat_data_type() /vagrant/dist/wp-includes/translations.php:316
PHP  26. preg_replace() /vagrant/dist/wp-includes/translations.php:1483
PHP Warning:  preg_replace(): Compilation failed: missing ) at offset 247 in /vagrant/dist/wp-includes/translations.php on line 1483
PHP Stack trace:
PHP   1. {main}() /usr/local/bin/wp:0
PHP   2. include() /usr/local/bin/wp:4
PHP   3. include() phar:///usr/local/bin/wp/php/boot-phar.php:11
PHP   4. WP_CLI\bootstrap() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php:23
PHP   5. WP_CLI\Bootstrap\LaunchRunner->process() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/bootstrap.php:74
PHP   6. WP_CLI\Runner->start() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Bootstrap/LaunchRunner.php:23
PHP   7. WP_CLI\Runner->_run_command_and_exit() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:1113
PHP   8. WP_CLI\Runner->run_command() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:388
PHP   9. WP_CLI\Dispatcher\Subcommand->invoke() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:365
PHP  10. call_user_func:{phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425
PHP  11. WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425
PHP  12. call_user_func:{phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89
PHP  13. Plugin_Command->activate() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89
PHP  14. activate_plugin() phar:///usr/local/bin/wp/vendor/wp-cli/extension-command/src/Plugin_Command.php:313
PHP  15. do_action() /vagrant/dist/wp-admin/includes/plugin.php:586
PHP  16. WP_Hook->do_action() /vagrant/dist/wp-includes/plugin.php:453
PHP  17. WP_Hook->apply_filters() /vagrant/dist/wp-includes/class-wp-hook.php:310
PHP  18. wpseo_activate() /vagrant/dist/wp-includes/class-wp-hook.php:286
PHP  19. _wpseo_activate() /vagrant/dist/wp-content/plugins/wordpress-seo/wp-seo-main.php:94
PHP  20. WPSEO_Link_Notifier->manage_notification() /vagrant/dist/wp-content/plugins/wordpress-seo/wp-seo-main.php:186
PHP  21. WPSEO_Link_Notifier->requires_notification() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:46
PHP  22. WPSEO_Link_Query::has_unprocessed_posts() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:125
PHP  23. wpdb->get_var() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-query.php:42
PHP  24. SQL_Translations->translate() /vagrant/dist/wp-includes/wp-db.php:2395
PHP  25. SQL_Translations->translate_incompat_data_type() /vagrant/dist/wp-includes/translations.php:316
PHP  26. preg_replace() /vagrant/dist/wp-includes/translations.php:1483
PHP Warning:  preg_replace(): Compilation failed: missing ) at offset 247 in /vagrant/dist/wp-includes/translations.php on line 1483
PHP Stack trace:
PHP   1. {main}() /usr/local/bin/wp:0
PHP   2. include() /usr/local/bin/wp:4
PHP   3. include() phar:///usr/local/bin/wp/php/boot-phar.php:11
PHP   4. WP_CLI\bootstrap() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php:23
PHP   5. WP_CLI\Bootstrap\LaunchRunner->process() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/bootstrap.php:74
PHP   6. WP_CLI\Runner->start() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Bootstrap/LaunchRunner.php:23
PHP   7. WP_CLI\Runner->_run_command_and_exit() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:1113
PHP   8. WP_CLI\Runner->run_command() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:388
PHP   9. WP_CLI\Dispatcher\Subcommand->invoke() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php:365
PHP  10. call_user_func:{phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425
PHP  11. WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php:425
PHP  12. call_user_func:{phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89}() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89
PHP  13. Plugin_Command->activate() phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php:89
PHP  14. activate_plugin() phar:///usr/local/bin/wp/vendor/wp-cli/extension-command/src/Plugin_Command.php:313
PHP  15. do_action() /vagrant/dist/wp-admin/includes/plugin.php:586
PHP  16. WP_Hook->do_action() /vagrant/dist/wp-includes/plugin.php:453
PHP  17. WP_Hook->apply_filters() /vagrant/dist/wp-includes/class-wp-hook.php:310
PHP  18. wpseo_activate() /vagrant/dist/wp-includes/class-wp-hook.php:286
PHP  19. _wpseo_activate() /vagrant/dist/wp-content/plugins/wordpress-seo/wp-seo-main.php:94
PHP  20. WPSEO_Link_Notifier->manage_notification() /vagrant/dist/wp-content/plugins/wordpress-seo/wp-seo-main.php:186
PHP  21. WPSEO_Link_Notifier->requires_notification() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:46
PHP  22. WPSEO_Link_Query::has_unprocessed_posts() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:125
PHP  23. wpdb->get_var() /vagrant/dist/wp-content/plugins/wordpress-seo/admin/links/class-link-query.php:42
PHP  24. SQL_Translations->translate() /vagrant/dist/wp-includes/wp-db.php:2395
PHP  25. SQL_Translations->translate_incompat_data_type() /vagrant/dist/wp-includes/translations.php:316
PHP  26. preg_replace() /vagrant/dist/wp-includes/translations.php:1483
Plugin 'wordpress-seo' activated.
MoatazAbdAlmageed commented 6 years ago

add the following code to wp-config.php

if ( isset( $_GET['debug'] ) && 'debug' == $_GET['debug'] ) {
 ini_set('display_errors','on');
ini_set('error_reporting', E_ALL );
define('WP_DEBUG', true);
define('WP_DEBUG_DISPLAY', true);
}
else {
ini_set('display_errors','Off');
ini_set('error_reporting', E_ALL );
define('WP_DEBUG', false);
define('WP_DEBUG_DISPLAY', false);
}

usage

http://yousite.com/?debug=debug

reference

https://wordpress.stackexchange.com/questions/170055/how-to-display-error-on-specific-template

RehanSaeed commented 6 years ago

Also getting this error. Are there any workarounds?