Thursday, June 28, 2012

clear both whitespace

Its common to use clear:both style to push the parent container box to fit the height nicely.
It recent finding, realized when ever there is a float div above it, it will cause a huge white space to the container.
One way to fix it is to set the parent container: overflow: hidden

Thursday, June 21, 2012

jquery e[h] not defined

jQuery("#formtargetname").submit() fail with e[h] error.
problem due to having a button or any field by the name "submit"

Sunday, June 3, 2012

Kloxo Roundcube unable to save to address book

Just faced this issue back 1 week ago, v 6.1.22 seems to face this issue on roundcube email.
upon further investigation into /var/log/httpd/error_log, found this:


PHP Notice:  MDB2 Error: no such field Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO contacts (user_id, changed, del, `vcard`, `name`, `email`, `words`) VALUES (1, now(), 0, 'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nFN:[name]\\r\\nEMAIL;type=INTERNET:name@example.com\\r\\nEND:VCARD', 'name', 'name@example.com', ' name@example.com name')] [Native code: 1054] [Native message: Unknown column 'words' in 'field list']  in /home/kloxo/httpd/webmail/roundcube/program/include/main.inc on line 2270, referer: ...



So, i went to dig into
/home/kloxo/httpd/webmail/roundcube/update/SQL/mysql.update.sql

And found these line which add the "word" column into the contacts table.

So i went to login as admin user into the kloxo and server > localhost > phpmyadmin,
and ran these script for roundcubemail database:

ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`;
ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER SET utf8 */ NULL DEFAULT NULL;
ALTER TABLE `contactgroupmembers` ADD INDEX `contactgroupmembers_contact_index` (`contact_id`);

And now it works perfectly.
Please take note not to run the entire file. You might likely to hit already ran sql syntax, and might took the risk to clear of your tables, especially message table.