and another error occurs, if I want to edit a blog. see the message below:

MySQL Fehler!

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 ') AND ( post_status IN ('') ) ORDER BY post_issue_date LIMI(Errno=1064)

Your query:
SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE cat_blog_ID = 2 AND postcat_cat_ID IN () AND ( post_status IN ('') ) ORDER BY post_issue_date LIMIT 5

I get a similar error here. It is quite strange. I can read the post just fine, but when I click on the permalink, I get a 1064 error.
This is b2evo 0.9.0.12.

MySQL 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 ''' at line 7(Errno=1064)

Your query:
SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE cat_blog_ID = 6 AND post_urltitle = '

Update: I played a bit with the urltitle, and it seems that the error happens only if there are certain words in the url:
I originally used 'limit_scenarios' as urltitle. That caused problems.
Similar with 'term_limit_scenarios'.
But, using 'term_scenarios' or 'scenarios' as urltitle works.
Is the word "limit" somehow prohibited somewhere?

I get the same error with any combination containing "limit" in the urltitle.I was trying 'gobierno_limitado' :-(

I could not reproduce this with either version 0.9.1 nor 1.6 at the demo site (http://demo.b2evolution.net).

Is this fixed since 0.9.1 or before?

I've only tried the limit issue Austriaco and jfeise had.

alexm12, could you figure out what the problem was with your installation?

blueyed wrote:

I could not reproduce this with either version 0.9.1 nor 1.6 at the demo site (http://demo.b2evolution.net).

Is this fixed since 0.9.1 or before?

I've only tried the limit issue Austriaco and jfeise had.

Sorry, it took me a while to find time, but I can confirm that my problem is fixed with 0.9.1.

I've found the problem:

 
function calc_max() {
[...]
if( $pos = strpos(strtoupper($this->request), 'LIMIT'))
{ // Remove the limit form the request
    $nxt_request = substr($this->request, 0, $pos);
}
[...]
}

This bug is in file b2evocore/_class_itemlist.php

This is not a good way to calculate the maximum results of a query...

Yes.. just upgrade to 0.9.1

I agree - upgrading to Dawn (v0.9.1.0) or Sparkle (v0.9.2.0) is the best move. However, if you you would prefer to solve this bug and upgrade at a later time, then you can replace the offending function with a copy from the Dawn (v0.9.1.0) release.

Replace the entire function in _class_itemlist.php [shown below, from Amsterdam (v0.9.0.12) ]

<?php


	/*
	 * Private ItemList->calc_max(-)
	 *
	 * @todo use COUNT(*)
	 */

	function calc_max()
	{
		global $DB;

		if( $this->preview )
			return 1;	// 1 row in preview mode

		$nxt_request = $this->request;
		if( $pos = strpos(strtoupper($this->request), 'LIMIT'))
		{ // Remove the limit form the request
			$nxt_request = substr($this->request, 0, $pos);
		}
		//echo $nxt_request;

		$DB->query( $nxt_request );
		$this->total_num_posts = $DB->num_rows;
		$this->max_paged = intval( ($this->total_num_posts-1) / max($this->posts_per_page, $this->result_num_rows)) +1;
		if( $this->max_paged < 1 )
			$this->max_paged =1;
	}


?>

With a copy from the following (from the same file in Dawn (v0.9.1.0):

<?php


	/*
	 * Private ItemList->calc_max(-)
	 */
	function calc_max()
	{
		global $DB;

		if( $this->preview )
			return 1;	// 1 row in preview mode

		$this->total_num_posts = $DB->get_var( $this->count_request, 0, 0, 'Get result count' );

		$this->max_paged = intval( ($this->total_num_posts-1) / max($this->posts_per_page, $this->result_num_rows)) + 1;
		if( $this->max_paged < 1 )
			$this->max_paged =1;
	}	


?>

Hope this helps, as I'm in that boat at the moment (want to solve the problem, but not ready to tackle an entire upgrade just to leave the word "limit" in the url_title). ;)