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

07 April 2022 later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that when downloading the certificate from GoDaddy and followed the steps above but it kept showing the certificate for...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 is all in the workflow settings. This worked for us but may not work for you or may be already working for you without this issue. By changing the workflow to execute not "When any field is upddated" but "When any selected field is updated" and then...

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

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 and its Attachments.csv to upload to Zoho. v_ChangeLogText = ( Date (v1.0): 10/01/2023 - Initial Release Date (???): ??? - Issue: ) ; -------------------------------------------------------------------------------------- ; Set program Defaults ;...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM...

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

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 == "Sales Team") { r_Field.setValue("Sales Pipeline"); } else { r_Field.setValue("Hire Pipeline"); } Save and Close Issue(s) Encountered Using the CS IDE Run: This can't run ZDK Apps.CRM.Users (this can't read any module)... Simply save the above code...

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

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 A frustrated article about an issue that took me a fair few hours to resolve. So I'm putting it here as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 we send out to our customers... How? Well fulfilling the brief (whether it's the right tool for the job is a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a new survey is...

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

Joomla: Unable to find install packagehttp://mail.joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

05 September 2009 This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and...

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

Setting a rocket theme background to fixedhttp://mail.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 You can probably find this information of the rocket theme forum but I thought I'd put how I resolved this here. The issue is basically that you want the background to stay in its position in the browser while the rest of the elements scroll about. Go...

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

Restoring your WYSIWYG editor after upgrading Joomlahttp://mail.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 The Issue Basically that after upgrading Joomla, my TinyMCE WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day...

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

Converting SQL date in PHP to European date format and vice-versahttp://mail.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....

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

How to make a HTML form post its variables to itselfhttp://mail.joellipman.com/articles/web-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

17 September 2009 The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do...

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

Prices get rounded up in Virtuemarthttp://mail.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card...

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

Changing the yourdomain.com for phpBB3http://mail.joellipman.com/articles/cms/joomla/changing-the-yourdomaincom-for-phpbb3.html

01 October 2009 This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first...

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

Joomla banners not rotatinghttp://mail.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating...

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

On Gui Resize Eventhttp://mail.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 for this solution. In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose...

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

SSRS Report Builder 2.0 - Error during processinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The issue was that I was building my first Joomla 1.5 component and getting the below error if I put in a menu: Warning: implode()...

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

SSRS Use T-SQL Like with a Parameterhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes for one thing. So let me rewrite this: SELECT rb.[GivenDate] , rb.[DateStart] ,...

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