I am working to get JoomlaComment working on a site. The component worked several times a long time ago but has stopped working since then. The problem is that when you write a comment it doesn't appear but an error code like this comes up:
<br />
<b>Warning</b>: mysql_real_escape_string() [<a href='function.mysql-real-escape-string'>function.mysql-real-escape-string</a>]: A link to the server could not be established in <b>/backup/tituscol/public_html/components/com_comment/joscomment/utils.php</b> on line <b>548</b><br />
<?xml version="1.0" standalone="yes"?><post><id>23</id><after>4</after><published>1</published><noerror>1</noerror><debug></debug><body><![CDATA[
<table class='postcontainer' id='post23' width='100%' cellpadding='0' cellspacing='0' style='margin-left:0px;'><!-- style='padding-left:0px;'> -->
<tr>
<td><a name='josc23'></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'>misiune</span>
</td>
<td align='right'>
<span class='postnotify0' title='do not notify if new post'> </span>
|<span class='postusertype'><span class='administrator'>SAdministrator</span></span>
|<span class='createdate'>2010-11-03 21:00:13</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(23)'>Reply</a> | <a href='javascript:JOSC_editComment(23)'>Edit</a> | <a href='javascript:JOSC_deleteComment(23)'>Delete</a></td>
<td align='right'><table cellspacing='0' cellpadding='0' border='0'><tr><td><a id='yes23' class='voting_yes' href='javascript:JOSC_voting(23,"yes")'>0</a></td><td> </td><td><a id='no23' class='voting_no' href='javascript:JOSC_voting(23,"no")'>0</a></td></tr></table></td>
</tr>
</table></td>
</tr>
</tbody>
</table>
</td>
</tr>
</table>
]]></body></post>
Yet the comment does appear, but with the comment text: "Character problem. empty comment"
I really do not know what is wrong. I can not access the site through FTP (Because when I activate it in settings it says it can't) and neither do I know how to access the Mambot code. It would be grate if you could give me some advise solving the problem through the Admin site. Maybe the above code can help.
Since I am short in time I appreciate fast help.
Thanks in advance
/Andy