Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

admin sql errors


jimlongo

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...