Turning off auto_increment

[textbook]

Hello,

 

Can someone please tell me how to turn off "auto_increment" in a table database.

Thanks.

[multimixer]

"auto increment" is a field property, used in general to create a unique id for a new row in a given DB table

 

Filed properties can be changed by using eg phpMyAdmin

 

I would suggest not to change this, you could mess up the whole database structure

 

What field exactly do you want to change and what's the purpose?

[textbook]

Ok thanks.

 

I`m trying to install the Unique Order Number add on.

One of the steps says to ``Turn off "auto_increment" in the "orders" table``.

I know its somewhere in phpmyadmin but I just cant find it.

[Guest]

@@textbook

 

using PHPMYADMIN Select the table., click structure and then change the field from auto increment

 

 

 

Chris

[textbook]

wow I cant believe I didnt see that...

Thank you!

[Jack_mcs]

You may want to think twice about adding that addon. It makes one of the most basic parts of oscommerce non-standard and you will find that you are always having to change code, as addons are installed or updates are made. Just my opinion for what it is worth.

[burt]

Agree with jack_mcs.

 

Any addon that changes something as important as this should never have been made public in the first place. It's very very poor practice to make such a drastic change. The addon should just have added a NEW column for the UON, then accessed that new column in the relevant places throughout the shop.

[multimixer]

Even better to leave the database alone at all and modify only the parts/files where you want to have a "fancy" order number to appear, say eg the invoice

 

You can take the "plain" order number that is e.g. 1278 and add to it any prefix, a date and whatever, so it looks like mmx-1278-14112_kuku/abc, but this will be just where you want it, leaving the core system in peace