Export

Please report bugs here!

Moderator: Thorsten

Post Reply
mojo_jojo
Posts: 12
Joined: Tue Feb 27, 2007 5:23 pm
Contact:

Export

Post by mojo_jojo »

Hi,

I've noticed that the export of the FAQ's doesn't work. The reason is in the sql-query in _getSQLQuery() in FAQ.php. I don't think you need a JOIN, you could simply do it like this (starting from the WHERE caluse):

Code: Select all

FROM faqdata, faqvisits, faqcategoryrelations 
WHERE faqdata.id = faqcategoryrelations.record_id 
AND faqdata.lang = faqcategoryrelations.record_lang
AND faqdata.date_start <= '".$now."'
AND faqdata.date_end   >= '".$now."' AND "...
Best regards,

Georgi
Thorsten
Posts: 15724
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi Gerogi,

thanks a lot, it's fixed in CVS.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply