WordPress MS-SQL Database Error on successful installation

  • I have installed WordPress on Windows Server running IIS 7.5 using Microsoft SQL Server 2008 R2. The installation completes with the Success! message, BUT above it there is the following two SQL error:-

    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 < 1392973460

    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 < 1392973460

    The system itself appears to be working correctly. I can load and populate themes without problems.
    What are these errors really telling me ?

  • The topic ‘WordPress MS-SQL Database Error on successful installation’ is closed to new replies.