jacoben Posted April 25, 2005 Posted April 25, 2005 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 :'(
Simplyeasier Posted April 25, 2005 Posted April 25, 2005 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 :'( <{POST_SNAPBACK}> 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!"
jacoben Posted April 25, 2005 Author Posted April 25, 2005 The answer to this is on page 1 of the tips section - a good place to start Charles <{POST_SNAPBACK}> 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:
Simplyeasier Posted April 26, 2005 Posted April 26, 2005 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: <{POST_SNAPBACK}> 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!"
Recommended Posts
Archived
This topic is now archived and is closed to further replies.