Bill MacKenty

MYSQL: changing a field type to longtext

Note to self:

To change a mysql filedtype from mediumtext to longtext simply type:

ALTER TABLE exp_templates CHANGE template_data template_data longtext;

This will change the field “template_data” in the table “exp_templates” to longtext.

Hope this helps someone.

HOWTO: reset lamp hours for a 600i series 2 unfi 45

To reset the lamp timer on a UNFI 45 (source here).

1. Press the power button on the ECP or remote twice to put the projector back into Standby mode. The
power button light on the ECP turns solid amber when the projector is in Standby.

2. Press and hold the up button on the remote control for approximately 10 seconds. When the projector
beeps, press and hold the down button on the remote control for approximately 10 seconds. The lamp
timer clears after another beep.

3. Press the power button on the ECP or remote to start up the system. The power button light on the ECP turns
solid green when the system starts.

4. To confirm that the lamp timer has been reset, press the MENU button on the remote control. Scroll to the
Status Display menu heading, and then confirm that 0 h appears in the Lamp timer field. Your lamp reset
count has increased by one.

5. Wait five minutes for the projector lamp to warm up.

6. After confirming that the lamp timer has been reset, put the system in Standby mode by pressing the power
button twice on the ECP or remote. The power button light on the ECP turns solid amber when the system is in
Standby.

7. Wait for the system to enter Standby mode, turn off the projector’s master power switch to shut off the system,
and then turn on the projector’s master power switch.

8. When you are ready to use the system, press the power button on the ECP to start up the system.

9. get out bottle of something strong

10. Drink until pain goes away.

HOWTO: turn a normal name into a username with excel

How do I take a list of first names and last names and turn it into a username? The answer is here:

HOWTO_turn_a_normal_name_into_a_username_with_Excel.pdf

Office: how to password protect an office document

How_to_protect_your_office_documents.pdf

Windows HOWTO: Using Acrobat Reader for new users

This small pdf is a guide for new users to use acrobat reader.  It covers zooming and selecting text.

Windows HOWTO: Creating filters in Eudora

This pdf is a short guide for new users to create a filter in Eudora.  There is also a short section to help newer users set out of office messages (vaction messages).

Enjoy!

Windows HOWTO: introduction to Windows

This small PDF is an extraordinarily simple guide for getting started with Windows. It is targeted for novice users with little to no experience using Windows.