1 Topic by losinggeneration

  • losinggeneration
  • Member
  • Offline
  • Registered: 2012-04-24
  • Posts: 3

Topic: SQL syntax bugs

==== Provide required information to help troubleshoot and get quick answer ====
- iRedMail version:
- Linux/BSD distribution name and version:
- Any related log? Log is helpful for troubleshooting.
==== ==== Provide required information to help troubleshoot and get quick answer ====
- DBMailAdmin version: 1.1.0
- Linux/BSD distribution name and version: CentOS 6
====

Fixes a table name left off the dbmail_ prefix and a stray comma after a WHERE clause.

Additionally it should be pointed out that dbmail_ does not have to be the table prefix as DBMail (at least 3.0) allows the table_prefix to be specified. This may cause users who specify a different table prefix issues.

Post's attachments

DBMailAdmin-MySQL-1.1.0-domain_sql_fix.patch 1.51 kb, 1 downloads since 2012-04-24 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: SQL syntax bugs

Committed, thanks very much for your report and patch. smile
https://bitbucket.org/zhb/dbmailadmin/c … 6c6eaf5a9d

P.S. There're several fixes after i announced v1.1.0 in DBMail mailing list, it turns out it was not well tested. I'm so sorry about this. sad But i'm so glad that you guys found and patched it. smile