Website Development Posts

Cancelling Asynchronous Tasks During a Jest Run
Jul 15, 2020
A solution to the warning "Can't perform a React state update on an unmounted component. This is a no-op, but it indicates a memory leak in your application. To fix, cancel all subscriptions and asynchronous tasks in the componentWillUnmount method."
Search Results and Passing State Between React Components
May 28, 2020
Jul 29, 2015
Blog Post Editor: Setting Publish Date
Oct 27, 2014
Blog Post Editor: Categories Selection
Oct 26, 2014
Blog Post Editor: Features
Oct 17, 2014
Code and Screenshots of the Blog Post Editor I coded to post these blog posts.
CakePHP: Restrict DebugKit to An IP Address
Sep 20, 2014
Wordpress Login Redirect Problems
Jul 30, 2014
MySQL: SQL Error (1329): No data - zero rows fetched, selected, or processed
Apr 3, 2014
MySQL: SQL Error (1062): Duplicate entry '16777215' for key 'PRIMARY'
Oct 9, 2013
A duplicate key error resulting from a trigger operation.
Rotating the Innodb Log File
Oct 9, 2013
How I rotate MySQL's InnoDB log files.
MySQL 5.6.13 : The incident LOST_EVENTS occured on the master. Message: error writing to the binary log
Oct 2, 2013
Setting Linux Prompt in CentOS 6.4
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
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.
PHP Class For Submitting Leads to MyMedLeads API
Aug 6, 2013
MySQL In Memory Temporary Tables in Stored Procedures with Replication
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
Mar 18, 2013
A resume of my skills and accomplishments.
Before and After Gallery Uploader
Mar 6, 2013
Notes From A MongoDB Presentation I Attended
Sep 7, 2012
I attended a free MongoDB presentation and these are the notes I took.
Replacing Bad Microsoft Characters in MySQL
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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,...