clsql-mysql problem with join

--===============1415468134==
Content-Type: multipart/alternative; boundary=001a113ce2b0373822050aa442fc

--001a113ce2b0373822050aa442fc
Content-Type: text/plain; charset=UTF-8

Hi,

the second point of your post helped thanks, I had to modify 2 Makefiles.

I have another problem with clsql: when querying an object (user) with a
one-to-many join

(jobs :reader user-jobs :db-kind :join :db-info (:join-class job
    :home-key id
    :foreign-key user-id
    :set t))

the slot sometimes returns all 4 job objects sometimes only 2 randomly.
What could this be?

Chris


On Sat, Dec 20, 2014 at 8:04 AM, Jussi Lahdenniemi <[email protected]> wrote:

> Hello,
>
> > using the most recent quicklisp version of clsql on sbcl 1.2.0 on ubuntu
> > 14.04 with the corresponding mysql and libmysqlclient-dev definitely
> > installed I receive this error upon loading clsql-mysql:
> >
> > OPERATION-ERROR while invoking #<COMPILE-OP > on
> > #<CLSQL-MYSQL-SOURCE-FILE "clsql-mysql" "db-mysql" "clsql_mysql">
>
> About a month ago I listed in my answer at Stackoverflow
> (
> http://stackoverflow.com/questions/27123292/installing-clsql-sqlite3-using-sbcl-quicklisp
> )
> the three issues I have faced when installing clsql on different
> systems. Maybe one of these covers your situation as well?
>
> --
> Jussi Lahdenniemi
> _______________________________________________
> CLSQL mailing list
> [email protected]
> http://lists.b9.com/cgi-bin/mailman/listinfo/clsql
>

--001a113ce2b0373822050aa442fc
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>the second point of your post helpe=
d thanks, I had to modify 2 Makefiles.</div><div><br></div><div>I have anot=
her problem with clsql: when querying an object (user) with a one-to-many j=
oin</div><div><br></div><div><div>(jobs :reader user-jobs :db-kind :join :d=
b-info (:join-class job</div><div><span class=3D"" style=3D"white-space:pre=
">						</span> =C2=A0 =C2=A0:home-key id</div><div><span class=3D"" style=
=3D"white-space:pre">						</span> =C2=A0 =C2=A0:foreign-key user-id</div><=
div><span class=3D"" style=3D"white-space:pre">						</span> =C2=A0 =C2=A0:=
set t))</div></div><div><br></div><div>the slot sometimes returns all 4 job=
 objects sometimes only 2 randomly. What could this be?</div><div><br></div=
><div>Chris</div><div><br></div><div class=3D"gmail_extra"><br><div class=
=3D"gmail_quote">On Sat, Dec 20, 2014 at 8:04 AM, Jussi Lahdenniemi <span d=
ir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=3D"_blank">jlahd@iki.=
fi</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<span class=3D""><br>
&gt; using the most recent quicklisp version of clsql on sbcl 1.2.0 on ubun=
tu<br>
&gt; 14.04 with the corresponding mysql and libmysqlclient-dev definitely<b=
r>
&gt; installed I receive this error upon loading clsql-mysql:<br>
&gt;<br>
&gt; OPERATION-ERROR while invoking #&lt;COMPILE-OP &gt; on<br>
&gt; #&lt;CLSQL-MYSQL-SOURCE-FILE &quot;clsql-mysql&quot; &quot;db-mysql&qu=
ot; &quot;clsql_mysql&quot;&gt;<br>
<br>
</span>About a month ago I listed in my answer at Stackoverflow<br>
(<a href=3D"http://stackoverflow.com/questions/27123292/installing-clsql-sq=
lite3-using-sbcl-quicklisp" target=3D"_blank">http://stackoverflow.com/ques=
tions/27123292/installing-clsql-sqlite3-using-sbcl-quicklisp</a>)<br>
the three issues I have faced when installing clsql on different<br>
systems. Maybe one of these covers your situation as well?<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
--<br>
Jussi Lahdenniemi<br>
</font></span><div class=3D"HOEnZb"><div class=3D"h5">_____________________=
__________________________<br>
CLSQL mailing list<br>
<a href=3D"mailto:[email protected]">[email protected]</a><br>
<a href=3D"http://lists.b9.com/cgi-bin/mailman/listinfo/clsql" target=3D"_b=
lank">http://lists.b9.com/cgi-bin/mailman/listinfo/clsql</a><br>
</div></div></blockquote></div><br></div></div>

--001a113ce2b0373822050aa442fc--

--===============1415468134==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql

--===============1415468134==--