I read through some old bug reports and thought this had been fixed.

Im trying to set up a new site based on Drupal, of which the Projects module will play a big part, but so far cannot find a version of the module that works. Having read about this issue being previously fixed in cvs, I am now running the latest (today) versions of both drupal and the project module, from cvs HEAD.

The problem is that unless I create a release file, projects still do not show up on the project list. With the new taxonomy changes, when I select a first level term, and get the "by name, by category, by date" tabs no projects are displayed after clicking any of the tabs.

If I create a release file for any of my projects, the project then shows up, but only under "by category" under the appropriate second level term. The project still does not show up under "by name" or "by date". Ive looked at the code, but Im not familiar with drupal code yet and couldnt see anything obvious.

I build 3d models for a certain game. These can take months to complete. I would like to use drupal for a site supporting this, but the project manager needs to be able to display projects without releases. Even before the model is finished, there is a need to manage tasks and feature requests, long before any release is considered. My sites users need to be able to see what projects I am working on, and how they are progressing. Even when the model is released, there are other ways to distribute it, and its not likely that it will be put up on my site for download, meaning I dont need releases at all. Having a link to download a 0 byte file, just to make things work, is confusing for the users.

I know that the module is being actively worked on in cvs, and understand that sometimes cvs is broken. Im just pointing out that it still seems to be broken, as I couldnt see any open issues about this.

Comments

nedjo’s picture

nedjo
he/him/his
Primary language English
commented

Thanks for the report. We did indeed remove the requirement for releases, but since then there have been a number of changes. I'll try to determine if and where we've broken the ability to view projects without releases.

nedjo’s picture

nedjo
he/him/his
Primary language English
commented
Assigned: Unassigned » nedjo
Status: Active » Fixed

We were filtering by version when we weren't supposed to be. I've changed the test for project_browse_releases variable from -1 (this was a confusion with another variable, project_release_overview) to 0, and this seems to fix the issue.

Please try a fresh CVS version (project.module file was changed) and reopen this issue if it doesn't work now.

dan_aka_jack’s picture

dan_aka_jack commented
Status: Fixed » Active

Hi there,

I'm afraid it's not working for me. I'm running the most recent version on the project module and drupal (from CVS).

Details of the problem:

Browse by category
Shows the category description but nothing else. There is a collapsable "Categories" fieldset but there's nothing within the fieldset

Browse by date

I get this error:

user warning: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near
 '(n.nid))) FROM node n INNER JOIN node_revisions nr ON n.vid = nr.vid INNER JOIN '
 at line 1 query: SELECT COUNT(DISTINCT(pr.DISTINCT(n.nid))) FROM node n INNER JOIN
 node_revisions nr ON n.vid = nr.vid INNER JOIN project_projects p ON n.nid = p.nid LEFT JOIN
 term_node r ON n.nid = r.nid INNER JOIN project_releases pr ON n.nid = pr.nid
 WHERE n.status = 1 AND r.tid = 21 ORDER BY pr.changed DESC, n.sticky DESC,
 n.title ASC in /var/www/html/intranet/includes/database.mysql.inc on line 118.

It shows the category description but then only shows one project (which has a release).

Browse by name

Seems to work perfectly!

Details of my setup:

* PHP 4.4.0
* MySQL 4.1.13
* I'm using the taxonomy module
* Most of my projects don't have releases (I'm using the project module as a "to do" list for building a website)
* I'm not using multi-level categories (i.e. I just have a "Projects" vocabulary with two terms in it)
* admin > settings > project > browse projects by releases = UNCHECKED
* admin > settings > project > default release overview = ALL
* cron.php runs daily

dan_aka_jack’s picture

dan_aka_jack commented

Hi,

I've just updated to project.module v1.230 (thanks for attempting a fix so quickly).

The MySQL errors are gone but I'm afraid the "browse by date" and "browse by category" tabs still show no projects.

nedjo’s picture

nedjo
he/him/his
Primary language English
commented

Categories will show only if there are categorized projects (in terms below the first-level ones).

For the dates problem, I think we need to change how we sort by date, see this issue:

http://drupal.org/node/50070

solipsist’s picture

solipsist commented

I got the same problems, when I finally got the tabs working, there's nothing listed, just a header saying Projects and nothing else. Will try CVS version and see if it helps.

solipsist’s picture

solipsist commented

Ok, done. I'm using 4.6.5, I get this PHP error:

Fatal error: Call to undefined function drupal_get_form() in /home/jakobper/public_html/modules/project/project.module on line 475

So I suppose the CVS version only works with 4.7.x, right?

Any suggestions what I can do?

Thanks.

nedjo’s picture

nedjo
he/him/his
Primary language English
commented
Status: Active » Fixed

Right, this is only for 4.7/HEAD.

Marking this fixed as I think the issue is not addressed.

solipsist’s picture

solipsist commented

Ok. What about us using the 4.6.x release, what can we do? How I fix it? Can you backport some code? I'd love to use the Projects module, such a shame it won't work.

dries’s picture

dries commented

This is intentional. On drupal.org, we don't want to list projects without release.

solipsist’s picture

solipsist commented

Ok but then why put a checkbox in the module settings for it then if it isn't optional? Makes no sense...

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)