[Asterisk-Users] Re: [Astguiclient-users] [PATCH][RFC] Quiet debugging messages in Net::MySQL Perl module

[Mike Fedyk]

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 at mikefedyk.com]
>Sent: Saturday, December 17, 2005 3:45 AM
>To: mattf
>Cc: astguiclient-users at 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 at lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/astguiclient-users
>
>  
>