Re: Re: [campsite-support] Problem adding staff users and subscribers
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Please run the following query on your campsite database:

    UPDATE liveuser_users SET Id = (SELECT Id FROM Users WHERE
    liveuser_users.UName = Users.UName);

    Mugur

    On Mon, Jan 19, 2009 at 5:57 PM, wrote:

    > Author: omni direction
    > Link: http://code.campware.org/phorum/read.php?8,6474,6849#msg-6849
    >
    > --------------------------------------------------------------------------------
    >
    > Hello,
    >
    > I have same problem, also on Campsite 2.7.0-rc5. This SQL script solved
    > this problem only temporary, in my case. After running the script i could
    > create few new subscribers and users, and several minutes latter messages
    > "The user account could not be created", and "There was an error when trying
    > to update the user info" started to appear again.
    >
    > Biggest problem is that some of the users and subscribers were deleted
    > after script execution, some only from LiveUsers table, some from both
    > LiveUser and Users tables. Good that I have a db dump, but i'm afraid that
    > restoring database, and running the script again will not solve the problem,
    > cause i tried that twice...
    >
    > Is there another solution?
    >
    > Thanx
    >
    > --
    > Sent from Campware Forums
    > http://code.campware.org/phorum
    >
Add a Comment