Sorry for the double post, but this was buried in the features section. Hopefully more people will see this that can respond
I want to update roundcube to the latest pkg package. Many people complained that the sender field was empty, and many pointed to the roundcube's FAQ, which states that this table must be altered by:
ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';
Falko pointed out that Roundcube uses ispconfig's db, which is the default one for me, db_ispconfig.
I looked inside db_ispconfig, but i cannot find a table called identities.
I also looked at the current installation of roundcube, in:
and found the lines:
$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
// postgres example: 'pgsql://roundcubepass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';
which means roundcube is using the sqlite database. I am confused now. Which database should I update? and what does this db store anyway?