Amrit Posted January 15, 2013 Report Share Posted January 15, 2013 Hallo, ich will die Bestellnummer verändern, habe nach Handbuch das in die Abfrage der DB eingetragen ALTER TABLE `xt_orders` AUTO_INCREMENT =3360000 die Nummer wird aber nicht verändert was mache ich falsch? Gruß Manfred mit der länge der Zahl hast jedenfalls nicht zu tun... achja, Shop Version 16 Link to comment Share on other sites More sharing options...
mzanier Posted January 16, 2013 Report Share Posted January 16, 2013 Die änderung der Nummer gilt natürlich nur für neue Bestellungen. Link to comment Share on other sites More sharing options...
Amrit Posted January 16, 2013 Author Report Share Posted January 16, 2013 Danke für die Antwort, habe dem Fehler gefunden -ist mir fast peinlich - habe den Wert in die falsche DB (Test-DB) eingetragen, da konnte sich (Live) keine Nummer ändern. jetzt geht es. Grüße Manfred Link to comment Share on other sites More sharing options...
nikkil Posted January 20, 2013 Report Share Posted January 20, 2013 Hi, sorry I wasn't able to get it. How was it resolved again please? Link to comment Share on other sites More sharing options...
Sentor77 Posted January 21, 2013 Report Share Posted January 21, 2013 Hi, use this SQL-statement in your live-database: ALTER TABLE `xt_orders` AUTO_INCREMENT =YOURNUMBER[/CODE] Replace "YOURNUMBER" with the number you want to start with. It will work for all NEW orders. LG Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.