JComments errors in PHP 7: plgContentJComments and JCommentsACLhttp://mail.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 in a future version of PHP; plgContentJComments has a deprecated constructor in /plugins/content/jcomments/jcomments.php on line 25 Fix: // change on line 27 function plgContentJComments(&$subject, $config) // to function __construct(&$subject, $config)...

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

K2 Items disappearhttp://mail.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80 If I went to K2 Comments, I'd get an additional error: Warning: Invalid argument supplied for foreach() in...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 Joomla 2.5.x systems will not have updated this: Open the file \plugins\captcha\recaptcha\recaptcha.php See if you have the line const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; If you do, change it to const RECAPTCHA_API_SERVER =...

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

Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 function. I ran into the following errors: Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 1: parser error : Document labelled UTF-16 but has UTF-8 content in /public_html/.../.../my_script.php on line ### Warning:...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 } // // ---------------------- QUOTE LINE ITEMS ---------------------- // line items get via api v2.1 or greater l_BooksLineItems = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/" + p_QuoteID type :GET...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 // // initialize m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem in salesorder.get("line_items") { r_BooksItem = zoho.inventory.getRecordsByID("items", v_BooksOrgID,...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 the item record has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per line item, the staff can specify which Sales Order the item relates to. How? At time of print, adding the lookup to the line item...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2 decimals but finance is so much more complicated. Why? Playing around with VAT / Tax, inclusive...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttp://mail.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the LocalSettings.php file in the web root folder where your MediaWiki is installed: $wgFileExtensions[] =...

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

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

15 November 2009 to modify the following file: /components/com_weblinks/models/category.php (make a backup/copy first) Look for the following line of code [the function is "protected function populateState("]: Line 181: $orderCol = JRequest::getCmd('filter_order',...

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

T-SQL Record Separatorhttp://mail.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 t0 WHERE [pretendField]='elephantastic' -- end your original SQL query here (note no "order by" allowed -- refer to 6th line of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL...

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

JDatabase: using the Joomla database with exampleshttp://mail.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 A quick note on how to chain, the following two statements are equivalent: -- note the semi-colons at the end of each line $query->select($db->quoteName(array('user_id', 'user_name'))); $query->from($db->quoteName('#__users'));...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 /PF :: check run hours on a Per File (not per pass) basis. /IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines. /SL :: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads (default 8). n must be at least...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace the line $captcha[] = JCommentsHTML::makeOption('kcaptcha', 'KCAPTCHA'); With this $captcha[] =...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\models\forms\settings.xml (line 398) Replace the line KCAPTCHA With this KCAPTCHA PLAYTHRU STEP #4: Set to PlayThru in admin setting We've made the change, now...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://mail.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 the function simplexml_load_string(). The error I get is something similar to: PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ! Bytes: 0xA0 0x3C 0x2F 0x73 in...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. How? So the trick is, go over the official...

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