by ·0 Comments

So today update data cross table in a MYSQL database. It took me way longer than it should have.  I spent way too much time trying to get my join to work only to continue getting syntax errors.  So long story short. If you are doing a cross table update in MYSQL you cannot use a join. Rather you must use WHERE a simple example looks like:

UPDATE TableToUpdate, TableToPullInfoFrom

SET

TableToUpdate.col1 = TableToPullInfoFrom.col1,

TableToUpdate.col2 = TableToPullInfoFrom.col2,

TableToUpdate.col3 = TableToPullInfoFrom.col3,

TableToUpdate.col4 = TableToPullInfoFrom.col4

WHERE TableToUpdate.id = TableToPullInfoFrom.id

And I will just leave this here so I don’t make that mistake again.

by ·0 Comments

So my girlfriend and I have been talking about how we both neglect our websites and blogs and that we really want to work on them.  I was curious and pulled up my site stats and checked out how much traffic I have been getting. On average I receive about 5,500 views in a month. I am quite proud of that, but there is clearly much room for growth.

So I made a bet with my girlfriend to keep us both motivated and working on our site. We both looked at our site statistics and found the busiest month that we had and are going to see who can double their traffic the fastest.

Now we both target very different audiences so we didn’t bet anything huge but the loser of the challenge has to buy the winner dinner (hopefully a very nice one! Since it is dinner with my girlfriend I guess we both win either way).

My busiest month was May 2011 with 6,161 views.

So my goal is to get 12,322 views in a month.

I am quite excited about this, as my blog tends to be very technical articles or tutorials this will hopefully force me to start researching and writing about some new technologies.  At the same time I am going document various strategies I use to raise the traffic of my site by focusing not only on new content, but also SEO and marketing tactics.

Let the challenge begin!

If you want to help the competition you can check out my girlfriend’s site at http://www.jennifervitti.com

by ·5 Comments

Today I did a factory reset on my T-Mobile My Touch 4G however on reboot I continued to get the following error:

Sorry!

The Application HTC Sense (process com.htc.launcher) has stopped unexpectedly.
Please Try Again.

The only option available was Force Close, and soon as that was pressed the message would appear again.

I tried the solutions listed at http://myhtcdesire.com/tutorials/fix-the-application-htc-sense-process-com-htc-launcher-has-stopped-unexpectedly, if the directions on that site work all the better, however if you are in the same boat as me those directions did not work.

My Problem:

On my phone I did have any way of getting to the search, nothing on screen, and no buttons would work.  Just hitting force close brought the force close option up instantly again and I had no time to do anything. So how did I get into the settings menu?

How I got into the settings menu:

The only way I was able to get was to do a factory reset though the boot menu.

You can perform a factory reset by (second half of this video) restarting the phone while holding the volume button down.  This will cause you to boot into your factory menu where you can select factory reset.

Once the factory reset gave me more time to react before the error popped up. Once the reset was done I was prompted with an introductory video all about my phone. I went through all the prompts until my home screen was loading. Right away before anything loaded I pushed and held on the home screen. This caused the option to add a shortcut to the home screen. I was able to add a shortcut to settings and get to it that way.

After that I was able to clear the data to go to Applications > Manage Applications > HTC Sense > and Clear Data. However this did not fix it for me. Instead I had to clear data on all my
applications until I found the one that was causing the problem.

Did this post save your expensive phone from being a paper weight? Did it save you hours of fustration? Consider buying me a coffee!

by ·0 Comments

Recently I was working on ClickOnce Application and I was trying to distribute XULRunner with my application. Unfortunately when deploying the application I realized that not all the files where included in the ClickOnce applications file, particularly text files such as files that ended in .ini or .manifest.

The solution was to go into the solution explorer in Visual Studio, select the files that there not being copied, and set the build action to content for those files.

by ·6 Comments

This one has caused me a few hours of pain….a couple of times.  It is about time I document how I fixed it.

The Error:

Cannot import the following key file: <filename>.pfx. The key file may be password protected. To correct this, try to import the certificate again or manually install the certificate to the Strong Name CSP with the following key container name: VS_KEY_ E2AEBF22AB52DD08    <Application Name>

The Fix:

  1. Open Visual Studio Command Prompt (It can be found in the Windows Start menu)
  2. Type sn -i “c:\Pathtofile\<filename>.pfx” TVS_KEY_ E2AEBF22AB52DD08
  3. Reimport the pfx file into Visual Studio

The sn.exe with the –i parameter, installs a key pair from <infile> into a key container named <container>.