You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 68 guest(s) and 1 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Errors in Top10 Module [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Mindl3ss
Sergeant
Sergeant


Joined: May 10, 2003
Posts: 148

Location: Karachi, Pakistan

PostPosted: Sat May 17, 2003 3:58 pm Reply with quoteBack to top

Errors in Top10 Module (downloaded from nukecops.com)

Quote:
10 most active categories



SQL query: select artid, secid, title, content, counter from nuke_seccont order by counter DESC limit 0, 10
SQL query: select uname, user_posts from nuke_users where uname<>'Anonymous' order by user_posts DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select uname, user_regdate from nuke_users where uname<>'Anonymous' order by uid DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select uname, counter from nuke_users where counter > '0' order by counter DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select * from nuke_poll_desc


Quote:
10 most recent Watched forum threads

· 1: General » Where Are Guys G0n3??
· 2: General » Mehrtaab here.....
· 3: General » Kazaa
· 4: General » Introduce Your Self Here!


SQL query: select id, name, hits from nuke_community_cool order by hits DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select id, name, hits from nuke_community order by hits DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select COUNT(theme) as cnt, theme from nuke_users group by theme order by cnt DESC limit 0, 10


url : http://smwebs.2ya.com/modules.php?name=Top
Debug Mode is Also On

i tried to change uname to username but i guess it didnt helped..

any help Very Happy

i made one more step now... i changed the uid's to user_id now it shows only two errors:

Quote:
10 most recent Watched forum threads

· 1: General » Where Are Guys G0n3??
· 2: General » Mehrtaab here.....
· 3: General » Kazaa
· 4: General » Introduce Your Self Here!


SQL query: select id, name, hits from nuke_community_cool order by hits DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select id, name, hits from nuke_community order by hits DESC limit 0, 10

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/salman/public_html/nuke/includes/sql_layer.php on line 238
SQL query: select COUNT(theme) as cnt, theme from nuke_users group by theme order by cnt DESC limit 0, 10


Welp!

url : http://smwebs.2ya.com/modules.php?name=Top
Debug Mode is Still On

_________________
Normal people ... believe that if it ain't broke, don't fix it. Engineers believe that if it ain't broke, it doesn't have enough features yet.
Find all posts by Mindl3ssView user's profileSend private messageSend e-mailVisit poster's websiteYahoo MessengerMSN Messenger
Mindl3ss
Sergeant
Sergeant


Joined: May 10, 2003
Posts: 148

Location: Karachi, Pakistan

PostPosted: Sun May 18, 2003 5:07 pm Reply with quoteBack to top

i switched the debug mode off cause my visitors were complaining

but you can see the debug results here : Http://smwebs.2ya.com/top10.html

anyonee?

_________________
Normal people ... believe that if it ain't broke, don't fix it. Engineers believe that if it ain't broke, it doesn't have enough features yet.
Find all posts by Mindl3ssView user's profileSend private messageSend e-mailVisit poster's websiteYahoo MessengerMSN Messenger
Raven
General
General


Joined: Mar 22, 2003
Posts: 5233

Location: USA

PostPosted: Sun May 18, 2003 6:30 pm Reply with quoteBack to top

Does nuke_community_cool table contain these columns?

id, name, hits

_________________
Those who hear not the music think the dancers mad.
Raven Web Hosting|My Scripts & Stuff
Find all posts by RavenView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
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 © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by · TOGETHER TEAM srl ITALY http://www.togetherteam.it · DONDELEO E-COMMERCE http://www.DonDeLeo.com
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.182 Seconds - 186 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::