Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 both PHPmail and sendmail So if this happens irrespective of whether I have PHP mail or sendmail set as the Mailer. Notice Could not execute: /usr/sbin/sendmail Warning Registration failed: An error was encountered while sending the registration email....

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the users screen. Three Webdevelopers phone in to say their computers can't view a website properly "Can someone...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 of some websites my website links to (about 153) for an extension (Quicklist Weblinks) I wrote for an OpenSource CMS. Could also be of some use if your portfolio is a bunch of online websites and you need screenshots of these. Whatever the reason, I...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because...

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

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

15 November 2009 It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution #2:...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 general-purpose computers, but in those that do, we wish to avoid the special danger that patents applied to a free program could make it effectively proprietary. To prevent this, the GPL assures that patents cannot be used to render the program...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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 to the includes/framework.php file. Comment that out and you will get errors regarding other elements of the 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....

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

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 I strafe right moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with...

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

Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 serves as documentation for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 = $response; } // close second request handler curl_close($ch2); } return $output; } Usage: $mime_type = 'video/mp4'; // could be 'image/jpeg', etc. $new_name = 'My Video'; $the_file_and_path = '../videos/my_video.mp4'; $result =...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 database names used in the below script to the ones you use!!! -- SKIP MIGRATION: -- -- Each section was written so that it could be migrated separate to the rest. -- -- It is recommended to skip the menu migration and to do this manually. -- -- This...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 the field @GivenDate off into an SSRS parameter (note do not declare it in the SQL code if using as a parameter). You could in the SQL above change the start time (note the end time if you want the end of the day should be "23:30:00" if you have 30...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an infinite number of man-hours (I exaggerate a little); but seriously, I needed a checklist that works for me....

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 % COM_Invoke(pwb, "document.SearchForm.search_keywords.value") Or if you only know the elements name is search_keywords, you could display the value of that element using all, which references all the elements on the webpage: Code: javascript:...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...

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