Hello.
After installing the mentioned version of the module, I've got a trouble vith the views on my website (core 7.43)
I've several views, some like the simple default tracker, others involving data on leaflet maps.
After enabling the module, the views don't show any data. The tracker view, as well as others just shows a php message with memory used, execution time etc. Those with maps instead, sometimes show the same error, other times warn me that there's no data to display. Infact not only is the map empty, but the map itself isn't shown anymore.
Disabling the module brings thinks back to normal
Fields selected for the views include, among the others, "(author) User: Name (Author)" or "(author) User: Name (User)".
I've never encrypted the username, only the email (btw in the config I can't unflag encrypt email field even after decrypting it, becasue a msg said it is required; but in the db it isn't encrypted anymore.... mah)

I suspect somehow the display of an encrypted field data of users interferes with views module.
Thank you
Kinmen

Comments

kinmen created an issue. See original summary.

pifagor’s picture

I will try to fix it as quickly as possible

kinmen’s picture

Thank you very much

pifagor’s picture

Good day. You can get more information? Screenshots problems?

pifagor’s picture

Status: Active » Postponed (maintainer needs more info)
kinmen’s picture

Hello. Do you want a screenshot? Of a view?

The views show errors like this:
Warning: Invalid argument supplied for foreach() in views_handler_field->advanced_render() (line 1053 of .../sites/all/modules/views/handlers/views_handler_field.inc).

The query for tracker view is:

SELECT node.type AS node_type, node.title AS node_title, node.nid AS nid, node.language AS node_language, users_node.name AS users_node_name, users_node.uid AS users_node_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, history.timestamp AS history_timestamp, node.created AS node_created, node.changed AS node_changed, DATE_FORMAT((DATE_ADD('19700101', INTERVAL node.created SECOND) + INTERVAL 7200 SECOND), '%Y%m%d%H%i') AS node_created_minute
FROM 
{node} node
LEFT JOIN {users} users_node ON node.uid = users_node.uid
INNER JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN {history} history ON node.nid = history.nid AND history.uid = '1'
WHERE (( (node.status = '1') )AND(( (node.type IN  ('article', 'blog')) )))
ORDER BY node_created_minute DESC
LIMIT 25 OFFSET 0

With enabled module and a logged user, the views are EMPTY, html shows only basic tags like head and body.
If user isn't logged, some views, like tracker, are shown BUT they are messed up! For example the Title field shows instead the Author, which is anyway displayed in the Author Field...
In other views instead, without logged user, only an empty container is displayed and sometimes there's a warning about nothing to show because the fields selected as a filter in the view (in my case: must be not empty) are empty; but they aren't! If I disable the module and the role for the user, everything goes back as normal

Something weird which I don't understand and could maybe give you a clue, is that when no user has encrypt field role assigned, and I unflag Mail (the only I use) under User fields, I always get an error "User fields field is required." which I don't understand.

My impression is like somehow fileds in the nodes have been shifted...
Thank you

kinmen’s picture

Hello, any progress with the issue?

kinmen’s picture

I'm still investigating. I've applied a patch (#15) to core (https://www.drupal.org/node/1874768) to avoid a warning about DATE which I was getting. I've found something in the tracker view which simply displays in a table the last nodes of type Article (for example):
If your module is disabled, the view is correctly displayed.
If it is enabled, the time of all the posts (articles) is set to "Thu, 01/01/1970 - 01:00", and the type of the node is shown only for the first raw. Moreover, except in the first raw, the field "title" has been filled up with the "Author" field, and therefore the links don't work anymore because they point to not existing nodes.

The same data (more or less) displayed on a map works if module is disabled, but with enabled module I just get a blank page with: "Page execution time was 2366.31 ms. Memory used at: devel_boot()=2.98 MB, devel_shutdown()=77.98 MB, PHP peak=120 MB."

Is it possible that your module somehow modifies / encrypts any Date data of the user, so that I get that messed up views?

pifagor’s picture

Sorry, but I have not been able to reach a solution. Once have time, I fix my problem.

pifagor’s picture

Status: Postponed (maintainer needs more info) » Active
alex_optim’s picture

Status: Active » Needs review
StatusFileSize
new718 bytes

Fixed problem with relapse author name in views.
Create patch.

  • pifagor committed 86aede4 on 7.x-1.x authored by alex_optim
    Issue #2798749 by alex_optim: compatibility issue with views
    
pifagor’s picture

Status: Needs review » Fixed
pifagor’s picture

Status: Fixed » Closed (fixed)
pifagor’s picture