[Devel] Usrloc / truncated SQL query

Günther Starnberger gst at sysfrog.org
Wed Jun 22 18:26:43 CEST 2005


On Wed, 2005-06-22 at 19:01 +0300, Bogdan-Andrei Iancu wrote:

Hello,

> indeed, the field was shorter than the advertised lenght (len) and some 
> zero padding was included. What's really interested is that the mysql 
> driver was not affected at all by this issue and work perfectly :).
> 
> the fix is on CVS. Please let me know if it's OK know.

I checked out CVS (HEAD), but i still get the same error :/

In my first mail i wrote that the 'domain' field may contain a null
value. This seems to be wrong - the quote and the comma after the value
of the 'socket' field in the log message isn't in the sql query but only
in the log msg - it does close the quoting of the log msg which starts
before the 'insert'.

So the truncation may already happen at the end of the 'socket' field.
The query ends with: 'Sipura/SPA841-3.1.2(d)',NULL,'yy.yy.yy.yy_5060

cu
/gst

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://openser.org/pipermail/devel/attachments/20050622/47001570/attachment.pgp


More information about the Devel mailing list