WordPress database error – mssql

  • Jason Frueh

    (@jfrueh)


    10 years, 5 months ago

    When installing WordPress on MSSQL I’m receiving the below error. I have all of the necessary pre-reqs installed using the wp-db-abstration as described here.

    I have no clue where to look as everything seems to work perfectly up to this point. Any help or ideas would be greatly appreciated!

    Thanks,

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

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Michal Smereczynski

    (@smereczynski)

    10 years, 5 months ago

    Hi jfrueh,
    We are working on this bug in Brandoo (wordpress.brandoo.pl). This thing is caused by changes in 3.7x: http://core.trac.wordpress.org/browser/branches/3.7/src/wp-admin/includes/schema.php

    form line 550.

    I will drop You a line if we patch this translation in wp-db-abstraction.

    paulnguyen574

    (@paulnguyen574)

    10 years, 5 months ago

    Hi every boday;
    Pls guding me how to solve my problem with WP3.7.1
    After config the WP-config.bhb and using FilleZala for uplaod to hosting;
    But I cannot running my site:

    http://www.Paulnguyen574.com

    Alway showing fail:

    “Fatal error: Call to undefined function wp() in /home/u591637287/public_html/wp-blog-header.php on line 14”

    Pls help me soon;

    Thanks

    Moderator t-p

    (@t-p)

    10 years, 5 months ago

    @paulnguyen574,
    Despite any similarity in symptoms, your issue is likely to be completely different because of possible differences in physical servers, hosts, plugins, theme, configurations, etc. Posting in an existing topic prevents from being able to track issues by topic. Also, it’s easier for volunteers to help you if you have your own topic. Thus, if you start your own thread, it is likely to get more responses, specific to your issue.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error – mssql’ is closed to new replies.