| View previous topic :: View next topic |
| Author |
Message |
judybootey
Joined: 01 Jun 2003
Posts: 4
|
 Posted: Sat Sep 06, 2003 11:28 pm Post subject: boo =( |
 |
|
I updated my b2 just to use this hack, and now its not working.
before it did, and then i customized it and blah! first it was that the comments wouldnt show, now i cant even post comments!
I get this
| Quote: | There is an error with the database, it can't store your comment...
Contact the webmaster |
btw, i also use b2lj 0.5. i tried resetting my database, i tired commenting before i installed this hack and i commented successfully. |
|
| Back to top |
|
 |
joan
Joined: 22 Dec 2003
Posts: 9
|
|
| Back to top |
|
|
kokoro
Joined: 03 Dec 2003
Posts: 4
|
| Posted: Mon Jan 05, 2004 1:40 am Post subject: I think I followed it right...but I get this |
|
|
I followed the instructions right but I get an error 500 thing.
Is this a server side error or is this because of the hack? |
|
| Back to top |
|
|
fluffyland
Joined: 12 May 2004
Posts: 9
|
| Posted: Wed Jun 30, 2004 9:46 pm Post subject: Error |
|
|
I followed all the instructions in the readme, and tried to reply to my own comment, but got an error. I figured it would be easier to retry everything than to find my own mistake, so I reverted to my backed up files of b2config.php, b2comments.php, b2comments.post.php, and b2-include/b2functions.php. Then I continued to get an error, even when posting regular comments, so I reuploaded every page of b2.. and I still can't comment.
I get this error:
| Quote: | There is an error with the database, it can't store your comment...
Contact the webmaster |
I'm tearing my hair out here.. I want my comments back!!
_________________
Sam
http://www.fluffyland.com |
|
| Back to top |
|
|
xtheunderdog
Joined: 15 Jun 2004
Posts: 10
|
| Posted: Sun Oct 24, 2004 1:33 am Post subject: |
|
|
I've followed all the directions, but look what's happened:
http://thought-like-flames.net/staffroom/index.php?p=2&c=1
| Code: | <?php // Do not delete these lines
if (basename($HTTP_SERVER_VARS["SCRIPT_FILENAME"]) == "b2comments.php")
die ("please, do not load this page directly");
if (($withcomments) or ($c)) {
$comment_author = (empty($HTTP_COOKIE_VARS["comment_author"])) ? "name" : $HTTP_COOKIE_VARS["comment_author"];
$comment_author_email = (empty($HTTP_COOKIE_VARS["comment_author"])) ? "email" : trim($HTTP_COOKIE_VARS["comment_author_email"]);
$comment_author_url = (empty($HTTP_COOKIE_VARS["comment_author"])) ? "http://url" : trim($HTTP_COOKIE_VARS["comment_author_url"]);
$queryc = "SELECT * FROM $tablecomments WHERE comment_post_ID = $id AND comment_reply_ID = '0' ORDER BY comment_date DESC"; {
?>
<!-- you can start editing here -->
<script language=JavaScript>
<!--
function reply_to(ID)
{
document.theform.comment_reply_ID.value = "" + ID + "";
}
-->
</script>
<a name="comments"></a>
<br>
<?php /* this line is b2's motor, do not delete it */ $wxcvbn_c=0; while($rowc = mysql_fetch_object($resultc)) { $wxcvbn_c++; $commentdata = get_commentdata($rowc->comment_ID); ?>
$comment_ID = $rowc->comment_ID;
<a name="c<?php comment_ID() ?>"></a>
<!-- comment -->
<center>
<div id="commenttable">
<b> <?php comment_author() ?> <?php comment_author_email_link("email", " - ", "") ?><?php comment_author_url_link("url", " - ", "") ?></b><br />
<?php comment_text() ?>
<?php comment_date() ?> @ <?php comment_time() ?> <a href="#post_a_comment" onclick="javascript:reply_to('<?php comment_ID() ?>')" title="reply to this comment" target="_self">Reply</a> <? dodos_thread($comment_ID); ?>
</div>
</center>
<br>
<!-- /comment -->
<?php /* end of the loop, don't delete */ } if (!$wxcvbn_c) { ?>
<!-- this is displayed if there are no pingbacks so far -->
<font class="maintext">No Comment on this post so far.</p>
<?php /* if you delete this the sky will fall on your head */ } ?>
<!-- form to add a comment -->
<a name="post_a_comment"></a>
<center><form action="<?php echo $siteurl; ?>/b2comments.post.php" method="post" name="theform">
<input type="hidden" name="comment_post_ID" value="<?php echo $id; ?>" />
<input type="hidden" name="redirect_to" value="<?php echo htmlspecialchars($HTTP_SERVER_VARS["REQUEST_URI"]); ?>" />
<input type="hidden" name="comment_reply_ID" value="0" />
<input type="text" name="author" class="textarea" value="<?php echo $comment_author ?>" size="40" tabindex="1"
onfocus="this.value=(this.value=='name') ? '' : this.value;" onblur="this.value=(this.value=='') ? 'name' : this.value;" /><br>
<input type="text" name="email" class="textarea" value="<?php echo $comment_author_email ?>" size="40" tabindex="2"
onfocus="this.value=(this.value=='email') ? '' : this.value;" onblur="this.value=(this.value=='') ? 'email' : this.value;" /><br>
<input type="text" name="url" class="textarea" value="<?php echo $comment_author_url ?>" size="40" tabindex="3"
onfocus="this.value=(this.value=='http://url') ? '' : this.value;" onblur="this.value=(this.value=='') ? 'http://url' : this.value;" /><br>
<textarea cols="40" rows="4" name="comment" tabindex="4" class="textarea"
onfocus="this.value=(this.value=='comment') ? '' : this.value;" onblur="this.value=(this.value=='') ? 'comment' : this.value;" >comment</textarea><br>
<p class="commentfield">
<input type="checkbox" name="comment_autobr" value="1" <?php
if ($autobr)
echo " checked=\"checked\"" ?> tabindex="6" /><font class="maintext"> Auto-BR (line-breaks become <br> tags)</font><br />
<input type="submit" name="submit" class="buttonarea" value="ok" tabindex="5" />
</p>
</form></center>
<!-- /form -->
<p> </p>
<?php // if you delete this the sky will fall on your head
}
} else {
return false;
}
?> |
|
|
| Back to top |
|
|
xtheunderdog
Joined: 15 Jun 2004
Posts: 10
|
| Posted: Sun Oct 24, 2004 2:33 am Post subject: |
|
|
nevermind, i fixed it.  |
|
| Back to top |
|
|
v0lc0m
Joined: 09 Feb 2005
Posts: 1
Location: Inland Empire, CA
|
| Posted: Wed Feb 09, 2005 9:06 am Post subject: |
|
|
I've read through all of the Posts on the comment hacks and I couldn't find an answer for this so if anyone could be of help it would be GREATLY appreciated!
I have it installed however when I click "comment plugger" inside my Post/Edit in the b2 CP i get this message
| Quote: | | You have an error in your SQL syntax near 'em'' at line 1 |
Its a white page that has that in plain text. I haven't edited anything else, just the files that I was told to in the read me file.
Thanks in advance!! |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
