Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid...

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

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 wikimedia_categorylinks.cl_from=p.page_id) AS PageCategory FROM wikimedia_page p LEFT JOIN wikimedia_revision r ON p.page_latest=r.rev_id LEFT JOIN wikimedia_text t ON r.rev_text_id=t.old_id WHERE p.page_namespace=0 AND t.old_text='' AND...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 04:00 - - 4:00 41:45 Some Requirements; StartTime will be the earliest someone starts work that day. EndTime will be the latest someone works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Specify Group(s) which can refresh thumbnails - Parameter: Description Length - Parameter: Image Rounded Corners (latest browsers only) - Parameter: Image Border Color - Parameter: Image Border Color on Hover - Parameter: Image Border Width - Parameter:...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 is a test text"; // // build up the endpoint (see https://www.twilio.com/docs/usage/requests-to-twilio#http-methods for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token + "@api.twilio.com/2010-04-01/Accounts/" +...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 2-way integration as the Zoho app needs information from additional apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps created before February 2022 won't be deprecated? Because the previous version was...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread = Map(); m_Thread.put("role","user");...

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 on the same server as my previous database. New db user and password added to the new database. Downloaded and uploaded the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 Hopefully you already have a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the time of this article, this was version 3.0.5, but RocketTheme are fully aware of this and seem to be...

• 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->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 enable it now. Otherwise, please...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 diagnostic page for this address I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder (v1.2) and Joomla (v1.0.14) then you're vulnerable to a hack. Watch for users signing up with...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 (to uninstall components) 18. Select AcctExp and click on the Uninstall icon. Now install Community Builder 1. Download the latest version from Joomlapolis.com 2. Unzip to a folder 3. Login to your admin panel 4. Go to Extensions > Install/Uninstall 5....

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

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

25 February 2010 Assign passwords and instructions on changing each password Website Initiation For JoelLipman.Com to do: Download latest Joomla, MediaWiki, Wordpress or other CMS version (if it has to be purchased, discuss with client) Install the CMS with respective...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 USING latin1) AS PageContent FROM wikimedia_page LEFT JOIN ( wikimedia_revision, wikimedia_text) ON wikimedia_page.page_latest=wikimedia_revision.rev_id WHERE wikimedia_page.page_namespace=0 AND wikimedia_revision.rev_text_id=wikimedia_text.old_id AND...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 email system as permanent host is £120/year (or £10/mo). This includes keeping the servers up-to-date and running with the latest technologies. You are welcome to find and use your own website hosts with their own support plans and I can help you...

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

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

24 March 2014 in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files Download the latest files from https://portal.areyouahuman.com/installation/php (If you want my cached download - v1.1.8: click here) Extract...

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

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

27 April 2014 in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files Download the latest files from https://portal.areyouahuman.com/installation/php (If you want my cached download - v1.1.8: click here) Extract...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app "byeBU" and this is version 0.4 Beta (unofficial app). Why? Something to do... How? The following code is using...

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