Help! parse error :(

[Guest]

was working in file:-

 

includes/languages/english.php

 

and now when i visit my shop i get error:-

 

Parse error: parse error in includes\languages\english.php on line 146

 

line 146 contains the following code... :-

 

define('JS_REVIEW_TEXT', '* The 'Review Text' must have at least ' . REVIEW_TEXT_MIN_LENGTH . ' characters.n');

 

Im completely new to PHP and programing so would appreciate any help, thanks :)

[OceanRanch]

Stop using the oscommerce File manager. It is removing escape characters and causing parse errors. Get a fresh copy of the file and edit locally with your editor and then ftp it back to your site.

 

define('JS_REVIEW_TEXT', '* The 'Review Text' must have at least ' . REVIEW_TEXT_MIN_LENGTH . ' characters.n');

 

should be

 

define('JS_REVIEW_TEXT', '* The \'Review Text\' must have at least ' . REVIEW_TEXT_MIN_LENGTH . ' characters.\n');

 

 

HTH

Tom

[Guest]

thanks! that was the problem, did not realise the editor was poo :blush: lol

 

however... new problem, when clicking on Newsletter Manager (in admin) i get error:-

 

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 newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]

[241]

http://www.oscommerce.com/community/bugs,1605

[Deskdirect]

Is this the same thing?

 

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

 

select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '70' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and o.orders_status != '99999' order by orders_id DESC limit -10, 10

[241]

Is this the same thing?

 

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

 

select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '70' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and o.orders_status != '99999' order by orders_id DESC limit -10, 10

<{POST_SNAPBACK}>

 

yes that is the same just a different set of value numbers for the resulting split page