Moving a wordpress e-commerce site

• UPDATE wp_options SET option_value="http://newsite/new_dir" WHERE option_value="http://oldsite/old_dir"; -- this fixes most of the site
• UPDATE wp_options SET option_value="http://newsite/new_dir" WHERE option_value="http://oldsite/old_dir"; -- this fixes the pagination for the e-commerce plugin.
• In .htaccess:
  
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f [NC]
RewriteCond %{REQUEST_FILENAME} !-d [NC,OR]
RewriteCond %{REQUEST_URI} / [NC]
RewriteRule ^(.*)$ /new/$1 [L,QSA]
  

Add-ons for Thunderbird

• Lightning = a calendar
• Mailbox Alert = pop up a message for important emails (first set a rule to copy them to a folder, then right click on the folder to set the Mailbox Alert)

Eclipse notes

• File associations are under Preferences | General | Editors | File Associations
• Background colour is under: Preferences | General | Editors | Text editors 
• and Preferences | oXygen | Editor
• Syntax highlighting is under: Preferences | XML | XML Files | Editor | Syntax Coloring
• and Preferences | oXygen | Editor | Syntax highlighting
• Eclipse plugins site: http://eclipse-plugins.info/eclipse/
• How to import/export syntax highlighting colours
• No word wrap!

Eclipse plugins

Eclipse 3.5

• Target Management (Remote file browsing, via SSH): http://www.eclipse.org/dsdp/tm/
• works great (but sshfs is simpler)
• Instead of that, see also http://wills-tech-notes.blogspot.com/2010/07/remote-file-browsing.html
• XSLT: http://www.eclipse.org/webtools/
• can't download through update manager, it's too slow
• supposed to offer XML/XSL features, but I can't see any
• Oxygen XML/XSLT: http://www.oxygenxml.com/download_oxygenxml_editor.html#Eclipse
• Works. To use step-through debugging,you need to open the 'Debug Scenario' in the XML or XSL menu (it appears when you open an XML or XSL file)
• vim -- why not use vim editor inside Eclipse? No good solution, apparently (none of these were tested):
• http://www.viplugin.com/viplugin/ (2009 - costs a few pounds)
• http://eclim.org/vim/ (recent)
• http://vrapper.sourceforge.net/ (recent)
• http://sourceforge.net/projects/vimplugin/ (2007, but states it supports syntax files)
• Full Screen: http://code.google.com/p/eclipse-fullscreen/ (just works) 
• P4WSAD: Perforce plugin: http://www.perforce.com/perforce/products/p4wsad.html (had to download zip file from FTP site and install manually, as automatic install URL was too slow)
• Plugin can be slow to use if you browse the repository directly, but is faster if you check out, then do right-click | Import as project, and use the standard Eclipse Navigator or Project tab to work with the files.

Screen capture for long pages in firefox

The Firefox add-on Aviary is a very powerful screenshot program that can easily capture a really long web page as an image.

Template Toolkit troubleshooting

If a module upon which your code is dependent does not compile, then Template Toolkit 2 under mod_perl 1.3 can give two misleading error messages:

1. can't locate that module in the @INC path, although it is really there
2. plugin error - load() returned a false value

The solution to both error messages is to syntax check all the dependent modules.