Richard Carter

If your professor disabled the ability to download the lectures, here’s the way to get around it. First, here’s the snippet you will need; then read below it for instructions.

javascript:__doPostBack('__Page','DownloadPresentation:1299fb37-f10a-31be-97fe-0224842e6cdd')

On the lectures list, hover over the link to the lecture you want and copy the peid from the URL. Put it after “DownloadPresentation” in the above JavaScript snippet, and add dashes exactly where that peid has them – you should have an extra “1d” on the end which you should just delete. Then run that javascript on the lecture list, and the download dialog will pop up.

Are you getting events in the event viewer every few seconds? Event IDs 50034 and 50068? The text of event 50034 is “An error has occurred in initializing the adapter 15. Error Code is 0×1392″ (perhaps a different adapter number), and event 50068 is “Address 192.168.1.100 being plumbed for adapter 15 already exists” (with a different address and/or adapter number). Here’s the solution:

First check if one of your adapters has a static IP address that you assigned it.

If not, then just disable one of the adapters. Suddenly the other one will be connected no problem. The reason is simply that one of the adapters was previously assigned address 192.168.1.100 (or whatever your error is saying), and even though that adapter is disconnected, it is still conflicting with your new adapter trying to become 192.168.1.100. The DHCP-client service won’t assign two adapters the same address, so it keeps renewing attempting to get a new IP, but the DHCP server (your router) keeps assigning it the same conflicting address.

It’s safe to leave the adapter disabled, but if you don’t like the idea of having one of your adapters disabled even when it’s unplugged, then re-enable it and plug it in to something which assigns the adapter (via DHCP) a new address. Then Windows will allow your other adapter to take the address it has been trying to get all along.

I saw this in my own laptop. It has an ethernet adapter (Local Area Connection) and wireless adapter. The ethernet was unplugged and I was trying to connect to my wireless network, but the wireless network kept connecting and disconnecting repeatedly. The solution was to disable my local area connection adapter. Then suddenly the wireless one was connected! The underlying problem was some static DHCP settings I had set in the past.

Also, if you’re reading this and it fixed your problem, you probably also enabled static DHCP like I did. If so, make sure to assign a different IP to each of your adapters even to the same computer; i.e. assign 192.168.1.100 to the ethernet adapter and 192.168.1.101 to the wireless adapter. Even if they will never both be connected at the same time, this and other problems can arise by them being set to the same DHCP address.

Hope this helped you. Feel free to add any other information in the comments below.

I’m trying to grasp a very slippery issue lately. Several users have OneNote 2007 installed and are sharing a notebook over the network (via a shared network drive). One of them will open OneNote and sometimes (randomly) a shortcut to a tab will be created in the shared notebook. This occurs without the user even viewing that specific notebook and sometimes multiple shortcuts are created at once. Looking at the owners of the shortcuts, not everyone is affected by this bug. They are all running Windows 7 64-bit with an almost identical environment.

I found a few instances of it across the web but it seems to be a very scarce bug:

• 2008-7-3
• 2010-5-7

The best idea is probably to bump them to OneNote 2010 (and hope it doesn’t happen) but we are not yet ready to migrate users, so in the meantime I’ll need to try and find a solution.

I need to run Office Diagnostics on each of the computers. It might fix the problem automatically, if the moon is aligned just right.

I will update this page once I find a solution. If you are also having this issue, please comment, especially if you have something to add.

Importing a CSV file which was saved from Excel 2007/2010 into MySQL using phpMyAdmin is easy once you know how! Just carefully follow all of these steps:

1. Sanitize the CSV file: Open the CSV file in a text editor (preferably something better than notepad.exe, such as Notepad++). If the first row contains column names, delete it. If there are extra last rows at the bottom of the file, delete them (leave one completely blank line at the end). Do a search for “,,” (two commas in a row) and wherever you find that, add a value between those commas; the value should match the type of that column, so if it’s a numeric column, add a number (0 or -1), and so on. Do a search-and-replace for “” (two quotation marks) and replace all by \” (backslash quotation mark). Save!

2. Open phpMyAdmin: In phpMyAdmin, click the table, and then click the Import tab at the top of the page.

3. Import: Browse and open the (sanitized) csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE dataset (or slow server). The format should already have selected “CSV” after selecting  your file, if not then select it (not using LOAD DATA). If you want to clear the whole table before importing, check “Replace table data with file”. Optionally check “Ignore duplicate rows” if you think you have duplicates in the CSV file. Now the important part, set the next four fields to these values:

• Fields terminated by: ,
• Fields enclosed by: “
• Fields escaped by: \
• Lines terminated by: auto

Currently these match the defaults except for “Fields terminated by”, which defaults to a semicolon. The crucially important sanitization step prepared the CSV file to work with these values so make sure you did in fact follow my sanitize step above. Now for column names, put a comma separated list of your table’s column names which match the CSV columns. This is case sensitive, no spaces after the commas, no quotes around the table names. Like this: column1,other_column,column3.

Now click the Go button, and it should run successfully. I tested this method with values that contained combinations of single quotes, double quotes and commas, and the values all seemed to import correctly after following everything above. If you have problems with this method please email me via the button on my homepage, and if you found this to be helpful please consider commenting or reposting and linking back to here so that perhaps this can rise to the top of search results. Thanks!

The following is the list of commands to crack into a WEP network on Ubuntu. It works for me so I’m recording it here; your experience may vary.
Read the rest of this entry »

I just got a fake email from “Skype Support” and wanted to let everyone know about it. If you are viewing this page, I assume you got here by searching because you got the email too. Don’t visit the website.
Read the rest of this entry »

I just wrestled with Arch Linux for several hours before figuring out a stupid mistake.
Read the rest of this entry »

Whew, I just had quite a difficult time getting Artifactory to install and run in CentOS. They have a nice installation guide, and it almost worked but not quite.
Read the rest of this entry »