After upgradeing from 4.4 to 4.5 and some time (1/2 a hour?) I get 20 empty listings with the head "Updated more than 305802 hours ago:"

Any way to reset the counter? TIA

Comments

bertboerland’s picture

bertboerland commented

after about one hour everything was fine again.

Bèr Kessels’s picture

Bèr Kessels commented

any idea what might have caused this?

bertboerland’s picture

bertboerland commented

no, I was bizzy wit implenting all the modules and configuring them. I am sure that cron has run before the rror resulting in a good weblink block. I do have my host synchronised with an ntp server so exterme time shift are not an option. I quess one variable went over the hill.

bertboerland’s picture

bertboerland commented

For anonymous users (see htpp://willy.boerland.com/myblog) the weblink is still empty. Registerd users have a normal weblink (try to login with your drupal id in case you want to check this)

ericatkins’s picture

ericatkins commented

My account. I recently posted to the forums (http://drupal.org/node/13289)

I recently started getting this bug on 2 sites:

When users without the permission to "administer nodes" visits http://cookedgamers.net, my weblinks monitor says:

Monitored weblinks
Updated more than 305856 hours ago:
*
*
*
*
*
*
*
*
*
*
etc.

-------------

So basically, everyone who is not an admin on the site can not use the Monitored weblinks block. When users are given permission to "administer nodes" the Monitored weblinks appear as normal.

This case has happened recently on 2 sites. Both sites were running idential modules. On both sites, I deactivied the node_privacy_byrole module. I suspect that node_privacy_byrole is causing the error, however, this may not be the case as I did more tinkering with the sites before I realized the error.

Has anyone ran into this problem before?

Can anyone offer some direction as this module is an important module to my sites.

Bèr Kessels’s picture

Bèr Kessels commented

just to be able to exclude certain problems:
"Do you have Cache enabled? "
Admins do not see cached pages, while ano users do!

Bèr

bertboerland’s picture

bertboerland commented

I disabled caching (was enabled) and still the pages for non admin have the weird time offset and an empty list.

ericatkins’s picture

ericatkins commented

I disabled caching (was enabled) and still the pages for non admin have the weird time offset and an empty list.[/quote]

Same case for me. :(

junyor’s picture

junyor commented
Title: Updated more than 305802 hours ago: » Monitored weblinks aren't shown in the block correctly
Component: Miscellaneous » Code

From the sounds of it, something is failing in weblink_monitor_list(), causing the weblink nodes not to be loaded. The numbers people are seeing is simply floor(time() / 3600). From a look at the code, I'd say the most likely culprit is the node_load() function. I have no idea what the problem is or how to fix it, though.

And, for the record, I'm seeing this problem too. :(

hafif uyku’s picture

hafif uyku commented

In case of an emergancy: this problem goes away if you remove the ". node_access_join_sql() ." and AND ". node_access_where_sql()." from the weblink_monitor_list() query.

bertboerland’s picture

bertboerland commented

thanks. this IS the line that is causing the problem looking by the time minus 604800 part. however deleting these two statements dindt do it for me (now both anonymous and registerd users have an empty list :-(

here the diff to make sure I did the right thing:

diff weblink.module weblink.module.org
612c612
< $result = db_query_range("SELECT * FROM {weblink} n WHERE change_stamp > ". (time() - 604800) ." AND ORDER BY change_stamp DESC", 0, $limit);
---
> $result = db_query_range("SELECT * FROM {weblink} n ". node_access_join_sql() ." WHERE change_stamp > ". (time() - 604800) ." AND ". node_access_where_sql()." ORDER BY change_stamp DESC", 0, $limit);

The line above this part makes the users global so I dont get why anonymous users are treated in another way than logged in users? Any more hints are welcome.
--
groets,
bertb

Bèr Kessels’s picture

Bèr Kessels commented

I have an idea, but no time to test or proof it.
Cron is ran as anonymous, but uses some functions. Thus the functions called by cron, should allos anonymous to "do stuff".
The access_sql will disallow cron to do his job.
\
Bèr

m_freeman2004’s picture

m_freeman2004 commented

Hi,

I'm getting the same problem under 4.5.0. Any ideas yet?

Marcus.

Anonymous’s picture

(not verified) commented

In case of an emergancy: this problem goes away if you remove the ". node_access_join_sql() ." and AND ". node_access_where_sql()." from the weblink_monitor_list() query.

This was really close.

Still, no answer to this problem though.

bertboerland’s picture

bertboerland commented
Title: Monitored weblinks aren't shown in the block correctly » [10 euro for the person solving this] Monitored weblinks aren't shown in the block correctly

So hereby I offer 10 Euro to the person who solves this problem. Might be a problem when you are from outside the EU. If you dont want the 10 E I will double it and donate it to a charity cause (including OSS projects like drupal itself) picked by you.

So you want to help me and others out here, and make a buck or donate two, try to solve this one.

James Addison’s picture

James Addison commented

Has their been any input on this outside of this 'issue' thread? Has anyone expressed an interest or knowledge that would help in fixing it? I took a quick look last night, but I'm not familiar enough with the code. I guess I'll keep trying, though.

junyor’s picture

junyor commented

Well, I think it's pretty clear that it's a permission problem. If you look at the last several comments, there's a good bit of information there about work-arounds and analyses.

ericatkins’s picture

ericatkins commented

I really wish there was a solution for this, also. A lot of people were visiting my sites just to see when other sites were updated.

I have dug around in the code and had a partial solution like some of the others in this thread.

I'll throw in $20 via paypal to anyone that gets this problem solved.

bertboerland’s picture

bertboerland commented
Title: [10 euro for the person solving this] Monitored weblinks aren't shown in the block correctly » [30 euro for the person solving this] Monitored weblinks aren't shown in the block correctly

Which sums up to 30 euro for just a bit of debugging ;-) any takers?

ericatkins’s picture

ericatkins commented

I don't think many people view this page. :(

Bèr Kessels’s picture

Bèr Kessels commented

I do,

But unfortunately I am being held on other tasks ATM. But most impoartantly: we are revising the complete links system. So fixing this makes littkle sense, since a few weeks after the 4.6 the new system will see daylight. Hence the old weblinks will probably not be updated for CVS/4.6.

Bèr

James Addison’s picture

James Addison commented

I'm hoping that the old weblinks will migrate over to the 'new' model during the upgrade process - is it fair to assume that, Bèr?

Thanks,

James Addison
http://www.pjsoft.ca

Bèr Kessels’s picture

Bèr Kessels commented

No, not really.
Most functionality will be replaced, but certainly not all. For example the directory system will surely be removed.

James Addison’s picture

James Addison commented

Actually, I was referring to the content of the weblinks - the URLs, descriptions, etc. I have confidence that the necessary functionality will be retained, in a new form that makes sense. I would just hate for users to lose their weblink information.

Thanks,

James Addison
http://www.pjsoft.ca

Bèr Kessels’s picture

Bèr Kessels commented

Yes, I will not release my new weblinks systems, untill I have proper update scripts/systems or backwards compatibility systems in place.

bertboerland’s picture

bertboerland commented

Ber, any idea when / if you will release a new weblink version for 4.6?

Bèr Kessels’s picture

Bèr Kessels commented

I was promised to get some patcheslast monday, but I guess somewhere before coming weekend we will be able o do some mayor upgrades.

Bèr Kessels’s picture

Bèr Kessels commented
Status: Active » Closed (won't fix)

All features etc are blocked for 4.7. please move over to the links project.