On Fri, 5 Jan 2007 21:55:13 +0900 (JST)
中村 充宏 <mets_type_f yahoo.co.jp> wrote:
>
> SELECT GROUP_CONCAT(resource.id ORDER BY
resource.modification_time DESC) INTO out_ress_w_item FROM
resource JOIN item_resource ON
resource.id=item_resource.id_resource JOIN item ON
item_resource.id_item=item.id WHERE resource.lang='fr' AND
item.id IN (1,) AND resource.audience='KIN'
>
> DB Error: syntax error
>
I would say the bug is on " item.id IN (1,)"
because the final "," is
wrong
This comes from a strange behaviour I noticed in MySQL. As I
had not
enough time to dig out the problem or ask questions to
lists, I have
addressed the bug among my recent fixes (see function
DBGetOne).
So please tell me if you have downloaded the most recent
files
(gnuedu.php version 1.290), so we can know what your bug
actually means!
Regards,
--
Odile Bénassy, OFSET
http://www.ofset.org
http://www.ofset.org/gnue
du
|