Wait a minute! If you don't have a messageblks table, just do *NOT* run dbmail-util -M
-M is meant to migrate content from messageblks to mimeparts. Not relevant in your case. On 21-01-14 16:14, Paul J Stevens wrote: > 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: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] 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/i...@nfg.nl/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
