Results 1 to 2 of 2

Thread: Installation failure with mySQL error creating default Sugar Data

  1. #1
    pbwebguy is offline Member
    Join Date
    Sep 2006
    Posts
    5

    Default Installation failure with mySQL error creating default Sugar Data

    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;

  2. #2
    pbwebguy is offline Member
    Join Date
    Sep 2006
    Posts
    5

    Default Re: Installation failure with mySQL error creating default Sugar Data

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •