Home :: Forums :: Downloads :: Shop
  1. Home
  2. Forums
  3. Codezwiz PHP Nuke Help
  4. Help with points block

Help with points block

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1.    Help with points block
mislead
CZ Newbie
mislead has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 30, 2004
0.00 posts per day
Posts: 17
Points: 3,305
   
i tried uploading the Top points block and got this message wen i activated it:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/clanfaa/public_html/kidnuke/includes/sql_layer.php on line 286

how can i fix this problem?
Back to top Reply with quote
#2.    re: Help with points block
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
 Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
re-install the sql file if you still get the same error message alter the case that is on line 285 or 286. the code should look like this:

case "MySQL":
        $row = mysql_fetch_row($res);
        return $row;
    break;;


change that to:

case "MySQL":
   if ($row = mysql_fetch_row($res)) {
      return $row;
   } else {
      print (mysql_error());
   }
    break;;



NOTE: that this will NOT fix the problem but it will give you a better explanation as to what the problem is. post back after you alter the file



taut
Back to top Reply with quote
#3.    re: Help with points block
mislead
CZ Newbie
mislead has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 30, 2004
0.00 posts per day
Posts: 17
Points: 3,305
   
i did it and got this:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/clanfaa/public_html/kidnuke/includes/sql_layer.php on line 286
Unknown column 'user_points' in 'field list'
Back to top Reply with quote
#4.    re: Help with points block
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
 Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
run the sql install file again. seems the table was not created and is missing


taut
Back to top Reply with quote
#5.    re: Help with points block
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
   
If your using 7.0 points the change all instances of user_points to just points.




_________________
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
#6.    re: Help with points block
mislead
CZ Newbie
mislead has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 30, 2004
0.00 posts per day
Posts: 17
Points: 3,305
   
ok scrap tht last query, i TRIED to do all this editing 2 the script 2 make this mod work, it hasnt, i looked round my site and found these errors:

when trying 2 post reply:


Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_points' in 'field list'

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,u.user_points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = 38 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 454
File : /home/clanfaa/public_html/kidnuke/modules/Forums/viewtopic.php




when trying 2 post NEW posts:
Parse error: parse error in /home/clanfaa/public_html/kidnuke/includes/functions_post.php on line 260

Fatal error: Call to undefined function: generate_smilies() in /home/clanfaa/public_html/kidnuke/modules/Forums/posting.php on line 1003



when trying 2 view members list:
Parse error: parse error in /home/clanfaa/public_html/kidnuke/modules/Members_List/index.php on line 77


on private message page:
Parse error: parse error in /home/clanfaa/public_html/kidnuke/includes/functions_post.php on line 260


Replying 2 private message:
Fatal error: Call to undefined function: generate_smilies() in /home/clanfaa/public_html/kidnuke/modules/Private_Messages/index.php on line 1607



There is probably more, sorry im such a newbie with this stuff but if you can help it would be much appreciated, thanks
Back to top Reply with quote
#7.    re: Help with points block
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
   
You need to make sure that there is a field on the nuke_users table that says user_points.




_________________
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

∧