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

17 November 2013 updated just the Joomla CMS and then the option to update Akeeba disappeared. The files backup was over a year old but the content was unaffected, the site was restored to satisfaction... not bad for an hours work. So I've heard it mentioned before,...

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

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

07 July 2014 aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 displays a standard Ok/cancel message popup which you attach to some event import android.app.AlertDialog; import android.content.DialogInterface; new AlertDialog.Builder(this) .setTitle("Some Title") .setMessage("some message") .setPositiveButton("OK",...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 as a reference and not a definitive tool to check flight regulations in your area. The restricted zone data is based on content found in Wikipedia.org. By using this app you agree to the following: JoelLipman.com shall not be responsible for any...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 = 2; Intent choosePictureIntent = new Intent( Intent.ACTION_PICK, android.provider.MediaStore.Images.Media.EXTERNAL_CONTENT_URI); startActivityForResult(choosePictureIntent, RESULT_LOAD_IMAGE); } }); b.setNegativeButton("Cancel", new...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file in the root of your joomla website: # Admin Redirect RewriteEngine On...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages display a question mark inside a diamond shape instead of the foreign character. How does it...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 // specify your assigned key here $apimo_sha = sha1($apimo_key.$my_timestamp); // receive content $output = file_get_contents( $apimo_url. '?provider='.$my_provider_id. '×tamp='.$my_timestamp. '&sha1='.$apimo_sha. '&method='.$apimo_method....

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

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 variables with fewer commands than unsetting specific variables. Let's specify the output page to be in JSON format: // set content type of this page header('Content-Type: application/json'); // init $api = array(); $access_token = ''; 2a. Specify the...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`,...

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

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

15 May 2020 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 is List when submitted as a file attachment. sendmail [ from:...

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

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

24 October 2020 frameworks: I’m going to use my favorite third-party extensions (Bootstrap & jQuery) which I’m referring to over the web (Content Delivery Network – CDN) Recap So as a recap, this is how it looks so far: The HTML: The CSS: The JavaScript: The Preview in...

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

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 a bill: // // build attachment request m_Attachment = Map(); m_Attachment.put("paramName", "attachment"); m_Attachment.put("content", f_BillsExport); // // this variable name is in plural, but as a custom function within ZohoBooks, we know this is just...

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 You have 0 Previous Quotes Get a New Quote! © 1999 Joel Lipman Ltd. All Rights Reserved the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { //...

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

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 menu link for registered users but not for public More Information: not so great, lot of text: http://help.joomla.org/content/view/476/146/

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

After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in /home/.../components/com_content/helpers/route.php on line 106 After googling I found an unlikely solution which is becoming typical of Joomla. I hadn't...

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

Thank You for your donation!https://www.joellipman.com/thank-you-for-your-donation.html

08 August 2010 applications have their benefits and neither should go. My day job doesn't involve any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add...

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

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be...

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