Problem with My_eGallery comments after upgrading to v2.02

Hangin' Around Joined: Jun 30, 2003 Posts: 39

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

registered · Posted: Mon Jan 16, 2006 6:13 am

checksum, see this thread here:

http://www.ravenphpscripts.com/postt8038.html

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

Posted: Mon Jan 16, 2006 8:43 am

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....

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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?

Posted: Mon Jan 16, 2006 11:03 am

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...

Posted: Mon Jan 16, 2006 5:30 pm

But I still don't know how to fix it...

Posted: Tue Jan 17, 2006 6:30 am

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: http://www.ravenphpscripts.com/posts8118-highlight-.html

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.

Posted: Tue Jan 17, 2006 12:02 pm

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