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 Applies to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...

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

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

06 February 2020 Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator record into Zoho Inventory via an invokeURL with API v2 rather than a connector. If you use POST then this...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 “https” rather than the default “http” [Optional Step] This is an added note/step if you get the following error when trying to access your app on your localhost: “127.0.0.1 normally uses encryption to protect your information. When Google Chrome tried...

• 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 for a while and it's returning this error despite having little installed, then check your logs to see if anyone has been trying to hack your website. There are a number of components I have found that even with captcha features, still get hacked with...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error...

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

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 table: Product_Name Product_SKU -------------- ------------- 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...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 We tried various other options such as adding a tickbox that would be used in an approval workflow but ran into issues when trying to update the record: { "response": { "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord",...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 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 this article is focused on getting this working against Project Issues. Also...

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

Zoho CRM & Zoho Books: Get SalesPersonshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

30 August 2021 An article so that I don't spend so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so...

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

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 "More tools" > "Developer Tools" Caveats Only make the changes necessary to how you like it. You will find issues with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the days of getting an MS Word document to...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 like: Error(s) Encountered Value is empty and '1234567000001234567' function cannot be applied: Possibly due to me trying to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 Modified: ??? - ??? More Info: Error 7008: There are no contact persons associated with this Invoice. - Encountered when trying to use the send an invoice API - Need the generated invoice to pre-select a contact person to email - Superceded by including...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 the CRM as well. A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is our friend. How? So we'll run a workflow that triggers on the creation of a lead...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal. How? Add a link with the prefix File:// and complete the rest of the path as per...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was getting...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 be permanently banned. Amendment 3 - Harrassing the administration about punishments is not allowed. The admins are only trying to do their job, and many times they have to make difficult decisions. You may post your opinion in the thread that announces...

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

Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 I added this article because when I was only trying to look up how to do this, this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• 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 data (and size is not 0) then it was successful. If not, then either your system isn't accepting the file type you are trying to upload, or the file is too big, or this feature just isn't available to you. Note: The temporary file gets deleted when the...

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 In this case, I want to display the current month with today highlighted. As I was trying to get my head round writing this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code....

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