Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
NC Software Offline
Member
 
NC Software's Avatar
 
Posts: 522
Join Date: Dec 2005
Location: Sitting
Question How do I set all users to Validated? - 08-01-2007, 03:14 AM

We moved our servers to a new data center and I'm sure we had e-mail issues in the process of DNS propagations. I need to know how to set all users to Validated. What is the SQL Query I should run in MySQL as obviously there is no method of doing this within SS 3.x.


Neal Culiner
NC Software, Inc.
Visual Basic .NET Forums
3.30.02 STABLE
   
Reply With Quote
  (#2) Old
Mahesh Slaria Offline
Member
 
Posts: 183
Join Date: Jul 2006
08-01-2007, 06:22 AM

Hi,

If you want to Validate all users you have to run following query:
Quote:
UPDATE `swusers` SET `enabled` = '1' WHERE 1;
Thanks.

Regards,
   
Reply With Quote
Reply

Tags
validated

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Require Validated Users to leave Comments NC Software Duplicate Requests 5 09-11-2007 11:02 AM
problem ! graziano68 SupportSuite, eSupport and LiveResponse 2 08-11-2006 07:07 AM
Swift CLI problem joshopkins SupportSuite, eSupport and LiveResponse 2 02-09-2006 06:12 AM



Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46