Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
checksum
Hangin' Around


Joined: Jun 30, 2003
Posts: 39

PostPosted: Mon Jan 16, 2006 3:39 am Reply with quote

Hi,

Sorry if this is not the right forum for this.
I am having an issue with my My_eGallery module after I installed raven disrto 7.6 v2.02.00 .
The problem i am having is the comment section in My_eGallery, looks like I cannot post more than 80 characters in the comment section (text area). Before I was able to make long post in the comment section, now when I try to post some long text (more than 80 characters), it does not go into the database, it just refreshes the page, but when I post something small like 'test' it works. I have also installed the wysiwyg editor that came with the distro.
This problem probably started after I installed the first distro v1.05.00 from scratch, but I did not notice it, after I upgraded to the v2.02.00 distro, I just noticed it today when i was trying to post a comment.

I would really apreciate any help, because that module in my site is very popular.
here is the sql code pour the comment section:
Code:
CREATE TABLE `nuke_gallery_comments` (

  `cid` int(11) NOT NULL auto_increment,
  `pid` int(4) NOT NULL default '0',
  `comment` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `name` varchar(255) default NULL,
  `member` int(1) NOT NULL default '0',
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12322 ;


Thanks
 
View user's profile Send private message
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Mon Jan 16, 2006 6:13 am Reply with quote

checksum, see this thread here:
Only registered users can see links on this board! Get registered or login!

Does your text have the word "union" in it?

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
checksum
PostPosted: Mon Jan 16, 2006 8:43 am Reply with quote

No, the text does not contains the word UNION, and it is a relatively small text ( about 200 characters), here is the text
Code:
Ahhh, enfin Viviane weuy seu meu serigne waay:-). Yala ne niou dadje aldjana...amine<br><br>

J'en profite pour remercier <b>Moizaa</b> qui nous a ramene toutes ces nouveautes de dakar.
More to come, stay tuned...
and I don't get redirected to the homepage, it stays (refreshes) on the same comment page with just no comment posted.
I also tried to change the comment field to LONGTEXT, but still does not work.
If you want , I can give you access to the module and database so you can see for yourself....
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Mon Jan 16, 2006 9:33 am Reply with quote

Since the distro does nothing with third party applications, I don't think it's the distro, per se. In an effort to debug, try adding just 1 or 2 words of your comment at a time and see when it stops accepting it. That will isolate if it is a particular word that is stopping it. Have you checked your error log?
 
View user's profile Send private message
checksum
PostPosted: Mon Jan 16, 2006 11:03 am Reply with quote

Reaven, I did what you told me, and this is what I found out. It worked when I took out the apostrophee ' in the second line in j'en.
When I entered this :
Code:
Ahhh, enfin Viviane weuy seu meu serigne waay:-). Yala ne niou dadje aldjana...amine<br><br>

Jen profite pour remercier <b>Moizaa</b> qui nous a ramene toutes ces nouveautes de dakar.
More to come, stay tuned...
it worked...
 
checksum
PostPosted: Mon Jan 16, 2006 5:30 pm Reply with quote

But I still don't know how to fix it...
 
montego
PostPosted: Tue Jan 17, 2006 6:30 am Reply with quote

checksum, with so many add-on tools out there, we may not have specific experience with your given issue. I am now thinking that this thread may be more appropriate: Only registered users can see links on this board! Get registered or login!

Although this is related to forums, I would take a look at the comment update/post code and see if you can add the addslashes() to the incoming user input on the comments field. Although I am not 100% certain this is the issue, it is worth you taking a look. I am thinking that you have the display errors turned off (which is definitely a good thing), and it is keeping us from possibly seeing a SQL error.
 
checksum
PostPosted: Tue Jan 17, 2006 12:02 pm Reply with quote

