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

03 April 2009 in section 4 to “keep intact all notices”. c) You must license the entire work, as a whole, under this License to anyone who comes into possession of a copy. This License will therefore apply, along with any applicable section 7 additional terms, to the...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 You may not post your last name, or your street address on TEU. This is because this information then becomes accessible to anyone. No Threatening to Leave the Board - Due to past experiences on the board, I have had to add this rule. You may not make...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 a whole morning following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with!...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 Joomla version needs updating... I'm writing this in case I ever have to upgrade other people's Joomla CMS and if it helps anyone else out there. How? There aren't too many steps but this is what I went through and I might amend this if I see any new...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 } catch(e) { info "Couldn't convert 'Bar' to an integer"; } } Pushing the product beyond it's design Note that before anyone says I'm only try catching a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 has been LIVE for a while and it's returning this error despite having little installed, then check your logs to see if anyone has been trying to hack your website. There are a number of components I have found that even with captcha features, still get...

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 " S " htmlText:=htmlText " S " htmlText:=htmlText " " htmlText:=htmlText "" ; GET NUMBER OF DAYS THIS MONTH ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 as this was not my idea but quite ingenious and worth a mention. Did anyone else have any problems with Aero effects when they first installed Windows 7? What’s your favourite Aero feature or do you even use them? Let us know by leaving a comment.

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed...

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

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 (source: Lockdown.co.uk 01/2007) By default, the Mozilla Firefox browser lists your stored passwords in plain text to anyone with access to your browser through the tools > options > security > Saved passwords > Show All. This includes a feature to...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Format(Fields!Date.Value,"d")=22,"nd", Format(Fields!Date.Value,"d")=3,"rd", Format(Fields!Date.Value,"d")=23,"rd") Can anyone say what I did wrong with this? It returns "#Error".

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

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

28 June 2011 I will do my best to get back to you as soon as I can so that we at least open a line of communication. If anyone has any cool ideas, I'd love to hear them. Why do I have to sign up? I develop lots of weird monstrosities that I release on to the web....

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 this was just a workaround and never a solution. Add in the ID of each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit of the drilldown). What's the problem? Enter this as a...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see the username/password details (granted read-only...

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

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 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 files on your site and hope that they're not at 0 bytes....

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

Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 do... How? The following code is using AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate"...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4 H107C This model is the DJI...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 within. How? So I'll be putting this program for download from the download section of this website but I don't expect anyone to trust an executable EXE so here's the code of what it's doing which you can copy and paste to an AutoHotkey script: #NoEnv ;...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 breadcrumbs. Unfortunately, this only deals with the opacity transition as the width transition is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *