Viewing posts for the category MediaPost

Comcast Blacklist

Posted by: scoopseven in MediaPost 17 years, 3 months ago

As a new Comcast subscriber I jumped through hoops to see if we could get white-listed and finally ended up being forwarded to this form. It, apparently is the only way for a subscriber or mail administrator to get off the black list. But let's call one more time, to see if we can't get this expedited. Error message is:

read more / 0 comments

MySQL “Explain”

Posted by: scoopseven in MediaPost 17 years, 3 months ago

This command would have saved me a couple of hours today should I have known about it. While running a query that returned 48k rows, I needed to run a subquery to check against another table to exclude certain other rows. (Querying a list of people to send a promotional email to while trying to make sure the email didn't go to any people who were already registered for a show [show registrants stored in that separate table]). I attempted to do this using several different techniques:

• and m_email not in (select email from attendees where shw_id = 19)
• and NOT EXISTS (SELECT * FROM attendees WHERE m_email = email AND shw_id='19')
• left outer join attendees on email = m_email where email IS NULL

read more / 0 comments

Sorbs Sucks

Posted by: scoopseven in MediaPost 18 years ago

My own personal experience with Sorbs is that they suck. They incorrectly listed us as part of a dynamic IP range likely to generate spam. WRONG! Apparently they're using a database of IPs that hasn't been maintained since 2003. Why bother? My advice to anyone looking to curb spam is to use a RBL, but whatever you do don't use Sorbs. Taken from: http://cpbotha.net/weblogs/cpbotha/archives/002023.html

 
• Why SORBS Sucks
• SORBS Sucks
• Why I agree that SORBS sucks!
• Google results for "sorbs sucks"
 

read more / 0 comments

New MediaPost.com

Posted by: scoopseven in MediaPost 18 years, 1 month ago

Finally, after months of work, and 2 weeks of labor and pushing, we've finally launched the new MediaPost.com website using CFMX 6.1, FuseBox 4.1 and MySQL on a DELL computer running Windows 2003 Enterprise Server. The site was moved from a really old computer running NT, CF5 and Microsoft SQL Server.

read more / 0 comments