This text is replaced by the Flash movie.

Archive for the ‘Joomla’ Category

Joomla 1.5 Article Trash

December 4th, 2010
While debugging the component I created I noticed that the query was returning some articles I didn't knew existed. I found out that these articles are just trashed.

The simple way to separate article trash from active articles is to get the state datafield of the table #__content equals to 1.

$query = "SELECT a.*, n.*, t.*, as linkThisPage"
. "\n FROM #__componentnews_news AS n"
. "\n LEFT JOIN #__content AS a ON = n.pr_id"
. "\n LEFT JOIN #__componentnews_types AS t ON = n.type_id"
. "\n WHERE ( a.state = 1 )"
. "\n AND ( a.publish_up = " .$database->Quote($nullDate) 
. " OR a.publish_up <= " . $database->Quote($now) . ")"
. "\n AND ( a.publish_down = " . $database->Quote($nullDate)
. " OR a.publish_down >= " . $database->Quote($now) . " )"
. "\n ORDER BY $orderby"
. "\n limit $skip," . $count;

Where in this query . "\n WHERE ( a.state = 1 )" should do it.

Joomla 1.5 phpbb bridge bug fixed

August 6th, 2008
*This happens when you verify the account through mail.
In /plugins/user/phpbb3.php, replace line 92:

    if(!isset($userid)) {

    if (( ! isset( $userid )) || ( strlen( $userid ) == 0 )) {              // it's set, but has no value

Forum Source

Module Title not showing up Joomla 1.5(fixed)

July 28th, 2008
  I encountered this problem, when I am upgrading a template from 1.0 to 1.5... I thought this was only a minor problem, until 3 hours past and I still couldn't fix it... I checked everything on the admin, settings, parameters, and even global configuration. Until I rechecked the module param at the template  <jdoc:include type="modules" name="user2"  /> and I try putting style... first a blank one... it doesn't work, then I try putting style="xhtml" and now the title of module shows

<jdoc:include type="modules" name="user2"  style="xhtml"  />

Virtue Mart Bug

December 22nd, 2007
When Adding Category, Product or Just change configuration, the administration page automatically Logs me out, I tried to Google for the solution which is easy to find... and visited the results which are forum of virtuemart but it takes me 3 forums before I finally got to the solution page.

Virtue Mart Session fix

Changes to be made:

103 doGzip();
105 // if task action is 'save' or 'apply' redo session check
106 if ( $task == 'save' || $task == 'apply' ) {
107 $mainframe->initSessionAdmin( $option, '' );
108 }

102 // if task action is 'save' or 'apply' redo session check
103 if ( $task == 'save' || $task == 'apply' ) {
104 $mainframe->initSessionAdmin( $option, '' );
105 }
106 doGzip();

Joomla SEF and IIS URL rewrite

December 3rd, 2007

Using ISAPI 3.0 over IIS 6.0 for rewriting URL to Search Engine Friendly URL, I experienced this problem that links return 404 error when clicking any links on joomla. After googling for 3 hours, I found the right solution, which requires to hack the code.

.htaacess code
RewriteCond %{REQUEST_URI} ^(/component/option,com) [NC,OR] ##optional - see notes##
RewriteCond %{REQUEST_URI} (/|\.htm|\.php|\.html|/[^.]*)$ [NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule (.*) index.php

This is because Joomla expects original URL in the REQUEST_URI server variable, but in IIS this variable is not available and cannot be emulated.
With ISAPI_Rewrite we store original request in HTTP_X_REWRITE_URL. You can then assign value of this variable in PHP code to the REQUEST_URI variable

at /components/com_sef/sef.php
// IIS patch.
if (isset($_SERVER['HTTP_X_REWRITE_URL'])) {

I append this code over sef.php by the way I'm using the component sh404SEF which I guess is the best for joomla I have tried OpenSEF (this component I guess is not continue for development) and ArtioSEF.