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."
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...
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 browserhttp://www.mysite.com/bogus.cfmLooking 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:1.9.2.3) Gecko/20100401...
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...
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...
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...
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 Meetup.com ...
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 ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:19
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 Databasehttp://bugs.mysql.com/bug.php?id=18308To fix it, I added the 2 connection strings they mentioned, to the JDBC URL in the MySQL Administrator...
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.
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
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! http://www.planetmysql.org/entries/4376 PlanetMySQL Blog: What to Tune in MySQL Server after Installation http://www.planetmysql.org/entries/4279 PlanetMySQL Blog: MySQL...
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
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
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...
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...
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...
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,...
