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.
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 | +----------+
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?
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.
Comments on items awaiting validation but not showin
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Posted Aug 30, 2012 - 12: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.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
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 |
+----------+
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I don't get how that's logically possible then, can you send me access? http://www.wsnlinks.com/inspection.html
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
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?
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
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.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I searched my email and can't find any inspection requests for british-expats.com.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
What should I do with these at my end, just delete them from the DB manually at this stage?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
No need to do anything with them, unless you have tens of thousands awaiting revision it won't take much space.