» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 39
1 members and 38 guests
doctornuke
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
Web Hosting - web hosting, dedicated servers and web design services
Online Degree - search for 1000+ online degrees, online colleges & online universities.
Tattoo - we are a group of tattoo enthusiasts
Gexa Energy - your absolute best choice in electric service
Texas electricity - save on electric rates
Oral Chelation - initial cleansing of your veins & arteries

Register Now! Contact Us

About this Page
This is a discussion on Problem with the nuke 6.5 visitors block. within the Nuke 6.5 to 6.9 - Blocks forums, part of the PHP-Nuke 6.5 to 6.9 category; i just installed your visitors block but now i get the error about line 286 of sql_layer.php :? does anyone ...


Go Back   Nukemods Forum » PHP-Nuke 6.5 to 6.9 » Nuke 6.5 to 6.9 - Blocks

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-27-2003, 02:27 PM
Junior Member
 
Join Date: Mar 2003
Posts: 1
Problem with the nuke 6.5 visitors block.
i just installed your visitors block but now i get the error about line 286 of sql_layer.php :? does anyone know how to fix this? below is a picture of the error...

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-27-2003, 05:44 PM
Member
 
Join Date: Nov 2002
Location: Michigan, USA
Posts: 359
Send a message via AIM to ReNeGaDe
that would be an installation error. try deleting all files/tables and reinstalling.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-03-2003, 10:24 AM
Junior Member
 
Join Date: Mar 2003
Posts: 3
Re: Problem with the nuke 6.5 visitors block.
Originally Posted by VooDoo427
i just installed your visitors block but now i get the error about line 286 of sql_layer.php :? does anyone know how to fix this? below is a picture of the error...

Hi There,
I have the same problem and I have tried to deleted and install it again few times and doesn’t help.
I have a fresh nuke 6.5
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-03-2003, 11:06 AM
Senior Member
 
Join Date: Sep 2002
Posts: 2,905
OK which block are you guys downloading, because I downloaded BOTH Site Visitors blocks for Nuke6.5 from this site and they both work fine on my Nuke6.5 testsite...

mikem
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-03-2003, 11:29 AM
Junior Member
 
Join Date: Mar 2003
Posts: 3
Originally Posted by mikem
OK which block are you guys downloading, because I downloaded BOTH Site Visitors blocks for Nuke6.5 from this site and they both work fine on my Nuke6.5 testsite...

mikem
I have tried both "Visitors block" from this website. And both showing
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tripnet/public_html/czechpub/includes/sql_layer.php on line 286

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tripnet/public_html/czechpub/includes/sql_layer.php on line 286
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-03-2003, 11:49 AM
Senior Member
 
Join Date: Sep 2002
Posts: 2,905
I don't know what to tell you.

I went to all this trouble.
I just setup Nuke6.5 FRESH INSTALL again on another testbed here on my local PC>
After creating my SuperUser, I installed the SiteVisitors block(both for Nuke6.5) from this site and they both work with NO errors.

mikem
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-03-2003, 01:50 PM
Junior Member
 
Join Date: Mar 2003
Posts: 3
Re: Problem with the nuke 6.5 visitors block.
Originally Posted by VooDoo427
i just installed your visitors block but now i get the error about line 286 of sql_layer.php :? does anyone know how to fix this? below is a picture of the error...

Hi again,

I think I have found where the problem is:
In fact you have two lines Hard Coded in block-Site_Visitors (prefix)
Line 120 and 126

Quote:
// Executing SQL Today
$sql2 = "SELECT COUNT(user_id) AS userCount from nuke_users WHERE user_regdate LIKE '$curDate2'";
$result2 = sql_query( $sql2, $dbi );
list( $userCount ) = sql_fetch_row( $result2, $dbi );
// end

// Executing SQL Yesterday
$sql3 = "SELECT COUNT(user_id) AS userCount from nuke_users WHERE user_regdate LIKE '$curDateP'";
$result3 = sql_query( $sql3, $dbi );
list( $userCount2 ) = sql_fetch_row( $result3, $dbi );
For those who have same problem it means that you are using prefix different from nuke_
You have to change nuke_users to $prefix"._users."

Quote:
// Executing SQL Today
$sql2 = "SELECT COUNT(user_id) AS userCount from $prefix"._users." WHERE user_regdate LIKE '$curDate2'";
$result2 = sql_query( $sql2, $dbi );
list( $userCount ) = sql_fetch_row( $result2, $dbi );
// end

// Executing SQL Yesterday
$sql3 = "SELECT COUNT(user_id) AS userCount from $prefix"._users." WHERE user_regdate LIKE '$curDateP'";
$result3 = sql_query( $sql3, $dbi );
list( $userCount2 ) = sql_fetch_row( $result3, $dbi );
Keep going
dc
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-03-2003, 01:54 PM
Senior Member
 
Join Date: Sep 2002
Posts: 2,905
Nice job dc006

I had actually just found that and changed it to prefix...let that one get by.
Of course you'll get no errors if your prefix is nuke 8)

I'll update the block files :-)

mikem
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 04-03-2003, 08:56 PM
Junior Member
 
Join Date: Apr 2003
Location: Dublin
Posts: 12
Oops
Just posted a new question relating to Site Visitors... Should have read some more first..

I can't see the block after installing.... Lost

Mikeo
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Site Visitors Block Online Now Link? jsterling Nuke 6.5 to 6.9 - Blocks 0 08-04-2003 12:43 AM
Site Visitors block MurphDog nukemods.com 2 07-20-2003 05:12 PM
Site Visitors block for 6.5 richiewinn Nuke 6.5 to 6.9 - Blocks 2 07-01-2003 03:18 AM
Site Visitors Block Link Problem bwillis Purged Topics 4 03-25-2003 03:37 PM
Site Visitors block v1.1 OiSole Purged Topics 1 03-18-2003 09:24 AM


All times are GMT -5. The time now is 11:53 PM.


Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.

LinkBacks Enabled by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31