Re:[Phpgroupware-users] mail issue... help?

[Chris Weiss]

the phpgw_anglemail table isn't a required table.  The email app will make use 
of it
if it's there and won't if it's not.  You can install the table in setup by
upgrading the email app, but this will only work if you don't have a backup 
email
dir like email.old that falls in front of the live email dir in the directory
order... assuming you have a new enough version of anglemail that includes the 
table...

btw, Angles has figured out the problem with the @'s in cache and will have a 
fix in
the next release availble from http://anglemail.org/ .  You can sign up for the 
mail
list there to get the release anouncement as well as other "leading edge" email 
app
developments.

River Hume, HHP (address@hidden) wrote:
>
>
>>I've seen similar problems and they always are solved by clearing all the
>>entries
>>for the user having problems (in your case all of the users) in the table
>>phpgw_anglemail
>
>I don't see any such table in our database... The closest thing I see is
>phpgw_felamimail_cache, but not one for anglemail, or email, or any other
>*mail I can see just trying to squint at the table list.
>
>Could THIS be our problem? how could a table just vanish tho? is that table
>even used in the current version?
>
>-River
>
>>This table is a the anglemail cache system to make the email app run faster
>>but
>>seems to experience problems occasionally.  I've seen it not report emails
>>properly
>>and prevent changes to the email config or user prefs for email from being
>>saved
>>properly.
>>
>>Since it's just a cache, all records will be recreated next time email is
>>run, so
>>you could wipe out the entire table and only experience some slow down on
>>the next
>>email run (for each user).
>>
>>
>>address@hidden wrote:
>> >
>> >Hello,
>> >
>> >We are experiencing a strange issue with the email app:
>> >
>> >First a wee bit o' background...
>> >
>> >We had .14 running (older release) and the server it was on died. We moved
>> >
>> >everything to a new machine running a diff IMAP (Uwash) and even after
>> >changing the admin (and tried the custom cfg too) settings for email we're
>> >
>> >not getting actual mailspools to come up in the inboxes, but rather 30
>> >copies of a non-existant email from '@' with 'No Subject'. - In fact ALL
>> >
>> >mailboxes seem to be empty in phpgw email (even though they're deffinately
>> >
>> >not) - ie: the 'Trash' folder
>> >
>> >Ive been twiddling all the email settings to no avail - and felamimail just
>> >
>> >gives me:
>> >Database error: Invalid SQL: select filter from
>> >phpgw_felamimail_displayfilter where accountid='6'
>> >MySQL Error: 1146 (Table
>> >'pacificwatershed_groupware.phpgw_felamimail_displayfilter' doesn't exist)
>> >
>> >(note - felamimail never werked b4, I just tried it to see what would
>> >happen - yes I configured it in the Admin tool)
>> >
>> >IMAP works fine - proof positive: we've got squirrelmail up and running
>> >smooth.
>> >
>> >I updated to the current release, ran setupIII and all seemed well, but
>> >the
>> >problem persists. The only slight possibility I can think of is possible
>> >db
>> >corruption, as we were unable to get an SQL dump b4 the server died; we
>> >had
>> >to just move the datafile. I can't seem to find a table in the db that even
>> >
>> >deals with email settings (except for felamimail) to try and verify this
>> >
>> >hypothesis. Is there a particular table I should look at? Is this even a
>> >
>> >possibility?
>> >
>> >We're all at a loss at this point. Has anyone else seen  a similar error?
>> >
>> >Any suggestions for a direction to investigate?
>> >
>> >Please CC the following addresses on any replies, as I will be away most
>> >of
>> >the weekend, but my team will be around:
>> >address@hidden
>> >address@hidden
>> >address@hidden
>> >
>> >Thanx In Advance!!!
>> >
>> >
>> >---------------------------------
>> >- Woont u in Antwerpen? Nog geen @antwerpen.be email adres?
>> >  Schrijf u gratis in op http://registratie.antwerpen.be
>> >
>> >
>> >
>> >
>> >
>> >
>> >_______________________________________________
>> >Phpgroupware-users mailing list
>> >address@hidden
>> >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>> >
>>
>>--

>>Brian Johnson
>>* This is where my witty signature line would be if I bothered to edit this
>>line :) *
>>
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>