MySQL Warning Error

Report bugs of current version 2.2.5 here!

Moderators: Moderator Team, Development Team

MySQL Warning Error

Postby Khokolate on Sat Nov 29, 2003 6:28 pm

I got the following error after install the new version from scratch and then try to view the last customer log. I shouldn't get that error even if thier havent been any visitors. I will check to see if I still get it after thier are visitors.

Code: Select all
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/tig/public_html/counter/libraries/functions.lib.php on line 1101
Changing the Web,

Khokolate
http://www.khokolate.com
http://www.naughtyonerecords.com
http://www.dactylproductions.com

-- Knowledge is power so learn as much as you can -R Terry
Khokolate
 
Posts: 15
Joined: Sat Nov 29, 2003 6:10 pm
Location: Baltimore, MD

Cont..

Postby Khokolate on Sat Nov 29, 2003 7:07 pm

This error still appears after the script records visitors.
Changing the Web,

Khokolate
http://www.khokolate.com
http://www.naughtyonerecords.com
http://www.dactylproductions.com

-- Knowledge is power so learn as much as you can -R Terry
Khokolate
 
Posts: 15
Joined: Sat Nov 29, 2003 6:10 pm
Location: Baltimore, MD

Postby steve on Sun Nov 30, 2003 5:06 pm

In admin/admin3.php
Just before the line
Code: Select all
$custtotal = get_totalrows('tbl_userlog');
add the new line
Code: Select all
$tbl_userlog = PPHL_TBL_USERLOG;
steve
 
Posts: 15
Joined: Sun Nov 16, 2003 6:07 pm

Wroks Fine Now.

Postby Khokolate on Sun Nov 30, 2003 5:40 pm

thank you for all the help...
Changing the Web,

Khokolate
http://www.khokolate.com
http://www.naughtyonerecords.com
http://www.dactylproductions.com

-- Knowledge is power so learn as much as you can -R Terry
Khokolate
 
Posts: 15
Joined: Sat Nov 29, 2003 6:10 pm
Location: Baltimore, MD

fixed in CVS

Postby pipo on Mon Dec 01, 2003 7:32 pm

This has been fixed in CVS.
If you don't wish to edit files manually, get the pphlogger-CVS_latest.tar.gz (CVS snapshot, updated daily) and replace the following files:

  • /libraries/functions.lib.php
  • /dspLogs.php
  • /dspBrowserOs.php
  • /admin/admin3.php

here's the CVS-diff if you wish to manually apply changes:

Code: Select all
=====================================================================
SUMMARY
C pphlogger/libraries/functions.lib.php 1.111  ->  1.112 Sun, 30 Nov 2003 12:53:15 +0100
C pphlogger/dspLogs.php 1.29  ->  1.30 Sun, 30 Nov 2003 12:53:16 +0100
C pphlogger/dspBrowserOs.php 1.21  ->  1.22 Sun, 30 Nov 2003 12:53:16 +0100
C pphlogger/admin/admin3.php 1.16  ->  1.17 Sun, 30 Nov 2003 12:53:16 +0100
=====================================================================
C pphlogger/libraries/functions.lib.php 1.111  ->  1.112 Sun, 30 Nov 2003 12:53:15 +0100

1097,1098c1097
<    global $$table;
<    $sql = "SELECT count(*) AS total FROM ".$$table;
---
>    $sql = "SELECT count(*) AS total FROM ".$table;
=====================================================================
C pphlogger/dspLogs.php 1.29  ->  1.30 Sun, 30 Nov 2003 12:53:16 +0100

52c52
< $logtotal = get_totalrows('tbl_logs');
---
> $logtotal = get_totalrows($tbl_logs);
=====================================================================
C pphlogger/dspBrowserOs.php 1.21  ->  1.22 Sun, 30 Nov 2003 12:53:16 +0100

37c37
<    $logtotal = get_totalrows('tbl_logs',$logs_from,$logs_to);
---
>    $logtotal = get_totalrows($tbl_logs,$logs_from,$logs_to);
39c39
<    $logtotal = get_totalrows('tbl_logs');
---
>    $logtotal = get_totalrows($tbl_logs);
=====================================================================
C pphlogger/admin/admin3.php 1.16  ->  1.17 Sun, 30 Nov 2003 12:53:16 +0100

52c52
< $custtotal = get_totalrows('tbl_userlog');
---
> $custtotal = get_totalrows(PPHL_TBL_USERLOG);
Philip Iezzi - Development Team Leader, phpee.com
PHPee.com | Downloads | PPhlogger
hosted by Onlime Webhosting
User avatar
pipo
Site Admin
 
Posts: 773
Joined: Sat Nov 15, 2003 2:57 pm
Location: Zurich, Switzerland


Return to PPhlogger bug reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron