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

Reply via email to