Hi, thanks Tomas - yep all DB's created as per documentation. And can manually verify this as well as the fact that the Squirrelmail configtest.php script verifies this also.
I'm been through the install several times now and still the same. I'm sure someone else must have had this problem ... Thanks - Julian. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tomas Kuliavas Sent: 02 June 2005 17:36 To: [email protected] Subject: Re: [SM-USERS] RE: Problem with address book Have you created database table for address book data? See doc/db-backend.txt CREATE TABLE address ( owner varchar(128) DEFAULT '' NOT NULL, nickname varchar(16) DEFAULT '' NOT NULL, firstname varchar(128) DEFAULT '' NOT NULL, lastname varchar(128) DEFAULT '' NOT NULL, email varchar(128) DEFAULT '' NOT NULL, label varchar(255), PRIMARY KEY (owner,nickname), KEY firstname (firstname,lastname) ); > Further to my post yesterday, if I goto > "squirrelmail/src/configtest.php" in a browser it tells me everything > is fine, particularly: > > Checking database functions... > PHP Pear DB support is present. > mysql database support present. > addressbook database connect successful. > > Congratulations, your SquirrelMail setup looks fine to me! > > So if it can connect to the addressbook via the test why does it fail > with "[Personal address book] Database error: syntax error" when > clicking the "Addresses" link? > > Again any help would be greatly appreciated. > > Thanks - Julian. > > -----Original Message----- > From: Julian Grunnell [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 01, 2005 1:05 PM > To: '[email protected]' > Subject: Problem with address book > > > Hi - hoping someone can help me with a new Squirrelmail server I'm > building. > > Platform is: > RedHat Linux X86 > Apache/1.3.33 > Qmail > mysql-4.1.12 > courier-imap-4.0.3 > squirrelmail-1.4.4 > PHP 4.3.11 with PEAR DB installed > > All has gone well and squirrelmail is working perfectly apart from the > "Address Book" which I want to use MySQL to store details in. When I > click the Addresses link I get: > > ERROR: > [Personal address book] Database error: syntax error > > I've setup the MySQL DB's and verified I can login / search with the > credentials used. The settings in the "SquirrelMail Configuration" > have also been checked. > > Anyhelp would be greatly appreciated. > > Thanks - Julian. > > Julian Grunnell > 3rd Line Technical Support > PIPEX > > Telephone: 0113 302 1005 > Mobile: 07803 649593 > Website: http://www.pipex.net > > > > ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 -- squirrelmail-users mailing list Posting Guidelines: http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines List Address: [email protected] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 -- squirrelmail-users mailing list Posting Guidelines: http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines List Address: [email protected] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
