Announcement

Collapse
No announcement yet.

Mass Change Members Visitor Messaging Option

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Nick
    replied
    Originally posted by Girlonthehill View Post
    This is all new to me but I have the same problem and tried running the above query to enable Visitor Messaging and was met with this error message:

    Code:
     
    An error occurred while attempting to execute your query. The following information was returned. 
    error number: 1146 
    error desc: Table 'mydbase-name.user' doesn't exist
    Did I do something wrong?
    You should start your own Support Thread with all relevant details.

    Leave a comment:


  • Girlonthehill
    replied
    Originally posted by Wayne Luke View Post
    Enable Visitor Messaging:
    On: UPDATE user SET options=options + 8388608 WHERE NOT(options & 8388608)
    Off: UPDATE user SET options=options - 8388608 WHERE options & 8388608

    Restrict it to contact list:
    On: UPDATE user SET options=options + 16777216 WHERE NOT(options & 16777216)
    Off: UPDATE user SET options=options - 16777216 WHERE options & 16777216
    This is all new to me but I have the same problem and tried running the above query to enable Visitor Messaging and was met with this error message:

    Code:
     
    An error occurred while attempting to execute your query. The following information was returned. 
    error number: 1146 
    error desc: Table 'mydbase-name.user' doesn't exist
    Did I do something wrong?

    Leave a comment:


  • .Immortal
    replied
    Thanks Wayne, worked perfectly.

    Leave a comment:


  • Wayne Luke
    replied
    Enable Visitor Messaging:
    On: UPDATE user SET options=options + 8388608 WHERE NOT(options & 8388608)
    Off: UPDATE user SET options=options - 8388608 WHERE options & 8388608

    Restrict it to contact list:
    On: UPDATE user SET options=options + 16777216 WHERE NOT(options & 16777216)
    Off: UPDATE user SET options=options - 16777216 WHERE options & 16777216

    Leave a comment:


  • .Immortal
    started a topic Mass Change Members Visitor Messaging Option

    Mass Change Members Visitor Messaging Option

    Can someone tell me what is the query to mass change members visitor messaging options to on?

    Thanks

Related Topics

Collapse

Working...
X