[asterisk-bugs] [Asterisk 0017557]: [patch] voicemail_odbc_postgresql step 11 typo

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17557 
====================================================================== 
Reported By:                cmaj
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17557
Category:                   Documentation
Reproducibility:            N/A
Severity:                   text
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.9 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-06-25 12:52 CDT
Last Modified:              2010-06-25 15:01 CDT
====================================================================== 
Summary:                    [patch] voicemail_odbc_postgresql step 11 typo
Description: 
Example sanity check query looks for undefined column "id" -- should be
"callerid".

Please change this:

[jsmith2 at localhost ODBC]$ echo "SELECT id, msgnum, dir, duration FROM
voicemessages WHERE msgnum = 1" | isql testing

To this:

[jsmith2 at localhost ODBC]$ echo "SELECT callerid, msgnum, dir, duration
FROM voicemessages WHERE msgnum = 1" | isql testing

Thank you!
====================================================================== 

---------------------------------------------------------------------- 
 (0123909) cmaj (reporter) - 2010-06-25 15:01
 https://issues.asterisk.org/view.php?id=17557#c123909 
---------------------------------------------------------------------- 
Patch attached.

"voicemail" table has no "id" column so SELECT fails on non-existent
column.

Problem exists in 1.6.0.28 as well. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-06-25 15:01 cmaj           Note Added: 0123909                          
======================================================================