Title: Database error (syntax) during/after installation with PG4WP
Last modified: August 21, 2016

---

# Database error (syntax) during/after installation with PG4WP

 *  Resolved [azibux1](https://wordpress.org/support/users/azibux1/)
 * (@azibux1)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-syntax-duringafter-installation-with-pg4wp/)
 * Hi all,
 * Attempting to install WordPress, I get to the install page fine, fill in all 
   the details then I get the below everytime.
 * Please does anybody know what is causing this?
 * If I try to access the site after this I do get the blank site “just another 
   wordpress site” etc etc, but I can’t log into the admin side as it doesn’t recognise
   any usernames, presumably because the install never completed properly
 * Hope you can help
 *     ```
       WordPress database error: [ERROR: syntax error at or near "a" LINE 1: DELETE a, b FROM wp_options a, wp_options b WHERE ^]
       DELETE a, b FROM wp_options a, wp_options b WHERE a.option_name LIKE '\_transient\_%' AND a.option_name NOT LIKE '\_transient\_timeout\_%' AND b.option_name = CONCAT( '_transient_timeout_', SUBSTRING( a.option_name, 12 ) ) AND b.option_value < 1389718357
   
       WordPress database error: [ERROR: syntax error at or near "a" LINE 1: DELETE a, b FROM wp_options a, wp_options b WHERE ^]
       DELETE a, b FROM wp_options a, wp_options b WHERE a.option_name LIKE '\_site\_transient\_%' AND a.option_name NOT LIKE '\_site\_transient\_timeout\_%' AND b.option_name = CONCAT( '_site_transient_timeout_', SUBSTRING( a.option_name, 17 ) ) AND b.option_value < 1389718357
       ```
   

Viewing 1 replies (of 1 total)

 *  Thread Starter [azibux1](https://wordpress.org/support/users/azibux1/)
 * (@azibux1)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-syntax-duringafter-installation-with-pg4wp/#post-4502534)
 * UPDATE
 * Not sure on my Postgresql version but I did see that on the PG4WP page
 * [http://wordpress.org/plugins/postgresql-for-wordpress/](http://wordpress.org/plugins/postgresql-for-wordpress/)
 * …It’s only compatible up to WordPress 3.4.2, whereas I’d downloaded 3.8 so that
   possibly caused it to fail.
 * I started from scratch with 3.4.2 and now it all works, so could have been a 
   mistake I made in the process, or I’m guessing it was the issue that 3.8 is not
   supported by PG4WP

Viewing 1 replies (of 1 total)

The topic ‘Database error (syntax) during/after installation with PG4WP’ is closed
to new replies.

## Tags

 * [pg4wp](https://wordpress.org/support/topic-tag/pg4wp/)

 * 1 reply
 * 1 participant
 * Last reply from: [azibux1](https://wordpress.org/support/users/azibux1/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-syntax-duringafter-installation-with-pg4wp/#post-4502534)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics