Newbie Question
| Project: | Organic groups |
| Version: | 5.x-3.1 |
| Component: | og.module |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
I've installed og and all seem to be working fine except when I click "Group" on My recent section, error is generated:
user warning: Unknown column 'og_node_data_title' in 'order clause' query: SELECT DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_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 FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node og_node_data ON og_ancestry.group_nid = og_node_data.nid LEFT JOIN og_uid og_uid_node ON og_node_data.nid = og_uid_node.nid AND og_uid_node.is_active = '1' INNER JOIN users users ON node.uid = users.uid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en-gb' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.status = '1') AND (og_uid_node.uid = '1') ) ORDER BY og_node_data_title ASC LIMIT 0, 25 in /home/hopuicom/public_html/includes/database.mysql.inc on line 172.
Also, what is My unread suppose to do? All it does on my setup is take me to my homepage. By clicking "read more" on posts makes no difference.
#1
Off the top of my head: this looks like the kind of error you'd get if an earlier version of OG was installed, you upgraded to the current version, but did not update your data tables. Try running the module update script (Administer/Modules and find the link to the update script).
Absent that, try uninstalling and reinstalling the module.
Good luck!
#2
To track down this problem, I installed a fresh copy of drupal 5.2 and og. Error again:
user warning: Unknown column 'og_node_data_title' in 'order clause' query: SELECT DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_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 FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node og_node_data ON og_ancestry.group_nid = og_node_data.nid LEFT JOIN og_uid og_uid_node ON og_node_data.nid = og_uid_node.nid AND og_uid_node.is_active = '1' INNER JOIN users users ON node.uid = users.uid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (og_uid_node.uid = '1') ORDER BY og_node_data_title ASC LIMIT 0, 25 in C:\xampp\htdocs\includes\database.mysql.inc on line 172.
#3
Problems no longer exist after installing og-5.4.0rc7
#4