Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post How To Change / Reset CMS Page IDs? 
 
Hi all,

I'd like to know how to change CMS Page IDs, and (most importantly) how to reset the counter for it.

I made a couple of CMS Pages, tried things out, and deleted them, but then, when I add another page, the CMS Page ID continues with whichever highest number it used to be, and keeps counting from there, finally resulting in something like this:

cmspageidproblem

As you can see, the CMS Page IDs read: 1, 2, 4, 6, 21, and 22. I'd like to have the Page IDs run chronologically, 1, 2, 3, ... etc. Now, whether or not I delete the last two pages, every time I add a new page, it will give it page ID 23 and higher. Editing the database record 'cms_layout' doesn't really do the trick - sure, I can change the existing page IDs, but 1. adding a new page will still result in a high ID number, meaning I would have to change it every time, and 2. clicking on 'Duplicate Blocks' when editing that particular CMS page will result in an error.

What can I do?
 



 
scorpsportalSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: How To Change/reset CMS Page IDs? 
 
Hi !

If my memory is good, the field is in auto increment. There's no solution to reset an AUTO_INCREMENT field, only this trick : delete it and re-add (as a Primary Key AUTO_INCREMENT). Do a save of the table before and don't forget to clear the cache, that should work.
 



 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: How To Change/reset CMS Page IDs? 
 
Thanks, it was very helpful!
 




____________
ScorpsPortal.com
 
scorpsportalSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: How To Change/reset CMS Page IDs? 
 
You may alternatively try to assign a name to your pages, so they will be independent from the ID.

For example, you have a page called "Commodore 64 Emulator": if you assign c64_emulator.php as a filename you will then be able to reach that page by typing c64_emulator.php in your browser, without needing to remember the ID of the page.

Just a suggestion...
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron