[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