PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://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: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar to when trying to enter a time against a project Task but...

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 What? I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS...

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

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 migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions have the issue where they will return all rows where studentadaccount is blank (this field can be null in the database); so that's a lot...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header......

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

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 - modified by front-end votes) --- Dependencies - Added Admin Section: Manage Support Tickets / Development Requests --- Bug/Issue/Development Request title --- Bug/Issue/Development Request description --- Bug/Issue/Development Request category type...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 the queries will work as normal with the NVL function. Running the second based on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing expression 00936. 00000 - "missing expression" The...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the contents background (white) shows. When I visit a very long page...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://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 backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection:...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 Stock) - Resolved fix of overpaid amount (Include Shipping Cost in SO) Date Modified: 2023-03-16 (Joel Lipman) - Resolves issue of SO / Invoice / Package / Shipment / Payment not updating. - Revamp and debug line by line - Switched email identifier back...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 in the advanced configuration... I can't see this panel, there is no advanced parameters under a weblinks category. The issue is that suppose a menuitem links to a category of weblinks, the default sort order (as in the first time you view the page) is...

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

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 that will hopefully comprise bug-tracking and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this solution unless we continue to pay for the...

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

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

28 June 2011 I'm the only one to have tested it and it works perfectly for me. And I guess I'll just keep testing but there is the issue that you can't do anything else while it's sitting there taking pictures; unless you have more than one screen. It's automation....

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