A volume failed to mount (Error code -6602)

Yesterday morning I started work as usual as ran into a problem mounting one of the shares from my XP PRO machine on my Macbook Pro.  Obviously the first question I asked was WTF? Everything worked yesterday, and not today.

I did some Googling and found mention about opening some UDP ports, but my TCP/IP settings currently has all ports open, so that didn’t help.  Then just for giggles I decided to turn off simple file sharing.  That fixed it!

So if you receive the message “A volume failed to mount”, and then another one with “Error code -6602″ in it, you should check your PC’s file sharing settings.  You would do this by following these steps.

How to disable simple file sharing on XP

  1. Open Windows Explorer ( Win+E  or  double click My Computer )
  2. Click Tools > Folder Options
  3. Click the View Tab
  4. Scroll down to the bottom, and uncheck “Use simple file sharing (Recommended)”
  5. Then retry mounting the share on OSX

The year of my internet wrap up

Now that ‘the year of my internet’ ( a.k.a. 2008 ) is down to it’s last hour, figured I’d dump some thoughts on what went down in the busiest year ever.

  1. Worked for beatport.com
  2. Finally put up this website
  3. Had contract gigs for most of the year
  4. Rocked a handlebar mustache
  5. Sold my 2007 Subaru STi limited
  6. Sold my 5 string Carvin LB75A
  7. Started a few blogs ( sk8colorado, ericsphone )
  8. Wrote my first free Adobe AIR application ( ifartair.com )
  9. Got a 3 foot high mini ramp from a friend of a friend
  10. Got back in touch with most of my posse from skating, and band days
  11. Bought a new 15″ Macbook Pro
  12. Met local Adobe gurus Realeyes Media
  13. Started playing ice hockey again
  14. Converted my single webpage into WordPress
  15. Got an iPhone 3G
  16. Accepted a new job at wiretree.com

I’m sure there was plenty more, especially being my first full year as a dad.  Fletch has grown so much this year that looking through the archives seems like further in the past.  I haven’t put a lot of thought into 2009 yet, but I know it’s going to be just as busy.

That’s all for 2008.  Peace out!

The ‘Why learn SQL’ list has begun

Today’s new social service is a top5 list making site called www.makefive.com.  I haven’t gotten too deep into the site yet, but it looks like a lot of fun.  I definitely dig the idea, especially if you can tie this into all your other social outlets.

My first list is a rough sketch of reasons why you should learn SQL.  I love SQL, and have been collecting reasons why you should learn it, but just haven’t gotten around to getting my ideas down.  I’m hoping this list will be the motivation I need to get my love for SQL out on the internets.

See more: Why you should learn SQL

PHP state picker options list maker

Here’s a static function I use in some of my PHP projects when I need to create a united states state picker.  It makes it really convenient to have an empty <select> in my form that wraps a $statelist variable containing my options.  The extra helpful part of this function is it can do selection for you if you pass in a state abbreviation.  Good for edit forms.


/**
 * Return an html options list full of states
 *
 * @param $selected_state string[optional]	abbreviation of state to select
 * @param $b_add_space bool[optional]		first option is blank
 * @return string
 */
public static function state_picker_options( $selected_state = "", $b_add_space=false )
{
	$states = array(
		'AL' => 'ALABAMA',
		'AK' => 'ALASKA',
		'AZ' => 'ARIZONA',
		'AR' => 'ARKANSAS',
		'CA' => 'CALIFORNIA',
		'CO' => 'COLORADO',
		'CT' => 'CONNECTICUT',
		'DE' => 'DELAWARE',
		'DC' => 'DISTRICT OF COLUMBIA',
		'FL' => 'FLORIDA',
		'GA' => 'GEORGIA',
		'HI' => 'HAWAII',
		'ID' => 'IDAHO',
		'IL' => 'ILLINOIS',
		'IN' => 'INDIANA',
		'IA' => 'IOWA',
		'KS' => 'KANSAS',
		'KY' => 'KENTUCKY',
		'LA' => 'LOUISIANA',
		'ME' => 'MAINE',
		'MD' => 'MARYLAND',
		'MA' => 'MASSACHUSETTS',
		'MI' => 'MICHIGAN',
		'MN' => 'MINNESOTA',
		'MS' => 'MISSISSIPPI',
		'MO' => 'MISSOURI',
		'MT' => 'MONTANA',
		'NE' => 'NEBRASKA',
		'NV' => 'NEVADA',
		'NH' => 'NEW HAMPSHIRE',
		'NJ' => 'NEW JERSEY',
		'NM' => 'NEW MEXICO',
		'NY' => 'NEW YORK',
		'NC' => 'NORTH CAROLINA',
		'ND' => 'NORTH DAKOTA',
		'OH' => 'OHIO',
		'OK' => 'OKLAHOMA',
		'OR' => 'OREGON',
		'PA' => 'PENNSYLVANIA',
		'PR' => 'PUERTO RICO',
		'RI' => 'RHODE ISLAND',
		'SC' => 'SOUTH CAROLINA',
		'SD' => 'SOUTH DAKOTA',
		'TN' => 'TENNESSEE',
		'TX' => 'TEXAS',
		'UT' => 'UTAH',
		'VT' => 'VERMONT',
		'VI' => 'VIRGIN ISLANDS',
		'VA' => 'VIRGINIA',
		'WA' => 'WASHINGTON',
		'WV' => 'WEST VIRGINIA',
		'WI' => 'WISCONSIN',
		'WY' => 'WYOMING'
	);

	$s_options_list = "";

	//add blank state?
	if($b_add_space)
	{
		$s_options_list .= "<option value=''></option>";
	}

	//construct list
	foreach( $states as $st => $name )
	{
		if( strtolower($st) == strtolower( $selected_state ) )
		{
			$s_options_list .= "<option value='$st' selected> $name </option>";
		}
		else
		{
			$s_options_list .= "<option value='$st'> $name </option>";
		}
	}

	return $s_options_list;
}

