[Asterisk-Users] CallerID name lookup AGI script

[Jay Milk]

Wrong version of mysql.  Run this instead:

CREATE TABLE `callerid` (
  `cid_id` int(11) NOT NULL auto_increment,
  `cid_number` varchar(50) NOT NULL default '',
  `cid_name` varchar(50) default NULL,
  `display_name` varchar(50) default NULL,
  `address` varchar(100) NOT NULL default '',
  `cid_source` char(1) NOT NULL default 'I',
  PRIMARY KEY  (`cid_id`),
  KEY `cid_number` (`cid_number`)
) TYPE=MyISAM;

> -----Original Message-----
> From: Nabeel Jafferali [mailto:asterisk-lists at x2n.ca] 
> Sent: Monday, May 09, 2005 3:48 PM
> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> Subject: RE: [Asterisk-Users] CallerID name lookup AGI script
> 
> 
> > Mine does business lookups properly, and also uses a mySQL 
> database to 
> > cache results (and allows you to store your own results):
> > 
> > http://www.muware.com/asterisk/
> 
> I run the SQL-query in your readme file and get the following:
> 
> You have an error in your SQL syntax near 'collate 
> utf8_unicode_ci NOT NULL default '',
>   `cid_name` varchar(50) collate u' at line 3
> 
> I have no experience with mySQL. Any idea what that means?
> 
> --
> Nabeel Jafferali
> X2 Networks
> www.x2n.ca
> T: 1.647.722.6900
>    1.877.VOIP.X2N
> F: 1.866.655.6698
> FWD: 46990
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com 
> http://lists.digium.com/mailman/listinfo/aster> isk-users
> To 
> UNSUBSCRIBE or update options visit:
>    
http://lists.digium.com/mailman/listinfo/asterisk-users