Error 1064

[Guest]

Can anyone help, the following error 1064 (see details below) when accessing review.php, specials.php & orders.php within admin section. rgds scott

 

Orders

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.customers_id, 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.customers_id = '617' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

[TEP STOP]

 

Reviews

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 reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

 

[TEP STOP]

 

Specials

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 p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

 

[TEP STOP]

[kgt]

This is a common error:

 

http://www.google.com/search?hl=en&lr=&q=Y...com&btnG=Search

 

Read the last comment on this bug report:

 

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

[selectronics4u]

there is a fix for this issue in the new update that is out.can be found at oscommerce.com

 

Don

[Guest]

Thanks very much for the info but I'm still having some problems.

 

I have been attempting to change the applicable pages as outlined in the bug fix however I receive the following error when I try to change lines in these pages:-

 

Error: I can not write to this file. Please set the right user permissions on: /home/equinesh/public_html/admin/includes/classes/split_page_results.php

 

I have tried to change the permissions of each of the split_page_results.php in CPanel from 644 to either 755 or 777 but although the response shows as saved file it doesn't actually change this from 644

 

Any help would be greatly appreciated.

Cheers, Scott

[selectronics4u]

thats strange what are you using to edit file? if you have never edited these files just ftp up the new ones and overwrite the file.

 

Don

[Guest]

Hi Don

After trying to edit within file manager of admin area, I tried to change permissions & update within CPanel without success. I had previously tried ftp'ing local amended copy of files via dreamweaver to the server but it failed to upload the file.

 

Scott

[selectronics4u]

i dont know if you have the latest version of osc but the file manager has a bug i would not use it unless you have done the new update that is out(newest version of osc) anytime you edit a file save a backup of the file then if you edit it and it doesnt work then you can just send up the backup copy and fix it.ftp the file you want to edit,edit it with a plain text editor like notepad,then send it back up.i have never used dreamweaver so i cant help you witth that.you should be able to change permissions on files on your server if you cant i would ask your host.

 

do a google search for editors and ftp software there is lots out there and a lot are free i use notepad++ for editing and filezilla for ftp.alot of people like crimson editor.

 

if you need a new file download another copy of osc then get a copy of the file you need from there.

 

 

hope some of this helps Don