Coment Queue Script/MT Hack
This Script/MT Hack will make it so that all comments to your blog(s) will go into a “pending” status. You can login into the script, see all the “pending” comments. Review them. Edit them. Delete the ones you don’t want on your site. Approve the ones you do.
For people who want to have their blogs open for anyone/everyone to join in on, but don’t like the idea of forcing registration before allowing comments from visitors, this is a great alternative. This way anyone can still comment on your site (without forcing them to register) - but you still control what actually goes on your site.
This script requires PHP to run the “review/edit/approve/delete” part. But you don’t need to have it running on your page. (ie. this will even work with the popupcomments)
This script also requires modifying two MT files and the MT database. (If you’re nervous about doing this - I suggest 1) backup your stuff before installing the script 2) set up another MT in a test environment - that way you can practice and test it out first.
One thing I would have liked to incorporate is integrating the mt-rebuild plugin/utility. If somone can figure out how to do that - please post it in the comments!
This script now needs the mt-rebuild script to work. (Simply download that file, upload it to the same directory as your MT files - no need to edit it). You will need to do this BEFORE you upgrade or install the Comment Queue Script.
Download the script/mt-hack here.
Current Version
version .03 - released June 25, 2003
What’s new in the latest version:
v.03:
fixed bug with wrong title displaying. (Thanks Marco!)
v.02:
Script now uses the mt-rebuild script to rebuild posts. (This is a seperate download. Go here to download the mt-rebuild script) No more poping up seperate windows to rebuild posts. This also fixes the bug with the “allow pings” box getting unchecked. Also fixed bug where the script assumes your blog pages are all .php.
Upgrade Instructions
Upgrade from previous versions - download .zip using above link - follow upgrade instructions included.
IMPORTANT: I’ve tried to be as specific as possible in the documentation and comments on pages that need to be edited. Before posting a question, please look over the included instructions very carefully.
Update 8/20/03: (David has a perl version of this here - his will work even if you’re not running MT with mySQL!)
June 10th, 2003 at 10:13 pm
Great work! Can’t wait to try it out!
June 11th, 2003 at 4:36 pm
Here’s a wonderful new MT hack from the Scripty Goddesses — comment pending queue. If you’ve been plagued by trolls, or just want more control over your comments, this script allows your comments to be pending rather than instantly published. You can …
June 12th, 2003 at 10:45 pm
I probably won’t add this to my blog, but if I put together a journal like I’ve considered, this plugin will be the first thing I install!
June 13th, 2003 at 4:41 am
It’s now less than two weeks before we set off to France (yay!), so, mostly for my own benefit, here’s a list of things I need to do before I go…
June 14th, 2003 at 10:55 pm
I’m getting errors on the install despite having permissions set correctly. Specifically, I’m being told:
Warning: fopen(/home/…/password.php) [function.fopen]: failed to create stream: Permission denied in /home/…/setpassword.php on line 20
Password file created. Make a local backup of this page (in case you ever want to change/reset your password - but remove it off your server.
But there is no file entitled password.php on my server and I cannot login to the script.
Help?!
June 14th, 2003 at 11:02 pm
Leah - please email me so I can help you figure this out… when we’ve figured it out - we can come back and post the results in the comments…
June 15th, 2003 at 5:17 am
It’s now less than two weeks before we set off to France (yay!), so, mostly for my own benefit, here’s a list of things I need to do before I go…
June 17th, 2003 at 4:08 am
Have any other bloggers had a comment from 194.177.210.228 ?
June 18th, 2003 at 3:12 am
I noticed on the ‘index’ screen (the one which shows a summary of all comments queued) - the links point to http://www.mydomain.com/archives/000001.php , even though I use http://www.mydomain.com/archives/000001.html . Am I doing something wrong, or is this a bug?
June 18th, 2003 at 6:21 am
Another apparent bug - when I approve comments on a post, the ‘Allow Pings’ box becomes unticked.
June 18th, 2003 at 6:36 am
It’s a bug… I need to add a customization setting to set what “file extension” people use… will update the script and download within the next day or so. (and I’ll let you know what you need to do if you’ve already installed it…)
Thanks for the heads up!!
June 18th, 2003 at 6:41 am
re: allow pings - that’s weird… I’ll look into it… most likely a bug
June 20th, 2003 at 5:55 pm
This is too cool, Jennifer! Before I start playing around this weekend, I thought I’d ask - is there anything special I need to pay attention to with my also having the Subscribe to Comments feature running?
Thanks for continuing to inspire me - I always get excited when I see the new things you’ve cooked up! =)
June 20th, 2003 at 10:11 pm
Ok just in case you’re subscribed to the comments here - I’ve just updated the post and the download… assumed “.php” is fixed. and script now uses mt-rebuild script, so no more windows popping up.
It’s VERY smooth. This also fixes the “allow pings” getting unchecked problem. See the update and the new download for details.
As for the comment subscribe thing - I will have to address that seperately. You can have both - one doesn’t affect the other - but anyone who is subscribed to comments will receive the comment notification when the person submits their comment. It doesn’t hold it until you approve it. I’ll have to come up with a version that doesn’t send out the emails to comment subscribers until they’re approved - but I can’t guarantee that it’ll happen soon…
June 20th, 2003 at 10:58 pm
Oh my gosh, look at you go!! Yay! =)
June 22nd, 2003 at 7:33 pm
Ok I have almost set it up but I wanted to know if i need to have mt setup with MYSQL to be able to use this?
June 22nd, 2003 at 7:39 pm
Yes - you will absolutely need the MySQL version of MT running in order for this to work.
June 22nd, 2003 at 7:45 pm
Sounds like I may have to reinstall MT with MYSQL.
Thanks
June 22nd, 2003 at 7:48 pm
You don’t need to reinstall MT - there’s a conversion script in the upgrade distribution, and instructions in the upgrade manual for converting from Berkeley to MySQL. =)
June 22nd, 2003 at 7:56 pm
I just got MYSQL installed onto my website so I was just running mt withour Berkley or MYSQL suport will i still be able to upgrade from that?
June 22nd, 2003 at 8:03 pm
At the risk of hijacking Jen’s site for an MT support issue: MT requires at least one database option - unless you installed with MySQL, PostgreSQL or SQLite - you’re using Berkeley.
(Sorry, Jennifer!)
June 22nd, 2003 at 8:06 pm
LOL! No need to apologize. I’m sure there’s others with the same questions.
June 22nd, 2003 at 8:06 pm
Thank-you, I am still a newbie to alot of this
June 22nd, 2003 at 10:19 pm
yay it worked! but I have one small problem, once I login and ‘view the comment’ its shows the wrong title for that particular post eg I tested it on a post called ‘My new design’ , I open the comments its said ‘My new design’ was the entry’s title but when I viewed the actual comments it said the entry was ‘opinions’ which was an entry from months ago.
June 25th, 2003 at 2:54 pm
Jennifer, how could I than you enough for this? I almost cannot believe that I am going to get rid of all those trolls on my blog. Thank you very very much!
June 25th, 2003 at 3:58 pm
Yeah, Sine. The same problem is occurring here. Weird, isn’t it?
June 25th, 2003 at 9:33 pm
To those of you who are subscribed to this post - FYI - new update to the download that should fix that problem with the title display bug.
June 26th, 2003 at 10:20 pm
Yay ! Its worked you guys are awesome!
July 13th, 2003 at 3:54 pm
Okay… problemo. Upgraded to 0.3 from 0.1. Works fine except it doesn’t rebuild the entries. I have MTRebuild installed to my MT folder and the permissions for it set to 700, and the folder paths are set correctly in config.php.
Any help would be appreciated.
July 16th, 2003 at 6:53 am
Will this eventually work with all blogging programs or is it specifically for MT? I use Word Press and this would be a great addition.
July 20th, 2003 at 3:28 pm
I know this isn’t directly related to this particular entry, but I was wondering if you, oh-MT-genius, could explain an MT comment problem I’ve seen on various blogs (including my own). I’ve noticed that some comment bodies on MT weblogs (specifically popup comments) show up blank. Does anybody else notice this? I must be crazy because I haven’t found any documentation on this. The popup link is clicked, the page pops up and the comment form loads fine, but the comment body and header shows up blank, so you have to click and drag your mouse over to highlight what would have been there, and THEN the text shows up. What’s up?
July 21st, 2003 at 3:07 am
I’ve disabled comments on the most recent entries. Once I install the comment queue script/hack, I will change that. xo,…
July 28th, 2003 at 12:29 pm
oh my goodness. this is going to save my life! beautiful script. the interface is great, btw.
August 1st, 2003 at 10:59 pm
Help? This is not working and I’m not sure if I have everything installed properly. I created a folder called “comment” outside of my public_html folder. I placed the dbconnect inside this folder and the mtrebuild and changes files in the cgi-bin directory (with the rest of my MT files).
I cannot get passed the “set password” stage no matter where I put the rest of the files!
It’s this sentence that has me geeking:
“All other files should be in the same directory as each other.”
Uh…….okay. Where would that be? I’ve tried the rest of the files in every conceivable configuration but I’m still getting a 404 when I type in
http://www.margilowry.com/comment/setpassword.php
I realize that this is going to be the DUMBEST question you have seen yet, but I’m dying to get this implemented (I have one hella troll) and I can’t figure out what it is I’m doing wrong!
I thank you for your patience.
August 3rd, 2003 at 1:31 am
I wanted to give a big and greatful, huge and…
August 3rd, 2003 at 1:37 am
I wanted to stop back by and thank Jennifer for being SO patient and kind and helping me fix this.
It was, as you all already probably guessed, OPERATOR ERROR.
What a wonderful thing you have here. You have my gratitude.
Thank you so much.
August 15th, 2003 at 9:26 pm
It looks like I got the comments queue script working fine. I can log in no problem. In fact, when I followed all the installation instructions everything went so smoothly I was shocked. The problem is now I can’t log into MovableType. I get the follow error message:
MT/Comment.pm did not return a true value at /home/myusername/www/www/cgi-bin/lib/MT/Entry.pm line 12. BEGIN failed–compilation aborted at /home/myusername/www/www/cgi-bin/lib/MT/Entry.pm line 12. Compilation failed in require at /home/myusername/www/www/cgi-bin/lib/MT/App/CMS.pm line 2098.
(”myusername” substituted for my real username)
I looked back at the two mt files I had to edit (comment.pm and comments.pm) and everything seemed exactly as it should be (the changed way). I’m not sure what I’m missing or where to look. Any suggestions?
August 15th, 2003 at 11:16 pm
Nevermind, I got it to work. I feel a little dumb, but nevertheless relieved that it is working now. Remember the two MT files that needed changes? Well, when I made the changes I downloaded them, made the changes and then uploaded them back to my server. I thought I uploaded them in ASCII mode, but I did it rather quickly and aparently wasn’t paying close attention. Well, long story short (after a lot of back tracking on my part), I carefully uploaded the files again (this time definately in ASCII mode). When I went back to try and logon to MT on my site everything worked.
Hope this can help others.
Another question: How does this script intergrate with the email new comments feature in mt? I don’t seem to be getting emails of new comments. It’s ok. I’d rather have this script and no emailing of comments, but it would be nice to have an email of a new comment that I could approve or delete. I wasn’t sure if I was missing something or that’s just how it is at the moment. Just wondering.
Thanks for the script.
August 15th, 2003 at 11:42 pm
Hi Tami ~
I can answer that last question (at least). Heh.
If you have the e-mail new comments feature turned on within Movable Type, you will still receive the e-mail notification, regardless. The comment will not show up on your site until you approve it, however.
HTH,
Margi
August 19th, 2003 at 12:36 am
Clap your hands or stomp your feet or do the happy dance like I’m doing right now!!! I’m here. I’m
August 19th, 2003 at 11:42 am
Is what I will be doing during the week now well until I get a new and improved calling plan.
August 20th, 2003 at 11:02 pm
You have probably all seen the Comment Queue hack over at scriptygoddess. Well, a couple nights ago Cheyenne asked me…
September 24th, 2003 at 10:42 am
In response to a LazyWeb request, I present a new low-impact high-efficacy solution for preventing comment spam and killing ones after the fact. Moveable Type and three MT plugins are required, but no source code hacks are used.
September 24th, 2003 at 10:44 am
In response to a LazyWeb request, I present a new low-impact high-efficacy solution for preventing comment spam and killing ones after the fact. Moveable Type and three MT plugins are required, but no source code hacks are used.
September 26th, 2003 at 3:32 pm
ƒRƒƒ“ƒg‚³‚ꂽ‚Æ‚«‚É‘¦ŒöŠJ‚ł͂ȂAˆê’UŒŸ‰{‚µ‚Ä‚©‚炳Ȃ¢‚ÆŒöŠJ‚³‚ê‚È‚¢‚悤‚É‚·‚邽‚߂̃XƒNƒŠƒvƒg‚¾‚»‚¤‚Å‚·BŽå‚É comment spam ‘ÎR‚Å‚µ‚傤‚©B scriptygoddess This Script/MT Hack will make it so that all comments to your blog(s) will go into a “pendin…
September 28th, 2003 at 8:55 pm
Yesterday Jay noticed that I was having a comment spam problem. A few low-life moron assholes have been using my blog to try to boost the PageRank of their various businesses: search engine optimization, porn, and cheap prescription drugs. He suggested…
October 3rd, 2003 at 9:45 am
I’m getting about five spam comments per day. It’s really annoying and I think it’s just the tip of the iceberg - a sign of things to come, if you will. There are a lot of people who are trying…
October 4th, 2003 at 6:02 pm
I was absolutely horrified when I read Phil Ringnalda’s comment spam alert story last year in which a Las Vegas real estate agent used a script to try to autogenerate comments to every single one of Phil’s entries, including links to the spammer’s real…
October 5th, 2003 at 6:35 pm
I’ve been getting a pile of stupid comments on the site, many of them loaded with URLs for casinos, male enhancement, among other crap. I don’t want to have to…
October 6th, 2003 at 5:53 pm
i started getting a LOT of comment spam … so i just renamed mt-comments.cgi to mt-c0mments.cgi to keep the robots away. i haven’t received any comment spam since then, and i used to get several every day, so i suppose it must be working. publicizin…
October 8th, 2003 at 9:38 am
It’s a hot topic in the blogosphere lately. As well it should be, since so many of us are hit by it. I’ve been getting a few a week, which I suppose I should be grateful. There are some who…
October 9th, 2003 at 10:49 am
Thanks to Judi, I’ve implemented this method of easily handling comment spam. What I’d really like is a link that does a few things:Deletes the…
October 12th, 2003 at 10:28 am
Like practically everybody else in the blogsphere at the moment, I’m suffering quite a bit of comment spam: I had to block my first IP address yesterday - and now I’m blocking the following 7 IP addresses: 209.210.176.19 209.210.176.20 209.210.176.21 2…
October 12th, 2003 at 2:03 pm
Comment spam. It seems that everyone is either complaining about it, or coming up with ideas on how to deal with it. This one, by Jay Allen shows a great deal of promise. It’s going to be released tomorrow on…
October 12th, 2003 at 4:13 pm
God I hate spam. I get enough of it in my mailboxes, and now my blog comments are getting them
October 12th, 2003 at 5:38 pm
Ok, I just spent the last five hour or so dealing with comment spam, basically since my last entry, across…
October 13th, 2003 at 11:03 am
Comment spam. It seems that everyone is either complaining about it, or coming up with ideas on how to deal with it. This one, by Jay Allen shows a great deal of promise. It’s going to be released tomorrow on…
October 13th, 2003 at 1:07 pm
I like blog comments. I understand why some folks don’t turn on the comments functionality in their blogs, either because…
October 13th, 2003 at 6:43 pm
There’s been a lot of talk recently about spammers posting comments in Moveable Type to attract people to their sites. Jay Allen has created MT-Blacklist which blacklists comments based on the linked content. He surmises that the linked content is…
October 13th, 2003 at 8:30 pm
In response to a LazyWeb request, I present a new low-impact high-efficacy solution for preventing comment spam and killing ones after the fact. Moveable Type and three MT plugins are required, but no source code hacks are used.
October 24th, 2003 at 8:21 am
MT-Blacklist rocks! The only problem is that, without having a Comments queuing system you can’t necessarily avoid new comment spam
November 3rd, 2003 at 10:25 am
Yesterday Jay noticed that I was having a comment spam problem. A few low-life moron assholes have been using my blog to try to boost the PageRank of their various businesses: search engine optimization, porn, and cheap prescription drugs. He suggested…
November 7th, 2003 at 12:42 am
This hack appears to be incompatible with Jay Allen’s mt-blacklist, I’ve just discovered. However, I think modifying his Blacklist.pm where you say to modify Comments.pm (in his file, it’s in the function comment_post_hdlr, the line is 3039) should make it work.
I haven’t tested it, since I decided not to queue comments after all, but I’m pretty sure that should work. I’ve also emailed Jay to tell him.
November 9th, 2003 at 5:24 pm
Hi, great site! Does your script work also without MT because I want to use a simple comment script for articlesposted on my website.
Thanks
November 11th, 2003 at 3:20 pm
I was having comments fail to show up in the Queue after installing BlackList the other day so I disabled BlackList temporarily. It took me a few days to realize it though *laughs* Was wondering where they were going!
Here’s the fix. I use the “All Blog Option”, but I assume it will work if you copy/paste the code for the other options as well.
Editing line 3039 in BlackList.pm from:
$comment->entry_id($q->param(’entry_id’));
to:
$comment->entry_id(’0′);
$comment->temp_entry_id($q->param(’entry_id’));
(Just like the Queue instructions have us do in the “All Blogs Option”)
Then re-upload the file as ASCII, CHMOD to 755 again and do a test run. It seems to have worked okay for me on my test entry. It showed up in the queue again and BlackList is back to running again
Hope that made sense hehehe
November 11th, 2003 at 3:34 pm
Comments not showing up in Comment Queue, while MT-BlackList is active too? Gotta edit a line!
November 18th, 2003 at 10:50 pm
Thanks for the script! Did you know that there are over 2 million MT comment pages indexed in Google!
If more comment-spammers realize this, your script will go through the roof!
Again Thanks.
November 21st, 2003 at 5:10 pm
I’m back. I’ve been ill, both in body and spirit. I’m not necessarily “better”, but I do have some idea what the problem is, so I can move on from here. I’ll talk more about that later; for now just…
November 21st, 2003 at 5:11 pm
I’m back. I’ve been ill, both in body and spirit. I’m not necessarily “better”, but I do have some idea what the problem is, so I can move on from here. I’ll talk more about that later; for now just…
November 22nd, 2003 at 2:32 pm
Thanks for this — what a great script!
I’m just curious…when one rebuilds one’s site so that new comments will appear, it can take quite a long time to go through all of the files. Are there any shortcuts for this, or am I out of luck?
Thanks again, Jennifer!
December 10th, 2003 at 9:16 pm
I am testing MT and CommentQueue for a nonprofit public affairs website I run called indiatogether.org.
1. I am not getting any errors, but I am unable to use setpassword.php. Everytime I enter a username and password and click, password.php is NOT created and the page gets refreshed and form comes back empty. I DO NOT SEE ANY MESSAGE.
2. Did you modify the original code at all?
I setup config.php and dbconnect.php according to my environment. I have not touched any code.
3. Where is the page you’re getting an error?
http://www.indiatogether.org/input/CQ/setpassword.php
- Remember, I don’t get an error message, but I know that password.php file is not getting created and the form just comes back without a message when I hit submit.
4. I have carefully checked and rechecked the “$logincheck” parameter setting in config.php as well as permissions (777) for the directory in which password.php is. I have also kept password.php and dbconnect.php outside of the document root.
The web server is Freebsd, running Apache. mySQL is running fine. I have not gotten to editing Comments.pm yet.
Can someone help?
December 11th, 2003 at 12:58 am
The dillhole at 62.213.67.122 has been banned for attempting to…
December 11th, 2003 at 4:16 am
I’m not really one to tolerate public blog spam, especially when I have to pay (in bandwidth and my time to delete messages) for these asshats’ arrogance. Therefore, I have implemented Scripty Goddess’ comment-queue script. This means that I will…
December 15th, 2003 at 5:23 pm
I’ve tried everything and I can’t seem to get it to work on my blog. I’ve followed the instructions, but when I log into MT, the five most recent comments box located to the right is gone as well as other comments through my blog. I was able to get it all back by reuploading the original comment and comments files. I also have no problems setting the password or logging in after, my comments just seem to vanish and none show up when I do log in to check, even though I had posted several test comments. Help please, I have a nasty troll and I’m so tired of the spammers.
December 22nd, 2003 at 10:00 am
Andrew gave me a few links to blogging programs a few months ago. What these programs do is allow you…
December 22nd, 2003 at 10:03 am
Andrew gave me a few links to ‘blogging’ programs a few months ago. What these programs do is allow you…
February 8th, 2004 at 12:23 pm
Spammers have discovered bloggers and sooner or later if you allow comments, trackback pings, or the Movable Type send-entry form on your weblog you will get spammed. Weblog spam is appearing in many flavors: 1) Basic comment spam. The spammer…
February 10th, 2004 at 11:11 pm
I really do enjoy reader feedback and while batting the trolls around was fun for awhile, I was growing rather weary of having to constantly change the litter after they kept…well…you get the idea. I was going to close comments…
February 10th, 2004 at 11:11 pm
I really do enjoy reader feedback and while batting the trolls around was fun for awhile, I was growing rather weary of having to constantly change the litter after they kept…well…you get the idea. I was going to close comments…
February 18th, 2004 at 7:06 pm
I have the same problem as Subhu from Dec. 10, 2003. I can’t get past the setpassword.php stage.
February 18th, 2004 at 8:15 pm
Aha! I figured it out. I had to change all of the PHP tags from short-open
February 18th, 2004 at 8:24 pm
Argh. Sorry, it decided to parse the pseudotags I used because I didn’t use the ASCII equivalents. Anyway, the deal is the script uses short-open tags (<?) instead of canonical tags (<?php), which causes a conflict for some installations of PHP due to XML using short-open tags for its own purposes.
I’d suggest using canonical tags in the next version of the script. Maybe this also fixes Subbu’s problem?
February 18th, 2004 at 11:50 pm
I could not fix this problem and my brother bailed me out. Here are the changes he made to make my problem go away:
(1) “setpassword.php”
It was foremerly using a variable “$_POST” to retrieve all request information (form submit information).
The $_POST was not working so “setpassword.php” was not able to identify whether the form was submitted or not.
The variable “$HTTP_POST_VARS” which has been suported from 3.0 of PHP and using this works.
And it asummed it was not submitted.
(2) “login.php”
Replaced $_POST to $HTTP_POST_VARS here too.
This fix was very critical — otherwise I would not have been able to operationalize MT for my publication.
February 22nd, 2004 at 9:38 pm
Thanks for your work on this. I probably won’t be implementing it at the current time because I don’t want to make my visitors wait until I have a chance to get online to see their comments. But it’s good to know that this is around in case I need it.
February 27th, 2004 at 3:30 pm
This does not bode well for the rest — this…
March 1st, 2004 at 8:50 am
Da oggi i commenti delle Notiziole sono moderati.
March 1st, 2004 at 3:46 pm
Jennifer, I am trying to install the comments queue script in a friend’s blog, and get the same error as Leah (Permission denied). Do you have any idea about what I could be doing wrong here?
Thanks a lot (again)
March 5th, 2004 at 11:53 pm
SEM Ūŵ|ÅĵijċĨīĈbGoogle 〓ŦŧŖÅŰJÅ–ÅŰbweblogbblog, or whateverKĘĎųšųňŹőŠ〓〓IJ〓〓ķĿĽĦćĹJĤĞĎĈij〓Ь〓ĩķĤKc GooglebŦŧŖÅŰXųšųňŹőŠ〓〓YIJ〓〓 〓〓Ď BloggerJiKÄĉĦķĆĤīĎīĊġĈ〓ăĿĩb Ã…
March 30th, 2004 at 5:00 pm
Love it? Hate it? Go on. Tell me about it. Guestbook temporarily shut down due to annoying comment spam. Once…
March 31st, 2004 at 7:22 pm
Thanks to what is now commonly known as blog "comment spam", I had shut my blog comments off last November for several months until I could take the time to figure out how I wanted to "deal" with it… at…
April 3rd, 2004 at 10:57 am
Great script..
Much appreciated.
One question.. Once a comment is approved, the comment is indeed visable but the comment count isn’t incremented until a manual rebuild is done. Can this be tweaked to autmatically update the comment count?
April 3rd, 2004 at 11:01 am
That’s what the mt-rebuild should be doing… if it’s working properly. My guess is, if it’s not rebuilding (and showing the correct count - that it ISN”T working)… try maybe setting the permissons on mt-rebuild to 777 (??)
April 4th, 2004 at 9:06 pm
When loading the viewcomments.php page (after login) I get this error:
View All Pending Comments (Summary List)
Warning: Access denied for user: ‘USERNAME@localhost’ (Using password: YES) in /…/viewcommentsdbquery.php on line 17
Could not connect
All my personal site info has been removed
April 4th, 2004 at 9:19 pm
USER ERROR! oops.. i figured it out. the user name to log into my database is case sensitive!!! It works now! btw, i had the same problem with not being able to get past the setpassword.php page, and found out it was because my host wasn’t allowing me to write to that file (even though it was 777) if i had it in the cgi-bin folder. I moved it somewhere else, and it worked!
April 4th, 2004 at 9:38 pm
Now it all seems to be working except the comment count doesn’t change and when i click on the comment (it shows up on my 5 recent comments) it goes to a 404 page because the actual url for that link is /archives/000005.php
it’s supposed to be /archives/000650.php
I have the mt-rebuild in the folder my mt files are in.. (cgi-bin) and it’s permissions are set to 777 for that file..
April 24th, 2004 at 4:12 pm
I just installed a module that will solve all my commenting problems by allowing me to approve or deny comments…
April 25th, 2004 at 6:25 pm
the mt-rebuild script is not available any longer. could anybody else upload it please?
April 25th, 2004 at 6:29 pm
i found the script.
May 3rd, 2004 at 11:16 pm
Alrighty, blacklist script in, comment queue script out. So far, it seems to be working fine, and my little bit of testing seems to have worked, too. If you tried to post a comment or two (ahem) earlier today that…
May 6th, 2004 at 11:06 am
I installed CommentQueue, but there is a nuisance. While comments are in the queue, entries are displayed in the list of last comments, as if they are from entry #0. The relevant line is
<a href=”<$MTBlogArchiveURL$><$MTCommentEntryID pad=”1″$<.html#<MTCommentID>”><$MTEntryTitle$> </a>
this makes sense, given how comments are stored before approvation. I wonder if it is possible to circumvent this somehow, however.
May 20th, 2004 at 7:01 pm
Gli spammers hanno scoperto i blog, s’intravedono già © primi risultati negli USA, e tra poco anche in Italia le funzioni tipiche d’interazione dei weblog: trackback e commenti saranno presi d’assalto. Ecco le tipologie di spam che possono presentarsi …
May 20th, 2004 at 7:02 pm
Gli spammers hanno scoperto i blog, s’intravedono già © primi risultati negli USA, e tra poco anche in Italia le funzioni tipiche d’interazione dei weblog: trackback e commenti saranno presi d’assalto. Ecco le tipologie di spam che possono presentarsi …
August 5th, 2004 at 2:32 pm
YEah I finally got rid of most of the damm SPAM on my site. I also installed a frankenstiened comment…
November 30th, 2004 at 11:58 pm
Very sorry about the problems over the weekend. I am overshooting my bandwidth at the end of every month, significantly helped by the automated blog spammers of the world. I’m instituting additional comment spam measures, including approval via this n…
December 3rd, 2004 at 1:00 am
I’ve set up CommentQueue on a new version of my website, but I discovered that importing entries with comments creates an error. Specifically, it tells me that the new comment property cannot be null as it attempts to create the comment. Do you know if there is a way to add that property to the text file that I import, so it sets a value? Is it as simple as adding the line
PROPERTY: 1
But I don’t know what the value should be.
December 29th, 2004 at 2:37 pm
Very sorry about the problems over the weekend. I am overshooting my bandwidth at the end of every month, significantly helped by the automated blog spammers of the world. I’m instituting additional comment spam measures, including approval via this n…