#3483 closed defect (bug) (worksforme)
Fresh Install of 2.1 Alpha has MySQL error
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | Priority: | high | |
| Severity: | blocker | Version: | 2.1 |
| Component: | General | Keywords: | |
| Focuses: | Cc: |
Description
The following error was given to me with a fresh install of Wp2.1 alpha
WordPress database error: [You have an error in your SQL syntax near '.* FROM wp_posts WHERE 1=1 AND (post_type = 'post' AND (post_status = 'publish' at line 1]
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) ORDER BY post_date DESC LIMIT 0, 10
WordPress database error: [You have an error in your SQL syntax near '()' at line 1]
SELECT FOUND_ROWS()
You may see the error here: http://info.rsow.com/wp-dev/
(and this is my first ticket so if I borked this up at all please tell me so I don't do it again..)
Change History (4)
Note: See
TracTickets for help on using
tickets.
Did you delete the default post? Having no posts in the database can throw some errors IIRC.
Also, what version of MySQL and PHP do you have? You'll need to provide more details. :)
I just did a fresh install on my local PC and was unable to reproduce any errors, but I'm running both PHP5 and MySQL5.