Webmastersite.net
Register Log In

items awaiting validation but not showin

Comments on items awaiting validation but not showin

nelgin


Usergroup: Customer
Joined: Jul 17, 2003

Total Topics: 39
Total Comments: 100
nelgin
items awaiting validation but not showin
Posted Aug 30, 2012 - 1:03 PM:

The left side on the admin panel shows me:

Additions
Pending Validation (2)
Add Categories
Add Links
Add Member

MySQL shows me:

mysql> select deleted,validated from wsnlinks_links where validated=0;
+---------+-----------+
| deleted | validated |
+---------+-----------+
| 0 | 0 |
| 0 | 0 |
+---------+-----------+
2 rows in set (0.02 sec)



Clicking on the pending link tells a different story:

Links (0) Links Edits (0) Links Awaiting Payment (0) Categories (0) Comments (0) Members (0) Attachments (0) Ratings (0) Trader Ratings (0) XML Feeds (0)

Nothing is pending validation at the moment.

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Aug 31, 2012 - 1:43 AM:

What does
SELECT * FROM wsnlinks_links WHERE unrevised=0 AND validated=0 AND alias=0 AND validatedemail=1 AND deleted=0
show?

My guess would be they might be pending self-email-validation, if you're requiring email validation for listings in the usergroup permissions? The Pending Validation (2) should have changed to 0 when the cache updated within an hour if that were the case, though.
nelgin


Usergroup: Customer
Joined: Jul 17, 2003

Total Topics: 39
Total Comments: 100
nelgin
Posted Sep 15, 2012 - 5:09 PM:

Sorry for the delay in responding. The result is 2.


mysql> SELECT count(*) FROM wsnlinks_links WHERE unrevised=0 AND validated=0 AND alias=0 AND validatedemail=1 AND deleted=0;
+----------+
| count(*) |
+----------+
| 2 |
+----------+

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Sep 16, 2012 - 7:35 PM:

I don't get how that's logically possible then, can you send me access? http://www.wsnlinks.com/inspection.html
nelgin


Usergroup: Customer
Joined: Jul 17, 2003

Total Topics: 39
Total Comments: 100
nelgin
Posted Sep 17, 2012 - 9:55 AM:

Do you still have the email I sent you previously? The shell passwords are still the same, only the admin password changed and you shouldn't need that if you're just checking the DB?
nelgin


Usergroup: Customer
Joined: Jul 17, 2003

Total Topics: 39
Total Comments: 100
nelgin
Posted Sep 17, 2012 - 9:56 AM:

Actually, what could have happened is that they were submitted and then I just stopped using the board at that time so things never got expired? Feel free to poke around if you think there may be a bug in there, otherwise they can be expired.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Sep 20, 2012 - 5:54 PM:

I searched my email and can't find any inspection requests for british-expats.com.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
Posted Sep 21, 2012 - 1:06 AM:

Discovered that unrevised listings pending revision were being counted in the left frame but not in the tabs. Fixed to not count them in either total.
nelgin


Usergroup: Customer
Joined: Jul 17, 2003

Total Topics: 39
Total Comments: 100
nelgin
Posted Oct 04, 2012 - 11:22 PM:

What should I do with these at my end, just delete them from the DB manually at this stage?
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7867
Paul
#10 - Quote - Permalink
Posted Oct 08, 2012 - 9:32 PM:

No need to do anything with them, unless you have tens of thousands awaiting revision it won't take much space.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.