Nick Bartlett“Every man I meet is my superior in some way, and in that I learn from him.” - Emerson

I installed Dreamweaver 8 for its awesome code searching ability and every time I’d navigate to a file the program would shut down.  The problem is a conflict between Microsoft Groove and Dreamweaver 8.  You’ll have to uninstall one of them. To uninstall Groove, follow these instructions http://support.microsoft.com/kb/907504

“Dreamweaver 8 may crash when it performs file browsing actions on Microsoft Windows Vista. Some examples include:

• Using File > Open to browse the hard drive to open a file.
• Inserting an image and using the file browser to select the image.
• Creating a hyperlink and using the file browser to select the target file.
• Creating a site definition and using the file browser to select the local root folder or remote folder.

Additional reported behavior includes:

• Crash occurs when a file browsing dialog appears.
• Crash occurs when browsing two or more folders away.
• Crash occurs after inserting four images.
• Crash occurs when you leave the file browsing dialog box open for a period of time. “

The environment is Windows XP running apache2 using TortoiseSVN. This is a development server that also has a copy of the repository trunk checked out and I want that checkout updated when somebody commits to the repository.

I spent hours on Google today trying to figure out how to get a hook script working on windows for SVN.

I found only one decent resource http://blog.pengoworks.com/index.cfm/2008/2/5/SVN-postcommit-for-Windows that didn’t work.  I kept getting the error ‘post-commit hook failed (exit code 1) with output: ’svn is not recognized as an internal or external command, operable program or batch file.

Finally, a friend helped me out by looking up their configuration, which was a similar setup, and pointed me in the right direction. In the post-commit.bat file you create, the only thing in the file should be this windows command:

“pathToYourSVN.exe” update –username yourSVNUserName –password yourSVNPassword pathToYourCodeCheckout

It’s a very different solution and very simple as well.  Hope this helps!

I have this search feature on the search input of my sites, but was annoyed when I’d hit the enter button the keyboard to submit the search after the autocomplete items were visible. Instead of submitting the form as I desired, the first autocomplete option was entered into the input and then the form was submitted.

To disable the pre selection of the first result item in the autocomplete, do the following:

In controls.js of the Scriptaculous library, on line 286: change “this.index = 0;” to “this.index = -1;”

Today I needed to import a 4.5GB file of SQL into a MySQL database. Good ole phpmyadmin won’t handle anything close to that large, I it had to be command line. It took me a bit to find the proper syntax, so hopefully this will rank well and provide a quick reference not only to myself but to everybody else.

Save your text file of SQL somewhere on your computer and open a command window (start > run and type “cmd” and hit enter). Type the following command

1. mysql -u root -p (then hit enter. “root” is the database username you’re using)
2. It’ll then prompt you to enter the password for that user. Enter it and hit enter.
3. type “USE databaseName” and hit enter. (”databaseName” must be changed to whatever your database name is).
4. the final step is to use the “source” command and provide the location of your text file on your hard drive like source C:\dump.sql

Hopefully this will save somebody an hour of digging like I did today. If you installed Zend Core and are using the bundled Apache2 that came with it, go to services.msc and you’ll find the apache2 service listed as “ZendCoreApache”. It’ll be at the bottom of the list of two hundred services listed instead of at the top where you’d expect near the A’s.