Revert r334472 due to properties going missing
authorGregory Nietsky <gregory@distrotech.co.za>
Tue, 6 Sep 2011 16:04:02 +0000 (16:04 +0000)
committerGregory Nietsky <gregory@distrotech.co.za>
Tue, 6 Sep 2011 16:04:02 +0000 (16:04 +0000)
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@334515 65c4cc65-6c06-0410-ace0-fbb531ad65f3

apps/app_voicemail.c

index d89d581..eec7d7f 100644 (file)
@@ -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) {