JDatabase: using the Joomla database with exampleshttp://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...

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

Restore MSSQL Error: Database is in usehttp://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as...

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

SSIS Convert a string into a datehttp://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a...

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

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

04 October 2013 asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements...

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

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

26 February 2014 to Joomla CMS v2.5.14 What? This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered"...

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

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

20 March 2014 What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on how to do this...

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

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

24 March 2014 to: Joomla CMS v2.5.11 (Joomla.org) jComments v2.3.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow-up of my article JComments 2.3.0 with Google ReCaptcha (Joomla 2.5.x) but instead of using ReCaptcha, we're going to...

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

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

27 April 2014 to: Joomla CMS v3.2.3 (Joomla.org) jComments v3.0.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://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 to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...

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

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

24 October 2014 This is an article serving as documentation for my first ever app on the Android Operating System. For tablets and phones. The app in a nutshell displays flight restrictions in a given area Description As a quadcopter flier myself, I wanted an app to...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttp://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 A quick article on how to remove the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from PCWorld.com. I adapted this to read a google news rss feed and...

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

TravelPort Universal API - Ping Request with PHP-cURLhttp://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Word Cloud (JWC) Downloadhttp://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 DS value for Joomla 3.x compatibility. - Date Uploaded: Mon, 16th Sep 2013 2.2- Enhancement: Parameter: If viewing an article, scan Displayed Article Only - Enhancement: Code Reduction (Removed unnecessary debug notes) - Enhancement: Code Optimization -...

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

Foreign Characters create symbols in PHP and MySQLhttp://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Accessing Apimo WebService APIhttp://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 to: Apimo Webservice 2.0 (apimo.com) PHP v5.5 What? This is an article on how I connected to the Apimo WebService. The Apimo Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was quite...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string()....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Windows Live Mail Error ID: 0x8DE00005http://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 to: Windows Live Mail 2012 What? A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new...

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

Excel - Check a column for values found in another columnhttp://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets...

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

Zoho Deluge - Update Creator from CRMhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the...

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

URL Alias uniqueness with PHP & MySQLhttp://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB