nav-left cat-right
cat-right
Recent Comments
  • Colin Edmonds: Same problem, going to do a fluid change but what is the rec...
  • syed: change gear transmsion oil with cvt or atf the prob will be ...
  • syed: really an useful comment sometimes the dealer or mechanic do...
  • friv: hi, admin disable rel="tag" links?...
  • Mervin Burnett: I drove my 2000 HRV for 4 years with this shudder shake prob...
  • : There is a start-up clutch in the Honda CVT transmission on ...
Random Articles
SQL Server: Find modified Stored Procedures with Dates... Good little query to find modified dates of SQL Server stored procedures. The following example will find stored procs that have been modified in the last 7 days. SELECT name, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 ORDER BY modify_date...
Welcome to RJPargeter.com – SEO, Google Adword’s Management & Web Development. With extensive experience in the web site development and management field since the mid 1990’s working at organisations and companies such as USC, Sony, WGSN.com & University of Warwick, I believe I can offer realistic web site solutions for your business needs. Please browse my services via the navigation links or use the contact details throughout the site to enquire about your web site requirements and how I can...
SEO Part 14 – Web Based Sitemap... A site map enables search engines to easily find all content on the site by following all the links from the sitemap page(s) With the implementation of Google sitemaps, discussed in the ‘Google webmaster tools’ section there is no longer a huge need from a Google SEO point of view for a web based sitemap. For other search engines however it would be beneficial to have a few pages on the site that linked to all content currently published....
Ranking 31st Position on Google... I (RichyP) took part in an interesting discussion over on the searchenginewatch forums the other day: http://forums.searchenginewatch.com/showthread.php?p=94871Â A web site owner was experiencing a ranking with Google that was always 31st position. It seemed whatever the search term the site always came in on page 4 of Google results. The main domain had a PR of 6 so I thought this was strange that they didn’t rank higher. Well I had a little look into this for them and...
Determine URL of an ImagePlaceholder... I came across a problem recently whereby I wanted to determine the MCMS URL of an image stored in the MCMS Resource gallery.  The script had several image placeholders, some of which may of had images bound to them. My requirements involved determining the URL of any given image and then to use this in some CSS styling.   Faced with this scenario the following code should help: //Setup placeholder object and string for URL Placeholder pl; string imgSrcUrl...
SEO Part 13 – ‘Linkbait’ Content... In the ‘Incoming Links’ section before it is described how incoming links to the site can great improve Page Rank and therefore pages ranking higher in the search engines. The section describes how to aim for links to your site and try to aim for keywords in link text. One of the best ways to attract incoming links is to publicise content that is commonly referred to as ‘link bait’. This content has two principle aims: 1. Informative content...

Solr, DataImportHandler, UUID and SQL Server

I’ve recently been setting up Apache Lucene/Solr to index static PDF files and also import data to the collection from MS SQL Server. After successfully indexing PDF files and providing them with a unique id via UUID I wanted to import several SQL tables that each had a ID column called ‘id’. These tables would obvioulsy have overlapping ID’s at some stage so I wanted to use UUID on these documents as well. I struggles to find much documentation on Solr, SQL Server and UUID, but after successfully setting up UUID via http://wiki.apache.org/solr/UniqueKey, you also need to the UpdateRequestHander on the dataimport handler as well. Therefore the following code: <requestHandler name=”/dataimport” class=”org.apache.solr.handler.dataimport.DataImportHandler”> <lst name=”defaults”> <str name=”config”>db-data-config.xml</str> </lst> </requestHandler> changed to this <requestHandler name=”/dataimport” class=”org.apache.solr.handler.dataimport.DataImportHandler”> <lst name=”defaults”> <str name=”config”>db-data-config.xml</str> <str name=”update.chain”>uuid</str> </lst> </requestHandler> then auto creates unique id’s when importing on mass from SQL Server...

SQL Server: create failed for user/ User, group, or role already exists in the current database...

