FAQ error....any idea?

[Kruna]

Hi all,
can anyone help me, please?

I get the following error:

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select count(*) as total from zen_faqs p, zen_faqs_description pd where p.faqs_status = '1' and p.faqs_id = pd.faqs_id and pd.language_id = '2' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 120]

when I enter NEW FAQ´s, please take a look here.

The rest of th emodule seems to work great!!!

Thank you very much for help.

Best ragrds,
kruna

[Kruna]

Hi all....

I got it fixed....

I found the solution here


Now it seems to work...

tahnks for this great mod.

Best regards,
kruna