Salut,
j'ai cette erreur :
Unknown column 'memo_lieux.ref' in 'field list'
dans la requete suivante :
SELECT memo_adr.ref, 0+5*(((memo_lieux.ref IN (633)))) as points, memo_adr.org1
FROM memo_adr AS `memo_adr`
WHERE (((memo_lieux.ref IN (633))))
ORDER BY points DESC
Cetet requete est générée par la boucle :
<B_annuaire>
<div class="liste-articles">
#ANCRE_PAGINATION
<h2>Lieux de consultation (#TOTAL_BOUCLE résultats)</h2>
<ul>
<BOUCLE_annuaire(memo_adr) {recherche} {par points} {inverse} {pagination}>
<li>
<h3 class="titre"><a href="spip.php?page=lieu_detail&id=#REF&var_recherche=#ENV{recherche}">#ORG1</a></h3>
</li>
</BOUCLE_annuaire>
</ul>
[<p class="pagination">(#PAGINATION)</p>]
</div>
</B_annuaire>
Et la table est déclarée comme suit dans mes_options.php
$spip_memo_adr = array(
"ref" => "int(11) NOT NULL auto_increment",
"id" => "varchar(20) character set latin1 default NULL",
"org1" => "varchar(250) character set latin1 default NULL",
"org2" => "varchar(250) character set latin1 default NULL",
"org3" => "varchar(250) character set latin1 default NULL",
"l1" => "varchar(250) character set latin1 default NULL",
"l2" => "varchar(250) character set latin1 default NULL",
"cp" => "varchar(250) character set latin1 default NULL",
"ville" => "varchar(250) character set latin1 default NULL",
"pays" => "varchar(250) character set latin1 default NULL",
"tel" => "varchar(250) character set latin1 default NULL",
"fax" => "varchar(250) character set latin1 default NULL",
"email" => "varchar(250) character set latin1 default NULL",
"contact" => "varchar(250) character set latin1 default NULL");
$spip_memo_adr_key = array(
"PRIMARY KEY" => "ref");
$tables_principales['memo_adr'] = array(
'field' => &$spip_memo_adr,
'key' => &$spip_memo_adr_key);
qq1 aurait une idée svp ?
Chag
--
"Ca ne marche pas" ne veut rien dire. Alors ne dites rien
"it doesn't work" means nothing. So, say nothing