Note: OpenOLAT is a fork of OLAT in version 7.2. Thus, if you installed OLAT 7.6, it is not necessarily compatible with the standard OLAT process as it contains things not available in OpenOLAT and misses things which were available in OLAT 7.2 (e.g. the o_noti_pub tables).
To process, you first need to create the missing o_noti* tables from the database setup file within OpenOLAT:
create table if not exists o_noti_pub (
publisher_id bigint not null,
version mediumint unsigned not null,
creationdate datetime,
publishertype varchar(50) not null,
data longtext,
resname varchar(50),
resid bigint,
subident varchar(128),
businesspath varchar(255),
state integer,
latestnews datetime not null,
primary key (publisher_id)
);
create table if not exists o_noti_sub (
publisher_id bigint not null,
version mediumint unsigned not null,
lastmodified datetime,
creationdate datetime,
fk_publisher bigint not null,
fk_identity bigint not null,
latestemailed datetime,
primary key (publisher_id),
unique (fk_publisher, fk_identity)
);
alter table o_noti_pub ENGINE = InnoDB;
alter table o_noti_sub ENGINE = InnoDB;
create index name_idx on o_noti_pub (resname, resid, subident);
alter table o_noti_sub add constraint FK4FB8F04749E53702 foreign key (fk_publisher) references o_noti_pub (publisher_id);
alter table o_noti_sub add constraint FK4FB8F0476B1F22F8 foreign key (fk_identity) references o_bs_identity (id);
Then restart. There might be other obstacles on your way. But: there are other people right now upgrading from OpenOLAT 7.8 to OpenOLAT, so we know that is works. We just don’t know what exactly they tweaked to make it work. Maybe someone from them will respond to your request.
Cheers
Florian