Call to a member function mark() on a non-object in Joomla CMShttp://mail.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 CMS. This error could have been caused by many things but in the case of one of my clients, the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://mail.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 database I want to export for offline backup. I have to raise and log a formal change request and follow a workflow process in order to make a change on a live system to a service user account... Especially one used by the scripts to access the...

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

Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 database you are WRITING to (eg. `myuser_joellipmancom_mysitedb`.`ejf1r_content`) How? Here's a brief outline of the whole process: Backups Install Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://mail.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update...

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

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

24 October 2020 nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through the installation process with the final step to move it to trash/bin. Open the terminal app on your Mac and type the following to test the install:...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 function Why are we doing this first? Well when I create a workflow, it will ask me to run a function, the Creator workflow process will then read what datatype of a parameter I'm sending to the function. So in "Edit this application" > go to Workflow >...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 + "64,Elephant Man,\"123 New Street,\nNew York City\",USA\n"; f_CSVfile = v_DataCSV.toFile("test.csv"); // // read and process CSV file v_FileContent = f_CSVfile.getFileContent(); l_FileRows = List(); if(!isBlank(v_FileContent)) { l_FileRows =...

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

GoDaddy Apache cPanel: Install SSL Certificatehttp://mail.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article. How? I know there are instructions on the GoDaddy website but this is how I do it...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 app that is behind a user wall (ie. login and password as a Zoho User). How? So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 when a user has requested the deletion of their personal data and closure of their eBay account. This article explains the process third-party developers must follow to subscribe to, receive, respond to, and validate these notifications. Why? As quoted...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 article to apply an automation that when creating an invoice in CRM from a related quote, it maps in the fields. Why? The process should be that you go to the CRM quote record and click on "Convert" > then select "Invoice", and it should map the fields...

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

View your available module positionshttp://mail.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 your site and should reflect exactly how your website is overlayed with the module positions. You will need to repeat the process when you select a different template but otherwise the bookmark will last as long as you keep that template.

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

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

15 November 2009 it's an ugly unordered list), but changing scripts gets overwritten in a joomla upgrade so too many changes is a hard process to keep track of. Joomla 1.6.x Responding to a comment by J16 User (9 July 2011): As an update for those of us brave enough to...

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

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

28 January 2010 a system clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe through the start menu search box, and...

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

Creating a Top 10 chart with less codehttp://mail.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttp://mail.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Intro I know there are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked...

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

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 are aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

MySQL: Find records in one table that are not in another.http://mail.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 Um I'll get back on this article when I work this out without using two SQL scripts. Currently I've returned to the process where one SQL query returns all possible results and the PHP script runs another SQL query for each row to check the ID does not...

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