SQL_CALC_FOUND_ROWS

  • Kamil Porembinski

    (@paszczak000)


    14 years, 3 months ago

    I get error:

    [26-Dec-2009 10:04:47] Błąd You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wp_posts WHERE 1=1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10' at line 1 bazy danych WordPressa podczas wykonywania zapytania SELECT SQL_CALC_FOUND_ROWS FROM wp_posts WHERE 1=1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10 wysłanego przez require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

    What is wrong? Propably the query would be:
    SELECT SQL_CALC_FOUND_ROWS * FROM wp_posts WHERE 1=1 ORDER BY wp_posts.post_date DESC LIMIT 0, 10

    Missing is *?

Viewing 1 replies (of 1 total)
  • s_ha_dum

    (@apljdi)

    14 years, 3 months ago

    It is the * that is missing.

    SELECT SQL_CALC_FOUND_ROWS *
FROM wp_posts
WHERE 1 =1
ORDER BY wp_posts.post_date DESC
LIMIT 0 , 10

    Any valid column name or column list would work too– SELECT SQL_CALC_FOUND_ROWS ID or SELECT SQL_CALC_FOUND_ROWS post_author or SELECT SQL_CALC_FOUND_ROWS ID,post_author.

Viewing 1 replies (of 1 total)
  • The topic ‘SQL_CALC_FOUND_ROWS’ is closed to new replies.