Thanks Michael,
I turned the user_shares off and it worked. Now all the address books
are displayed as desired.
regards
Manilal
2008/6/4 Michael Rubinsky <mrubinsk at horde.org>:
> Do you *really* want shares enabled on this source? I have a feeling that
> might be at least part of the issue.
>
> Quoting Manilal K M <libregeek at gmail.com>:
>
>> Hello,
>> I have installed and configured the latest stable version horde(3.2)
>> and turba(2.2) in our Centos-4.6 server with PHP-5.2.6 and MySQL-5.0.
>> I have configured three address books in turba - Two from LDAP and one
>> from a MySQL table in the default horde database(mysql). These three
>> address books work perfectly. But everything went bad when I added an
>> address book from an external MySQL database. After adding the
>> external database, the existing three sources disappeared and only the
>> external source is listed without a proper title. Here is the
>> sources.php file entry corresponding to the external address book:
>>
>> $cfgSources['sql_crm_contacts'] = array(
>> 'title' => _("CRM Contacts"),
>> 'type' => 'sql',
>>
>> 'params' => array(
>> 'phptype' => 'mysql',
>> 'hostspec' => 'localhost',
>> 'username' => 'vtigeruser',
>> 'password' => '*********',
>> 'database' => 'crmdb',
>> 'table' => 'vtiger_contactdetails LEFT JOIN vtiger_account ON
>> vtiger_contactdetails.accountid=vtiger_account.accountid',
>> 'charset' => 'iso-8859-1'
>> ),
>> 'map' => array(
>> '__key' => 'vtiger_contactdetails.contactid',
>> 'name' => array('fields' => array('firstname',
>> 'lastname'),'format' => '%s %s', 'attribute' => 'name'),
>> 'firstname' => 'vtiger_contactdetails.firstname',
>> 'lastname' => 'vtiger_contactdetails.lastname',
>> 'email' => 'vtiger_contactdetails.email',
>> 'cellPhone' => 'vtiger_contactdetails.mobile',
>> 'workPhone' => 'vtiger_contactdetails.phone',
>> 'title' => 'vtiger_contactdetails.title',
>> 'company' => 'vtiger_account. accountname'
>> ),
>> 'search' => array('name','email','company'),
>> 'strict' => array(),
>> 'export' => true,
>> 'browse' => true,
>> 'use_shares' => true,
>> 'readonly' => true,
>> );
>>
>> Does any one know why this happens? How can I troubleshoot this problem ?
>>
>> regards
>> --
>> Manilal K M : മണിലാല് കെ എം.
>> http://libregeek.blogspot.com
>> --
>> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>>
>
>
>
> Thanks,
> mike
>
> --
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
>
> "Time just hates me. That's why it made me an adult." - Josh Joplin
> --
> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>
>
--
Manilal K M : മണിലാല് കെ എം.
http://libregeek.blogspot.com