This error or the equally frustrating ‘ Incorrect integer value: ‘ error seems to bite quite a few people in the butt that are running MySQL 5. If you’re getting one of these errors then MySQL is running in strict mode and you are trying to run a query that isn’t inserting a proper value into one of your fields. For example, you have an int field and the value you are inserting into that field is blank.
The proper thing to do would be to go through all of your queries and make sure you are always inserting the proper values, ie. some type of integer for an int field.
There isn’t always time for the proper way however. If you need a quick fix you can run the following MySQL command from your favorite MySQL command prompt, the shell, phpmyadmin, etc.
Here’s how I make Buffalo wings in our house. Wife and kids don’t like spicy so these are VERY mild.
Ingredients
Chicken Wings – However many you want
3 sticks of sweet cream butter
1 16 oz. bottle of Kraft Honey Barbeque Sauce
1/3 cup of Frank’s Red Hot Sauce
Vegetable Oil
Directions
Preheat oven to 325. Heat an electric skillet to 375. Put a light coat of oil in the skillet, how much depends on the size of the skillet, just need enough to coat the bottom.
In a sauce pan, mix in the hot and barbeque sauces and throw in the sticks of butter. Heat on medium low until butter is thorughly melted.
Chop your wings in half to make the drumlette and the wing. Give them all a sprinkle of salt and pepper. Once the oil is hot, cook the chicken for about 4 minutes per side. Transfer to a plate with paper towels to soak up the extra grease when finished.
Pour the sauce into a large bowl and then throw in the chicken and make sure all of the chicken gets a good coating. Put some tinfoil over a large cookie sheet and then place the sauce coated chicken on top. Throw in the oven for about 15 minutes and you’re done.
Ok, so I had been neglecting this site for quite awhile. Had somewhere around 2000 spam comments I had to wade through. Since I’ve decided to get active on this site finally I’ve made a few changes. First, I’ve turned on Akismet and secondly I’ve installed reCaptcha.
I hate having to manually approve people that are posting legit comments, so with those I’m going to go ahead and open up comment posting without approval and see how it goes. If it is still a headache then I’ll adjust from there.
Flatten the raw chicken breasts so the entire breast is fairly even in thickness. Season to your liking and broil or grill them until 165 degrees. Grilling is always better, but sometimes weather doesn’t permit. Broiling time may vary on your oven. I normally broil them about 6 inches from the burner for about 6-8 minutes on each side. Check temperature to make sure they are done, but don’t overcook.
Once the chicken is cooked you can slice it into small strips or chunks, whichever you prefer.
Bring some water to a boil and cook the Rotini for about 7 minutes. While that’s cooking, dice up the Roma Tomatoes, shred the lettuce and drain the olives.
Drain the noodles and run them under cool water to keep them from cooking any further.
Mix up the noodles, chicken, lettuce, tomatoes and olives. Slowly mix in the Caesar Salad Dressing and the Parmesian Cheese. How much you add is up to you, but I usually end up using about half a package of the cheese 8oz and the full bottle of dressing, sometimes more.
So occassionaly I like to try my hand at cooking. I’d rather grill it if possible, but weather doesn’t always permit. My problem is, I’m horrible at writing stuff down, so I can never quite remember exactly what I may end up using for ingredients, etc. So, I’ll be posting some things here. Mainly for me to reference when needed, I have no big dreams of people actually using my recipes, but if you so choose, it’s your funeral
So my anniversary is coming up, and for the past month I’ve been considering asking the wife for an iPhone, but I’m a bit torn. If I buy now I’m pretty much locked into the hardware that it comes with. Software upgrades will come no matter when I buy, but I’m just not sure if I should wait for the next generation.
I don’t have an iPod, my cell phone won’t hold a charge, and when I’m out it would definitely be useful to be able to get on the web or check email. But does that justify buying an iPhone. Just can’t decide.
Working on our hosting webserver the other day and came across an issue that took me a while to figure out. When trying to restart apache I was getting “No space left on device”, yet we had plenty of hard drive space. It turns out that we actually had no semaphores available. Using the following little script run from bash cleared it up.
I routinely work on small linux boxes that basically run off of a small flashcard as the hard drive. We use these for out client-side network monitoring boxes. The problem with these is they can very quickly run out of drive space, if there is anything being written to the drive at all.
Here’s a very useful command that can be ran from the command line. This will give you a list, starting from your current directory, of files and their modification dates in descending order. So anything recently modified will be at the bottom of the list. Comes in quite handy.
find . -type f -printf ‘%TY-%Tm-%Td %TT %p\n’ | sort
Yeah, I’m late to join the blog party. Between a family with 3 kids, working fulltime at Techtell, Inc. and also working on UBB.threads, my time is limited. So, why am I setting up a blog? A couple of reasons.
#1. Sometimes I actually have something useful to say.
#2. We’ll soon be adding blogging functionality to UBB.threads so I figured what better way to get an idea of what people will expect than to actually use one for awhile.
Comments Off
Entries (RSS)