SquirrelMail 1.4.4 configtest.php does not check if table exists. Script checks libraries and performs only db connect test.
I think, there are only two possible error causes. Invalid table structure and invalid table name set in conf.pl -> 9. Database -> 2. Table for Address Book. If your user does not have select privilege on table, error message should show 'unknown error' message. > 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
