ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Pages uri in database

February 02, 2012 6:23pm

Subscribe [2]
  • #1 / Feb 02, 2012 6:23pm

    anonymous162744

    58 posts

    I’m having an issue with the pages module in that it doesn’t seem to keep it’s information when I transfer the database. Can you tell me in which table the pages uri’s are kept? Doing a search of my database turns up no results, yet when I go the entry, I see it populated.

    Thanks.

  • #2 / Feb 03, 2012 7:13pm

    Shane Eckert

    7174 posts

    Hello Anthony,

    Thank you for using the ExpressionEngine forums!

    I added a new page using the pages module and then ran a few queries to find my newly created page.

    There are two tables that get updated.

    exp_channel_data
    exp_channel_titles

    Look for uri_title and field_id_15.

    I am not sure this the answer you wanted, but I hope it helps.

    Cheers!

  • #3 / Feb 03, 2012 7:18pm

    anonymous162744

    58 posts

    Hello Shane,

    Thanks for the reply.

    I ended up finding the answer. The actual pages_uri gets saved in the exp_sites table as a hash, which is the reason I couldn’t find it after doing a search for it in the database.

    ac.

  • #4 / Feb 03, 2012 7:22pm

    Shane Eckert

    7174 posts

    Hi Anthony,

    You know, I was thinking it did, but I had no way to confirm that. Do you mind sharing how you figured that out?

    Cheers!

  • #5 / Feb 03, 2012 7:29pm

    anonymous162744

    58 posts

    I actually stumbled upon an old post referencing it 😊

    I tried looking for it again, but couldn’t find it.

  • #6 / Feb 03, 2012 7:31pm

    Shane Eckert

    7174 posts

    Hi Anthony,

    Ha! Well, glad to know the information was on the forums somewhere. 😊

    Have a great weekend.

    Cheers!

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases