Migrate MediaWiki to another serverhttp://mail.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

MySQL Updating a database table from another tablehttp://mail.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE b.`CountryName` COLLATE...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

ZohoCRM GetRelatedRecords INVALID_DATAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 published. Step Three: To finish and make it all work requires editing of a single file in the Joomla installation. If you update or reinstall Joomla you will possibly lose this modification and have to apply it again. The file that you will be editing...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Add the website name to the page title in Joomla!http://mail.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 been upgraded to, I've noticed some differences that I've noted down below. Specific Joomla Template Providers Everytime I update this article, Joomla seems to come out with a new version. If you have installed Joomla 2.5, this is now a setting in the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

View your available module positionshttp://mail.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 Update for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Using K2 with jezReCaptcha plugin causing errorshttp://mail.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 then there are some settings you need to change in the plugin options: Inclusion Syntax = NO Auto-verify =YES Update 16.NOV.2009 I don't see this supported anymore so I wouldn't recommend using the JezRecaptcha plugin. In fact I'm not impressed with...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Mediawiki Extension for Camtasia Studio SWF videoshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 Macromedia Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here. // url . '", "csSWF", "640", "550", "9.0.28", "#000000");...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 too many changes is a hard process to keep track of. Joomla 1.6.x Responding to a comment by J16 User (9 July 2011): As an update for those of us brave enough to use the upgraded CMS, I have looked into this and it would appear that Joomla! CMS have not...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Add Image Mouseover effect in AutoHotkey GUIhttp://mail.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 are applying this mouseover effect to. With a bit more time, you could tidy up the code to do multiple images. Note: I've updated the above code so that even if you have other objects in the GUI, hovering the mouse over other objects will no longer...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 Agree on splash / slideshow image(s) What will be included in terms of features (calendar, polls, login, etc) Progress Update and Review Website Page Layout Standard article / presentation page Contact form(s) Discuss page types with module layouts...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Windows Live Messenger: Error 80048820http://mail.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and update this article. I found someone else on the Internet who doesn’t use the “remove device safely” blab and he got the same...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Run commands for Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 (if installed) acrodist Adobe ImageReady (if installed) imageready Adobe Photoshop (if installed) photoshop Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $0040 Const DLGC_WANTCHARS = $0080 Const DLGC_STATIC = $0100 Const DLGC_BUTTON = $2000 ;#End Region ;#Region Update Layered Windows Flags Const ULW_COLORKEY = $00000001 Const ULW_ALPHA = $00000002 Const ULW_OPAQUE = $00000004 ;#End Region ;#Region...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Joes Bug Tracker (JBT)http://mail.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Combining all file versions, descriptions, statistics, documentation and changelog under each project. This means you only update one documentation/changelog page which will be a Joomla! article. The Joomla! article will support whatever content based...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes DNS Correction (JDC)http://mail.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

MySQL: Display Users and Duration in Matrix Timesheethttp://mail.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if you want to list users who...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *