1064 - You have an error in your SQL syntax;

[Guest]

For some reason my posts disappear so here is my post again,

 

If I log in as a customer and go to my Account Information and click "Overview Show All Order" Following message shows up,

 

My Order History

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 = '2' 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' order by orders_id DESC limit -10, 10

 

[TEP STOP]

 

According to my hosting service, he says there is a bug in osCommerce??

[Jan Zonjee]

For some reason my posts disappear

No, you posted this on March 30 and was answered by Jack_mcs. Then again on April 1. Same answer by Jack_msc.

And now again. Too lazy to even go back to see if your own topics have been answered?

 

Pretty annoying... :angry:

[Guest]

Hi Jack,

 

I'm sorry, but for some reason they do not show up when I search for them.

 

Thank you very much for your help and sorry for being a pain in the ***

[Guest]

you dont have to search for them, just click on the link 'my assistant' and you can find all your posts

[istyfu]

Please from the start! What do I need to do when I get this error:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Please help me! Thank you!

[Guest]

Please from the start! What do I need to do when I get this error:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Please help me! Thank you!

 

I was told to update to the latest version of oscommerce, it has a lot of bug fixes, this is one of them.