mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears when I try to "data export" the database. Why? The quick solution...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 FOR DOWNLOAD! v0.4 (01/07/2011) - Accepts a text file containing a list of websites and batch processes the list. - Enabled output thumbnail quality options: 100`%, 75`%, 50`%, 25`%, 10`% - "Help 2.0" programmed to diagnose new features. v0.3...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 (not the "General" tab in the top left) At the bottom, type ROKBB3 then press the "Create new module" button. Make sure "enabled" is selected in the radio buttons and click on the "Submit" button. Click on "Back to previous page" This will create a...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 button_acl, button_open_tag, button_close_tag, -- button_title, button_prompt, button_image, button_css, button_enabled, ordering, -- published -- ) -- SELECT -- id, `name`, simple_pattern, simple_replacement_html, simple_replacement_text, pattern, --...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 the data column being processed private int[] inputBufferColumnIdx; // Create variables used in debug logging (when it is enabled) private byte[] emptyBytes = null; private const string DebugLogEventName = "JL - Mixed Case Component Debug"; private...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 - [1.8.0] Pilot: profile page with preferences - [1.8.0] Start: fetches current lat/lng - [1.8.0] Start: launch section enabled - [1.8.0] Help: re-categorized law, how-to, ToS - [1.8.0] News: include search words SUA, RPAs and UAVs - [1.8.0] News:...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this...

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

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

15 September 2009 which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You will still need to suffix the frontend URL with ?tp=1 Joomla 1.5.x This is another feature which took me a few years to...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 and then copy over to the newly created 'regmenu' module or what ever you called yours.) Make sure both menu modules are enabled. 2. Set the "Access Level" to 'public' and "Menu Items" to 'none' for both of your menu modules. 3. In the modules list,...

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

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

08 October 2009 $this->getViewPath($this->file); $this->code = ' The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Macromedia Flash Player. If you are you using a browser with JavaScript disabled please...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 option and then select all the effects from the list below it. Hit apply and ok and you should have all the Aero effects enabled. Now what are these Aero effects? Aero Peek: Aero Peek What this is it gives you a preview of windows in a thumbnail without...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to the files to create as being in this folder. ./profile5/profile5.php User - Profile -...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 TB_HIDEBUTTON = (WM_USER + 4) Const TB_INDETERMINATE = (WM_USER + 5) Const TB_MARKBUTTON = (WM_USER + 6) Const TB_ISBUTTONENABLED = (WM_USER + 9) Const TB_ISBUTTONCHECKED = (WM_USER + 10) Const TB_ISBUTTONPRESSED = (WM_USER + 11) Const TB_ISBUTTONHIDDEN...

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress that you have a PHP enabled server available. Here's code to top off the user migration, save it to an empty PHP file and upload/run it on your server:...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 much all I needed. Change www.YourSite.com - Yeah note the URL to the mootools-core-uncompressed.js file, if you have this enabled in Joomla then you already have this and don't need to include it again (just view the source of your webpage that this...

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

Battery Constantly Drained on iPhonehttps://www.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that needs to constantly monitor your whereabouts in order to "remind you". The reminder...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 This will be because the setting to display search areas has been switched off in the admin panel. You should keep this enabled so that the filters are carried through to the next search: Go to Components > Search > Options > set "Use Search Areas" to...

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