Title: After installing: WordPress database error Last modified: August 18, 2016 --- # After installing: WordPress database error * [katiebird](https://wordpress.org/support/users/katiebird/) * (@katiebird) * [19 years, 6 months ago](https://wordpress.org/support/topic/after-installing-wordpress-database-error/) * > WordPress database error: [Unknown column ‘publish’ in ‘where clause’] > … * I’ve successfully installed 3 WordPress blogs on hosted (Linux) servers. I’ve never had any trouble at all. I’ve even changed hosts without losing anything. * But at work I’ve I can’t get past the above error message. I’ve followed the installation instructions step-by-step and I get the admin password and can log in. But when I try to view the site, that message (and more) is displayed across the top of the screen and the template doesn’t display at all. * I’ve found some talk that the problem has something to do with single and double quotes in the classes.php file. * I’ve poked around in the classes.php file, but that query is built with code that includes double quotes nested within single quotes. * And when I try to just trade them out, I get a parsing error. (I think it’s line 600-607 of wp-includes/classes.php — is this correct?) * We have another web server that is running on Windows. Do you think I’d have better luck running the Windows version of WordPress? * I’m really confused, because as I said I’ve run WordPress blogs from 2 different commercial hosts without this problem. * Also, I’ve started completely over (even with deleting the database and recreating it) 4 times. And re-downloaded the files. And in between came home and built a new blog without the error. So it seems like it’s probably related to the environment there and not to errors by me. * Still, if I could figure out what to fix, I’d rather do that than run it on Windows. * Please let me know if this doesn’t make sense. I’m so confused, I might have left out important information. Although I’ll say that I don’t know what version of Apache or FreeBSD we’re running. * Thank you very much. Viewing 2 replies - 1 through 2 (of 2 total) * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [19 years, 6 months ago](https://wordpress.org/support/topic/after-installing-wordpress-database-error/#post-477979) * Can you find the MySQL, PHP, and Apache versions? * Does it really look like the [database tables](http://codex.wordpress.org/Database_Description) got setup? Use [phpMyAdmin](http://codex.wordpress.org/phpMyAdmin) to look at those… * Thread Starter [katiebird](https://wordpress.org/support/users/katiebird/) * (@katiebird) * [19 years, 6 months ago](https://wordpress.org/support/topic/after-installing-wordpress-database-error/#post-478186) * Hi MichaelH, * Yes, when I look at the tables everything looks fine. Actually, I can log-in and the dashboard works fine so I can look at what’s there through manage posts& pages. * It just won’t display as a blog. * One suggestion is that it could be an encoding issue. But I won’t be able to check it until I get to work tomorrow. * It’s PHP 5 & MySQL 5 — oh, could it be that? MySQL 5? I think we’re running MySQL 4 on another server?? Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘After installing: WordPress database error’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [freebsd](https://wordpress.org/support/topic-tag/freebsd/) * [installation](https://wordpress.org/support/topic-tag/installation/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 2 replies * 2 participants * Last reply from: [katiebird](https://wordpress.org/support/users/katiebird/) * Last activity: [19 years, 6 months ago](https://wordpress.org/support/topic/after-installing-wordpress-database-error/#post-478186) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics