The block settings have been updated. warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home

Hi,

thanks for reporting it. This bug shows up in mysql-5.x and I am still using 4.x series so I didn't notice it before. I will prepare new release soon but the immediate solution is to replace lines 320-321

$query = "SELECT n.nid, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 AND n.uid = " . $account->uid . $limit . " ORDER By n.created DESC ";
$postpermonth = mysql_num_rows(db_query($query));

with the following lines
$query = "SELECT COUNT(n.nid) FROM {node} n WHERE n.type = 'blog' AND n.status = 1 AND n.uid = " . $account->uid . $limit . " ORDER By n.created DESC ";
$postpermonth = db_result(db_query($query));

I tested this solution and can confirm it works fine but let me know if you have any problems.

Cheers

Patch works, fixes the problem.

How can I implement the patch?

I have the same problem

I wasnt able to use the patch :(. Is there any other way I could fix this problem/bug?

Change listed in #1 fixed the problem in 6.x-1.1.

--> FYI:
The solution provided in #1 for Blog_AddOns ver 6.x.11
works also for the Blog_AddOns ver. 5.x-1.0.

Note:
_{Tested in LAN environment with MySQL database 5.1.30 Drupal ver. 5.12.
Error evidence come on using the Blog_AddOns-Block inside a BlockBar-Module's Block.}

Code from REPLY #1 worked successfully on Drupal 6.10 using latest MySql v 5.x with Blog Add-Ons 6.x-1.1.

Thank you so much. Just confirming for those who need an infinity of confirmations. ;)