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
