Recently I stumbled upon a great script for extracting modified files between two GIT commits. This is great for website deployments assuming on client side only ftp is accepted. #!/bin/bash BOLD=”\033[1m” _BOLD=”\033[22m” RED=”\033[31m” YELLOW=”\033[33m” GREEN=”\033[32m” RESET=”\033[39m” range=$1 if [ -z … Continue reading →

let’s assume you have a mysql field which is composed from comma separated values table name: products field name from table products: category_ids (the comma separated list of categories) let’s assume that we want to search all products for a … Continue reading →

The exact error I kept getting was: exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[HY000]: General error: 1005 Can’t create table ‘xxx catalog_category_flat_store_1.frm’ (errno: 150)’ in xxx/lib/Zend/Db/Statement/Pdo.php:234 The solution is to execute the following statements inside phpMyAdmin: ALTER TABLE catalog_category_entity ENGINE=INNODB ALTER TABLE … Continue reading →

A quick post about validating anything you want using regex. I used it in a project that created forms on the fly, so validations like email, numbers and so on wasn’t so simple (I couldn’t do it by just adding … Continue reading →

Recently I wanted to test the ajax capabilities from cakePHP and after setting up the links to prototype.js and scriptaculous.js just as shown on cakePHP website, I’ve noticed the ajax is not working. In the javascript error console I noticed … Continue reading →

Today I needed to move some sites to a different server.  A wordpress and an old oscommerce. The server was a windows server from godaddy – the hosting was a shared one After setting up the database and the files … Continue reading →

Godaddy can be a killer of time for a programmer. It can take ages to figure out some things that are just now standard to webhosting. Recently I took care of a client that had a windows hosting package and … Continue reading →