Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 of works. The licenses for most software and other practical works are designed to take away your freedom to share and change the works. By contrast, the GNU General Public License is intended to guarantee your freedom to share and change all versions...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Upgrading a Joomla 1.5 module to Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be referring to a...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://mail.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 protocol). The error ONLY appears when I try to "data export" the database. Why? The quick solution for everyone else is to change/reset the password of the connecting database user, but herein lies the problem. When you read my workaround, you'll say...

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

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 Phone and Tablet then a relatively old version of the Android OS: Add an activity to Mobile: select Google Maps Activity: Change the Title to what you want (don't change the activity or layout) and click on Finish: Get yourself a developers' Google...

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

Copy a Wordpress Site for Developmenthttp://mail.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 to DEV\wp-config.php Backup the database in LIVE environment Clear the database in DEV Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` //...

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

Warning: Save failed. Another menu item has the same aliashttp://mail.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 Panel (to check for and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already...

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

Protecting your Joomla Administrator Sectionhttp://mail.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 DoS, Injection, etc. I'm not saying these are silver bullets, but they will slow down some people. How? The below will a) change the /administrator location and b) limit access to a single IP address. Note that you will need to ensure you have a static...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttp://mail.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 Or more specifically, the primary contact, company, address and phone from the customer record and not from the sales order change. How? The key is a setting you need to change by going to Settings > Preferences > Packing Slip Settings > and Enable...

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

ZohoCRM: Template: not being able to edit a text boxhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 organization into the body of a template (just below the header... they weren't using the header section) but then they changed address and couldn't change the template. So they had something like: ${Organization.Organization Name}...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)http://mail.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 A client's first-line agents would have a lead record with the status "New Lead". The client wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could...

• 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 How to redirect the visitor after the contact page: Open Contact.php and go to line 473 - 475 and change the line: $link = ‘index.php?option=com_contact&task=view&contact_id=’. $contact[0]->id .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE )...

• 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 net and kinda needed it so am making a note of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or dll needed, just a slight...

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

URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your Reporting Server Change "%2fMYREPORTS%2fDemos%2fRB+Report+for+Me" to the name and folder of your...

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

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

03 October 2011 commercial migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to change their passwords but that is what the commercial applications are doing. The script to transfer users This is a free solution...

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

Search a database with SOUNDEXhttp://mail.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 as well as "Data not yet available". These are obviously the same values, so I should go through the database and change all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire database for similar...

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

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 click on the “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes): “Hello,\n\nA request has been made to reset your...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 See if you have the line const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; If you do, change it to const RECAPTCHA_API_SERVER = "http://www.google.com/recaptcha/api"; STEP #2: Check ReCaptcha Private Key This is assuming you have already signed...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 > Save Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066)...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 > Save Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\models\forms\settings.xml (line...

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

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 a user with that ID in the old system who might inherit privileges they shouldn't have. This script has been adapted to change the Admin ID to a number that hasn't been taken yet or to use the current one and is specified as a local variable. -- Specify...

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