Newbie with 2 issues, hoping for some assistance

[howardm]

Hello,

I am a new OSCommerce user and love the system.

I am new to this and not, by any means a pro at MySQL and need assistance in changing the Order #.

I saw the directions to enter in these commands "alter table osc_orders auto_increment = 1000;" but my prob is that i don't know the commands to get to that point. (I want to change the 1000 to be somewhere around 6 or 7000)

I did try to enter "mysql" and then "use osc" but I was just guessing.

Would someone be kind enough to steer me thru the proper commands and at what directory level I need to start at (if that is an issue)?

My guess is this is probably pretty simple, but being I haven't played with mysql at all, I'm lost.

 

The last issue I had was on the specials, when I click on that link to add some special pricing in the ADMIN menu, I get

 

"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 '-15, 15' 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 -15, 15"

 

 

I do appreciate any help you folks can offer. otherwise, OSCommerce is running great and I love it!

Thanks!

Howard

[Guest]

what version of mysql are you working with? look in tips and tricks, there is something on the error you have listed there.

[howardm]

what version of mysql are you working with?  look  in tips and tricks, there is something on the error you have listed there.

<{POST_SNAPBACK}>

 

I should've put that info down..

here ya are:

Database: MySQL 4.1.11

Server OS: FreeBSD 4.7-RELEASE-p28

HTTP Server: Apache/1.3.33 (Unix) PHP/4.3.11

PHP Version: 4.3.11 (Zend: 1.3.0)

 

Thanks!

Howard