Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error 1064 - HELP!


jacoben

Recommended Posts

Posted

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 '-20, 20' 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 ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

[TEP STOP]

 

 

can someone help me please?

 

i cant configure the order.php

:'(

Posted
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 '-20, 20' 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 ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

[TEP STOP]

can someone help me please? 

 

i cant configure the order.php

:'(

 

 

The answer to this is on page 1 of the tips section - a good place to start

 

Charles

A kite flies highest AGAINST the wind !

 

"Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body, but rather to skid in sideways, a lover in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO!! What a ride!"

Posted
The answer to this is on page 1 of the tips section - a good place to start

 

Charles

 

thanks bro :D

 

you're the master ;)

 

i need help about 2 minor problem.

 

1- Warning: I am able to write to the configuration file: c:/program files/easyphp1-8/www/catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

 

-> how can i remove this warning ?

 

2- You are not protected by a secure SSL connection.

 

-> how can i set the secure SSL connection ?

 

 

thanks in advance,

 

Greetz :thumbsup:

Posted
thanks bro :D

 

you're the master ;)

 

i need help about 2 minor problem.

 

1- Warning: I am able to write to the configuration file: c:/program files/easyphp1-8/www/catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

 

-> how can i remove this warning ?

 

2- You are not protected by a secure SSL connection.

 

-> how can i set the secure SSL connection ?

thanks in advance,

 

Greetz  :thumbsup:

 

You need to set the permissions on your catalog/includes/configure.php and admin/includes/configure.php to something like 444 or 400 by chmoding the files - you can use your ftp client or your server account management facility to do this.

 

For SSL you need to make sure you have

 

1) purchased the certificate

2) installed it correctly

3) changed your configure.php files (above) to the correct settings

 

Charles

A kite flies highest AGAINST the wind !

 

"Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body, but rather to skid in sideways, a lover in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO!! What a ride!"

Archived

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

×
×
  • Create New...