How to repair crashed tables in MySQL if auto repair fails

Here is what you should do if a table crashes and auto repair after mysql restart fails. Open a terminal / command line utility If crash is on remote server you will need to ssh first service mysql stop cd /var/lib/mysql/{your database name} myisamchk -r {table name} – recovering (with sort) MyISAM-table ‘{table name}’ Data records: ...

VT Commerce Image: drupal module for slideshow

VT Commerce Image: drupal module for slideshow
We were searching for a image slideshow module that would match with the designer’s vision. Fortunately, we found this interesting module VT Commerce Image: https://www.drupal.org/project/vtcommerce_image It was almost what we needed. But was it was non-maintained module. This is very common when it come to Drupal module world where in someone created a module according to ...

Drupal Commerce with CiviCRM 4.7.x

We at Web Access recently worked on a project where the requirement was to have an integration between CiviCRM and Drupal Commerce module. Fortunately for us, there is already Commerce CiviCRM module that matched our requirements. However after implementation we found that it didn’t work with the latest CiviCRM version 4.7.x. So we took on the task to ...

Kolibri GUI widget toolkit evaluation

Kolibri GUI widget toolkit evaluation
It’s an early stage for Kolibri project and are in the phase of evaluating GUI widget toolkit that can be used for the project. Along with my colleague Lobo, I decide to help in this evaluation. I volunteered to implement the basic prototype using Angular 2, which will be used for evaluation. Initial specs:   Based ...

Experimenting with MEAN

I have been working on LAMP stack for almost a decade now. Lately there has been a lot of buzz about MEAN stack, hence I decided to give it a spin. The MEAN stack is based on MongoDB, Express.js, Angular, and Node.js technology. There are various tutorials available online to learn MEAN. I particularly like the ones ...

Do’s and don’t for a software programmer

Do's and don't for a software programmer
Actually I had drafted below notes, several years back but somehow I forgot to post it here. So here you go.. In this post I would like to talk about some of the do’s and don’t if you are into computer programming  never write a sql query inside a loop, most of the times there ...

Content body disappeared for all content types in drupal 7

This is what happened recently on one of our drupal 7 website: Problem: Content body (node description) disappeared for all content types. Content body was present in the database but it was not displayed on website. Solution: After lot of debugging and searching we found a related post: http://drupal.org/node/989540 Hence I fired below queries: UPDATE ...

CiviSprints Europe 2012

how to bootstrap or initialize joomla environment in external script

If you want to get the information about the logged in joomla user in your external script here is the recipe for it: 1. First you need to get the joomla base path eg: http://example.com So something like below might work or you will have to adjust according to the path of your script file $joomlaBase = ...

Upgrade to PHP 5.3.10 on Ubuntu 10.04 5

Ubuntu 10.04 is LTS release hence it does not support latest releases of php, i.e you cannot upgrade to latest php version. Here are the instruction how to upgrade to php 5.3.10 on Ubuntu 10.04 You need to add this PPA: https://launchpad.net/~brianmercer/+archive/php5 sudo apt-add-repository ppa:brianmercer/php5 If you get below error: sudo: add-apt-repository: command not found ...