Welcome to our technical tips blog – solutions and answers for numerous Joomla, Wordpress, Magento, Linux, MySQL and other problems.
Magento – display product attributes in category list page Say you’ve added ‘brand’ as an attribute and added it to the Default attribute set (make sure the attribute is visible in the frontend). Then add this: From http://www.magentocommerce.com/boards/viewthread/19215/ <?phpecho $this->htmlEscape($_product->getData(‘brand’));
Magento admin page xxx.com/index.php/admin gives 404 error. SET FOREIGN_KEY_CHECKS=0; UPDATE `core_store` SET store_id = 0 WHERE code=’admin’; UPDATE `core_store_group` SET group_id = 0 WHERE name=’Default’; UPDATE `core_website` SET website_id = 0 WHERE code=’admin’; UPDATE `customer_group` SET customer_group_id = 0 WHERE
Fix the Magento Database import error : Can’t create table ‘api_session.frm’ (errno: 150). the problem is caused by having ENGINE=InnoDB in lines for foreign keys. edit the file and do a find/replace for “ENGINE=InnoDB” to remove them. Make sure to
Joomla countModules function <?php if ($this->countModules( ‘user1’ )) : ?> <div id=”image_division”><jdoc:include type=”modules” name=”slider_image” style=”xhtml” /> </div> <?php endif; ?>
Joomla default menu (homepage), view, option variables in index.php // if a section set background body type for background image $menu = &JSite::getMenu(); // echo the menu item nameecho $menu->getActive()->name;echo $menu->getActive()->id; // id number if ( JRequest::getCmd(‘view’) === “section” )
Obtain Joomla Base URL in index.php template file Use : echo $this->baseurl; eg. <img src=”<?phpecho “$this->baseurl/images/some_special_file.jpg”;?>
Found this on my Poundhost server when trying to send emails to Gmail – “The sender does not meet basic ipv6 sending guidelines of authentication and rdns resolution of sending ip. Please review https://support.google.com/mail/answer/81126for more information.” Strangely, turned out to
To fix the problem where the Joomla Update component doesn’t appear in the Components menu in Jooma, just run this SQL : INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`,
Useful in Virtuemart or elsewhere: /* may be necessary to include: jimport( ‘joomla.application.module.helper’ ); */ $mainframe =& JFactory::getApplication(‘site’); $modules = JModuleHelper::getModules(‘left’);$document = JFactory::getDocument();$renderer = $document->loadRenderer(‘module’);$attribs = array(‘style’ => ‘xhtml’);$contents = ”;foreach( $modules As $mod ){ $contents .= $renderer->render($mod, $attribs);}echo $contents;
Had some addresses of the type below and want to grab the postcode from them, so created the following Excel formula : Unit L39, Lower Mall, Arndale Shopping Centre, Manchester M4 3AQ =RIGHT(C877;11-FIND(” “;RIGHT(C877;11))) Returns: M4 3AQ