vw_idx_proposed.php

[rightbyte]

After installing the latest code from CVS, I get the following error when trying to access the project module and then no projects are listed:

Invalid argument supplied for foreach() in C:\www\mysite.com\dotproject\modules\projects\vw_i dx_proposed.php on line 61

In the upgrade process from 1.0.2-1 to the latest CVS files, I simply copied my db folder, config.php, and dotproject/files folder into the new installation.

Any ideas? Thanks :)

[rightbyte]

Has the database structure changed since 1.0.2-1?

[miinx]

Yes, there are 4 new fields for the Projects table, plus some other changes, not sure if that would cause your error tho.

Did you run upgrade_latest.sql & upgrade_latest.php?

They're in /db from the latest CVS

cheers
miinx

[rightbyte]

Thanks.

When I run the sql, I get the following error message:

ERROR 1062 at line 42: Duplicate entry '2' for key 1

The code at line 42 is:

UPDATE modules SET permissions_item_table='forums', permissions_item_field='forum_id', permissions_item_label='forum_name' WHERE mod_directory='forums';

Any ideas?

Thanks again :)

[rightbyte]

Actually the code at line 42 may be something else - I think I was counting commented lines whereas the SQL interpreter doesn't.

Also, when I ran upgrade_latest.php, I received the following error:

Fatal error: Call to undefined function: db_loadlist() in c:\www\mysite.com\dotproject\db\upgrade_latest.php on line 8

It looks like it might be time to reinstall(?) I'd hate to do it because I would lose all my projects and tasks. Can I reinstall and somehow preserve projects and tasks?

Thanks :oops:

[PoMM3]

I got the db_loadlist pb!!!! too!!!

[rightbyte]

So it's not just me :)

Is anyone looking into this?

[Revelation7]

Well, I looked, seems like db_loadlist is part of includes/db_conect.php, so I added a require statement in upgrade_latest.php, but got these errors:
Warning: main(/includes/db_.php): failed to open stream: No such file or directory in /home/revelati/public_html/dotprojectcvs/includes/db_connect.php on line 9

Fatal error: main(): Failed opening required '/includes/db_.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/revelati/public_html/dotprojectcvs/includes/db_connect.php on line 9
seems that the AppUI stuff in db_connect.php did not work/translate. It is like a chicken and egg thing, should this script be run once you logged into the system?

[rightbyte]

I tried to include db_connect.php as well with the following results:

Notice: Undefined variable: AppUI in C:\www\mysite.com\dotproject\includes\db_connect.p hp on line 9