If experiencing the following errors in SQL Server: Create failed for User ‘xyz’. (Microsoft.SqlServer.Smo) User, group, or role ‘xyz’ already exists in the current database. (Microsoft SQL Server, Error: 15023) The above error can sometime occur when migrating a SQL Server Database from one staged environment to another. If both those environments have the same users present you can get issues when trying to add users from the new staged environments to the recently restored DB that the users are already present within. A solution I found is to map the DB users to the accounts already within the DB. This is achieved by using the stored procedure sp_change_users_login USE AdventureWorks GO EXEC sp_change_users_login 'Update_One', 'xyz', 'xyz' GO The above will take the specified user {parameter 2} and map to the login user {parameter 3}. Further information and other actions are available here: http://msdn.microsoft.com/en-us/library/ms174378(v=sql.105).aspx Note: MSDN state this feature will be removed in a “future...

SQL Server: Find modified Stored Procedures with Dates...

Good little query to find modified dates of SQL Server stored procedures. The following example will find stored procs that have been modified in the last 7 days. SELECT name, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 ORDER BY modify_date desc

Resize VMWare Disk

I was looking for a simple slider to resize a disk in VMWare server recently and its not that simple if you want to resize a disk. The solution is detailed in more detail here, but essentially you need run the following command on the host of the VMware machine: vmware-vdiskmanager -x 30GB D:\VirtualMachines\virtualMachine1\virtualMachine1.vmdk The above command essentially will resize the disk for virtualMachine1 to 30GB. vmware-vdiskmanager is located in the installation directory as detailed here, but the following table gives common locations under 32 bit windows: Workstation \Program Files\VMware\VMware Workstation Player / ACE Instance \Program Files\VMware\VMware Player VMware Server \Program Files\VMware\VMware Server GSX \Program Files\VMware\VMware GSX Server Converter \Program Files\VMware\VMware Converter Capacity Planner \Program Files\VMware\VMware Capacity Planner Lab Manager \Program Files\VMware\VMware Lab Manager Server Stage Manager \Program Files\VMware\VMware Stage Manager Server Virtual Desktop Manager \Program Files\VMware\VMware VDM\Server Consolidated Backup \Program Files\VMware\VMware Consolidated Backup Framework VirtualCenter 2.5.x \Program Files\VMware\Infrastructure\VirtualCenter Server VirtualCenter 2.0.x \Program Files\VMware\VMware VirtualCenter 2.0 Virtual Infrastructure Client 2.5.x \Program Files\VMware\VMware Virtual Infrastructure Client 2.0 Virtual Infrastructure Client 2.0.x \Program Files\VMware\Infrastructure\Virtual Infrastructure Client Server Console (VMware Server) \Program Files\VMware\VMware Server Console Remote Console (GSX) \Program Files\VMware\VMware Remote...

The original Discount Voucher/voucher code sites

