[Typo3] Irfaq FAQ Extension SQL Problem

Boris Senker typo3 at dvotocka.hr
Sun Jul 17 22:02:49 CEST 2005


"Ingo Renner" <typo3 at ingo-renner.com> wrote in message 
news:mailman.1.1121621162.23873.typo3-english at lists.netfielders.de...
> Am Sun, 17 Jul 2005 17:27:02 +0200 schrieb Boris Senker:
>
> Now you should see some more detailed information...
>

Hi Ingo,

thanks for your reply.

Here is the debug info (apologies for not turning it on before):


ERROR:

You have an error in your SQL syntax. Check the manual that corresponds to 
your MySQL server version for the right syntax to use near '32 AND 
tx_irfaq_q.deleted=0 AND tx_irfaq_q.hidden=0 AND tx_irfa


lastBuiltQuery:

SELECT DISTINCT tx_irfaq_q.uid, tx_irfaq_q.q, tx_irfaq_q.q_from, 
tx_irfaq_q.a, tx_irfaq_q.cat, tx_irfaq_q.expert
FROM tx_irfaq_q
WHERE
tx_irfaq_q.pid IN (32,43) AND pid = 43,32 AND tx_irfaq_q.deleted=0 AND 
tx_irfaq_q.hidden=0 AND tx_irfaq_q.fe_group IN (0,-1) AND 
tx_irfaq_q.deleted=0 AND tx_irfaq_q.hidden=0 AND tx_irfaq_q.fe_group IN 
(0,-1)
ORDER BY tx_irfaq_q.sorting


debug_backtrace:

      0 DISTINCT tx_irfaq_q.uid, tx_irfaq_q.q, tx_irfaq_q.q_from, 
tx_irfaq_q.a, tx_irfaq_q.cat, tx_irfaq_q.expert

      1 tx_irfaq_q

      2 tx_irfaq_q.pid IN (32,43) AND pid = 43,32 AND tx_irfaq_q.deleted=0 
AND tx_irfaq_q.hidden=0 AND tx_irfaq_q.fe_group IN (0,-1) AND 
tx_irfaq_q.deleted=0 AND tx_irfaq_q.hidden=0 AND tx_irfaq_q.fe_group IN 
(0,-1)

      3

      4 tx_irfaq_q.sorting




Thanks,


Boris Senker

: dvotocka design
________________________________________________________________

Graphic Design for Print and Web, Prepress, Website Production, TYPO3 
Hosting

J. Laurencica 8, 10000 Zagreb, Croatia
http://www.dvotocka.hr 





More information about the TYPO3-english mailing list