[asterisk-bugs] [Asterisk 0018288]: Error when storing queue_log data in RT - "column 'time' cannot be type 'int(10) unsigned'"

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18288 
====================================================================== 
Reported By:                trymes
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18288
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.13 
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-11-10 10:33 CST
Last Modified:              2010-11-10 15:06 CST
====================================================================== 
Summary:                    Error when storing queue_log data in RT - "column
'time' cannot be type 'int(10) unsigned'"
Description: 
I have followed the instructions available here:
https://issues.asterisk.org/view.php?id=11625 to setup my queue_log to
write to the realtime database on an elastix 2.0/Centos 5 system. 

Upon reloading asterisk, I receive this error:

WARNING[9853] res_config_mysql.c: Realtime table general at queue_log: column
'time' cannot be type 'int(10) unsigned' (need char)

I have not found anything in the bug tracker or elsewhere to indicate that
the structure of the table has changed and that the original instructions
linked above are now invalid. Having said that, I did find this:
https://issues.asterisk.org/view.php?id=17082 , which indicates that
modifications have been made to realtime queue_log behavior for Asterisk
1.8, though I have not found any reason to believe that those changes
should be affecting the table structure for my 1.6.2.13 version of
Asterisk.
====================================================================== 

---------------------------------------------------------------------- 
 (0128754) trymes (reporter) - 2010-11-10 15:06
 https://issues.asterisk.org/view.php?id=18288#c128754 
---------------------------------------------------------------------- 
My apologies. I do understand that the issue report is not documentation,
but information about this is thin on the ground, other than sites that
reference the issue report. More specifically, I have downloaded the 1.6.13
source tarball and I cannot find the queue_log.sql file you mention.

[root at vox mysql]# pwd
/usr/src/asterisk-1.6.2.13/contrib/realtime/mysql
[root at vox mysql]# ls
iaxfriends.sql  meetme.sql  musiconhold.sql  sipfriends.sql  voicemail.sql 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-11-10 15:06 trymes         Note Added: 0128754                          
======================================================================