Online discount vouchers and discount codes are now accepted as the norm in online shopping. The number of ‘voucher codes’ sites is near saturation point in the UK, so it’s worth remembering which web sites started the trend and what they are offering online consumers. One the original sites I used to use was UK Frenzy (http://www.ukfrenzy.co.uk/) back in around 2002/2003. UK Frenzy was one of the original sites for online vouchers and regularly featured Amazon, Dell, Dixons and Comet Vouchers. Today they are still offering information in pretty much the same format and also have a fairly active forum of users sharing vouchers and online bargains. The second site is started to use around 2005 was HotUKDeals (http://www.hotukdeals.com/). This site started small and rapidly grew into a massive list of product offers, deals and merchant specific voucher codes. Over the years the categorisation has changed but the site still offers a vast amount of fantastic buyer’s advice. A third site that featured heavily in my online purchasing for sourcing bargains and money saving opportunities was Martin Lewis’s Money Saving Expert (http://forums.moneysavingexpert.com). In particular it was the user forums and specifically the Discount Vouchers and Discount Codes forum. Over the years Martin’s site has grown from strength to strength and is regularly featured on the BBC, but the true value of this site is its users. I regularly check back here to search for merchant vouchers. The following two sites are close to my heart but also worth a mention. Greedymoose (http://www.greedymoose.co.uk) was a site I set up in 2004 and ran till 2005/06. It hasn’t received much in the way of updates since then but at its time was heavily visited voucher code site that produced some good revenue. At its heyday it ran several unique discount vouchers that can still be found on some the later ‘voucher code’ sites – but at the time these were unique to GreedyMoose. Maybe soon GreedyMoose will have revamp – watch this space. The final site that will be mentioned is UK Discount Vouchers (http://www.ukdiscountvouchers.co.uk/). UK Discount Vouchers (UKDV) was formed in mid 2004 as a user’s forum for discount vouchers and sharing them easily with fellow shoppers. This worked to a certain degree but forum spammers eventually got too much and the site was changed to a Blog in August 2006. Since 2006 the site has grown and has now transformed into a store specific site where users can access their favourite shops and easily check for discount vouchers and codes for that store. So that’s a brief round-up of...

Honda HR-V automatic shudder/shake from start off

I’ve come across this problem now twice on Honda HR-V/HRV automatics whereby the car will do a big shudder/shake/judder/vibration from a stand still start. Having done my own research into it at the time it relates in most instances to the automatic transmission fluid is past its best and the clutch brake is sticking when the car comes to stand still. When you then try to pull away the brake does not disengage in time and you get the sudden judder and shake of the car. As you can imagine this will probably not do the car much good in the long term so the solution is as follows: 1) Buy official Honda Automatic transmission fluid. This will either be Honda CVT Fluid or Honda ATF Premium fluid. Your Honda dealer will advise the current recommendation. 2) Drain the transmission fluid as follows: 2.1) Bring the tranismission up to normal operating temperature. Drive the vehicale to do this or run the engine until the radiator fan comes on. 2.2) Park the car on a level surface and turn the engine off. 2.3) Remove the transmission drain plug as pictured below and drain fluid into a suitable container. 2.3) Reinstall drain plug (or new one if it looks damaged/corroded). 3) Refill with the transmission fluid from 1) to the recommended level You should then find the HR-V’s shudder/judder has stopped. If you still experience the issues then the transmission will probably need to be looked at by a qualified Honda technician. Good luck and let me know if this helps...

Removing wp_head() elements (rel=’start’, etc.)...

In customising WordPress you may find a need to occasionally remove or add to the Link elements that WordPress automatically outputs in the function call wp_head(). I’ve recently had a need to remove the rel=’prev’ and rel=’next’ link elements and in trying to avoid customising the core WordPress functions the following solutions works. Ensure you have a functions.php file in your theme directory that you are using. If not create the file and edit the file. The following lines will help remove select lines from your wp_head() function: remove_action( 'wp_head', 'feed_links_extra', 3 ); // Removes the links to the extra feeds such as category feeds remove_action( 'wp_head', 'feed_links', 2 ); // Removes links to the general feeds: Post and Comment Feed remove_action( 'wp_head', 'rsd_link'); // Removes the link to the Really Simple Discovery service endpoint, EditURI link remove_action( 'wp_head', 'wlwmanifest_link'); // Removes the link to the Windows Live Writer manifest file. remove_action( 'wp_head', 'index_rel_link'); // Removes the index link remove_action( 'wp_head', 'parent_post_rel_link'); // Removes the prev link remove_action( 'wp_head', 'start_post_rel_link'); // Removes the start link remove_action( 'wp_head', 'adjacent_posts_rel_link'); // Removes the relational links for the posts adjacent to the current post. remove_action( 'wp_head', 'wp_generator'); // Removes the WordPress version i.e. - WordPress 2.8.4 Don’t remove these items unless you have a need to. The WordPress generator removal could be useful if you are not religiously upgrading your WordPress install as it helps hide the WP version from potential hackers to a certain...

RGB to HEX Converter

Working with CSS I am constantly trying to convert RGB values from Photoshop to their hex equivalent. There is probably a setting in PhotoShop that I have missed, but the following small form will quickly convert RGB values to the HEX equivalent. You can then use these values in CSS with # at the beginning. Let me know if you find this useful: R: G: B:...