chrish123 Posted December 15, 2008 Share Posted December 15, 2008 Hi I have discovered a weird issue when trying to add a order number prefix to the database. It works fine when done on a local machine running xampp... but on the live server on apache it wont take for some reason. Why is this? When I manually create an order the prefix is not auto incrementing from the order number I specified but instead form the last order no style(without the prefix added). For example: Last order was 2289. I create a new test order which will be for instance 2290, in the database I then edit the orders field to 90102290. (On home PC) = (which works fine!) I go back into admin section, the 2290 order disapears which is normal I think, the new order 90102290 is not there except if you look manually within the database(this order is lost forever it only now exists within the database), but if you create a new order after then you then see the new order prefix..... so all is ok except the order you originally made and modified to the new order prefix... So yes its all working... (On live server) = (does not work?) I go back into admin section, the 2290 order disappears which is normal I think, the new order 90102290 is not there except if you look manually within the database(this order is lost forever it only now exists within the database), but if you create a new order you DO NOT SEE new order prefix..... But instead just a new order of 2291 instead of 90102291... Any help appreciated, Kind regards Chris Link to comment Share on other sites More sharing options...
angryquaker Posted December 15, 2008 Share Posted December 15, 2008 From a prior post by Nic (Fimble): Back up your database, ALTER TABLE `orders` AUTO_INCREMENT =1000 Run this in your phpmyadmin, change the 1000 for a number of your choice Regards Nic Worked for me. Namasté, Russ One: people are not wearing enough hats. Two: matter is energy. In the universe, there are many energy fields which we cannot normally perceive. Some energies have a spiritual source which act upon a person's soul. However, this soul does not exist ab initio, as orthodox Christianity teaches. It has to be brought into existence by a process of guided self-observation. However, this is rarely achieved, owing to man's unique ability to be distracted from spiritual matters by everyday trivia. Link to comment Share on other sites More sharing options...
chrish123 Posted December 15, 2008 Author Share Posted December 15, 2008 Hi, Thanks very much that worked perfect, funny thing is I had seen that post before and tested on my local pc it didnt work, it had to be done the above way. Seems to be a case of vice versa, I wonder what causes this? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.