1 Topic by LUTi (edited by LUTi 04/04/2011 12:02:48 pm)

  • LUTi
  • Member
  • Offline
  • From: Slovenia, Notranje Gorice
  • Registered: 01/07/2010
  • Posts: 42

Topic: Errors after logout when $show_users_online is set in version 2.3.3

The following errors:

mysql_query(): supplied argument is not a valid MySQL-Link resource in file: <frontaccounting_path>/includes/db/connect_db.inc at line 51
mysql_errno(): supplied argument is not a valid MySQL-Link resource in file: <frontaccounting_path>/includes/db/connect_db.inc at line 143
mysql_num_rows(): supplied argument is not a valid MySQL result resource in file: <frontaccounting_path>/includes/db/connect_db.inc at line 103

are displayed after logout (Thank you for using FrontAccounting 2.3.3 / Click here to Login Again... screen), when $show_users_online is set ($show_users_online = 1; in config.php).

$db variable does not seem to be set there...

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Errors after logout when $show_users_online is set in version 2.3.3

Thanks. The HG repository is updated in a while.
You can change the following in /admin/users_db.inc, line 148, show_users_online:
Add $db as global.
Add || !isset($db) in the first long line of restrictions. This eliminates the problem.

/Joe

  • LUTi
  • Member
  • Offline
  • From: Slovenia, Notranje Gorice
  • Registered: 01/07/2010
  • Posts: 42

Re: Errors after logout when $show_users_online is set in version 2.3.3

Thank you, joe.

I can confirm that the code provided resolved this issue (just a note for the others: users_db.inc is in /admin/db/, not in /admin/).

Just a minor (cosmetic) thing. If this option is switched off, there should be no dash after Theme, I believe (a dash which separates theme info and online users info when this option is on).