Re: (ITS#4061) [PATCH] back-sql - SQL syntax errors when removing

[ando@sys-net.it]

OK, that seems to only affect re22; I've fixed it as well.

Please test.

Thanks, p.


>
> Sorry,
>
> After all, I discovered I've sent you a correct but still
> incomplete patch...
> There's yet another missing space in schema-map.c (line 323).
>
> With what you have fixed (CVS rev 1.19.2.12) plus this other change
> (line 323, diff below), I'm running OK at least for this issue.
>
> Many thanks and sorry again for my lapse...
>
> ========================================================================
> --- schema-map.c.orig   2005-10-04 12:42:22.528037656 +0000
> +++ schema-map.c        2005-10-03 13:59:09.000000000 +0000
> @@ -320,7 +320,7 @@
>                  snprintf( tmp, sizeof(tmp),
>                          "DELETE FROM ldap_referrals "
>                          "WHERE entry_id=(SELECT id FROM ldap_entries "
> -                       "WHERE oc_map_id=%lu"
> +                       "WHERE oc_map_id=%lu "
>                          "AND keyval=?) and url=?",
>                          oc_map->bom_id );
>                  at_map->bam_delete_proc = ch_strdup( tmp );
> ===========================================
>
> Pierangelo Masarati escreveu:
>> Fixed in HEAD/re22; please test.
>>
>> Thanks for reporting, though.
>>
>> p.
>>
>>
>
>
> --
> ---------------------------------------------------------------------
> Marcio Scheibler
> UFSM - CPD - Divisao de Suporte
> =====================================================================
>


-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it


    SysNet - via Dossi,8 27100 Pavia Tel: +390382573859 Fax: +390382476497