Installation failure with mySQL error creating default Sugar Data

[pbwebguy]

When I ran the installation it bombed when trying to insert data with a datetime value.

Creating default Sugar data

Inserting default settings... done
Creating default users... done
Creating default scheduler jobs... Query Failed:INSERT into schedulers set id='df880d21-5be6-ada9-93e4-45193d53ea7c', deleted='0', date_entered='2006-09-26 14:49:09', date_modified='2006-09-26 14:49:09', created_by=null, modified_user_id='1', name='Check Inbound Mailboxes', job='function:ollMonitoredInboxes', date_time_start='2000-01-01 H:00:00', date_time_end='2000-01-01 H:00:00', job_interval='*::*::*::*::*', status='Active', catch_up='0'::MySQL error 1292: Incorrect datetime value: '2000-01-01 H:00:00' for column 'date_time_start' at row 1

Environment:

Windows XP
Sugarcrm 4.5
Php 4.4.2
mySQL 5.0.22

Note: I had to work around the PHP 4.x/mySQL 5 password issue that isn't documented in your installation instructions. It might be worth mentioning in your docs. Here's the commands that I had to issue, after creating the user 'sugarcrm'.


GRANT ALL ON sugarcrm TO sugarcrm;

UPDATE mysql.user SET Password = OLD_PASSWORD('my-secret-password') WHERE user='sugarcrm';

flush PRIVILEGES;

[pbwebguy]

I got into the application since the error and found that I get the same error in the "Rebuild Schedulers" utility.

I examined the installation code and found that the problem was in fact the rebuildDefaultSchedulers call in the performSetup.php.

// default OOB schedulers
echo $line_entry_format.$mod_strings['LBL_PERFORM_DEFAULT_SCHEDULER'].$line_exit_format;
$scheduler = new Scheduler();
// $scheduler->rebuildDefaultSchedulers();
echo $mod_strings['LBL_PERFORM_DONE'];

I commented out the one line and re-ran the install.php script. Note, that the instructions mention adding the line:

'installer_locked' => false,

to the config.php script. The problem is that further down in the script, there is one that is set to:

'installer_locked' => true,

So you need to remove or edit it appropriately.

Anyways, I got past the creating tables step and when I click the Next button for the install, Apache CRASHES.
I'm running Apache 2.0.55

Here is the apache error log:

[Tue Sep 26 11:49:25 2006] [notice] Apache/2.0.55 (Win32) SVN/1.3.0 PHP/4.4.2 DAV/2 configured -- resuming normal operations
[Tue Sep 26 11:49:25 2006] [notice] Server built: Oct 9 2005 19:16:56
[Tue Sep 26 11:49:25 2006] [notice] Parent: Created child process 3272
[Tue Sep 26 11:49:25 2006] [notice] Child 3272: Child process is running
[Tue Sep 26 11:49:25 2006] [notice] Child 3272: Acquired the start mutex.
[Tue Sep 26 11:49:25 2006] [notice] Child 3272: Starting 250 worker threads.
[Tue Sep 26 11:51:36 2006] [error] [client 192.168.1.199] PHP Notice: Undefined variable: currentModuleFile in C:\\opt\\SugarCRM\\SugarSuite-Full-4.5.0b\\index.php on line 344
[Tue Sep 26 11:51:36 2006] [error] [client 192.168.1.199] PHP Warning: load_menu(modules//Menu.php): failed to open stream: No such file or directory in C:\\opt\\SugarCRM\\SugarSuite-Full-4.5.0b\\include\\utils.php on line 274
[Tue Sep 26 11:51:36 2006] [error] [client 192.168.1.199] PHP Fatal error: load_menu(): Failed opening required 'modules//Menu.php' (include_path='.;c:\\php4\\pear') in C:\\opt\\SugarCRM\\SugarSuite-Full-4.5.0b\\include\\utils.php on line 274
[Tue Sep 26 11:53:17 2006] [notice] Parent: Received restart signal -- Restarting the server.