×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Archive
!joomlacomment
Installation
I installed it but can not post a comment
  • Page:
  • 1

TOPIC: I installed it but can not post a comment

I installed it but can not post a comment 16 years 2 months ago #798

  • eehjhay
  • eehjhay's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
I installed the JoomlaComment already. But when I was posting a new comment to test it, an alert pop-up saying Request Failed and it returns some codes inside the comment field with this:
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/mounted-storage/home61b/sub003/sc38127-PHZD/net/v3/components/com_comment/joscomment/utils.php</b> on line <b>678</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/mounted-storage/home61b/sub003/sc38127-PHZD/net/v3/components/com_comment/joscomment/utils.php</b> on line <b>678</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/mounted-storage/home61b/sub003/sc38127-PHZD/net/v3/components/com_comment/joscomment/utils.php</b> on line <b>678</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/mounted-storage/home61b/sub003/sc38127-PHZD/net/v3/components/com_comment/joscomment/utils.php</b> on line <b>678</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/mounted-storage/home61b/sub003/sc38127-PHZD/net/v3/components/com_comment/joscomment/utils.php</b> on line <b>678</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/mounted-storage/home61b/sub003/sc38127-PHZD/net/v3/components/com_comment/joscomment/utils.php</b> on line <b>678</b><br />
<?xml version="1.0" standalone="yes"?><post><id>1</id><after>-1</after><published>1</published><noerror>1</noerror><debug></debug><body><![CDATA[
<table class='postcontainer' id='post1' width='100%' cellpadding='0' cellspacing='0' style='margin-left:0px;'><!-- style='padding-left:0px;'> -->
	<tr>
		<td><a name='josc1'></a>
<table class='post' width='100%' cellpadding='0' cellspacing='0'>
  <tbody class='sectiontableentry'>
    <tr>
      <td><table class='postheader' width='100%' cellpadding='0' cellspacing='0'>
          <tr>
            <td align='left'>
            	<span class='postusername'>eehjhay</span>
 
            </td>
            <td align='right'>
 
				<span class='postnotify0' title='do not notify if new post'>&nbsp;</span>
            	|<span class='postusertype'><span class='administrator'>SAdministrator</span></span>
            	|<span class='createdate'>2008-08-29 20:12:17</span>
            </td>
          </tr>
        </table></td>
    </tr>
    <tr>
      <td colspan='2'><table class='postbody' width='100%' cellpadding='0' cellspacing='0'>
          <tr>
 
			<td style='overflow: hidden;'>Character problem. empty comment</td>
          </tr>
        </table></td>
    </tr>
 
  <tr>
    <td><table class='postfooter' width='100%' cellpadding='0' cellspacing='0'>
        <tr>
          <td align='left'><a href='javascript:JOSC_reply(1)'>Reply</a> | <a href = 'javascript:JOSC_quote(1)'>Quote</a> | <a href='javascript:JOSC_editComment(1)'>Edit</a> | <a href='javascript:JOSC_deleteComment(1)'>Delete</a></td>
          <td align='right'><table cellspacing='0' cellpadding='0' border='0'><tr><td><a id='yes1' class='voting_yes' href='javascript:JOSC_voting(1,&#34;yes&#34;)'>0</a></td><td>&nbsp;</td><td><a id='no1' class='voting_no' href='javascript:JOSC_voting(1,&#34;no&#34;)'>0</a></td></tr></table></td>
        </tr>
      </table></td>
  </tr>
 
  </tbody>
</table>
		</td>
	</tr>
</table>
]]></body></post>

After that, if I check the comment list, a new comment post has been created but it always have this message in it "Character problem. empty comment"

I installed it but can not post a comment 16 years 2 months ago #804

  • Ajay Lulia
  • Ajay Lulia's Avatar
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 32
  • Thank you received: 0
Hello,

Can you provide more details as to what is the PHP version and mysql version?

Cheers,
Ajay.

I installed it but can not post a comment 16 years 2 months ago #806

  • eehjhay
  • eehjhay's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
This is what's on the website of my host provider PHP v 4.4.4 & 5.2.1 and the version of mysql is 5.

I installed it but can not post a comment 16 years 2 months ago #807

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Is there any chance on upgrading to php5?

I installed it but can not post a comment 16 years 2 months ago #810

  • eehjhay
  • eehjhay's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
I will suggest to them to upgrade to php5, they might take it into consider because also sometimes my whole Joomla! site receives error messages saying that it couldn't connect to the database. I submitted a support ticket already and they said they will try their best to find a solution for that.

Anyway, what seems to be the problem with my installation for this? :unsure: Is it because of the version of the PHP? Or there's another way on solving this? :S

I installed it but can not post a comment 16 years 2 months ago #822

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
I suppose it is the php version.
The problem is - we can not test !jocomment with every single php version.

