oscommerce sql fix

Hello all!

I've got a weird oscommerce error and I can't figure it out..

I have running on the latest oscommerce the "product extra fields [url removed, login to view]" contribution as well as the "Advanced Search Infobox [url removed, login to view]" contribution and the "Edit Order" contribution.

I think it is the first two that is causing my problem.

With the "Advanced Search Infobox" when I am searching via a price range I am getting the below error..

You can check for yourself at

[url removed, login to view]

##########################################

**1109 - Unknown table 'gz' in where clause

select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (IF([url removed, login to view], s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= 30) and (IF([url removed, login to view], s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= 50)

[TEP STOP]

**

##########################################

I'm guessing it is a mySQL error but I really don't have much of a clue! and I also don't have the time so if someone can hepl me out he I would be very happy.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

WIN XP

Amazon Web Services Engineering MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3207942

About the project