Em Andamento

Quick and Easy Fixes at 2 Different osCommerce Sites

I manage a bunch of osCommerce sites. Two of them require minor fixes:

Site 1:

The [url removed, login to view] file which is being used to manage the site's discount coupon displays the following SQL error message whenever a coupon is not active:

--Error Begins--

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 '-5, 5' at line 1

select *, DAYOFMONTH(start_date) AS coupon from coupons_calendar where end_date >= '2006-05-09' and MONTH(end_date) = '05' and language_id = '1' order by start_date limit -5, 5

--Error Ends--


1. Fix the query problem so that the coupon page is blank when all coupons have expired or no coupon is active.

2. Make it possible to have the 1 discount coupon applicable to all the products the site offer (only 5 products). The system currently allows for 1 to 1 relationship but we prefer to have 1 (coupon) to many (products).

Site 2:

The thumbnail images stop displaying in the product listing, product info and shopping cart screens when we FTP'd the images and used txt file format to upload the product information. This problem also affected the PDF datasheet as well.


1. Fix the thumbnail images to display in the following screens:

product listing (or search result display), product info and shopping cart pages.

2. Fix the PDF datasheet code errors.


My budget is less than $100

Future Benefit:

On going support and maintenance tasks for those sites that I manage.

Habilidades: PHP

Veja mais: sql code pdf, problem fixes, my fixes, error fixes, easy problem, discount shopping sites, discount shopping site, discount and coupons, coupons discount, budget offer code, oscommerce display product info, oscommerce error sql syntax check manual corresponds mysql, sql less than, syntax, quick order, php fixes, fixes, fix mysql query, easy fix, easy 2

Acerca do Empregador:
( 72 comentários ) Gaithersburg, United States

ID do Projeto: #60206