msql & nuke treasury

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   msql & nuke treasury
Edge
CZ Newbie
Edge has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 22
Points: 5,281
   
Hi,

I have installed Nuke Treasury and it works fine, but when i am on the admin page and click the treasury icon there is an error up towards teh top of the page taht says teh folowing:




Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site21/fst/var/www/html/phpnuke/admin.php on line 159

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site21/fst/var/www/html/phpnuke/admin.php on line 162


Here are lines 159 and 162 according to notepad:


159:


$newsubs = mysql_num_rows(mysql_query("SELECT qid FROM ".$prefix."_queue"));



162:


$row = mysql_fetch_array($result);


I have no clue and would appreciate any thoughts. I have already reinstalled and it did not work. I even reinstalled the whole board but it's still there.
So, i now turn for help icon_wink.gif

TIA



Back to top Reply with quote
#2   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
Verify that you have a table in your database called nuke_queue




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   re: msql & nuke treasury
Edge
CZ Newbie
Edge has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 22
Points: 5,281
   
The site db has nuke_queue in it the nuketreasury does not. I appreaciate your help and i know that i shold have went to there site, but there seems to be some pretty knowledgeable peeps here.

thanks again



Back to top Reply with quote
#4   re: msql & nuke treasury
Tendency
CZ Super Newbie
 Codezwiz Site Donator
Tendency has been a member for over 20 year's 20 Year Member
usa.gif florida.gif
Occupation: Longshoreman
Age: 54
Gender: Male
Fav. Sports Team: Dallas Cowboys
Website:
Status: Offline
Joined: Nov 25, 2003
0.01 posts per day
Posts: 97
Points: 9,373
  MSN Messenger 
Heres the problem with the nuke treasury. There's a mispelling and sometimes it looks for the config.php instead of the config.inc.php file. So make a copy of the config.inc.php and rename config.php
So in the main directory for the Donations module, you will have a config.inc.php and a config.php file.



Back to top Reply with quote
#5   re: msql & nuke treasury
Edge
CZ Newbie
Edge has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 22
Points: 5,281
   
I did that before and the i had to go and edit other files which i did BUT, the conflict with the survey block appeared again if i remember right. I did look on there forums but i think i would have better luck here icon_wink.gif



Back to top Reply with quote
#6   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
$newsubs = mysql_num_rows(mysql_query("SELECT qid FROM ".$prefix."_queue"));
$row = mysql_fetch_array($newsubs);


Try that.



_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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
You cannot attach files in this forum
You cannot download files in this forum