Website Development Blog Entries


Posted Jul 29, 2015

Blog Post Editor: Features

Posted Oct 17, 2014

Code and Screenshots of the Blog Post Editor I coded to post these blog posts.

Wordpress Login Redirect Problems

Posted Jul 30, 2014

MySQL: SQL Error (1062): Duplicate entry '16777215' for key 'PRIMARY'

Posted Oct 9, 2013

A duplicate key error resulting from a trigger operation.

Rotating the Innodb Log File

Posted Oct 9, 2013

How I rotate MySQL's InnoDB log files.

Setting Linux Prompt in CentOS 6.4

Posted Sep 5, 2013

My Linux prompt looked like this: bash-4.1, and I want it to at least tell me who and where I was.

MySQL 5.6 - [Note] Slave: received end packet from server, apparent master shutdown

Posted Sep 5, 2013

I was receiving this error multiple times in the MySQL 5.6.13 error log for my slaves. This is how I figured out the problem and fixed it.

MySQL In Memory Temporary Tables in Stored Procedures with Replication

Posted Jul 6, 2013

Some solutions to MySQL temporary tables disappearing after a MySQL restart, especially within a Stored Procedure during Replication.

Website and MySQL Developer Resume - Orlando, Fl

Posted Mar 18, 2013

A resume of my skills and accomplishments.

Notes From A MongoDB Presentation I Attended

Posted Sep 7, 2012

I attended a free MongoDB presentation and these are the notes I took.

Replacing Bad Microsoft Characters in MySQL

Posted Apr 20, 2010

If you've ever pasted a word document into a browser's text area and then insert it into a MySQL table, you've probably encountered some funky characters replace the quotes, dashes and other special characters.This is due to Microsoft using extended character sets over ASCII 128.In the past I'd have to manually search and replace the bad text. Today I decided to find a better solution. Searching on Google, I came across the following blog postReplacing smart quotes, em-dashes, and ellipses with...

How to fix a 404 File Not Found causing a 302 redirect

Posted Apr 19, 2010

A few weeks ago, one of our consultants told us that when a file not found was issued on our servers, it was reporting a 302 redirect. To test it, I entered a bogus page for our website in the browser at the Apache access log, I was quickly able to find the line reporting this. grep bogus.cfm virtual_log192.168.0.x - - [19/Apr/2010:10:05:25 -0400] "GET /bogus.cfm HTTP/1.1" 302 316 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/20100401...

Software Development Books I Have Read

Posted Jul 26, 2009

These are a list of computer related books I have read or in the process of reading:Agile Software Development with Scrum by Ken Schwaber and Mike BeedleDesign Patterns: Elements of Reusable Object-Oriented Software by Erich Gamma, Richard Helm, Ralph Johnson, John M. Vlissides (In process)The Object-Oriented Thought Process by Matt Weisfeld (In process)The Mythical Man-Month: Essays on Software Engineering, Anniversary Edition (2nd Edition) by Frederick P. BrooksJoel on Software: And on Diverse...

Agile Software Development with Scrum Chapter 3

Posted Jul 26, 2009

This is continued from my first post on Agile Software Development with Scrum.I've skipped over chapter 2 because I honestly didn't get to take any good notes. I might have to go back and skim over it.Chapter 3 has the following to say that stood out to me: Mix people with different strengths and weaknesses Scrum is empirical - The team can still break the work (functionality) down and meet their goals, as long as they are working on something. Teams should be about 7 people, plus or minus...

Scoping Makes Me And You Think Less

Posted Jun 14, 2009

When I'm programming in Coldfusion I don't want to have to think. To help me not to think much, I make an effort to scope out every variable.When I go into a piece of code, I want to know whether the variable I'm looking at came from a query, form, argument or the various other sources a variable could come from. Otherwise I look at an unscoped variable and the first thought I have is where the !@#$%^ did this piece of code come from? Did it come from a query I see in a cfloop. Or is it an attribute...

Agile Software Development with Scrum

Posted Jun 7, 2009

I started reading the above book yesterday by Ken Schwaber and Mike Beedle. So far I am through the first chapter and I feel I have taken in so much useful information, I can't imagine what else the authors have to say. They give some hints that seem promising and I could always use the reinforcement, since it seems easier for me to learn things through repetition or when I'm truly inspired.Before I started reading this book, I did have a brief introduction to Scrum through an Orlando ...

MySQL and Coldfusion - No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

Posted Nov 3, 2006

