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

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to