Ticket #3093 (closed defect: worksforme)
Error PgDBEngine.pm
| Reported by: | tim@… | Owned by: | jamor@… |
|---|---|---|---|
| Milestone: | 2.0.X | Component: | base |
| Severity: | normal | Keywords: | |
| Cc: |
Description
I am found this error message in the ebox.log file I am running Zentyal 2.0.22 x64 version as well as getting an email to the root user once an hour.
2011/08/02 21:17:02 ERROR> PgDBEngine.pm:440 EBox::PgDBEngine::do - Error doing statement: UPDATE mailfilter_smtp_traffic_hourly SET mta-blocked = mta-blocked + 1 WHERE (date = '2011-08-02 21:00:00') , ERROR: syntax error at or near "-" LINE 1: UPDATE mailfilter_smtp_traffic_hourly SET mta-blocked = mta-...
Attachments
Change History
comment:1 Changed 21 months ago by jacalvo@…
- Owner changed from jacalvo@… to jamor@…
- Milestone set to 2.0.X
comment:2 Changed 21 months ago by jamor@…
- Status changed from new to closed
- Resolution set to worksforme
Thanks a lot for your report, Tim.
I think the error is fixed in the 2.1 series but to make sure I would need a dump of your mailfilter logs.
To get it, execute this commands:
sudo -s su postgres -c'pg_dump -f /tmp/pg.out eboxlogs'
Send me the file /tmp/pg.,out to jamor AT zentyal.com . Be aware that in the database dump there will be data such mail connections that maybe you do not want to share.
Thanks for your help
