macparts Posted March 24, 2006 Posted March 24, 2006 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
kgt Posted March 24, 2006 Posted March 24, 2006 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
macparts Posted March 24, 2006 Author Posted March 24, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.