Every now and again the worst thing may happen and you will get error messages saying things like:

Invalid query: 144 Table ‘table_name’ is marked as crashed and last (automatic?) repair failed

A new feature has been added to Google webmaster tools which will let you know when a url won't appear due to duplicant content.

Google have launched a new service called Google Trusted Stores, this service is designed to put a badge on the retailers site which when the user rolls over the badge it shows the retailers customer satisfaction results.

Sometimes you need to archive very large tables with millions and millions of rows, the normal way of creating a new table and inserting from the old just isn't quick enough especially if this is a important table. One very fast method is to rename the original table to a archive name and then recreate the original. Here is now to do it.

There are lots of articles out there on how to fix the pragnation not appearing after upgrading to 1.4 or 1.5, we tried all of them and they did not work, in the end we copied the code from the pager files into the toolbar file.

Jargon Buster

We have created this list of IT Jargon to try and help you though the minefield that of the abbreviation world.

This allows you to add a link that will open an article in a new window and automatically send it to print.

You can have several articles within the page and all of these have separate print links.

If you want to update all the products on your Magento website TAX class then use the following SQL Statements

In this blog we will take you through the process of fixing the problem of PHP mysql_connect trying to connect on a link that has timed out.

Have you ever been doing a bit of shopping online, browsed a few items, maybe bought a couple of things and then gone on to a completely unrelated site only to see targeted adverts displaying things that you had been looking at on a completely different website just moments before? Have you felt that 'Big Brother' is really watching you and that your privacy has been completely violated?

Boots are lauching their mobile commerce platform to boost their digital operations and to stay ahead of the supermarkets that are encroaching on their market. 

Boots are also considering the trialling of smartphone apps for its prescription services. Alliance Boots director of insight, loyalty and multi-channel Ruth Spencer says "Our first priority is mobile commerce because customers want product details..."

We are pleased to announce that Acorn Media UK's new iPhone app is now available for download via the iTunes store.

You can download it at the following address:

http://itunes.apple.com/gb/app/dvd-gifts/id421428048?mt=8

I have come across many methods of writing classes and passing variables to them, most of them may work but are not the best method for large scripts or projects. Here I will show you the best method if maybe not the quickest.

When moving from Windows 2003 to Windows 2008 a common task and annoying one is to transfer over the schedule tasks, which can sometime be hundreds, unfortunately Microsoft do not make this an easy task but we have found a way.

The benefits of eCommerce and the need to be able to sell online are self-evident and well documented but what we are witnessing now, is consumers becoming much more comfortable with using their mobile devices to access the internet and purchase products.
Mobile devices are freeing people from the static desktop, allowing them to access the internet from anywhere, at anytime.

Just thought I would do a quick post to hopefully help some other people out of the never ending search for the JQuery no-conflict not working bug.

I have tried most tricks to get mootools and JQuery working together on the same page, in the end I found out what it was, it was simply that I had two JQuery libraries included.

This is very simply a list of useful Regular Expressions we use on a day by day basis and we though might help a few others:

This is a great MySQL stored procedure we use to create a duplicate of a database for development. When we want to duplicate a customers enviroment to test something new we use this to copy the database over. It works with magento builds.

You can have a play with a full working version of Magento. It's our try before you buy!

Follow the links below to the frontend and the admin console.