Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

can somone tell me where to find this code?


Guest

Recommended Posts

Posted

Hi! can somone tell me where to find this code?

 

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 'limit 0, 12' at line 1

 

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '2' and ot.class = 'ot_total' order by limit 0, 12

 

Thanks!

Posted

Hi thanks for the link. i checked it however and these changes have already been made.

I also have a problem with the fact that my product listing does not 'split' onto another page when it reaches the max number of products per page variable. Any ideas where and what this is? Unfortunatly i am not a php programmer nor do i have time to learn to be. If you have any advice on the subject i would be much appreciative!

thanks!

Posted

in fact could someone just send me a working version of both the admin and catalog versions of spit_page_results.php if it is easier. I have been trying to address this problem for several months now and

im am very eger to get this sorted once and for all.

thanks!

Archived

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

×
×
  • Create New...