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 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
