standard installation with wrong query

  • schicker

    (@schicker)


    20 years, 2 months ago

    WordPress database error: [Unknown column 'publish' in 'where clause']
    SELECT COUNT(DISTINCT ID) FROM wp_posts WHERE 1=1 AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment"

    Hello,

    I tried to install the standard installation of WordPress,
    all went fine.
    But using it, or going to the manage section in the admin area, causes this db error.

    Is this a bogus, has anybody a fix,
    will there be an update.
    Or what the hell seems to be the problem with this query?
    Tried to run it directly run in under MySQL with correct quotes and it workes.

    So does anybody know which file which line (hoho) this query is, so i can fix it, or has anybody an idea at all.

    Would be very kind to get some response,
    though I`ve seen several question for similar problems, with no answers at all.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter schicker

    (@schicker)

    20 years, 2 months ago

    the problem is clear,

    the double quotes at “publish” and “attachment” should be
    single quotes like ‘publish’,

    but where`s the query build at,
    is there a fix out there

    Thread Starter schicker

    (@schicker)

    20 years, 2 months ago

    hi folks,

    i installed the same distribution on Windows and did not got errors at all,
    so my fedora core 4 installation don`t likes it,
    wrong encoding,.. ?!?

    please can anyone help with this problem.

    katiebird

    (@katiebird)

    19 years, 6 months ago

    I’ve installed wordpress several times on hosted blogs.

    So I didn’t think I’d have any trouble getting it up and going here on out Intranet at work (where I’m the Web Coordinator).

    But I keep getting this error message referred to here.

    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’re using FreeBSD rather than Linux, do you suppose that’s why this code is causing me grief now when it never ever has?

    I’m sorry to sound like an idiot, but I just know how to get WP going. I’ve tried it 4 or 5 times with no success.

    Does anyone have any suggestions?

    katiebird

    (@katiebird)

    19 years, 6 months ago

    I’m sorry I meant to say that “I just don’t know how to get WordPress going….”

    (I’m falling apart)

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘standard installation with wrong query’ is closed to new replies.

Tags