Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 3

  Posted: Jan 26, 2005 - 12:31 AM

  After searching several forums I haven't found this problem anywhere.
  This error only appears on the forum pagesa and seems to be caused by the newsletter subscription block.
  I am using PN gold 750 and Pntresmailer version 6.03
  
  Here is the error I get:
  Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ffa/public_html/modules/pnTresMailer/pnblocks/pnTresMailer.php on line 79
  
  Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/ffa/public_html/modules/pnTresMailer/pnblocks/pnTresMailer.php on line 82
  
  Here are those lines of code:
  function pntresmailer_display($blockinfo) {
  global $prefix;
  
  if (!pnSecAuthAction(0,
  'pnTresMailer::',
  "$blockinfo[title]::",
  ACCESS_READ)) {
  return;
  }
  
  list($dbconn) = pnDBGetConn();
  
  $pnuid = pnUserGetVar('uid');
  $pnuname = pnUserGetVar('uname');
  $pnemail = pnUserGetVar('email');
  
  $SQL = mysql_query("SELECT sub_reg_id FROM $prefix"._nl_subscriber." WHERE sub_uid = '$pnuid'");
  $check = mysql_num_rows($SQL);
  
  $SQL = mysql_query("SELECT nl_unreg, nl_popup, nl_popup_days FROM $prefix"._nl_var."");
  list($nl_unreg, $nl_popup, $nl_popup_days) = mysql_fetch_row($SQL);
  
  $output = "";
  
  $lang = pnSessionGetVar('lang');
  
  I have been fighting this for 2 weeks, please help.

  • 
  •  
• **unknown user**
  
  

  • Rank: Senior
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 2204

  Posted: Jan 26, 2005 - 06:03 AM

  change:
  global $prefix;
  
  to:
  $prefix = pnConfigGetVar('prefix');
  
  
  ..i'm really surprised that module is working with .750 or has someone removed the majority of global vars?

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 40

  Posted: Jan 26, 2005 - 06:22 AM

  Hi IR
  pnTresMailer works good in 750 and even seems to be a version re-written especially for 750. Is available here
  http://www.ev-jugend.de/juleica/modules.php?op=modload& name=UpDownload&file=index&req=viewdownload&cid=11

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 3

  Posted: Jan 26, 2005 - 09:04 AM

  InvalidResponse

  change:
  global $prefix;
  
  to:
  $prefix = pnConfigGetVar('prefix');
  
  
  ..i'm really surprised that module is working with .750 or has someone removed the majority of global vars?

  
  
  I found it and it seems to fix that problem but now knowone can sign up for the newsletter. Any ideas?

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.