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 163 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/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. 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

    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
  3. 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
  4. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-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
  5. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  6. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  7. 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

    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
    • Language: *
  8. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  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-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
    • Language: *
  11. Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  12. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  13. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  14. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  15. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  16. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  17. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making some minor changes to the MediaWiki LocalSettings.php...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  18. K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

    gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument supplied for foreach() in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    the report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the deployed report on the Reporting Server: An error occurred during client rendering. An error...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

    I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 21 - 40 of 163

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.