summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGregory Nietsky <gregory@distrotech.co.za>2011-09-06 16:04:02 +0000
committerGregory Nietsky <gregory@distrotech.co.za>2011-09-06 16:04:02 +0000
commit8a8baa19344262a58467f7d5402dc6d5dc07c47f (patch)
tree652f71093d337841ac2c6ac63274b815ec402f2a
parent4435439eda8ff97d68086a2dd4d5d3eac0b6e0fd (diff)
Revert r334472 due to properties going missing
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@334515 65c4cc65-6c06-0410-ace0-fbb531ad65f3
-rw-r--r--apps/app_voicemail.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/apps/app_voicemail.c b/apps/app_voicemail.c
index d89d581fd..eec7d7f71 100644
--- a/apps/app_voicemail.c
+++ b/apps/app_voicemail.c
@@ -3483,7 +3483,7 @@ static int last_message_index(struct ast_vm_user *vmu, char *dir)
struct odbc_obj *obj;
obj = ast_odbc_request_obj(odbc_database, 0);
if (obj) {
- snprintf(sql, sizeof(sql), "SELECT msgnum FROM %s WHERE dir=? order by msgnum desc", odbc_table);
+ snprintf(sql, sizeof(sql), "SELECT msgnum FROM %s WHERE dir=? order by msgnum desc limit 1", odbc_table);
stmt = ast_odbc_prepare_and_execute(obj, generic_prepare, &gps);
if (!stmt) {