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:[EMAIL PROTECTED] > 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 > [email protected] > http://lists.digium.com/mailman/listinfo/aster> isk-users > To > UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
