Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#3483 closed defect (bug) (worksforme)

Fresh Install of 2.1 Alpha has MySQL error

Reported by: Palamedes Owned by: anonymous
Priority: high Milestone:
Component: General Version: 2.1
Severity: blocker Keywords:
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)

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.

comment:2   ryan6 years ago

What version of MySQL? WP 2.1 will require 4.0 or greater.

  • Resolution set to worksforme
  • Status changed from new to closed

No reply, closing as WORKSFORME for now.

  • Milestone 2.1 deleted
Note: See TracTickets for help on using tickets.