1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

VERY IMPORTANT PROBLEM - Two sites with same page ID after upgrade to 4.1

Discussion in 'Sitebuilder 4.1 for Linux' started by zooming, Mar 4, 2008.

  1. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Hello,

    I'm having some problems with Sitebuilder after upgrade from version 4.0 to 4.1

    The most important of them is one that I have figured out today.

    I have two (so far) different sites with the same page ID in the site_page table.

    That means that if one customer changes his home page, he is changing the home page of the other site too, and vice-versa.

    And after the upgrade, both sites had their home page content changed, what probably means that this ID in the site_page is for a page from a third site, that I don't know yet.

    And worst, this are the only cases I know so far because of the client's complains, I hope that there are no others.

    In resume, the upgrade has screwed completely my Sitebuilder. I have other threads about other problems with the upgrade, just search by user name "zooming" and think twice before starting the upgrade.

    Thanks.

    Alexandre
     
  2. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Yep, I have other sites with the home page with the same ID in the NEW site_page table.

    Every single upgrade in Plesk and Sitebuilder is a nightmare...

    The upgrade was made two weeks ago, I can't just restore a backup, there are new sites and changed sites in this period.
     
  3. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Sorry, the problem isn't the same ID in the site_page table. It looks like it is the same value in the "identity" column.

    It looks like SiteBuilder is getting the first page in the site_page table with the "identity" column with the value "index".

    There are several pages with the same "identity" column value.

    Sites without pages in the site_page table with the "identity" column named "index" are working fine.

    Now what?

    Anybody from SwSoft/Parallels?
     
  4. zooming

    zooming Regular Pleskian

    25
    57%
    Joined:
    Jul 12, 2006
    Messages:
    112
    Likes Received:
    0
    Confirmed, updating the table "site_page" with unique values in the "identity" column seems to fix the problem.

    It was happening with the "file_name" column too, I have updated this field with the value from the identity column, that is now unique.

    Everything looks good until now, I hope that these changes do not break anything else.
     
Loading...