[TYPO3-project-formidable] modify custom LISTER query

[Ivan Gomez Rodriguez]

Hi,

I got a similar error. When formidable builds the query puts all fields
 from table specificates in <tablename>, then you need put all fields
from that table in the SELECT which defines the view.

Regards,

Iván Gómez Rodríguez
Ingeniero en Informática
mailto:igomez at igalia.com
Igalia-http://www.igalia.com




Asbjørn Morell wrote:
> Hello,
> 
> That might be what I was looking for. Hmmm I get an error when I try to use 
> a compileddatasource:
> 
> caller t3lib_DB::sql_query
> 
> ERROR Unknown column 'plain.pid' in 'field list'
> 
> lastBuiltQuery SELECT SQL_CALC_FOUND_ROWS 
> plain.uid,plain.pid,plain.tstamp,plain.crdate,plain.cruser_id,plain.deleted,plain.hidden,plain.text,plain.price,plain.category,plain.image,plain.title
> FROM tx_myart_art467304d960658467304d96e1a9 AS compiled, 
> tx_myart_art467304d960658 AS plain
> WHERE
> 1 AND plain.uid = compiled.uid
> ORDER BY compiled.uid DESC
> 
> debug_backtrace require // include // TSpagegen::renderContent // 
> tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->COBJ_ARRAY 
> // tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CTABLE // 
> tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CONTENT // 
> tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // 
> tslib_cObj->CASEFUNC // tslib_cObj->cObjGetSingle // tslib_cObj->COBJ_ARRAY 
> // tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CASEFUNC 
> // tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // 
> tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // 
> tx_myart_pi1->main // tx_ameosformidable->render // 
> tx_ameosformidable->_render // tx_dhlister->_doTheMagic // 
> t3lib_DB->sql_query // t3lib_DB->debug
> 
> 
> Formidable : Mayday
> SQL QUERY IS NOT VALID
> Unknown column 'plain.pid' in 'field list'
> SELECT SQL_CALC_FOUND_ROWS 
> plain.uid,plain.pid,plain.tstamp,plain.crdate,plain.cruser_id,plain.deleted,plain.hidden,plain.text,plain.price,plain.category,plain.image,plain.title 
> FROM tx_myart_art467304d960658467304d96e1a9 AS compiled, 
> tx_myart_art467304d960658 AS plain WHERE 1 AND plain.uid = compiled.uid 
> ORDER BY compiled.uid DESC
> 
> 
> This is my LISTER:
>   <datahandler:LISTER>
> 
>    <tablename>tx_myart_art</tablename>
>    <keyname>uid</keyname>
>    <labelname>title</labelname>
> 
>         <compiledatasource>
>           <view>
>             <select><![CDATA[
> 
>           SELECT
>       tx_myart_art.uid AS uid,
>       tx_myart_art.cruser_id AS cruser_id,
>       tx_myart_art.title AS title,
>       tx_myart_art.category AS category,
>       tx_myart_images.title AS imgtitle,
>       fe_users.name as name
>     FROM
>       tx_myart_art
>       LEFT OUTER JOIN tx_myart_art_image_mm ON (tx_myart_art.uid = 
> tx_myart_art_image_mm.uid_local)
>       LEFT OUTER JOIN tx_myart_images ON (tx_myart_art_image_mm.uid_foreign 
> = tx_myart_images.uid)
>       LEFT OUTER JOIN fe_users ON (tx_myart_art.cruser_id = fe_users.uid)
>     GROUP BY
>       tx_myart_art.uid
> 
>             ]]></select>
>           </view>
>         </compiledatasource>
> 
> 
> 
> 
>    <pager>
>     <rows>
>      <perpage>10</perpage>
>      <alternate>###ROW1###</alternate>
>     </rows>
>     <nav>
>      <window>7</window>
>     </nav>
>    </pager>
> 
>    <callback>
>     <userobj>
>      <php><![CDATA[
> 
>       $aParams = func_get_args();
>       $this->_oParent->sHtmlList = $aParams[1]["HTML"];
> 
>      ]]></php>
>     </userobj>
>    </callback>
> 
> 
>   </datahandler:LISTER>
> 
> 
> Possible a bug?
> 
> Best regards.
> Asbjørn Morell.
> 
> 
> "Ivan Gomez Rodriguez" <igomez at igalia.com> wrote in message 
> news:mailman.327483.1181907021.21067.typo3-project-formidable at lists.netfielders.de...
>> Hello,
>>
>> You can try with compiledatasource.
>>
>> http://lists.netfielders.de/pipermail/typo3-project-formidable/2006-December/000162.html
>>
>>
>>
>> Asbjørn Morell wrote:
>>> Hello,
>>>
>>> I have a page that generates a search form and a lister from the same xml
>>> file. (sHtmlList) I have created a custom query for my lister, but now my
>>> search form does not work anymore. My custom query is executed each time 
>>> and
>>> all my input fields gets ignored. Also tried with <overridesql> and
>>> <onfields> . Any ideas?
>>>
>>> Best regards.
>>> Asbjørn Morell.
>>>
>>>
>>>    <search>
>>>     <sql>
>>>      <query>
>>>
>>>       <userobj>
>>>        <php><![CDATA[
>>>
>>>        return "
>>>
>>>        SELECT
>>>          tx_myart_art.uid,
>>>          tx_myart_art.cruser_id,
>>>          tx_myart_art.title,
>>>          tx_myart_art.category,
>>>          tx_myart_images.title AS img_title,
>>>          fe_users.name
>>>        FROM
>>>          tx_myart_art
>>>          LEFT OUTER JOIN tx_myart_art_image_mm ON (tx_myart_art.uid =
>>> tx_myart_art_image_mm.uid_local)
>>>          LEFT OUTER JOIN tx_myart_images ON
>>> (tx_myart_art_image_mm.uid_foreign = tx_myart_images.uid)
>>>          LEFT OUTER JOIN fe_users ON (tx_myart_art.cruser_id = 
>>> fe_users.uid)
>>>        GROUP BY
>>>          tx_myart_art.uid
>>>
>>>          ";
>>>
>>>        ]]></php>
>>>       </userobj>
>>>      </query>
>>>     </sql>
>>>    </search>
>>>
>>> _______________________________________________
>>> TYPO3-project-formidable mailing list
>>> TYPO3-project-formidable at lists.netfielders.de
>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>>>
> 
> _______________________________________________
> TYPO3-project-formidable mailing list
> TYPO3-project-formidable at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>