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 enabled is required, the following 35 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

    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 appears when I try to "data export" the database. Why? The quick solution...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    FOR DOWNLOAD! v0.4 (01/07/2011) - Accepts a text file containing a list of websites and batch processes the list. - Enabled output thumbnail quality options: 100`%, 75`%, 50`%, 25`%, 10`% - "Help 2.0" programmed to diagnose new features. v0.3...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  3. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    - [1.8.0] Pilot: profile page with preferences - [1.8.0] Start: fetches current lat/lng - [1.8.0] Start: launch section enabled - [1.8.0] Help: re-categorized law, how-to, ToS - [1.8.0] News: include search words SUA, RPAs and UAVs - [1.8.0] News:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  4. 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-crm-zoho-bookings-full-name-appears-in-last-name.html

    "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    (not the "General" tab in the top left) At the bottom, type ROKBB3 then press the "Create new module" button. Make sure "enabled" is selected in the radio buttons and click on the "Submit" button. Click on "Back to previous page" This will create a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    button_acl, button_open_tag, button_close_tag, -- button_title, button_prompt, button_image, button_css, button_enabled, ordering, -- published -- ) -- SELECT -- id, `name`, simple_pattern, simple_replacement_html, simple_replacement_text, pattern, --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    the data column being processed private int[] inputBufferColumnIdx; // Create variables used in debug logging (when it is enabled) private byte[] emptyBytes = null; private const string DebugLogEventName = "JL - Mixed Case Component Debug"; private...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    "DEL" key every second or so. Go to "Advanced" > "Chipset Configuration" > Scroll down to "iGPU Multi-Monitor" and set to "Enabled". Exit > Save and Restart Still no luck... I know the pain. Go and have a cup of tea/coffee. Then let's work on that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  11. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    TB_HIDEBUTTON = (WM_USER + 4) Const TB_INDETERMINATE = (WM_USER + 5) Const TB_MARKBUTTON = (WM_USER + 6) Const TB_ISBUTTONENABLED = (WM_USER + 9) Const TB_ISBUTTONCHECKED = (WM_USER + 10) Const TB_ISBUTTONPRESSED = (WM_USER + 11) Const TB_ISBUTTONHIDDEN...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    This will be because the setting to display search areas has been switched off in the admin panel. You should keep this enabled so that the filters are carried through to the next search: Go to Components > Search > Options > set "Use Search Areas" to...

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

    "Myproduct1" exists counts as zero (0). It doesn't think the product 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    + "-" + v_ThisTill; } } } Note: Play around with the Status, there are "Pending", "Cancelled" (UK spelling), "Approval Not Enabled" and I think "Approved", "Rejected". We're using the !="Cancelled" and probably !="Rejected" because we want pending ones...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  15. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://www.joellipman.com/component/content/article/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html?catid=129&Itemid=165

    “Clear Data” You will be prompted to confirm, click on “Clear” Then also click on “Reset Permissions” (usually only if you enabled notifications previously) > Reset Return to Zoho Desk and you will get the popup to enable Desktop Notification Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  16. ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

    = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  17. Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-enable-tracking-using-the-api.html

    missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory enabled. But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  18. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    any query and any field. It doesn't matter which one here, as long as I can get to the 3rd tab of the widget (it becomes enabled once you've completed enough on the 1st tab): I'll click on the 3rd tab called "Settings" then on the sub-tab "Image", and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  19. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    to know is that it is passed the crmAPIRequest (string) variable and that the function itself had to have API Key and OAuth enabled (hover over function in CRM setup and select REST API, then tick both to the "on" position). The returned output from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    for accurate time comparisons - Map Xero tax rates to Zoho tax rates (same names in Zoho) - output to console if debug mode enabled More Information: http://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 1 - 20 of 35