I received the following error when trying to create a project issue:

"user warning: Unknown column 'prsv.snapshot' in 'where clause' query: SELECT DISTINCT(n.nid), n.created, r.* FROM node n INNER JOIN project_release_nodes r ON r.nid = n.nid WHERE (r.pid = 148) AND (n.status = 1) AND r.rebuild = 1 AND prsv.snapshot = 1 ORDER BY r.version_major DESC, r.version_minor DESC, r.version_patch DESC, r.file_date DESC in D:\htdocs\includes\database.mysql.inc on line 172."

also when submitting issues to a project I get:

"user warning: Table 'drupal.project_issues' doesn't exist query: SELECT DISTINCT(n.nid), n.title, COUNT(ni.nid) AS count, MAX(ni.changed) AS max_issue_changed FROM node n LEFT JOIN project_issues p ON n.nid = p.pid AND p.sid IN (1,2,4) LEFT JOIN node ni ON ni.nid = p.nid AND ni.status = 1 WHERE n.type = 'project_project' AND n.status = 1 AND n.uid = 15 GROUP BY n.nid, n.title ORDER BY n.title ASC in D:\htdocs\includes\database.mysql.inc on line 172."

Here are the modules that i have installed and enabled:

Project 5.x-1.2 Provides a project node type and browsing of projects.
Required by: Project issue tracking (enabled), Project releases (enabled), Project usage (enabled)
Project issue tracking 5.x-2.2 Provides issue tracking for the project.module.
Depends on: Project (enabled), Comment (enabled), Comment upload (enabled), Upload (enabled)
Required by: Project issue generator (disabled)
Project releases 5.x-1.2 Provides a release node type to represent releases of projects.
Depends on: Project (enabled), Taxonomy (enabled)
Required by: Project usage (enabled)
Project usage 5.x-1.2 Provides data about installed usage of projects (requires update_status.module clients connecting to this site -- most sites should NOT enable this module).
Depends on: Project (enabled), Project releases (enabled)

I do not have this one enabled:
Project issue generator

Here are the tables I have in mysql
project_issue_comments
project_issue_projects
project_issue_state
project_projects
project_release_nodes
project_release_package_errors
project_release_projects
project_release_supported_versions
project_subscriptions
project_usage_day
project_usage_raw
project_usage_week_project
project_usage_week_release

and indeed there is no table called 'project_issues'; I am not sure exactly how to address this.

I am a total newbie to drupal and the project/project issues modules so any help would be greatly appreciated.

Thanks,

Sean

Comments

webchick’s picture

Status: Active » Closed (cannot reproduce)

I'm going to be bold here and say that an issue from 5 years ago is no longer relevant in the D7 version of the code.