Title: [Plugin: WP Db Abstraction] Database Update Issues
Last modified: August 20, 2016

---

# [Plugin: WP Db Abstraction] Database Update Issues

 *  [shaythai](https://wordpress.org/support/users/shaythai/)
 * (@shaythai)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/)
 * When upgrading the database after the move to 3.4 I got this error:
 * WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]
   Incorrect syntax near ‘)’.]
    ALTER TABLE wp_sp_blogterms ADD );
 * WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]
   Incorrect syntax near ‘)’.]
    ALTER TABLE wp_sp_blogterm_taxonomy ADD );
 * WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]
   Incorrect syntax near ‘)’.]
    ALTER TABLE wp_sp_blogoptions ADD CONSTRAINT [_option_name]
   UNIQUE NONCLUSTERED (option_name) );
 * Also getting an 500 Internal Server error when trying to go to the Dashboard.
   Plus this error when getting to various areas of the admin areas:
 * WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]
   Incorrect syntax near the keyword ‘LIKE’.]
    SELECT COUNT(NULLIF(meta_value LIKE‘%”
   administrator”%’, false) as Computed), COUNT(NULLIF(meta_value LIKE ‘%”editor”%’,
   false) as Computed), COUNT(NULLIF(meta_value LIKE ‘%”author”%’, false) as Computed),
   COUNT(NULLIF(meta_value LIKE ‘%”contributor”%’, false) as Computed), COUNT(NULLIF(
   meta_value LIKE ‘%”subscriber”%’, false) as Computed), COUNT(*) as Computed FROM
   wp_blogusermeta WHERE meta_key LIKE ‘wp_blogcapabilities’
 * [http://wordpress.org/extend/plugins/wordpress-database-abstraction/](http://wordpress.org/extend/plugins/wordpress-database-abstraction/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Gideon7](https://wordpress.org/support/users/gideon7/)
 * (@gideon7)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/#post-2812787)
 * I get the same error on a fresh install of WordPress 3.4.1 on IIS 7.5 with SQL
   Server 2008 R2. Whenever I try to add a new user I get:
 *     ```
       WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'LIKE'.]
       SELECT COUNT(NULLIF(meta_value LIKE '%"administrator"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"editor"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"author"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"contributor"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"subscriber"%', false) as Computed), COUNT(*) as Computed FROM wp_usermeta WHERE meta_key LIKE 'wp_capabilities'
       ```
   
 * The problem is that naked boolean expressions are not allowed inside of a function.
   The above needs to be re-written to use a numerical expression:
 * `SELECT COUNT(CASE WHEN meta_value LIKE '%"administrator"%' THEN 1 ELSE 0 END)
   as Computed, COUNT(CASE WHEN meta_value LIKE '%"editor"%' THEN 1 ELSE 0) as Computed...`
 *  [Gideon7](https://wordpress.org/support/users/gideon7/)
 * (@gideon7)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/#post-2812788)
 * To handle NULL cases use ISNULL(meta_value,”), like this:
 * `SELECT COUNT(CASE WHEN ISNULL(meta_value, '') LIKE '%"administrator"%' THEN 
   1 ELSE 0 END) as Computed, ...`
 *  [Andyt8](https://wordpress.org/support/users/andyt8/)
 * (@andyt8)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/#post-2812792)
 * Maybe I have some simular problem. I didn’t created any user, but I get an simular
   error message.
 * Was you able to solve that for yourself?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘[Plugin: WP Db Abstraction] Database Update Issues’ is closed to new 
replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wordpress-database-abstraction.svg)
 * [WP Db Abstraction](https://wordpress.org/plugins/wordpress-database-abstraction/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-database-abstraction/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-database-abstraction/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-database-abstraction/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-database-abstraction/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-database-abstraction/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [Andyt8](https://wordpress.org/support/users/andyt8/)
 * Last activity: [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/#post-2812792)
 * Status: not resolved