Re: mysql 5.x error: Unknown column 'c.id_case' in 'on clause'

Thanks for your information and your attention.

I have solved "downgrading" (clearing mysql 5 and putting mysql 4) and
goes perfect. In any case I will consider your recommendations and I
will prove LCM version 0.7

As far as the rest of your message, I am using LCM to manage subjects
not strictly legal. Already for a long time I have been knowing your
program and I have followed close by its evolution.

I have analyzed other approaches to the management of legal files with
free software like Kumula or with specific modules, for example,
vtiger or other systems of groupware or CRM. What it inclines to me
towards your program is the simplicity of the approach that you are
doing which is oriented directly to the main problem without greater
difficulty.

Personally, I believe that it needs some important functionalities and
that it must have more flexibility. It is not a critic, but an
opinion.

Very I am implied in the support that my regional government is
contributing to Free Software and, if the people in charge of the
project ready stays to come to Andalusia and Extremadura, I am at
readiness to promote that these regional governments invite to you to
come to contrast what is basic for your project needs and as they
would be the requirements so that it can be used, in general, by the
Spanish lawyers.

A good moment for your visit can be III the Open Source Wordl
Conference that will be celebrated in Badajoz (Extremadura, Spain) the
next month of February.

I'll waiting for your news in this respect. If it is not competition
yours, I request you that you transmit east offer to the people in
charge of project LCM.


2006/11/10, Mathieu Lutfy <mathieu-jgIWuTNmrII@xxxxxxxxxxxxxxxx>:
> Hello,
>
> Thank you for the bug report. Recent MySQL versions have indeed caused
> a few problems and we are getting many reports these days.
>
> I must mention that I personally don't use LCM 0.6.x any more (or at least
> I don't upgrade installations using it), so I don't know how many similar
> SQL problems it may have. I develop/test exclusively with LCM 0.7.x.
>
> Find attached a new "listcases.php", to overwrite the existing one.
> It backports a fix from LCM 0.7.x, tested on MySQL 5.0.26-2. Please
> report whether it works or not.
>
> If you are a new LCM user, I highly suggest that you start with the latest
> 0.7.x release, even if it is a development branch. We won't make any
> more drastic changes at this point, and it fixes many SQL issues.
>
> I also recommend to subsribe to our "announcements" mailing-list, and
> to upgrade to LCM 0.7.2 when it is released.
> https://lists.sourceforge.net/lists/listinfo/legalcase-news
>
> Please do not forget to make a backup of your database before upgrading it.
>
> Finally, if you have any comments on the Spanish translation, or on the
> software in general, please do not hesitate to write to this list!
>
> Regards,
> Mathieu
>
> Le 2006-11-08, à 05:49:59 +0100, Jesús Martín 
> (erbrujo-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx) écrit:
> > With mysql 4.x run perfectly, but with mysql 5.0 don't work search cases.
> >
> > http://bugs.mysql.com/bug.php?id=12943
> >   a critical priority bug - it definitely
> >   should be fixed before the next release.
> >   A patch for this bug has been committed
> > http://lists.mysql.com/internals/29598
> >  The problem was that in the first production in rule 'join_table'
> >
> > ??
> >
> > I are probed with Ubuntu Dapper, Mandriva 2007 and Fedora Core 6, and
> > this is the message:
> >
> > [INTERNAL] (v0.642-db42, PHP v5.1.6)
> > Server: Apache/2.2.3 (Mandriva Linux/PREFORK-1mdv2007.0)
> > SQL server: MySQL 5.0.24a-log
> > Referer: http://localhost/legalcase/listcases.php
> > Request: GET /legalcase/listcases.php?find_case_string=a&submit=Buscar
> > Error: Error de la base de datos SQL.
> >
> > SELECT DISTINCT c.id_case, title, status, public, pub_write, date_creation
> >               FROM lcm_case as c, lcm_case_author as a  LEFT JOIN 
> > lcm_keyword_case
> > as kc ON kc.id_case = c.id_case  WHERE (c.id_case = a.id_case  AND (
> > kc.value LIKE '%a%' OR  c.title LIKE '%a%'  )) AND  (a.id_author = 2 )
> >  AND TO_DAYS(NOW()) - TO_DAYS(date_creation) < 91 ORDER BY
> > date_creation DESC
> >
> > « Unknown column 'c.id_case' in 'on clause' »
> >
> >
> >
> >       lcm_panic("Error de la base de datos SQL.<br />
> > SELECT DISTINCT c.id_case, title, status, public, pub_write, date_creation
> >               FROM lcm_case as c, lcm_case_author as a  LEFT JOIN 
> > lcm_keyword_case
> > as kc ON kc.id_case = c.id_case  WHERE (c.id_case = a.id_case  AND (
> > kc.value LIKE '%a%' OR  c.title LIKE '%a%'  )) AND  (a.id_author = 2 )
> >  AND TO_DAYS(NOW()) - TO_DAYS(date_creation) &lt; 91 ORDER BY
> > date_creation DESC<br />
> > &laquo; Unknown column 'c.id_case' in 'on clause' &raquo;<br />") #
> > line  108, file: /var/www/legalcase/inc/inc_db_mysql.php
> >    lcm_query_db("SELECT DISTINCT c.id_case, title, status, public,
> > pub_write, date_creation
> >               FROM lcm_case as c, lcm_case_author as a  LEFT JOIN 
> > lcm_keyword_case
> > as kc ON kc.id_case = c.id_case  WHERE (c.id_case = a.id_case  AND (
> > kc.value LIKE '%a%' OR  c.title LIKE '%a%'  )) AND  (a.id_author = 2 )
> >  AND TO_DAYS(NOW()) - TO_DAYS(date_creation) < 91 ORDER BY
> > date_creation DESC", false) # line  419, file:
> > /var/www/legalcase/inc/inc_version.php
> > lcm_query("SELECT DISTINCT c.id_case, title, status, public,
> > pub_write, date_creation
> >               FROM lcm_case as c, lcm_case_author as a  LEFT JOIN 
> > lcm_keyword_case
> > as kc ON kc.id_case = c.id_case  WHERE (c.id_case = a.id_case  AND (
> > kc.value LIKE '%a%' OR  c.title LIKE '%a%'  )) AND  (a.id_author = 2 )
> >  AND TO_DAYS(NOW()) - TO_DAYS(date_creation) < 91 ORDER BY
> > date_creation DESC") # line  194, file:
> > /var/www/legalcase/listcases.php
> >
> >
> > --
> > Thanks,
> > Jesús Martín
> >
> > _______________________________________________
> > Legalcase-devel mailing list
> > Legalcase-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> > https://lists.sourceforge.net/lists/listinfo/legalcase-devel
>
> --
> Mathieu Lutfy        <mathieu-jgIWuTNmrII@xxxxxxxxxxxxxxxx>       
> http://www.bidon.ca
> GPG 0x5F5BCEB4 0D3B 1AEE EF9B FB34 2FE7  80EC 8E8D F00A 5F5B CEB4
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (GNU/Linux)
>
> iD8DBQFFU7fQjo3wCl9bzrQRAqKPAJ4whXaqJi6ebM7Vgi4MiB43ZbqM4wCdEMrp
> JofC3vvlwWGcBTn2HeO76Jw=
> =xMzJ
> -----END PGP SIGNATURE-----
>
>
>
>


-- 
Saludos,
Jesús Martín

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV