dp 2.0 running on IIS

[sdabel]

I know that IIS is not officially supported......

But I have upgraded dp 1.2 => 2.0 on our IIS server

PHP 4.3.11
IIS 5.0 (Windows 2000)
MySQL 4.0.20-standard running on Solaris 8 (SPARC 64)

Still under testing but looking good so far.....

Thanks for the great product.

regards
sean

[dumarjo]

running also with easyphp 1.8 on windows xp

:)

Jonathan

[efficiondave]

I've got it up and running on IIS as well though the upgrade wasn't exactly smooth...

When I selected the Upgrade DB and Config file selection the first time, I recieved the error listed at the bottom of this message... It seems it thried to install the DB rather than upgrade... I then tried to login and got an error that I didn't record... I then went and tried the install again and nothing happened... so then I restored my DB from the 1.0.2 version... and tried the upgrade once more and everything seems to be working fine since then.

Error I got after first install:
rogress:

Creating new Database
Installing database
There were 35 errors in 198 SQL statements
Creating new Permissions objects
Converting admin user permissions to Administrator Role
Searching for add-on modules to add to new permissions

ERROR: c:\[myhost]\projects\dotproject\includes\db_adodb.php(61): Error executing:

SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = 'user'


Backtrace:
0 c:\hosting\webhost4life\member\oledave\projects\do tproject\includes\db_adodb.php:61 dprint()
1 c:\hosting\webhost4life\member\oledave\projects\do tproject\includes\db_connect.php:131 db_exec()
2 c:\hosting\webhost4life\member\oledave\projects\do tproject\db\upgrade_permissions.php:170 db_loadlist('c:\\hosting\\webhost4life\\member\\ol edave\\projects\\dotproject\\includes\\db_adodb.ph p',61,0,'Error executing:

SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = \'user\'

')
3 c:\hosting\webhost4life\member\oledave\projects\do tproject\install\do_install_db.php:183 include_once('c:\\hosting\\webhost4life\\member\\o ledave\\projects\\dotproject\\db\\upgrade_permissi ons.php')
ERROR: Unknown column 'permissions_item_table' in 'field list'
Updating version information
Creating config


Database Installation Feedback: DB setup incomplete - the following errors occured:
Table 'companies' already exists
Table 'departments' already exists
Table 'contacts' already exists
Table 'events' already exists
Table 'files' already exists
Table 'files_index' already exists
Table 'forum_messages' already exists
Table 'forums' already exists
Table 'forum_watch' already exists
Table 'permissions' already exists
Table 'projects' already exists
Table 'task_log' already exists
Table 'tasks' already exists
Table 'tickets' already exists
Table 'user_tasks' already exists
Table 'users' already exists
Table 'task_dependencies' already exists
Table 'user_preferences' already exists
Column count doesn't match value count at row 1
Duplicate entry '1' for key 1
Duplicate entry '1' for key 1
Table 'modules' already exists
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1

Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.
Config File Creation Feedback: Config file written successfully

Login and Configure the dotProject System Environment

The Administrator login has been set to admin with a password of passwd. It is a good idea to change this password when you first log in
c:\hosting\webhost4life\member\oledave\projects\do tproject\includes\db_adodb.php(61): Error executing:

SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = 'user'

[ajdonnison]

Can you tell me what options you used in the installation screen? Like persistent connection, drop existing database, etc?

[tomandre]

Upgraded from 1.0.2 to 2.0. After a few tries and visits to the Issues pages, I'm up and running and it is looking good.

Essentially, there was one real problem and one perceived problem. Got a bunch of messages when the database was upgrading. Things looked OK at first, then couldn't see tasks -- error messages displayed.

I assumed the problem was the messages I saw during the install. However, according to issue 0000731, this was not it.

Instead, I found that by adding columns to the History table, everything worked OK. The entries were:
history_action varchar(10)
history_item int(10)
history_table varchar(15)

Thanks to all of you who worked on this great product!

[tcoates_au]

This is my log of the upgrade for v1.02 to 2.0. Readers can take what they want from this. hopefully, other users may benefit from my troubles. But it is now working... mostly, some reports appear not to work - see end of post for details.

Before upgrading I check the database structure for 1.02. ODD. Seemed we had a mix of 1.02 and 2. We had prev. tried to upgrade earlier, but would have thought that when the database was restore (from zip file) that v2.0 files/table were removed (by the users!?!?). Anyway,

delete user_access_log
delete user_event
delete task_contact
delete task_dep
delete gacl*
delete project_department

Got a few errors in installation....

dotProject Logo dotProject Installer
Progress:

Applying database updates
There were 0 errors in 198 SQL statements
There were 0 errors in 7 SQL statements
There were 1 errors in 8 SQL statements
Applying data modifications

ERROR: c:\inetpub\wwwroot\dotproject\includes\db_adodb.ph p(61): Error executing:

INSERT INTO project_departments (project_id, department_id) values (1, )


Backtrace:
0 c:\inetpub\wwwroot\dotproject\includes\db_adodb.ph p:61 dprint('c:\\inetpub\\wwwroot\\dotproject\\includes \\db_adodb.php',61,0,'Error executing:

INSERT INTO project_departments (project_id, department_id) values (1, )

')
1 c:\inetpub\wwwroot\dotproject\db\upgrade_to_20.php :54 db_exec('INSERT INTO project_departments (project_id, department_id) values (1, )')
2 c:\inetpub\wwwroot\dotproject\install\do_install_d b.php:174 dpupgrade('1.0.2','2.0','')

ERROR: c:\inetpub\wwwroot\dotproject\includes\db_adodb.ph p(61): Error executing:

INSERT INTO project_contacts (project_id, contact_id) values (1, )


Backtrace:
0 c:\inetpub\wwwroot\dotproject\includes\db_adodb.ph p:61 dprint('c:\\inetpub\\wwwroot\\dotproject\\includes \\db_adodb.php',61,0,'Error executing:

INSERT INTO project_contacts (project_id, contact_id) values (1, )

........

Converting users to contacts
Creating new Permissions objects
Converting admin user permissions to Administrator Role
Searching for add-on modules to add to new permissions
Adding Task Log permissions
Fetching companies list
Contact's company updated - (1) Gary Penner - (10) RMST
Contact's company updated - (2) Andrew Boyd - (10) RMST
Contact's company updated - (4) Barbie Holland - (11) RMS Telecommunications
Error found in contact_company in the contact (6) Stewart Foote
Error found in contact_company in the contact (7) Barbara Holland
Error found in contact_company in the contact (9) Tim Coates
Error found in contact_company in the contact (13) Mike Chando
Error found in contact_company in the contact (14) guest guest
Error found in contact_company in the contact (15) Sandra Briley
Updating version information
Creating config


Warning: fopen(../includes/config.php): failed to open stream: Permission denied in c:\inetpub\wwwroot\dotproject\install\do_install_d b.php on line 222


Database Installation Feedback: DB setup incomplete - the following errors occured:
Can't DROP 'idx_wcnt'; check that column/key exists

Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.
Config File Creation Feedback: Config file could not be written

Had to fix config file:

o rootdir variable - copied from config.dist file

But was still able to login as tim

Viewing tasks

o Windows does not support dates prior to midnight
o Hacked pear timezone.php:

function inDaylightTime($date)
{
return date("I");
return date('I', $date->getDate(DATE_FORMAT_UNIXTIME));

Also Had to patch setup.php in timcard module:

//require_once( $AppUI->cfg['root_dir'].'/modules/system/syskeys/syskeys.class.php' );
require_once( dPgetConfig( 'root_dir' ).'/modules/system/syskeys/syskeys.class.php' );

Had to hack vw_timecard.php in timecard module:

$min_hours_week =count(explode(",",dPgetConfig("cal_working_days"))) * $min_hours_day;

More problem viewing tasks:

o somehow lost index file for task_dependencies
o only had a .frm file
o deleted the .frm and recreated table

Reports

o tasks currently overdue report generates error...
o file does not start with %pdf-
o task log repors though as pdf
o complained about permssions also
o set files/temp so everyone has full access (opps)
o ditto for lib/ezpdf and lib/expdf/fonts

Tim

[tcoates_au]

PS. Is it possible to attach a log to a post. I would like to have attached the log from the installation, but not sure if this is possible? Thanks.

[efficiondave]

Can you tell me what options you used in the installation screen? Like persistent connection, drop existing database, etc?

I enter the db connect info, I did not check Use Persistent Connection or Drop Existing Database, I clicked UpgradeDB & Write cfg...

I upgraded my live site (after a backup).

[blue]

For what its worth, I was seeing similar errors. And trying to use the product, I could not assign anthing to anyone. No choices would show up under Human Resources.
I had unpacked my dotproject 2 directory right over my dotproject 1.0.2 directory. I did it again with a clean copy of dotproject 2 (i.e. I didn't unpack it over an old installation) and then I copied the includes/config.php file from the old installation to the new, clean dotproject 2 installation (so that it would recognize that it needed to upgrade). I then ran through the install/upgrade process and it seems to have worked much better. I still got a number of errors reported when upgrading the database, but everything else is working MUCH better.

[pedroa]

Hi,

Just wanted to add, and leave to the developers consideration that there are several Server Superglobals (things accessed by $_SERVER['SUPERGLOBAL'] in php) that are available in Apache and not in IIS, and vice-versa (the vice-versa is neglectable since dP is based on Apache foundations).

For example $_SERVER['REQUEST_URI'] is not available trough IIS 5.1, and this SuperGlobal is invoked at least 5 times by dP:
modules/calendar/index.php lines 50,56,61
modules/calendar/vw_day_events.php line 66
modules/calendar/week_view.php line 53
and gacl admin about 5 times in 5 files (this has nothing to do directly with dP functioning)

I add a nice link with all these Superglobals for you to dig and watch carefully:
http://koivi.com/apache-iis-php-server-array.php

Pedro A.