[Home]

Summary:ASTERISK-02167: cdr_sqlite.so fail to create cdr.db+table
Reporter:master (master)Labels:
Date Opened:2004-08-01 05:07:34Date Closed:2008-01-15 15:04:19.000-0600
Priority:MinorRegression?No
Status:Closed/CompleteComponents:CDR/cdr_sqlite
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:cdr_sqlite.so failes to create cdr.db+table 08/01/04 cvs version. Works fine with 07/28/04 cvs version.

[cdr_sqlite.so] => (SQLite CDR Backend)
Aug  1 19:39:41 ERROR[16384]: cdr_sqlite.c:178 load_module: cdr_sqlite: Unable to create table 'cdr': near ")": syntax error
Aug  1 19:39:41 WARNING[16384]: loader.c:328 ast_load_resource: cdr_sqlite.so: load_module failed, returning -1
 == Unregistered 'sqlite' CDR backend
Aug  1 19:39:41 WARNING[16384]: loader.c:423 load_modules: Loading module cdr_sqlite.so failed!
Comments:By: twisted (twisted) 2004-08-01 05:22:43

I'm going to ask that you doublecheck your sqlite configuration, as the code for cdr_sqlite.c hasn't changed since 7/18/04.

By: master (master) 2004-08-01 06:01:40

When I change
#define LOG_UNIQUEID    0  (default)
to
#define LOG_UNIQUEID    1
in cdr_sqlite.c, this error occurs.

By: Brian West (bkw918) 2004-08-01 12:49:49

You might wanna also fix the bug where it stops logging after reload :P

bkw

By: Mark Spencer (markster) 2004-08-01 14:42:12

Fixed in CVS head

By: Digium Subversion (svnbot) 2008-01-15 15:04:19.000-0600

Repository: asterisk
Revision: 3563

U   trunk/cdr/cdr_sqlite.c

------------------------------------------------------------------------
r3563 | markster | 2008-01-15 15:04:19 -0600 (Tue, 15 Jan 2008) | 2 lines

Fix double comma typo in sql_create_table (bug ASTERISK-2167)

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=3563