urgent help needed please !

[fantasticals]

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;

[madmumbler]

Your page wouldn't load for me.

When all else fails, reinstall. Did you make a back-up before you started the mods you can fall back on?

[Ajeh]

Looks like you are missing configuration_keys in the configuration table ...
EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT
EXPECTED_PRODUCTS_SORT
MAX_DISPLAY_UPCOMING_PRODUCT

Can you check in phpMyAdmin if you have them in the configuration table?