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 I then carried out all the changes going up and down the document, double-checking I had done everything their instructions said. For demonstration purposes: I am installing phpBB3 on a website at http://www.mysite.com/ and am going to pretend the...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 girls name) posted to a forum which was even more useless asking him about a write-protect switch (physical). The user then said nevermind and found the answer himself. The discussion is on the page http://www.hardwareanalysis.com/content/topic/46202/....

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

Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 popup. (if already installed it just lets you click on "Ok"). Initially I got a support agent from GoDaddy to do this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 quick article on demonstrating a nested try...catch()... statement working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my Cx is that they...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not sure for the same reasons....

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 used to use MS Outlook to store these kind of things until the company implemented a software to deal with room bookings and said we shouldn't use Outlook for this... The DataSet The script I used to generate the dates comes from...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 all installed for you. I just need you to restart your computer now and tell me when that's done.". "I've done what you said but it's still not working". "From my logs, you haven't restarted this machine in a while.". "No I definitely log off every...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 close the dialogs click on the TFS icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 because their system was case-sensitive despite the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the same...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 (or COMMAND) > Enter/OK Browse to folder you want to apply to this by using the "CD" command (type "CD /?" for help) As I said, I'm going to use a short batch process (*.bat). The reason the instructions below use the command prompt are because the...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 one worked on my old Acer monitors. Adding older GPU in PCIe 3.0 x4 Slot (put in a cheap GPU to run more than 4 screens they said): Stopped my RTX 3060 (in PCIe 3.0 x16 Slot) from extending to multiple monitors (would only display 1 monitor or 2...

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

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

06 March 2023 strict policies and procedures in place to prevent unauthorized access, disclosure, or modification of your data. That being said, it's important to note that the use and distribution of trained models may be subject to legal or ethical considerations,...

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

Outputting PHP files into different file formatshttps://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8');...

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You...

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

Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want the button to show so... How? Well edit the HTML......

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