I received the following after connecting to MySQL 5.0.24a through Coldfusion MX 6.1 using the MySQL JDBC 5.0.4 J/Connector.No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** STACKTRACE: at com.mysql.jdbc.MysqlIO.readFully(

MySQL and Colfusion - Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP

Posted Nov 3, 2006

I was upgrading the MySQL java connector from 3.0.17 to mysql-connector-java-5.0.4-bin.jar on my Coldfusion server. When I tried running a script I received this error:Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMPI had this problem connecting to both MySQL 4.1.15 and MySQL 5.0.24a.After a quick search, I found this in the MySQL Bugs Database fix it, I added the 2 connection strings they mentioned, to the JDBC URL in the MySQL Administrator...

Removing Passphrase from SSL key

Posted Oct 31, 2006

To remove a passphrase from an SSL Key, run the following command:openssl rsa -in source.key -out target.keyit will prompt you to enter the passphrase, in order to remove it.Once this is done, you won't have to enter the passphrase each time you restart Apache. Just make sure your ssl key's and certificates are only readable by root or whatever user Apache is running as.

How many files does MySQL have open on Redhat Linux

Posted Oct 31, 2006

To tell how many files MySQL has open, you need to login as root and run one of the following commands:# lsof | grep mysql# lsof | grep mysqld# lsof -c mysqld# ls -l /proc/<PID>/fd  /* where <PID> is the process ID of the program you are interested in */# lsof | grep "/var/lib/mysql"You can tell how many files your OS has opened with this:# cat /proc/sys/fs/file-maxOn a MySQL client, you can run the following:SHOW OPEN TABLESTo close the open files run:FLUSH TABLES

MySQL 5 Certification DBA Review

Posted Oct 24, 2006

I am compiling a list of resources I am using to study for the MySQL 5 Certification. This blog entry is for Part I and II of the DBA exam. I will have a separate blog for the Developer exam as well.MySQL DBA Part ILinks to Check OutMySQL DBA Part IILinks to Check Out PlanetMySQL Blog: I Can't See My Databases! PlanetMySQL Blog: What to Tune in MySQL Server after Installation PlanetMySQL Blog: MySQL...

ImageMagick Perl Batch File

Posted Oct 20, 2006

I wrote this perl script to convert a large number of images using ImageMagick. I tried doing it using ImageMagick itself on the command line, but it kept going in an infinite loop. #/usr/bin/perlopendir(DIR,"/tmp/pics");while ($file = readdir(DIR) )  {        if ($file ne "." and $file ne "..")        {         print " $file ";    &nb

ImageMagick not working with Coldfusion and cfexecute

Posted Oct 16, 2006

I updated our Redhat server with the latest version of ImageMagick 6.2.9-8 a few days ago. We have 2 servers and the install from source seemed to work on both of them. I was able to run the test command the source install says to run. /usr/local/bin/convert logo: logo.gifBut when I tried running the convert command through the cfexecute tag to resize an image, it wasn't doing anything on one of the servers, but working find on the other one. The cfexecute command was doing this: <CFEXECUTE NAME="/u

Setting Run Level on SuSe Linux - Adding services

Posted Oct 8, 2006

I just learned how to set the run level today. I used to do it manually, but creating symbolic links to the startup/shutdown script in /etc/init.d. But when I tried it on my newly setup system, I couldn't get it to work. Then I found how to use the chkconfig script. This is on my SuSe 10.0 environment. I read it works on Redhat too.# chkconfig --listThis will list all services that are started up at boot time and what run level they are at.# chkconfig --level 345 mysql.server onThis will set the...

Using JDBC connector to connect to MySQL 5.0.24 for high encryption

Posted Oct 8, 2006

Since Coldfusion MX 6.1 and 7 don't include the drivers to connect to MySQL version 5, I had to install the latest JDBC drivers from the MySQL site. This also alleviates the problem of being able to use the higher level of encryption MySQL uses for its passwords, that Coldfusions bundled drivers can't handle.To get the driver, visit the MySQL developer zone and try the latest JDBC driver. In the past, I sometimes have to try different versions, as the latest one doesn't alway work. For my system...

ByteArray objects cannot be converted to strings error

Posted Oct 4, 2006

I ran into this error yesterday from a query that's been running fine for months now. I don't know why it all of a sudden happened, but I thought I would share it with you in case you run across it.I was retrieving some records and outputting the fields to the screen. As I outputted certain fields, they were returning this message:  ByteArray objects cannot be converted to strings error  It wasn't just one field type, and included text and numeric fields. When...

Coldfusion Introduction

Posted Sep 23, 2006

I have been working with the Coldfusion Application Server since 1998. Back then version 3.1 was out. I started out using dbase IV as the database server and to learn on, until my boss introduced me to MySQL in 1999, which is what I still use. I later moved on to working with versions 4, 4.5 and now work with Coldfusion MX 6.1. I currently have an Advanced Coldfusion Certification in Coldfusion MX that I received in December 2004. I work on all types of projects, which include writing whole applications,...

Latest Discussions

  • Carlos: Thank you!
    May 16, 2014 | Replies (0)
  • Jessica: Great info, thanks!
    May 15, 2014 | Replies (1)
  • Walter: Thanks, you totally saved me a bunch of searching around just now. I was setting up a percona xtradb...
    Feb 25, 2014 | Replies (0)
  • Avi: I've found the reason of the problem in my case. It's a bug as described here :
    Dec 12, 2013 | Replies (0)
  • Avi: I've also met that behavior twice on 5.6.12 slaves. However, i didn't find the root cause of that....
    Dec 12, 2013 | Replies (0)