Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 error with salemaker_sales


hoggar

Recommended Posts

Hi

 

On the first attempt to open a new installation of a standard myshop download (MS2fr)I have this error displaying on the left part of the pages, stopping the complete displaying ot those pages.

 

 

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 '_date_start = '0000-00-00') and (sale_date_end >= now() or sale

 

select sale_specials_condition, sale_deduction_value, sale_deduction_type from salemaker_sales where sale_categories_all like '%,15,%' and sale_status = '1' and (sale_date_start <= now() or sale _date_start = '0000-00-00') and (sale_date_end >= now() or sale_date_end = '0000-00-00') and (sale_pricerange_from <= '54.9900' or sale_pricerange_from = '0') and (sale_pricerange_to >= '54.9900' or sale_pricerange_to = '0')

 

[TEP STOP]

 

 

 

Looking, digging, searching, as much on my local server as on the forums, I don't find the solution.

 

Help would be appreciated ;-)

 

OSX 10.3.9 (Darwin 7.9.0)

Apache/1.3.33 (Darwin) PHP/4.3.11

MySQL 4.0.26-standard via socket

MySQL Client Version 5.0.10

MS2fr with Register Globals Patch Files

 

Thank you...

 

Yves

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...