• Resolved baudesign

    (@baudesign)


    Hi everyone,
    I am trying to implement a WordPress publishing platform on our Website. So far so good. I am testing the script.
    The Search form is not working well: I get database errors when I click on Search, and the results are always wrong:
    Database error: [Unknown column ‘1[search term]’ in ‘where clause’]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1[search term] AND post_date_gmt <= ‘2004-10-25 01:40:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 20
    Notice the “1” in front of the search term. e.g. search for halloween, return 1halloween. This is very strange, and annoying.
    Can someone tell me what this problem is about?
    http://quebecaudio.com/actualites if you want to test by yourself (In French).
    Thanks

Viewing 1 replies (of 1 total)
  • Thread Starter baudesign

    (@baudesign)

    Nevermind, I found the source of the problem:
    <input name=”s” type=”text” id=”s” […]
    I changed the id of the input for design purposes, and the script did not like that for unknown reason. Oh well…

Viewing 1 replies (of 1 total)

The topic ‘Database error on Search’ is closed to new replies.