Hobbes23

Forum Replies Created

Viewing 1 replies (of 1 total)
  • Forum: Fixing WordPress
    In reply to: 4.2 broke MSSQL

    Petr Barták, thanks! That helped a lot!

    Yet when I try to install a new WP site with MSSQL, I’m still getting this at setup:

    WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘,’.]
    DELETE a, b FROM wp_options a, wp_options b WHERE a.option_name LIKE N’\_transient\_%1$s\_transient\_timeout\_%2$s_transient_timeout_’, SUBSTRING( a.option_name, 12 ) ) AND b.option_value < 1442217761

    WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘,’.]
    DELETE a, b FROM wp_options a, wp_options b WHERE a.option_name LIKE N’\_site\_transient\_%1$s\_site\_transient\_timeout\_%2$s_site_transient_timeout_’, SUBSTRING( a.option_name, 17 ) ) AND b.option_value < 1442217761

    This is WP 4.3 install.
    I even tried this tip:
    https://www.sudhirtiwari.com/wordpress/how-to-install-wordpress-on-internet-information-services-iis/

    – Change code in wp-content/mu-plugins/wp-db-abstraction/translations/sqlsrv/translations.php at line #726 .

    $pattern = ‘/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*)(;{0,1})$/is’;

    to

    $pattern = ‘/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*);{0,1}$/is’;

Viewing 1 replies (of 1 total)