"mysql_num_rows() expects parameter 1 to be resource…" Error

comziz
(@comziz)

12 years, 5 months ago

Hello,

Thank you so much for such a beautiful plugin, I installed the plugin via WordPress and activated it without any problems.

I don’t know what’s wrong but unfortunatelly I’m having these errors in my widget;

`Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line149

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line162

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line164

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line165

Warning: mysql_result() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line166

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line167

Warning: mysql_result() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line168

Warning: mysql_result() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line169

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line171

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/mydomainadress…/mechanic-visitor-counter/wp-statsmechanic.php on line172
`

I didn’t check every line pointed, but I’m planning to, in the meantime I wanted to let you know of a possible bug.

I would appreciate any help, suggestion and replies of any kind.
Thank you all in advance.

http://ww.wp.xz.cn/plugins/mechanic-visitor-counter/

Viewing 2 replies - 1 through 2 (of 2 total)

Thread Starter

comziz

(@comziz)

12 years, 5 months ago

Update:

149:
if(mysql_num_rows($sql) == 0){

162:
$bulan1=mysql_num_rows($bulan);

164-169:

$tahunini1=mysql_num_rows($tahunini);
              $pengunjung       = mysql_num_rows(mysql_query("SELECT * FROM <code>". BMW_TABLE_NAME . "</code> WHERE tanggal='$tanggal' GROUP BY ip"));
              $totalpengunjung  = mysql_result(mysql_query("SELECT COUNT(hits) FROM <code>". BMW_TABLE_NAME . "</code>"), 0);
              $hits             = mysql_fetch_assoc(mysql_query("SELECT SUM(hits) as hitstoday FROM <code>". BMW_TABLE_NAME . "</code> WHERE tanggal='$tanggal' GROUP BY tanggal"));
              $totalhits        = mysql_result(mysql_query("SELECT SUM(hits) FROM <code>". BMW_TABLE_NAME . "</code>"), 0);
              $tothitsgbr      = mysql_result(mysql_query("SELECT COUNT(hits) FROM <code>". BMW_TABLE_NAME . "</code>"), 0);

172-173:

$pengunjungonline = mysql_num_rows(mysql_query("SELECT * FROM<code>&quot;. BMW_TABLE_NAME . &quot;</code> WHERE online > '$bataswaktu'"));
			  $kemarin1 = mysql_num_rows($kemarin);

Hope it helps.