[attachment=13386:auto.jpg]
I have 2 storefronts in one hosting.
When clicking paypal payment button, it shows "Service unavailable" sign.
I found that as resolution, I have to change “Auto increment number 16777216†at phpMyadmin to less number
to fix order problem.
But the number 16777216 is never changed even though I clicked “go†save button.
How to change the number 16777216 on earth???
See attached picture.
auto.jpg
Hello.
Please click on "SQL" tab and execute query
ALTER TABLE cscart_orders AUTO_INCREMENT = 16076926;
where 16076926 is the last order number.
But this is not a normal behavior that sets such a high order number because it is the maximum value of this field.
Best regards.
Robert.
Hello.
Please click on "SQL" tab and execute query
ALTER TABLE cscart_orders AUTO_INCREMENT = 16076926;
where 16076926 is the last order number.
But this is not a normal behavior that sets such a high order number because it is the maximum value of this field.
Best regards.
Robert.
I found SQL tab that you told me,,,
But,, I dont know how to execute query....
Could you explain in detail again using picture?
auto.jpg
I have 2 storefronts in one hosting.
When clicking paypal payment button, it shows "Service unavailable" sign.
I found that as resolution, I have to change “Auto increment number 16777216†at phpMyadmin to less number
to fix order problem.
But the number 16777216 is never changed even though I clicked “go†save button.
How to change the number 16777216 on earth???
See attached picture.
I assume there is an order with ID=16777216 in your store. This is why you cannot change the AUTO_INCREMENT value.
How many orders is there in your store and what is the Initial order ID value on the Settings > General page of the admin panel?
I assume there is an order with ID=16777216 in your store. This is why you cannot change the AUTO_INCREMENT value.
How many orders is there in your store and what is the Initial order ID value on the Settings > General page of the admin panel?
Anway,, I made "Open ticket" and they solved the problem.
Thank you anyway.