WebmasterSite.net: PHP scripts to enable your creativity
WSN Links PHP Directory Software
PHP Scripts Webmaster Links Support Forums

Register | Forgot Password

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

Version: 4.0.33
printPrint


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:
quote post
#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
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5965
Posted 07/11/07 - 12:01 AM:
quote post
#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:
quote post
#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:
quote post
#4
Hi

I ran the query as suggested and they all seem to have appeared again :-)

Thanks for your help ;-)
DR
Experienced
Avatar

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72
Posted 09/12/07 - 01:00 PM:
quote post
#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
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5965
Posted 09/13/07 - 02:36 AM:
quote post
#6
If you require link email validation, that requires an email.

Attached Files:
ug.jpg
(98 KB, 23 downloads)
attachment

"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
Avatar

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72
Posted 09/13/07 - 02:07 PM:
quote post
#7
Thanks Paul - That was it !!!

...there is no finish line...
Search thread for
Download thread as


You don't have permission to post.

Please login or register.

   
 
© 2008 Paul Knierim. All rights reserved.