Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How To Change "auto Increment Number 16777216" Phpmyadmin? Rate Topic   - - - - -

 
  • melkong
  • Member
  • Members
  • Join Date: 28-Jun 17
  • 17 posts

Posted 01 August 2018 - 09:42 PM #1

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.



 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 511 posts

Posted 01 August 2018 - 10:18 PM #2

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.


Team of SoftSolid
cs-cart.pl

 
  • melkong
  • Member
  • Members
  • Join Date: 28-Jun 17
  • 17 posts

Posted 02 August 2018 - 01:24 AM #3

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?



 

Posted 02 August 2018 - 06:06 AM #4

attachicon.gif 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?


Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • melkong
  • Member
  • Members
  • Join Date: 28-Jun 17
  • 17 posts

Posted 05 August 2018 - 04:00 AM #5

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.