installation on windows 7

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Am getting these 2 errors on Perform Setup page how do i solve this
Creating SuiteCRM configuration file (config.php)

Creating SuiteCRM application tables, audit tables and relationship metadata
Creating the database 54 on localhost…done

…
[color=#bb4400]Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\one\suitecrm\modules\AOR_Reports\AOR_Report.php on line 85[/color]
…
[color=#ff4400]Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\one\suitecrm\modules\AOW_WorkFlow\AOW_WorkFlow.php on line 89[/color]
…

Creating default SuiteCRM data

 Creating default users...   done
 Creating default scheduler jobs...   done

The setup of SuiteCRM is now complete!
Total time: 45.298295021057 seconds.
Approximate memory used: 43993200 bytes.

2

Hi Weed,

These are just warnings. You can disable these from showing in your CRM by editing your php.ini error reporting settings.

Thanks,

Will.

3

Hi weed,

You could suppress the errors, but the underlying problem is severe. In your sugarcrm.log file, you will most likely find one or more errors similar to the following:

03/21/14 12:20:46 [5380][-none-][FATAL]  Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table 'suitecrm702.securitygroups_default' doesn't exist

You do need to get rid of warnings and deprecated messages etc so that the user interface works after installation. Find “error_reporting” in your php.ini file and make it the same as the following or add it if it is not there at all.

error_reporting=E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED

To fix the issue of the installer confirmation page showing “foreach” errors then make sure that the default MySQL storage engine is set to MyISAM in my.ini instead of “INNODB”. Find and change, or add the following in the mysqld section.

[mysqld]
default-storage-engine = MyISAM

Delete your existing database and create a new one and run the installer again.

After installation, you can get rid of the “SugarSearchEngineQueueManager” error (sugarcrm.log), by following the instructions from this forum post.
This fix apparently also fixes issues with workflow emails not being sent so it is well worth applying.

Cheers

Bruce