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

30 January 2011 0)); SET @new_jos_assets_id_last_lft=( SELECT MAX(`lft`) FROM `my_new_database`.my_prefix_assets); SET @new_jos_banners_parent_id=( SELECT MIN(`id`) FROM `my_new_database`.my_prefix_assets WHERE `name`='com_banners'); SET @new_jos_banners_parent_id = (...

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

Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 could try adding a subform to Creator but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the user to be able to click and download/open the...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 `v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.article.%'); SET @nextAssetContentID = @maxAssetContentID; SET @assetParentID = (SELECT `id` FROM `v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.category.%' AND `title` = 'Uncategorised' LIMIT...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 different to Attachment ID which has to be unique as you may have many files called "image001.jpg" but for other records. Parent Id: The CRM Record ID you are going to attach the file to (eg. "zcrm_123450000000000123456"). the Attachments.zip This needs...

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

Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home/{dunno_id}/teams/{dunno_id}/ws/{parent_id}/folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url...

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

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 Configuration Wizard > Backup Now Adding articles in Administrator interface: Save failed with the following error: Invalid parent ID. Asset ID is incorrect... Categories > Clear Filter Options > Show All > Tick to select all > Rebuild [does not work]...

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

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

14 January 2011 the report wizard and returned to the designer. Right-click on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week grouping expression: you're being asked to Group by, so we click on the "fx" button to enter the...

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

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

07 July 2011 --- Specify number of days a file is "UPDATED" - Added Admin Section: Manage Categories --- Category Title --- Category Parent --- Create Date / Modified Date / Expired Date --- Order by / Order az --- Display all reviews/comments (or just for this...

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

Importing Joomla articles to WordPress postshttps://joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 '' to_ping, '' pinged, modified 'post_modified', modified 'post_modified_gmt', '' post_content_filtered, '0' post_parent, CONCAT('http://demo.joellipman.com/wordpress/', '?p=', id) AS guid, '0' menu_order, 'post' AS 'post_type', '' post_mime_type, 0...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source,...

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

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query =...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 -- to return unknown nodes from XML column - Event_XML SELECT Event_XML.query('//* ') FROM [dbo].[XML_EVENTS] Parent/Child Node Names -- to get name of parent node -- returns STAFF SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM...

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 here we are using SRS as the dictionary and CAP as the entity. (If your change spans different entities, just use the parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent Set xRow = WorkRng.Rows(1) Application.ScreenUpdating = False For i = 1 To WorkRng.Rows.Count Step SplitRow resizeCount = SplitRow If...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 page, you can add the following code: openUrl("#Script:dialog.close","same window"); Known Issues Popup opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have tested on both Mac and PC but I had a...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 that occur under your account or password. If you are under 18, you may use our website only with the involvement of a parent or guardian. JoelLipman.com and its associates reserve the right to refuse service, terminate accounts, remove or edit content,...

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const WM_MBUTTONDOWN = $0207 Const WM_MBUTTONUP = $0208 Const WM_MBUTTONDBLCLK = $0209 Const WM_MOUSEWHEEL = $020A Const WM_PARENTNOTIFY = $0210 Const WM_ENTERMENULOOP = $0211 Const WM_EXITMENULOOP = $0212 Const WM_NEXTMENU = $0213 Const WM_SIZING =...

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

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

05 September 2011 alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row Labels" (put it at the top as parent) Right-click on the pivotTable on one of the values of the row label you just moved Select "Sort" Select "More Sort Options"...

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

Slideshow div layer through a windowhttps://joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *