PHPee.com PHP development forum
MySQL Warning Error

 
Post new topic   Reply to topic    phpee.com Forum Index -> PPhlogger bug reports
View previous topic :: View next topic  
Author Message
Khokolate



Joined: 29 Nov 2003
Posts: 15
Location: Baltimore, MD

PostPosted: Sat Nov 29, 2003 5:28 pm    Post subject: MySQL Warning Error Reply with quote
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:

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
Back to top
View user's profile Send private message Visit poster's website AIM Address MSN Messenger
Khokolate



Joined: 29 Nov 2003
Posts: 15
Location: Baltimore, MD

PostPosted: Sat Nov 29, 2003 6:07 pm    Post subject: Cont.. Reply with quote
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
Back to top
View user's profile Send private message Visit poster's website AIM Address MSN Messenger
steve



Joined: 16 Nov 2003
Posts: 15

PostPosted: Sun Nov 30, 2003 4:06 pm    Post subject: Reply with quote
In admin/admin3.php
Just before the line
Code:
$custtotal = get_totalrows('tbl_userlog');
add the new line
Code:
$tbl_userlog = PPHL_TBL_USERLOG;
Back to top
View user's profile Send private message
Khokolate



Joined: 29 Nov 2003
Posts: 15
Location: Baltimore, MD

PostPosted: Sun Nov 30, 2003 4:40 pm    Post subject: Wroks Fine Now. Reply with quote
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
Back to top
View user's profile Send private message Visit poster's website AIM Address MSN Messenger
pipo
Site Admin


Joined: 15 Nov 2003
Posts: 761
Location: Zurich, Switzerland

PostPosted: Mon Dec 01, 2003 6:32 pm    Post subject: fixed in CVS Reply with quote
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:
=====================================================================
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 | CVS
Back to top
View user's profile Send private message Visit poster's website
Post new topic   Reply to topic    phpee.com Forum Index -> PPhlogger bug reports All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB
Theme design based on Team 101 Designs, modified by Philip Iezzi