Well, here is part of the code reponsible for the comment in displaymedia.php , the part in red is the textarea.
Code:
function displayCommentsPic($pid, $orderby) {

   global
        $adminpath,
      $user,
   $baseurl,
   $admin,
   $imagepath,
   $prefix, $db,
        $font,
      $bgcolor1,
      $bgcolor2
   ;

   include("$adminpath/config.php");

   $out = '<br><p align="center">';
   $out .= '<font class="'.$font['title'].'">'._GALCOMMPOST.'</font></p><br><br>';
   $result3 = $db->sql_query("select cid, pid, comment, date, name, member from $prefix"._gallery_comments." where pid=$pid order by date ASC");
   if ($db->sql_numrows($result3) == 0) {
      $out .= '<p align="center"><font class="content">'._GALNOCOMM.'</font></p><br>';
         }
   else {
      $out .= '<TABLE border="0" bgcolor="white" cellPadding="2" cellSpacing="2" width="80%" align="center">';

           while(list($cid, $cpid, $comment, $date, $name, $member) = $db->sql_fetchrow($result3)) {
              if ($member)
                 $poster = '<a class="'.$font['normal'].'" href="userinfo-.html'.$name.'">'.underscoreTospace($name).'</a>';
              else
                 $poster =  '<font class="'.$font['normal'].'">'.underscoreTospace($name).'</font>';

           $out .= '<TR>';

      $out .= '  <TD align="center" bgColor="'.$bgcolor2.'" vAlign="top" width="140"><font class="'.$font['normal'].'"><b>'.$poster.'</b><br>('.substr($date,0,10).')</font></TD>'
              .'  <TD align="left" bgColor="'.$bgcolor1.'" vAlign="top"><font class="'.$font['normal'].'">'.$comment.'</font></TD>';            

      if (is_admin($admin))
              $out .= '  <TD align="center" width="30"><a href="'.$baseurl.'&amp;do=deletecomment&amp;cid='.$cid.'&amp;pid='.$pid.'&amp;orderby='.$orderby.'" onClick="return confirm(\''._GALSURE2DELETECOMMENT.'\')">'
              .'<img src="'.$imagepath.'/delete.gif" border="0" alt="'._DELETE.'"></a></td>';

      $out .= '</TR>';
           } //while
           $out .= '</TABLE>';
   }
   print '<br><br>';
   [color=red]if (is_user($user)) {
      $userdata=cookiedecode($user);
      $out .=
      '<center><p align="center"><form action="'.$baseurl.'" method="POST">'
      .'<input type="hidden" name="do" value="Post">'
      .'<font class="'.$font['title'].'">'._GALNAME.'</font>&nbsp;<b>'.$userdata[1].'</b>'
             .'<input type="hidden" name="gname" value="'.$userdata[1].'">'
             .'<input type="hidden" name="member" value="1"><br>'
      .'<font class="'.$font['title'].'">'._GALCOMMENT.'</font><br>'
        .'<textarea wrap="virtual" cols="40" rows="8" name="comment" type="text" maxlength="70"></textarea><br>'
     .'<input class="textbox" type="hidden" name="pid" value="'.$pid.'">&nbsp;'
        .'<input type="submit" value="Envoyer">'
      .'</form>'
      .'<font class="option">'._GALNOTE.'</font></p></center>';
   }[/color]
   elseif (!$galleryvar['anoncomments']) {

$out .=
      '<p align="center"><form action="'.$baseurl.'" method="post">'
      .'<input type="hidden" name="do" value="Post">'
      .'<font class="'.$font['title'].'">'._GALNAME.'</font><br>'
           .'<input type="text" SIZE="20" MAXLENGTH="20" name="gname">'
           .'<input type="hidden" name="member" value="0">'
           .'<br><font class="'.$font['title'].'">'._GALCOMMENT.'</font><br>'
      .'<input class="textbox" type="text" name="comment" size="70" maxlength="70"><br>'
      .'<input class="textbox" type="hidden" name="pid" value="'.$pid.'">&nbsp;'
      .'<input type="submit" value="Post">'
      .'</form>';
//      .'<font class="option">'._GALNOTE.'</font></p>';
   }
   else {
      $out .= '<p align="center"><font class="'.$font['tiny'].'">'._GALREGISTER."</font></p>";
   }
  return $out;
}

I added
Code:
$comment = addslashes($comment);
right after the include command, but still did not work
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous 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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©