I am getting the following two errors when visiting the list of patches (../admin/build/patch):

user warning: Unknown column 'field_module_value' in 'field list' query: SELECT COUNT(*) FROM (SELECT node.nid AS nid, node.created AS node_created, node.title AS node_title, node.language AS node_language, field_module_value AS unknown FROM node node WHERE node.type in ('patch') ) count_alias in ../sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.

and

user warning: Unknown column 'field_module_value' in 'field list' query: SELECT node.nid AS nid, node.created AS node_created, node.title AS node_title, node.language AS node_language, field_module_value AS unknown FROM node node WHERE node.type in ('patch') ORDER BY unknown ASC LIMIT 0, 10 in ../sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1119.

Note: This is in a fresh installation of patch manager without any patch nodes created, so the list should be empty.

I'm using the latest 3.x-dev of views (mentioning because it is in both warnings) and this is in a php 5.3.x environment (mentioning because I've had various php related issues after the upgrade from 5.2.x).

Comments

DrewMathers’s picture

DrewMathers commented
Status: Active » Fixed

I got the same thing in 6.x-1.2 when I allowed Patch Manager to enable its dependencies on the Modules page. In addition to the error, some the fields were missing from the Patch content type, including the filefield. Letting modules enable their own dependencies can be problematic because sometimes the module enables itself before one of its dependencies.

I fixed the problem by:
1. Disable Patch Manager
2. Uninstall Patch Manager (/admin/build/modules/uninstall)
3. Re-enable Patch Manger

If this doesn't work for you, please re-open this issue.

klonos’s picture

klonos
he/him
Primary language English
Location 90% Melbourne, Australia - 10% Larissa, Greece
commented

I agree with setting this to fixed. I would have set it so myself, but it slipped off my radar somehow and thus was left active. It's been quite some time now since the time I reported this and I got the issue fixed somehow (I guess I must have done what you explain Drew - can't recall). I never came across it since, but I will re-open if I -ever- see this again and the steps above do not solve it. Thanx ;)

aidanlis’s picture

aidanlis commented

I can't replicate this, I just did a fresh install twice and nothing.

Let me know if it happens again.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Aldu_boy’s picture

Aldu_boy commented
Issue summary: View changes

Solution in #1 solved the issue!
Thanks!