AOS_Fields Table not created

💬 General Discussion
1

When setting up the reporting module, received a database failure. Ran Quick Repair & Rebuild and received the following error in the Log: Query Failed:CREATE TABLE aor_fields (id varchar(36) NOT NULL ,name nvarchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id varchar(36) NULL ,created_by varchar(36) NULL ,description nvarchar(max) NULL ,deleted bit DEFAULT ‘0’ NULL ,aor_report_id varchar(36) NULL ,field_order int NULL ,module_path nvarchar(max) NULL ,field nvarchar(100) NULL ,display bit NULL ,link bit NULL ,label nvarchar(255) NULL ,function nvarchar(100) NULL ,sort_by nvarchar(100) NULL ,sort_order nvarchar(100) NULL ,group_by nvarchar(100) NULL ,group_order nvarchar(100) NULL )::: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ‘function’.

Verified the table does not exist. Any suggestions?

2

Hi dgreene,

Please see this forum topic which details this issue.

Thanks,

Will.

3

I’m running SuiteCRM on MS-SQL…it sounds like you are also. Are you live with it all or are you just experimenting?
regards
Andrew

4

We are live with SugarCRM CE 6.5.14 with AOS Modules, using IIS 7 and MSSQL 2008R2 and have been running it in production since April 2013. I am however migrating to a new install of SuiteCRM and am currently testing for use in production.