I'm having an issue with pending links that seem to be acting odd after the latest upgrade(s) which I did between the submissions and the approvals.
I had about 20 links to approve/decline in queue. After the recent upgrade warning about SQL-injection, I did the upgrade to 5.0.81 (and the prior 5 to 6 minor upgrades as well that I had been delaying). As usual, I skipped the auto-updates of customized templates. These particular updates did not cause the normal manual instructions for templates so I'm assuming (?) they were all PHP related and not template based.
After upgrade, I began approving/declining the links in the queue. All went normal and users received their approval emails.
However, they notified me they could not see their newly approved links. When logged in as "admin" I can see them in the category listing pages (displaylinks) just fine. But when logged out, the newly approved links disappear. However, both logged-in and logged-out users can view the individual link listing. The difference seems to be only on the category listing page.
I went and compared every field in the database between the newly approved links (that do not show) and the older approved links (that do show) and can't find any differences to which a database call could be making a difference. The only difference is ownerid which was showing as "0" for the newly approved links, although that did not seem to be unique. Not sure what zero means, but I changed the newly approved links to "1" (admin) in the WSN Links Admin Edit screen, but they still did not show on the category listing pages.
I'm out of guesses as to what happened or how I can fix it. I'm guessing something odd happened during the updates that caused a conflict from the submission time to the approval time (with the updates in between), so this may be very unique to just me. I haven't had a new suggested link yet since the upgrades so I don't yet know if this is going to continue or if it just relates to those links. There's only about 12 of them - so I could just update something in MySQL if I knew what to update, but as I said, they appear to be identical to the previously approved (and showing) links.
I've looked around for the WSN Links Changelog (which I thought I had bookmarked, but I guess not) to see what PHP/dB calls changed to see if I could narrow down what it is requesting, but can't seem to find it anymore on webmastersite.net.
By the way, I do not have any unusual "if admin" loops in my template, and I triple-checked the HTML output to make sure it wasn't outputting in HTML but not displaying on the web page itself.
Any ideas as to where to look next would be greatly appreciated. I'm hoping this is specific to my install, but maybe not.
Thank you...
P.S. If anyone knows a quick way to "purge" all the previously unapproved links from the dB I'd appreciate it. I'm up to about 400 and would just like to clear the rows for easier data analysis. No big deal, but when I went to "Bulk Edit Links" I couldn't figure out how to pull just in the "deleted" links (although you can do it easily in "Search Items" but then I can't seem to take actions upon those results. I could of course easily delete them in MySQL, but I'm concerned it may torque other tables that cross-reference them somewhere. Thanks again.
The only way I can imagine that kind of difference between member and non-member for a category page is as a result of the cache system, with an old cache served up to guests while the current page is served to members. Do you have caching enabled for guests at Admin Panel -> Settings -> General? Or, do you have it set to enable guest caching when the server load exceeds a specified number?
An ownerid of 0 means nobody owns the link. That's correct if it was submitted by a guest. Doesn't affect who can view it.
If anyone knows a quick way to "purge" all the previously unapproved links from the dB I'd appreciate it.
Do you mean hard-delete soft-deleted ones? At Admin -> Miscellaneous -> Advanced Options, in the run SQL box, DELETE FROM {PREFIX}links WHERE validated=0 AND deleted=1; will do that. It won't cause any problems.
Well, I guess I was completely asleep. Thank you, Paul. At least someone is thinking logically and objectively. Of course!... the caching system! I had it set (for good reason) just as you said... it cached just for guests and not members or admins. It was set to refresh after 20 page views or 1000 hours, but I emptied the cache and reset it for 10 page views and 168 hours (1 week). The pages in question weren't highly viewed pages (deep internal links) and even though I was viewing them repeatedly, most of that was as an admin and I guess admin pages views don't count toward the cache refresh count which of course makes perfect sense. Why would they? I did view them as a "guest" in a separate browser but not enough times to kick the page refresh in gear.
Anyway, thank you for your help. I couldn't imagine that the upgrade had caused it, but it was the only thing that kept popping in my head.
Also, thank you for the SQL statement; that did the trick A-OK.
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.
Comments on Admin sees approved links after upgrade; public does not
Beginner
Usergroup: Customer
Joined: Aug 31, 2008
Location: Melbourne, FL
Total Topics: 3
Total Comments: 7
I'm having an issue with pending links that seem to be acting odd after the latest upgrade(s) which I did between the submissions and the approvals.
I had about 20 links to approve/decline in queue. After the recent upgrade warning about SQL-injection, I did the upgrade to 5.0.81 (and the prior 5 to 6 minor upgrades as well that I had been delaying). As usual, I skipped the auto-updates of customized templates. These particular updates did not cause the normal manual instructions for templates so I'm assuming (?) they were all PHP related and not template based.
After upgrade, I began approving/declining the links in the queue. All went normal and users received their approval emails.
However, they notified me they could not see their newly approved links. When logged in as "admin" I can see them in the category listing pages (displaylinks) just fine. But when logged out, the newly approved links disappear. However, both logged-in and logged-out users can view the individual link listing. The difference seems to be only on the category listing page.
I went and compared every field in the database between the newly approved links (that do not show) and the older approved links (that do show) and can't find any differences to which a database call could be making a difference. The only difference is ownerid which was showing as "0" for the newly approved links, although that did not seem to be unique. Not sure what zero means, but I changed the newly approved links to "1" (admin) in the WSN Links Admin Edit screen, but they still did not show on the category listing pages.
I'm out of guesses as to what happened or how I can fix it. I'm guessing something odd happened during the updates that caused a conflict from the submission time to the approval time (with the updates in between), so this may be very unique to just me. I haven't had a new suggested link yet since the upgrades so I don't yet know if this is going to continue or if it just relates to those links. There's only about 12 of them - so I could just update something in MySQL if I knew what to update, but as I said, they appear to be identical to the previously approved (and showing) links.
I've looked around for the WSN Links Changelog (which I thought I had bookmarked, but I guess not) to see what PHP/dB calls changed to see if I could narrow down what it is requesting, but can't seem to find it anymore on webmastersite.net.
By the way, I do not have any unusual "if admin" loops in my template, and I triple-checked the HTML output to make sure it wasn't outputting in HTML but not displaying on the web page itself.
Any ideas as to where to look next would be greatly appreciated. I'm hoping this is specific to my install, but maybe not.
Thank you...
P.S. If anyone knows a quick way to "purge" all the previously unapproved links from the dB I'd appreciate it. I'm up to about 400 and would just like to clear the rows for easier data analysis. No big deal, but when I went to "Bulk Edit Links" I couldn't figure out how to pull just in the "deleted" links (although you can do it easily in "Search Items" but then I can't seem to take actions upon those results. I could of course easily delete them in MySQL, but I'm concerned it may torque other tables that cross-reference them somewhere. Thanks again.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The only way I can imagine that kind of difference between member and non-member for a category page is as a result of the cache system, with an old cache served up to guests while the current page is served to members. Do you have caching enabled for guests at Admin Panel -> Settings -> General? Or, do you have it set to enable guest caching when the server load exceeds a specified number?
An ownerid of 0 means nobody owns the link. That's correct if it was submitted by a guest. Doesn't affect who can view it.
If anyone knows a quick way to "purge" all the previously unapproved links from the dB I'd appreciate it.
Do you mean hard-delete soft-deleted ones? At Admin -> Miscellaneous -> Advanced Options, in the run SQL box,
DELETE FROM {PREFIX}links WHERE validated=0 AND deleted=1;
will do that. It won't cause any problems.
Beginner
Usergroup: Customer
Joined: Aug 31, 2008
Location: Melbourne, FL
Total Topics: 3
Total Comments: 7
Well, I guess I was completely asleep. Thank you, Paul. At least someone is thinking logically and objectively. Of course!... the caching system! I had it set (for good reason) just as you said... it cached just for guests and not members or admins. It was set to refresh after 20 page views or 1000 hours, but I emptied the cache and reset it for 10 page views and 168 hours (1 week). The pages in question weren't highly viewed pages (deep internal links) and even though I was viewing them repeatedly, most of that was as an admin and I guess admin pages views don't count toward the cache refresh count which of course makes perfect sense. Why would they? I did view them as a "guest" in a separate browser but not enough times to kick the page refresh in gear.
Anyway, thank you for your help. I couldn't imagine that the upgrade had caused it, but it was the only thing that kept popping in my head.
Also, thank you for the SQL statement; that did the trick A-OK.