I went through the whole thread and saw the problem listed

clarocque <[email protected]> 13 Sep 2003 08:18:32 -0000
Newsgroups gmane.comp.web.oscommerce.contributions
Message-ID <47ba3a3935ea290ab04248c24cff9c07@osCommerce-Forums>
This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=228809#228809
----------------------------------------------------------------

I, like may others am gettinthe following error
[code]1064 - You have an error in your SQL syntax near 'select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk' at line 1

select count(select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk_date_added, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short from faqdesk_description pd, faqdesk p, faqdesk_to_categories p2c where p.faqdesk_status = \'1\' and p.faqdesk_id = p2c.faqdesk_id and pd.faqdesk_id = p2c.faqdesk_id and pd.language_id = \'1\' and p2c.categories_id = \'2\' order by pd.faqdesk_question) as total 

[TEP STOP]

[/code]

I saw the problem listed but no fix (atleast not what I saw)  Any help for this????

Chris