It's a know bug. I wrote earlier:
Definitely a bug. Until it's fixed, just fetch the table DDL from somewhere and add it to the database. http://git.dbmail.eu/paul/dbmail/tree/sql/mysql/create_tables.mysql?h=dbmail_2_2#n158 On 21-01-14 15:39, Gray, Patrick wrote: > mysql> select distinct(physmessage_id) from dbmail_messageblks limit 10000; > ERROR 1146 (42S02): Table 'dbmail.dbmail_messageblks' doesn't exist > > So I got that... but I have no clue why dbmail_messageblks doesn't exist. > > Could it have been a problem with migration when I upgraded from > dbmail-3.0..2 to 3.1.7? I checked that .mysql file and it doesn't seem to > have anything in it concerning dbmail_messageblks. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Paul J Stevens > Sent: Saturday, January 18, 2014 10:27 AM > To: DBMail mailinglist > Subject: Re: [Dbmail] Dbmail-util functionality problems > > On 16-01-14 20:40, Gray, Patrick wrote: > >> Error:[db] db_query(+361): failed query [SELECT DISTINCT(physmessage_id) >> FROM dbmail_m essageblks LIMIT 10000] > > Again, try to replay above query - minus the spaces: > > > SELECT DISTINCT(physmessage_id) FROM dbmail_messageblks LIMIT 10000; > > and see if it gives you a decent error, if any. > -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, github, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/[email protected]/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
