admin sql errors

[jimlongo]

I am getting a similiar sql error on the following admin pages

 

Catalog>Manufacturer

Catalog>Reviews

Catalog>Specials

Catalog>Products Expected

Customers>Orders

Reports>Customer Orders-Total

 

Here is the error from Customers>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.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

 

I figure there must be something in the mysql export-import that changed something in the database, but I don't see anythng obvious.

I've repaired the database and otherwise everything seems to function alright.

 

The only other change is the files changed to the Register Globals V1.5 versions.

 

Thanks for any help,

jim

[jimlongo]

anyone?

 

thanks,

jim

[Guest]

you should upgrade your store.

http://www.oscommerce.com/solutions/downloads

 

The particular bug is documented here:

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

[jimlongo]

Thank you very much(!)

I thought I did have the latest version since I only installed it in december 06, but perhaps not.

 

At any rate the end post in that bug fix corrected all the errors in the admin panel.

 

 

 

 

Also thanks for pointing out the Bug Report section as it solved my next problem of 1054 errors on the Catalog page

 

 

 

jim

[Guest]

I thought I did have the latest version since I only installed it in december 06, but perhaps not.

 

did you install something else at the top of the latest osc code? Like an outdated template for instance that includes osc files from 2003 or something.

[jimlongo]

did you install something else at the top of the latest osc code? Like an outdated template for instance that includes osc files from 2003 or something.

 

I installed the Register_globals v1.5 files the other day. I had moved my store and the new server did not allow register_globals to be set in the php.ini or .htaccess files. This was the contribution I found that fixed that problem.

 

http://www.oscommerce.com/community/contri...egister_globals

[Guest]

I installed the Register_globals v1.5 files the other day. I had moved my store and the new server did not allow register_globals to be set in the php.ini or .htaccess files. This was the contribution I found that fixed that problem.

 

http://www.oscommerce.com/community/contri...egister_globals

 

Ok this should be good but you may want to review the latest osc changes on the catalog end. Make sure you have those too.

[jimlongo]

Ok this should be good but you may want to review the latest osc changes on the catalog end. Make sure you have those too.

 

Where is there any changes beyond the 2.2 Milestone??

[Guest]

Where is there any changes beyond the 2.2 Milestone??

the 2.2 ms went through few upgrades. Unfortunately you cannot tell by the version number - without looking the files. They all state ms2.2 The latest one is 060817 available from the downloads link.

[jimlongo]

If i downloaded and installed in December 2006 then that would be the one I have . . . wouldn't it?

 

Thanks,

jim

[Guest]

If i downloaded and installed in December 2006 then that would be the one I have . . . wouldn't it?

 

Thanks,

jim

 

initially. If you then installed a template at the top then no it wont necessarily. Many of the commercial osc templates that are around are using very old files.

[jimlongo]

I see what you mean. No I haven't installed anything other than the Register_Globals and the bug fixes you pointed out today.