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

04 February 2025 as my previous database. New db user and password added to the new database. Downloaded and uploaded the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created earlier Pointed a...

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

Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

30 May 2009 is subject to change without notice. Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any...

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

Sun-Dried Tomato Basil Couscous Recipehttps://joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 onions, and basil. This dish may be served hot or at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4 teaspoon dried garlic powder 1 package (10 ounces) plain couscous 1/2 cup...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the time of this article, this was version 3.0.5, but RocketTheme are fully aware of this and seem to be committed to keeping their...

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

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

15 November 2009 category. The issue is that suppose a menuitem links to a category of weblinks, the default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by title in...

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

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 I picture as a perfect project; unfortunately the first 2 pages tend to be completed in just over a day and the rest of the time is spent faffing around with design and functionality. We use the ProjectFork extension to manage projects, it helps during...

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

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

05 January 2011 is remote as well as the MySQL database. BIDS is on the client machine. Download and install the MySQL ODBC driver (at time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your...

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

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 DECLARE @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate)...

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

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

25 February 2011 AND wikimedia_text.old_text'' AND wikimedia_page.page_is_redirect=0 -- yields: let's call it MyTable1: Query time: 0.187s. 880 rows returned. PageID PageTitle PageContent ---------------- ------------------ --------------------- 1144 7911_and_7912_t......

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

Newbies guide to be the local computer guyhttps://joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 students, learn how to troubleshoot Macs and iPods. Develop a protocol for troubleshooting common problems It’ll save you time. Underpromise and overdeliver. Source:...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns the local variable ID (@StudentReference) everytime. So after an hour or so I came across "Cascading...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the...

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

MySQL last year week month day trend periodshttps://joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 DATE(registerDate)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)); -- TREND: count yesterdays from midnight (00:00) up to the same time today SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)) AND TIME(registerDate)

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun"...

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

Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 'VARCHAR') random_other, -- testing string (any char) UFN_DATASCRAMBLE(TO_DATE('01:00:00','HH:MI:SS'), 'DATE') random_time, -- testing time UFN_DATASCRAMBLE(TO_DATE('12/31/2012','mm/dd/yyyy'), 'DATE') random_date, -- testing date...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in...

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

Country Lookup by IP address CSVhttps://joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; // Database host name $db_user =...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 query, change and suggest other actions or route to take. My pricing structure: Easy, my base rate is £20/hour. I use my own timesheet system, so if you have a 5 minute job, this will only be added to subsequent tasks until these add up to 1 hour....

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