Paul,
There's something not right with the mysql create tables script, on this
view:
CREATE VIEW dbmail_fromfield AS
SELECT physmessage_id,sortfield AS fromfield
FROM dbmail_messages m
JOIN dbmail_header h USING (physmessage_id)
JOIN dbmail_headername n ON h.headername_id = n.id
JOIN dbmail_headervalue v ON h.headervalue_id = v.id
WHERE n.headername='from';
ERROR 1146 (42S02) at line 177: Table 'dbmail.dbmail_messages' doesn't exist
---
>From what I see in the file, this dbmail_message table is only created after
the views.
A possible fix is to insert the view's creation on the end of the file.
Jorge,
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev