Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming error is required, the following 168 results were found.

  1. 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/else/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

    connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears when I try to "data export" the database. Why? The quick solution for everyone else is to change/reset the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    A quick article on how to debug some errors in Zoho. Why? I wanted a general note 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    + p_InvoiceID type :GET parameters: m_Params connection:"joels_connector" ]; info r_InvoiceDetails; Common Error(s): {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not found","status":"error"} is because you did...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    a separate workflow as I didn't want to spend more time trying to see how I could automate this at the end of this function. Error(s) Encountered {"code":"INVALID_DATA","details":{"api_name":"Remind_At"},"message":"invalid reminder...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    } } } /* {"code":"INVALID_DATA","details":{"api_name":"id","json_path":"$.tags[0].id"},"message":"invalid tag id","status":"error"} -> Error was due to trying to assign map with removed key to a new map. -> Solution was to remove the assignment and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    if the student does not have a username but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  8. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  9. Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

    So I'm getting an error like this: The requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    creator file upload field value as attached file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported in Zoho Creator and nor...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  11. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    Toolkit (ZET) via command line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    r_ScheduleCall = zoho.crm.createRecord("Calls", m_ScheduleCall); info r_ScheduleCall; Error(s) Encountered: {"code":"INVALID_DATA","details":{"expected_data_type":"datetime","api_name":"Call_Start_Time"},"message":"invalid data","status":"error"}...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    that the address on the CRM record 'pulls through'. Sending the address in the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  16. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is terminated...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06" = 34 hours and 6 minutes). Error(s) Input Parameter Missing (6831): Can happen when there are either too many parameters or one is missing. Instead of abiding...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  18. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  19. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    intended to be all in the same function as there are references to some variables in earlier snippets of code on this page. Error(s): 2945: UPLOAD_RULE_NOT_CONFIGURED Was happening when I was trying to update the Zoho Creator record, specifically the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 21 - 40 of 168