Re: UPDATE problems

Alle 16:12, mercoledì 9 febbraio 2005, [email protected] ha scritto:
> Hi
>
>
> In my script when I use the command: UPDATE , bayonne crash.


Hi this is a well known problem of Bayonne

see the Mysql-HowTo http://www.gnu.org/software/bayonne/howto/mysql-howto.pdf
for a patch

the problem is definitly solved with bayonne 1.2.13 and the new commoncpp

bye

Luca



>
> I have this message :
>
>
> trace: pid=12298 reason=11
> trace(0):
> /usr/lib/bayonne/1.2.11/bayonne.bin(stackTrace__Q23ost5Debugi+0x2f)
> [0x807a3eb] trace(1): /usr/lib/bayonne/1.2.11/trace.dbg [0x400156ad]
> trace(2): /lib/i686/libpthread.so.0 [0x401f6f75]
> trace(3): /usr/lib/bayonne/1.2.11/bayonne.bin [0x42029098]
> trace(4): /usr/lib/bayonne/1.2.11/bayonne.bin(_IO_vfprintf+0x1099)
> [0x42051349] trace(5): /usr/lib/bayonne/1.2.11/bayonne.bin(vsprintf+0x5f)
> [0x4206dbf3] trace(6): /usr/lib/bayonne/1.2.11/bayonne.bin(sprintf+0x23)
> [0x4205a257] trace(7):
> /usr/lib/bayonne//1.2.11//mysql.sql(loader__Q23ost10MySQLTrunkPQ23ost5Trunk
>PQ23ost11trunkdata_t+0x2d5) [0x40027011] trace(8):
> /usr/lib/bayonne/1.2.11/bayonne.bin(run__Q23ost10XMLService+0xe1)
> [0x807d9f1] trace(9): /usr/lib/libccgnu2-1.0.so.0 [0x400af132]
> trace(10): /lib/i686/libpthread.so.0 [0x401f3fef]
> trace(11): /usr/lib/bayonne/1.2.11/bayonne.bin(__clone+0x3a) [0x420e779a]
> driver stopping...
>
> There is my script:
> ::lect
>
> clear %id
>         sql {SELECT id,msgdir FROM message where nouveau=1 AND tel=}%tel
> fordata #sql %id %msgdir
> loop
>
> play %msgdir
>
> play mevo:menumess.wav
>
> sleep 10
> return.exit       statusi="timeout"
>
> ^1
>         goto ::lect
>
> ^2
> set  "UPDATE message SET nouveau=0 WHERE id="%id
>         goto ::lect
>
> ^3
>         goto ::fin
>
> If you have a comment or if you can tell where is the error.
>
> Thank
>
> Marc
>
> Red-hat 7.3 (2.4.18-3), Bayonne 1.2.11, ccscript 2.2.1
>
>
>
>
>
>
> _______________________________________________
> Bayonne-devel mailing list
> [email protected]
> http://lists.gnu.org/mailman/listinfo/bayonne-devel

-- 
Luca Bariani
Software developer
Wireless Solutions SpA (DADA Group)
[email protected]
http://www.wseurope.com
Tel: +39.051.2966813