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 SET a.`asset_id`=b.`id` WHERE b.`name` LIKE 'com_banners.category.%' AND b.`title` LIKE '% :|joes|%' AND SUBSTR( b.`title`, LOCATE(' :|joes|', b.`title`)+8, (LOCATE('|: ', b.`title`) - ( LOCATE(' :|joes|', b.`title`)+8)) ) = SUBSTR( a.`note`, LOCATE('...

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

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

07 June 2012 subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2)) END AS thread_id,...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; SELECT `id` , `title` , IF(LOCATE( @stringtoFind, REPLACE(`content_column`, @stringtoFind, @stringtoReplaceWith) )>0,'yes','no') as OldFoundInNew, IF(LOCATE(...

• 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 fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) DETERMINISTIC BEGIN DECLARE iStart, iEnd, iLength int; WHILE Locate( '', Dirty, Locate( '', Dirty, Locate( '

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

How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 You can open it in Dreamweaver or other good editors. (Joomla 1.5.2) Near lines 193-195 locate: Code: $msg = JText::_( 'Thank you for your e-mail'); $link =...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 2. Set the "Access Level" to 'public' and "Menu Items" to 'none' for both of your menu modules. 3. In the modules list, locate the one named metamod and copy it. (Only there if you installed the metamod module) 4. Edit newly copied metamod and rename it...

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

Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset]) PATINDEX(%needle%, haystack) CHARINDEX(needle, haystack [, offset]) String Concatenation...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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