Jorge, Peter, I don't believe there's a problem with the query.
Peter, try connection to the remove database using the mysql client (mysql -h somehost...) and run the query mentioned below. That way you will evade any dbmail issues. My guess is this is a libmysqlclient versioning issue. Jorge Bastos wrote: > > > H i peter , > >> [1] http://www.dbmail.o rg/mantis/view.php?id=824 > <http://www.dbmail.org/mantis/view.php?id=824> > > I ' m with a bit of time today, and I saw: > > Dec 25 20:38:57 Arzamas postfix/pipe[8407]: 4DACB17077F: to=<sales@< > redacted>.net>, relay=dbmail-pipe, delay=18432, > delays=18432/0.12/0/0.16, dsn=4.3.0, status=deferred (temporary failure. > Command output: Dec 25 * ** 20:38:57 Arzamas dbmail-smtp[8411]: > Error:[sql] dbmysql.c,db_query(+290): [You have an error in your SQL > syntax; check the manual that corresponds to your MySQL server version > for the right syntax to use near '' at line 1] * [SELECT physmessage_id > FROM dbmail_messages WHERE message_idnr = 3812926] Dec 25 20:38:57 > Arzamas dbmail-smtp[8411]: Error:[db] db.c,db_get_physm essage_id(+341): > error getting physmessage_id Dec 25 20:38:57 Arzamas dbmail-smtp[8411]: > Error:[delivery] pipe.c,insert_messages(+545): failed to store temporary > message. Dec 25 20:38:57 Arzamas dbmail-smtp[8411]: Error:[smtp] > main.c,main(+343): insert_me s sages failed Dec 25 20:38:57 Arzamas > dbmail-smtp[8411]: Warning:[smtp] main.c,main(+391): exit code [75] > because something went wrong; turn up trace level for more detail ) > > A nd I see a query failing. > > I see the version 2.2.11 on the tracker, can you update to the latest > 2.2x version? I think I hit that query failin g when I used 2.2x also, > but if it is what I ’ m thinking, it was solved long time ago. > > I f possible update DBMail and tell us the feedb ack. > > J orge, > > > ------------------------------------------------------------------------ > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
