mayreee

WordPress database error: [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 ‘-1’ at line 21]
SELECT posts.*, CASE WHEN posts.post_title REGEXP ‘Search’ THEN 1 ELSE 0 END AS keyword_in_title, MATCH ( posts.post_title, posts.post_content ) AGAINST ( ‘Search’ ) AS mysql_score FROM wp_posts as posts LEFT JOIN wp_postmeta as postmeta ON postmeta.post_id = posts.ID WHERE posts.post_date_gmt <= ‘2007-03-01 02:02:00’ AND ( posts.post_password = ” ) AND ( ( post_status = ‘publish’ OR ( post_status = ‘static’ AND postmeta.meta_value = ‘article.php’ ) ) ) AND ( posts.post_title REGEXP ‘Search’ OR posts.post_content REGEXP ‘Search’ ) ORDER BY keyword_in_title DESC, mysql_score DESC, posts.post_date DESC LIMIT 0, -1

I am having this same exact problem also. Anyone have any ideas?

Thanks everyone! It was StatTraq that was causing the error in the search form.

Okay, sorry if this is a stupid question, but I don’t see this at all in my HTML and it is what is causing the problem:

<input type="hidden" name="PHPSESSID" value="e89363766bfb929a188fb876568d318c" />


What is cauing that?

This is the whole code according to WC3:

<form id="searchform" method="get" action="/index.php"><input type="hidden" name="PHPSESSID" value="e89363766bfb929a188fb876568d318c" />
<fieldset><input type="hidden" name="PHPSESSID" value="e89363766bfb929a188fb876568d318c" />
<input type="text" name="s" id="s" size="15" />
<input type="submit" value="Search" />
</fieldset>
</form>


This is what is in my HTML:

<form id="searchform" method="get" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<fieldset>
<input type="text" name="s" id="s" size="15" />
<input type="submit" value="<?php _e('Search'); ?>" />
</fieldset>
</form>

Tried that and it didn’t work

I am using a q&a script and it seemed the form needed to have the page be submitted to a page with a .php extension.

Thank you very much for your help!!! I made it a seperate page with my page.php template and it worked great. Thanks again!

Anyone??????

I am having the same problem. I think it is because it is pointing to /wp/index.html instead of where it should be /index.html

Well, they are in the directory but I don’t have the index file pointing to them… I just have all my html on the index.php file.

I don’t understand that though because I am not useing any one of those themes. Yes, one is activated but I am my page is another one that I made and it is not a theme… just on the index.php page.

Thanks, not sure if I needed to upgrade or not, but I did and it worked!!!! Thanks for taking the time to help me ??

Anyone?