Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order_id modification?


macparts

Recommended Posts

Posted

Here is what I have tried so far to change the order_id number on my store

 

I have found this information

 

http://www.oscommerce.info/kb/osCommerce/G...s_and_Tricks/31

 

which tells me to goto my php/SQL admin window and do this query

 

alter table osc_orders auto_increment = 1000; which should change the new start number to 1000.

What I get as a response is #1146 - Table 'mysql9a42d8d607ffa64c1f970d9a1e2.osc_orders' doesn't exist , so I then try to look at the mysql site to see if this is the proper format of the command at this page and it seems to be correct

 

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

 

Ok .... so that leaves me with the option that I am not entering the proper name to the alter table command?

 

Ideas as to what I should try?

 

As a side comment ........ I am enjoying working with this. I haven't done any "real" programming in 20 years when the machines where VAX's and the code of choice was fortran , pascal and unix. When I was done with that program I figured I would never need unix again . My how times have changed :rolleyes:

 

Currently running on a PLESK server version 7.5.4 , and the 2.2 build

Posted

When MySQL reports an error, read it! It's saying the table osc_orders doesn't exist. I'm betting that's because you don't have a table called osc_orders. Yours is probably called orders. Look at the names of your tables to see.

Contributions

 

Discount Coupon Codes

Donations

Posted
When MySQL reports an error, read it! It's saying the table osc_orders doesn't exist. I'm betting that's because you don't have a table called osc_orders. Yours is probably called orders. Look at the names of your tables to see.

 

 

Thanks ..... I think I found the same info here

http://www.oscommerce.com/forums/index.php?sho...1&hl=osc_orders

 

My learning curve for Mysql is showing. I am use to databases that don't always show the full data tree. Such as if I issued a change command on a database it may take more than one item or run a script and change it rather than just the one column. So the correct command should be

 

alter table orders auto_increment = 1000

Archived

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

×
×
  • Create New...