We have managed to resolve the "1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check
your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay" fix for Cakephp and Croogo on the Heart Internet servers.

We first tried a number of .htaccess fixed to try and resolve the permanent redirect loop when you're nog logged in to the site. As soon as we logged in to the Back-End then the redirect loop dissapeared.

When visiting the admin pages we noticed the "1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay" error and realized that Heart Internet set their SQL_MAX_JION_SIZE much lower as other hosting providers and also that SQL_BIG_SELECT was not enabled for MyQSL. (To check these setting you can use PhpMyAdmin and insert "SHOW VARIABLES" in the SQL tab).

We also tried to use this fix from Gawgle but it dit not work. Also cleared the cache in the tmp directory without any luck.

Finally we struck gold by inseting $this->TheProblemModelName->query("SET SQL_BIG_SELECTS =1"); in the AppController's beforeFilter()

In this instance it was the Node model that we had to set.

Hope this helps someone in the future.

Happy coding...

Revive started to make use of the Open Source RAD framework called Cakephp since 2008. We've opted for this development framework seeing that it speeds up the development process tremendously and therefore freeing up time to focus on plugin/module development which allows us to expand our product offering.

Revive decided to harness the power of Google by creating a free Google Applications account for businesses and organizations when creating hosting accounts. Now what does this mean you ask?

Revive will setup your company email to run through Google Mail which acts as a fail safe just in case something goes GaGa with your hosting account.

If your business have less than 50 members/employees then we will setup a free Google Applications account for your business which will allow you to share Calendars, Documents, Sites and also allows you to run your company email through Google Mail.

Not only will your employees have access to shared documents and calendars but they will also be able to make use of Google Chat for employees to communicate with one another. This Chat accounts can be setup to include or exclude chats from outside your business.

We've been running Google Applications ourselves for a couple of months now and feel that this is a value added service that should be used by any business irrespective of size.

Feel free to contact us if you are interested in website-, email hosting or if you want us to assist you in setting up your domain to make use of Google applications.

Welcome to the new version of our website. We are happy to announce that we've developed a CMS product that includes content pages as well as a blogging platform.

We can even migrate your current Word Press blog to our platform if you already have a blog.

Kindly have a look at our list of services and if you would like us to assist you please do not hesitate to contact us.

Regards,

AJ de Waal