7.3 Community - Reports not working

[HawkHogan]

I have a clean 7.3 install of the community edition, and the Reports functionality is not working.

In the dms.log file, anytime I run a report, I'm getting:

Code: Select all

org.hibernate.exception.SQLGrammarException: Table  "ld73.ld_workflowhistory" doesn't exist 

I'm on mysql. The ld_history table has the available data. Could someone provide the MySQL table create for ld_workflowhistory for 7.3 so I can use the reporting function?

Thanks

[car031]

Sure, here you go:

create table ld_workflowhistory (ld_id bigint not null, ld_lastmodified timestamp not null, ld_recordversion bigint not null,
ld_deleted int not null, ld_tenantid bigint not null, ld_date timestamp, ld_event varchar(255),
ld_comment varchar(4000), ld_docid bigint, ld_userid bigint,
ld_username varchar(255), ld_templateid bigint not null,
ld_instanceid varchar(255), ld_sessionid varchar(255),
ld_new int, ld_filename varchar(255), primary key (ld_id));

[HawkHogan]

Thanks, that did it!