Skip to Content
0
Former Member
Dec 04, 2014 at 12:28 PM

Clean 5.3.0.2 install on mysql gives initialisation error

302 Views

The initialisition error:

 Table 'hybris.pcp2wrtblecvrel' doesn't exist

It's a clean developer install of the full 5.3.0.2 commerce suite, the mysql schema is initialised as follows:

 CREATE USER 'hybris'@'localhost' IDENTIFIED BY ‘hybris’;
 CREATE DATABASE hybris DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
 GRANT ALL ON hybris.* TO 'hybris'@‘localhost’;
 flush privileges;

The local.properties config for mysql:

 db.url=jdbc:mysql://localhost/hybris?useConfigs=maxPerformance&characterEncoding=utf8
 db.driver=com.mysql.jdbc.Driver
 db.username=hybris
 db.password=hybris
 db.tableprefix=
 db.customsessionsql=SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
 mysql.optional.tabledefs=CHARSET=utf8 COLLATE=utf8_bin
 mysql.tabletype=InnoDB
 mysql.allow.fractional.seconds=true

Version info:

  • hybris-commerce-suite-5.3.0.2

  • OpenJDK7u71-2.5.3-0ubuntu0.14.04.1

  • Mysql Server 5.5.40-0ubuntu0.14.04.1