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 Please ask someone who does. -- IMPORTANT NOTES (to be included in SQL script): -- -- The script below is to migrate your existing Joomla! 1.5 database -- -- to an instance of Joomla! version 1.6.x or greater. -- -- You should have both sites up and...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however, for some reason the code does not exist the code lookup will fail: -- If...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 get a valid Access Token for the rest of these steps. Once we have an access token, we will check what notifications already exist (if any), and then we will create a function that subscribes the application so that any order is sent to a URL,...

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 resolve. If not, add the required A records to the dns zone such that it does. 5) The directory /etc/virtual/hostname must exist.. (eg: /etc/virtual/server.domain.com). It must not contain any files. 6) Any domains that you want to use for email (eg:...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 view it using a Web-Browser, the image does not display: Get report to see images hosted on an external URL Check if image exists to display alternative placeholding image. Solution #1: Image does not appear within SSRS Configure the Unattended...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 were derived from a post to the Stack Overflow website about the best way to check for rows in one table which don't exist in another. -- STATEMENT2 SELECT PageID, PageTitle, PageContent FROM MyTable1 WHERE PageID NOT IN (SELECT ArticleID FROM MyTable2)...

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

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

28 June 2011 same time on the same monitor). Download Details: JoelLipman.Com is my repository for scripts, programs and extensions to existing web-development systems. I use it to store notes that other websites either do not have or have stopped providing, or just...

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

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

07 September 2015 me to add) - Date Uploaded: Mon, 25th Jul 2011 1.4- Retrieves website thumbnails on the fly or uses local images if they exist. (Note: This retrieves thumbnail from a service and stores this on your server) - Warning: Images will reset if you specify a...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P...

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

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 may add this to their zoho.encryption namespace such as zoho.encryption.htmldecode(string). But at time of print, it doesn't exist and in the meantime, I've made a function that does this. How? Not sure how else to do this but I simply wrote a function...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 find Zoho Creator reliable when receiving and responding to webhooks. Important!: For the REST API to detect what webhooks exist, it can only detect what webhooks it initialized. If you added webhooks via another app or via the Shopify Admin interface,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 `user_id`333; Akeeba Backup Install: Warning JInstaller: :Install: Error SQL Table 'newdb.#_akeebabackup_profiles' doesn't exist Extension installation stopped. Package Install: There was an error installing an extension: com_akeebabackup-core.zip...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 feature just isn't available to you. Note: The temporary file gets deleted when the script finishes. So the file shouldn't exist if you check after the script has completed. Do the following step to keep the file in a specified folder. 5. Form...

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

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 any other link returned an error something along the lines of "template tpl load file styles prosilver login body does not exist empty". I backed up my local copy of the prosilver folder as well as my local copy of the Affinity for phpBB3 template. I...

• 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 system. Create test space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name Assign unique database username/password Add the user to the database Create test...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 details in the review list. v1.0 (17/05/2010) - Program to cycle through a folder of files to KEEP and check they already exist in the folder of files to REMOVE. - Ignores file extensions and file size differences. - Released to the world via...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 as English Bulldogs, Yorkshire Terriers and Chihuahuas. These ads are usually accompanied by staged pictures. The pets don't exist and the fraudsters are simply trying to get you to pay money upfront. Remember, be wary of overseas sellers. Source:...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 Guess It, Brute Force (=try every combination), Dictionary Attack (=try every combination starting with words that exist). (source: Lockdown: Choosing a good password) And some more which have become more popular in recent years: There are loads of...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *