I don't know why but I got this error...
Warning [2] mysql_num_rows(): supplied argument is not a valid MySQL result resource - Line: 40 - File: inc/plugins/userbarplugin.php PHP 5.2.9 (Linux)
File Line Function
[PHP] errorHandler->error
/inc/plugins/userbarplugin.php 40 mysql_num_rows
[PHP] userbarplugin_activate
/admin/modules/config/plugins.php 215 call_user_func
/admin/index.php 381 require
Warning [2] chmod() [function.chmod]: No such file or directory - Line: 124 - File: inc/plugins/userbarplugin.php PHP 5.2.9 (Linux)
File Line Function
[PHP] errorHandler->error
/inc/plugins/userbarplugin.php 124 chmod
[PHP] userbarplugin_activate
/admin/modules/config/plugins.php 215 call_user_func
/admin/index.php 381 require
I'm not at my PC right now but I'll have a look at it when I get home, anyone else have this problem?
in userbarplugin.php, replace:
if(mysql_num_rows(mysql_query("SELECT userid FROM ".TABLE_PREFIX."settinggroups WHERE gid = '999'")))
with:
if(mysql_num_rows(mysql_query("SELECT userid FROM ".TABLE_PREFIX."settinggroups WHERE gid = '999'"))==1)
That should fix it
Still the same...
Source code of this:
<div class="php_warning"><strong>Warning</strong> [2] mysql_num_rows(): supplied argument is not a valid MySQL result resource - Line: 40 - File: inc/plugins/userbarplugin.php PHP 5.2.9 (Linux)<br />
<table style="width: 100%; margin: 10px 0; border: 1px solid #aaa; border-collapse: collapse; border-bottom: 0;" cellspacing="0" cellpadding="0" border="0">
<thead><tr>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">File</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Line</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Function</th>
</tr></thead>
<tbody>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">errorHandler->error</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/inc/plugins/userbarplugin.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">40</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">mysql_num_rows</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">userbarplugin_activate</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/modules/config/plugins.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">215</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">call_user_func</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/index.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">381</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">require</td>
</tr>
</tbody></table>
</div><div class="php_warning"><strong>Warning</strong> [2] chmod() [<a href='function.chmod'>function.chmod</a>]: No such file or directory - Line: 124 - File: inc/plugins/userbarplugin.php PHP 5.2.9 (Linux)<br />
<table style="width: 100%; margin: 10px 0; border: 1px solid #aaa; border-collapse: collapse; border-bottom: 0;" cellspacing="0" cellpadding="0" border="0">
<thead><tr>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">File</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Line</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Function</th>
</tr></thead>
<tbody>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">errorHandler->error</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/inc/plugins/userbarplugin.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">124</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">chmod</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">userbarplugin_activate</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/modules/config/plugins.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">215</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">call_user_func</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/index.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">381</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">require</td>
</tr>
</tbody></table>
</div><meta http-equiv="refresh" content="0; url=index.php?module=config/plugins">
Just comment out the "check for old versions "part, as well as the chmod part. It seems your server doesn't support it
(2010-04-30, 11:50 PM)darkly Wrote: [ -> ]Still the same...
Source code of this:
<div class="php_warning"><strong>Warning</strong> [2] mysql_num_rows(): supplied argument is not a valid MySQL result resource - Line: 40 - File: inc/plugins/userbarplugin.php PHP 5.2.9 (Linux)<br />
<table style="width: 100%; margin: 10px 0; border: 1px solid #aaa; border-collapse: collapse; border-bottom: 0;" cellspacing="0" cellpadding="0" border="0">
<thead><tr>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">File</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Line</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Function</th>
</tr></thead>
<tbody>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">errorHandler->error</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/inc/plugins/userbarplugin.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">40</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">mysql_num_rows</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">userbarplugin_activate</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/modules/config/plugins.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">215</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">call_user_func</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/index.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">381</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">require</td>
</tr>
</tbody></table>
</div><div class="php_warning"><strong>Warning</strong> [2] chmod() [<a href='function.chmod'>function.chmod</a>]: No such file or directory - Line: 124 - File: inc/plugins/userbarplugin.php PHP 5.2.9 (Linux)<br />
<table style="width: 100%; margin: 10px 0; border: 1px solid #aaa; border-collapse: collapse; border-bottom: 0;" cellspacing="0" cellpadding="0" border="0">
<thead><tr>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">File</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Line</th>
<th style="border-bottom: 1px solid #aaa; background: #ccc; padding: 4px; text-align: left; font-size: 11px;">Function</th>
</tr></thead>
<tbody>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">errorHandler->error</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/inc/plugins/userbarplugin.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">124</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">chmod</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">[PHP]</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;"> </td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">userbarplugin_activate</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/modules/config/plugins.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">215</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">call_user_func</td>
</tr>
<tr>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">/admin/index.php</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">381</td>
<td style="font-size: 11px; padding: 4px; border-bottom: 1px solid #ccc;">require</td>
</tr>
</tbody></table>
</div><meta http-equiv="refresh" content="0; url=index.php?module=config/plugins">
I have the same problem...
Did yo. Uplaod ALL of the files? Even the cache folder?
OK, I've edited the plugin and removed the CHMOD, so you'll have to CHMOD the /cache/userbars directory to 777 manually.
I think I've fixed the sql
v2.2 r2 released
how to upgrade?? v2.2 --> v2.2 r2
Sorry, just upload all the files overwriting the old ones then activate as normal