I installed it but can not post a comment 15 years 11 months ago #1831

  • astepas
  • astepas's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Hi,

I installed component. But when I try to add new comment, I just see "Request failed" message. And after that in comment field is:

<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/home/cejot/public_html/testowa/components/com_comment/joscomment/utils.php</b> on line <b>652</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/home/cejot/public_html/testowa/components/com_comment/joscomment/utils.php</b> on line <b>652</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/home/cejot/public_html/testowa/components/com_comment/joscomment/utils.php</b> on line <b>652</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/home/cejot/public_html/testowa/components/com_comment/joscomment/utils.php</b> on line <b>652</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/home/cejot/public_html/testowa/components/com_comment/joscomment/utils.php</b> on line <b>652</b><br />
<br />
<b>Warning</b>:  mysql_real_escape_string() expects parameter 2 to be resource, object given in <b>/home/cejot/public_html/testowa/components/com_comment/joscomment/utils.php</b> on line <b>652</b><br />
<?xml version="1.0" standalone="yes"?><post><id>2</id><after>-1</after><published>1</published><noerror>1</noerror><debug></debug><body><![CDATA[
<table class='postcontainer' id='post2' width='100%' cellpadding='0' cellspacing='0' style='margin-left:0px;'><!-- style='padding-left:0px;'> -->
	<tr>
		<td><a name='josc2'></a>
<table class='post' width='100%' cellpadding='0' cellspacing='0'>
  <tbody class='sectiontableentry'>
    <tr>
      <td><table class='postheader' width='100%' cellpadding='0' cellspacing='0'>
          <tr>
            <td align='left'>
            	<span class='postusername'>Anonymous</span>
 
            </td>
            <td align='right'>
 
				<span class='postnotify0' title='do not notify if new post'>&nbsp;</span>
            	|<span class='postusertype'>83.29.8.xxx</span>
            	|<span class='createdate'>2008-12-14 12:10:53</span>
            </td>
          </tr>
        </table></td>
    </tr>
    <tr>
      <td colspan='2'><table class='postbody' width='100%' cellpadding='0' cellspacing='0'>
          <tr>
 
			<td style='overflow: hidden;'>Character problem. empty comment</td>
          </tr>
        </table></td>
    </tr>
 
  <tr>
    <td><table class='postfooter' width='100%' cellpadding='0' cellspacing='0'>
        <tr>
          <td align='left'><a href='javascript:JOSC_reply(2)'>Reply</a> | <a href = 'javascript:JOSC_quote(2)'>Quote</a></td>
          <td align='right'><table cellspacing='0' cellpadding='0' border='0'><tr><td><a id='yes2' class='voting_yes' href='javascript:JOSC_voting(2,&#34;yes&#34;)'>0</a></td><td>&nbsp;</td><td><a id='no2' class='voting_no' href='javascript:JOSC_voting(2,&#34;no&#34;)'>0</a></td></tr></table></td>
        </tr>
      </table></td>
  </tr>
 
  </tbody>
</table>
		</td>
	</tr>
</table>
]]></body></post>


My system:
PHP Version 5.2.6
utf8_general_ci
MYSQli 5.0.67-percona-b6-log

Do you have any idea?

I installed it but can not post a comment 15 years 10 months ago #1912

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
are you sure you have php5? This should not happen if you are working on php5 server.

I installed it but can not post a comment 15 years 10 months ago #1944

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey there astepas!
I was reading the documentation to the mysql_real_escape_string function I saw several comments about mysqli .
( http://de.php.net/manual/en/function.mysql-real-escape-string.php )

Can you do the following test for me:
go to line 652 in utils.php
and change:
$result = mysql_real_escape_string( $value, $database->_resource );

to
$result = mysqli_real_escape_string( $database->_resource, $value );

I installed it but can not post a comment 15 years 10 months ago #1949

  • astepas
  • astepas's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Yeahh!:) It's working! Thanks:)

But I have another bug: when i click on "List of joomlacomment Comments" I see message:
Catchable fatal error: Object of class stdClass could not be converted to string in /home/cejot/public_html/testowa/administrator/components/com_comment/admin.comment.html.php on line 50


Do you know how it fix?

I installed it but can not post a comment 15 years 10 months ago #1951

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
I don't know what you have on line 50, but perhaps your problem looks like this here:
forum.wordpress-deutschland.org/design/3...d-not-converted.html

I installed it but can not post a comment 15 years 10 months ago #2018

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey guys!
Can you please take 3 minutes to fill out this survey for us compojoom.com/survey/index.php?sid=28833
  • Page:
  • 1
Forum
Archive
!joomlacomment
Installation
I installed it but can not post a comment
Time to create page: 0.136 seconds