Copy a MySQL database to your local MySQL machine

Here’s one way to copy a MySQL database from one server to another using phpMyAdmin, and the MySQL command line client.

Requirements :

  • MySQL 5.x installed on your local machine
  • MySQL command line client on your local machine
  • Access to phpMyAdmin on your source MySQL machine

Assumptions:

  • You have access to the MySQL command line client.
  • You have the root password for your local MySQL instance
  • You are comfortable using phpMyAdmin and MySQL command line client

Instructions:

  1. Log into phpMyAdmin on your source MySQL machine.
  2. Click the Export link on the lower part of the home page.
  3. Select your database in the ‘Export’ box on the left.
  4. Make sure SQL is selected under the database box.
  5. In the ‘Options’ box on the right, make sure Structure and Data are selected.
  6. Make sure to check ‘Add DROP TABLE / DROP VIEW’ as well.
  7. Towards the bottom, check the box next to ‘Save as file’. This will be the file we import later.
  8. Click the GO button, and your browser should prompt you to download your SQL file. *Make note of where you saved your exported sql file. I saved mine to d:\downloads\import.sql because it’s an easy path to use later.
  9. Open your local MySQL Command Line Client. ( From MySql Program menu or type “mysql -u root -p” in the run dialog box ).
  10. Enter your root password when prompted.
  11. Import your database by running this command “mysql \. d:\downloads\import.sql“. Be sure to adjust the path to match where you saved your sql file from step 8.
  12. Now you should see your database listed when you run the command “show databases;

 

Here are instructions for doing the same thing on OS X

  1. Follow steps 1 through 8 above to created your sql export file
  2. Connect to mysql “/usr/local/mysql/bin/mysql -u root -p”
  3. {enter root password}
  4. If it’s not already created, created your databse “create database {your db name};”
  5. Select your database “user {your db name};”
  6. “mysql \. /users/ericfickes/Downloads/mydbfile.sql”

Be sure to adjust the paths listed to match your MySQL install, and the location where you downloaded the sql file.

The sad trombone

Borrowed this SWF from sadtrombone.com

Go ahead and add this to the list of reasons why Flash is awesome.

New auto advertisement from America’s Big Three

Found this one on the internets.

The Bailout.  Coming this January

The Bailout. Coming this January

 You probably thought it was smart to buy a foreign import of superior quality, with better mileage and resale value.  Maybe you even thought that years of market share loss might prod us into rethinking our process and redesigning our products with better quality in mind.  But you forgot one thing : We spend a shitload of money on lobbyists.  So now you’re out $25 billion, plus the cost of your Subaru.

Maybe next time you’ll buy American like a real man.  Either way, we’re cool.
 

Hey big three, why don’t you stop making rental cars, and start making cars even the C level’s would be proud riding in.  American automobiles FTL.

XCOPY script maker utility

Here is an old utility project I started a few years ago to help make XCOPY scripts.  It’s an HTA ( HTML Application ) so it currently only runs in Internet Explorer.  Normally I wouldn’t release IE only code, but XCOPY is a windows only utility, and this is really just a quick and dirty little tool.

Usage is simple :

  1. Open with Internet Explorer
  2. Point and click through the options
  3. Click the ‘Make Script’ button

From here you can paste the xcopy script directly onto the command line, or into notepad and Save As “yourfile.bat”.

Download xcopier here

XCOPY maker in action

XCOPY maker in action

The phones have SQL, so does AIR

It’s pretty damn cool that the smartphones of today can run SQL databases.

Google’s Android has SQLite, which you can read about here.

Apple’s iPhone also has SQLite.

The SQLite library lets you embed a lightweight SQL database into your application without running a separate remote database server process. From your application, you can create local database files and manage the tables and records in those files. The library is designed for general purpose use but is still optimized to provide fast access to database records.  The header file for accessing the SQLite library is located in <iPhoneSDK>/usr/include/sqlite3.h, where <iPhoneSDK> is the path to the target SDK in your Xcode installation directory. For more information about using SQLite, go to http://www.sqlite.org.

Microsoft even has a mobile version of their SQL Server.  Of course they can’t seem to stick with a name for it.  SQL Server Mobile, SQL Everywhere, SQL Server Compact Edition, and currently SQL Server Compact 3.5

I’m just getting over the excitement about Adobe’s AIR having SQLite, and now my phone can run it too.  This makes for some interesting development choices.  In my opinion, being able to have a database on your device is one of the final steps of making a device a true platform.  Now it’s time to get dirty with some Sqlite coding.

By the way, I’d put this on my list of reasons why you should learn SQL.