Mike Fedyk
2005-Dec-17 08:44 UTC
[Asterisk-Users] Re: [Astguiclient-users] [PATCH][RFC] Quiet debugging messages in Net::MySQL Perl module
That TINYINT is probably the culprit then since the message is "in short". That code is converting the number to a 16bit short value. Are there any other perl scripts that modify tables with TINYINTs in them? From looking at the module, it doesn't look like it is reporting an error, but just outputting when doing the number conversion (going to 16bit can be lossy). Do we really have an issue here besides quieting the debug message? Mike mattf wrote:>Hello, > >No, alphamuneric is not strange, we have letters and numbers in ours and >I've never had an issue with it. > >There is one TINYINT field for dial_timeout, other than that it's all >VARCHARs and ENUMs. > >MATT-- > >-----Original Message----- >From: Mike Fedyk [mailto:mfedyk@mikefedyk.com] >Sent: Saturday, December 17, 2005 3:45 AM >To: mattf >Cc: astguiclient-users@lists.sourceforge.net >Subject: Re: [Astguiclient-users] [PATCH][RFC] Quiet debugging messages >in Net::MySQL Perl module > > >mattf wrote: > > >>looks like this is the statement that causing problems: >>SELECT * from vicidial_campaigns where active='Y' or >>SELECT * from vicidial_campaigns where campaign_id='$CLIcampaign' >> >>I have no idea how that would return an error, What are your campaign >> >> >names? > > >>do you have any strange character in them? >> >> >> >Is [a-zA-Z0-9] strange? > >I suspect it is converting data for numerical fields. Are there any INT >fields in that table? > >I did a google for that error, but nobody has debugged it. > >Mike > > >------------------------------------------------------- >This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >for problems? Stop! Download the new AJAX search engine that makes >searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click >_______________________________________________ >Astguiclient-users mailing list >Astguiclient-users@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/astguiclient-users > > >