Hi,

I have the following message when i enter the url for my homepage: i havnt a clue what this means is anyone able to help ?

1064 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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070701 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

The site was working perfeclty 20 mins ago since then i have done two things:

1) backed up my httpdocs file by dragging and dropping all files in httpdocs using cuteftp.
2) uninstalled a payment module and installed the latest version, as part of this i run the following database update from the zen admin panel:
ALTER TABLE `protx_direct`
ADD
`threed_secure_status` VARCHAR( 20 ) NULL,
ADD
`cavv_result` VARCHAR( 32 ) NULL;