Installed from scratch on Debian/Sid; linux 2.4.18, apache 1.3.31, mysql 4.0.18, php 4.3.4.

Trying to view any project listing produces the following:

Warning: Invalid argument supplied for foreach() in /home/httpd/dotproject/modules/projects/vw_idx_proposed.php on line 58

..which has been reported elsewhere already. The line is:
foreach ($projects as $row) {
..and should maybe be
if(is_array($projects)) foreach ($projects as $row) {
or some such. I can confirm that the projects I created were actually added to the database (through MySQL, as the same user dotproject uses, though they appear nowhere in the interface).

In any case, there is also a red X at the bottom of the page, with the error: Table 'dotproject.tasks_sum' doesn't exist. The tasks_sum table isn't created in the schema; glancing briefly at the code it seems to be a temporary table?

Thanks; any suggestions welcome (I need something up and running today, so I'll probably be moving on for the moment, but I'll leave this install up for a bit and see if there is a fix..)

added note: I noticed a similar topic further down regarding the privileges necessary to create temporary tables... I didn't modify the code/schema, but I did make sure that those privs were granted.. no difference..

thanks..

If you have permissions to create the temporary tables, then this should work, unless the version of MySQL has other problems with temp tables. Also IIRC there is a discussion on modifying the code to remove the need for temporary tables, you might want to have another look around and see if you can find the thread.