• Replies 8 replies
  • Subscribers 248 subscribers
  • Views 97 views
  • Users 0 members are here
Related

Cannot inactivate email b/c used by login

Kanani Reichlin
$organization

Hi Friends,

We had an odd occurrence.  A patron contacted our box office saying when she logs in to our website with her email address it says her name is Eileen Wilcox, when really her name is Linda Corcorran.  I went into Eileen Wilcox's account, and sure enough Linda's email address is in her record and it can not be inactivated because it is used by a login.

I don't know how this happened, but would like to fix it.  After some researching, I think this will be a SQL task, but wondering if anyone can tell me what needs to be done.

 

Thanks,

Kanani

Parents
  • $organization

    I’m on version 10.  So I suppose that functionality isn’t on version 10?

     

    Kanani Knudson| Sales and Database Coordinator | (206) 443-0807 x1206| Ticket Office: (206) 441-3322
    Seattle Children's Theatre |    www.sct.org| 201 Thomas St. Seattle WA, 98109

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Sabina Spilkin
    Sent: Friday, December 14, 2012 11:56 AM
    To: Kanani Knudson
    Subject: RE: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If you’re on Version 11 , under Contact Details , RB Logins – you are able to delete the login email address from there …

     

    Sabina

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Kanani Knudson
    Sent: Friday, December 14, 2012 11:29 AM
    To: Sabina Spilkin
    Subject: Re: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If I can do it from the front end that would be best.  Where do you inactivate the login?

     

    p.s. I'm now essentially the DBA and learning SQL so if you know which table this would be under that would be helpful, but like I said front end is preferred.

     

    Thanks for you reply!

    From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com>
    Sent: 12/14/2012 1:04:48 PM

    Weird indeed. But we had a situation like this a few months ago. It is possible for your DBA to transfer the email and login to the correct account using SQL.

    Or if you'd prefer to do it from the front end you can inactive the login then inactive the email address on the wrong account. Then simply add the email address and create a new login on the correct account.




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    I’m on version 10.  So I suppose that functionality isn’t on version 10?

     

    Kanani Knudson| Sales and Database Coordinator | (206) 443-0807 x1206| Ticket Office: (206) 441-3322
    Seattle Children's Theatre |    www.sct.org| 201 Thomas St. Seattle WA, 98109

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Sabina Spilkin
    Sent: Friday, December 14, 2012 11:56 AM
    To: Kanani Knudson
    Subject: RE: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If you’re on Version 11 , under Contact Details , RB Logins – you are able to delete the login email address from there …

     

    Sabina

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Kanani Knudson
    Sent: Friday, December 14, 2012 11:29 AM
    To: Sabina Spilkin
    Subject: Re: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If I can do it from the front end that would be best.  Where do you inactivate the login?

     

    p.s. I'm now essentially the DBA and learning SQL so if you know which table this would be under that would be helpful, but like I said front end is preferred.

     

    Thanks for you reply!

    From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com>
    Sent: 12/14/2012 1:04:48 PM

    Weird indeed. But we had a situation like this a few months ago. It is possible for your DBA to transfer the email and login to the correct account using SQL.

    Or if you'd prefer to do it from the front end you can inactive the login then inactive the email address on the wrong account. Then simply add the email address and create a new login on the correct account.




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children