Make WordPress Core

Opened 19 years ago

Closed 19 years ago

Last modified 19 years ago

#3483 closed defect (bug) (worksforme)

Fresh Install of 2.1 Alpha has MySQL error

Reported by: palamedes's profile Palamedes 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)

#1 @Viper007Bond
19 years ago

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.

#2 @ryan
19 years ago

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

#3 @foolswisdom
19 years ago

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

No reply, closing as WORKSFORME for now.

#4 @Nazgul
19 years ago

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