cancel
Showing results for 
Search instead for 
Did you mean: 

Can't create the tables.

sshgz
Champ in-the-making
Champ in-the-making
When i ran alf_start.bat first time, i found some error  about "can't create the tables" on the console.

There are some errors in the log file:
"09:57:35,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table access_control_entry (id bigint not null auto_increment, acl_id bigint not null, permission_id bigint not null, authority_id varchar(100) not null, allowed bit not null, primary key (id), unique (acl_id, permission_id, authority_id)) type=InnoDB
09:57:35,062 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\access_control_entry.frm' (errno: 121)
09:57:35,171 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table access_control_list (id bigint not null auto_increment, inherits bit not null, primary key (id)) type=InnoDB
09:57:35,312 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\access_control_list.frm' (errno: 121)
09:57:35,421 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table applied_patch (id varchar(64) not null, description text, fixes_from_schema integer, fixes_to_schema integer, applied_to_schema integer, target_schema integer, applied_on_date datetime, applied_to_server varchar(64), was_executed bit, succeeded bit, report text, primary key (id)) type=InnoDB
……….
"
1 REPLY 1

derek
Star Contributor
Star Contributor
Hi,

Have you run the db setup script?  It creates an empty database (no tables) called alfresco and grants the alfresco user all rights to it.

Check that the user you are using has the correct permissions granted.

Regards