Author: james

Gmail rejecting or blocking emails via SMTP : 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.

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

read more

Add Joomla Update to Component menu

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`,

read more

Display or render Joomla 2.5 module using PHP

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;

Excel formula to grab a postcode from an address

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

Add admin user to wordpress using MySQL?

INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (‘3’, ‘USERNAME’, MD5(‘PASSWORD’), ‘NAME’, ‘EMAIL@HOST.COM’, ‘https://www.startnet.co.uk/’, ‘2013-06-07 00:00:00’, ”, ‘0’, ‘NAME’);   INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘3’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);   INSERT INTO

read more

Allow duplicate email addresses in Joomla 2.5 user logins

To remove the duplicate e-mail address check in Joomla 2.5 – though beware of password resetting functions. Edit file: libraries/joomla/database/table/user.php Comment out the lines below: Line: 238 if ($xid && $xid != intval($this->id))        {        // XXX ALLOW DUPLICATE

read more

Getting font-face to work on ALL browsers – Chrome, Firefox and IE

Usage : use CSS declarations like below – this should work on Chrome, Firefox, IE7, IE8, IE9 on PC and Apple Mac – iphone/ipad : @font-face { font-family: ‘newbaskervillestd-italic-webfont’; src: url(‘/includes/js/fonts/newbaskervillestd-italic-webfont.eot’); /* IE9 Compat Modes */ src: url(‘/includes/js/fonts/newbaskervillestd-italic-webfont.eot?#iefix’) format(’embedded-opentype’); /*

read more

Allow access to MYSQL database for a specific user only

To grant full permissions : mysql> grant all privileges on database_name.* to ‘username’@’localhost’; Query OK, 0 rows affected (0.09 sec) mysql> flush privileges;Query OK, 0 rows affected (0.09 sec)mysql -uusername -p mysql> show databases… To Revoke all permissions : mysql>

read more