Lost all links pending validation: WSN Support

Lost all links pending validation
Lost all links pending validation in upgrade

Version: 4.0.33

Lost all links pending validation

wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 13
Total Posts: 22

Posted 07/09/07 - 06:11 AM:	#1
Hi I have recently upgraded to WSNlinks 4.0.33 - but somewhere along the line the 100 or so links waiting to be validated have disappeared from the admin validation section. They are still listed in the MySql database - I can still see all the details on the records, but they don't appear for validating in the admin control panel. How can I get them back to validate them? (Can I manually switch something in the database? - I have tried regenerating everything and repairing the tables) Is there a way of deleting entries through the admin panel without the system automatically sending out an sort of message? (If it does anyway when a link is deleted) Many thanks for your help :-) Trevor. Edited by wsnl on 07/10/07 - 03:33 AM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5965

Posted 07/11/07 - 12:01 AM:	#2
If you upgraded from a 3.x version, they're probably pending email verification. It should be running the query automatically though: UPDATE wsnlinks_links SET validatedemail=1; There are no messages sent for deletion (which you do by clicking 'edit'), only for rejection.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 13
Total Posts: 22

Posted 07/11/07 - 01:11 AM:	#3
Hi How can I get the pending ones to display again in the validation/rejection area of the admin section? So I can validate or reject them. Can I run this query myself through the database query box in the admin section? Many thanks for your help :-) Edited by wsnl on 07/11/07 - 01:26 AM

wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 13
Total Posts: 22

Posted 07/12/07 - 04:18 AM:	#4
Hi I ran the query as suggested and they all seem to have appeared again :-) Thanks for your help ;-)

DR
Experienced

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72

Posted 09/12/07 - 01:00 PM:	#5
Found this thread very helpful By using the Query suggested UPDATE wsnlinks_links SET validatedemail=1 - it "exposed" a number of submissions that were hiding - to suggest a new link .... I thought that because I was running 4.0.31 ( I believe) - so I upgraded to the most current WSN Links 4.0.39 - and I am still having to run this query manually to find "hidden" submissions ... - This is where people are submitting - without including an email address .. Is it possible that I have something else switched on that is "demanding an email address ? - Either way - it is not automatically bringing the submitted links to the validation area - or Mod Control Panel - but when submitting the query - all shows up where it is supposed to be .. Thanks in advance for your insight on this .. DR
...there is no finish line...

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5965

Posted 09/13/07 - 02:36 AM:	#6
If you require link email validation, that requires an email.
Attached Files: ug.jpg (98 KB, 23 downloads) "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

DR
Experienced

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72

You don't have permission to post.