prooph / proophessor-do

prooph components in action
http://getprooph.org
BSD 3-Clause "New" or "Revised" License
254 stars 65 forks source link

[mac][mariadb] Installation error #144

Closed sebastianblum closed 6 years ago

sebastianblum commented 6 years ago

I'm playing with the manual installation and I got these error running php scripts/create_event_stream.php

php scripts/create_event_stream.php
PHP Fatal error:  Uncaught Prooph\EventStore\Pdo\Exception\RuntimeException: Error during createSchemaFor: 42000; 1064; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,
    `aggregate_id` CHAR(36) CHARACTER SET utf8 COLLATE utf8_bin GENERA' at line 8 in /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/pdo-event-store/src/MySqlEventStore.php:805
Stack trace:
#0 /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/pdo-event-store/src/MySqlEventStore.php(180): Prooph\EventStore\Pdo\MySqlEventStore->createSchemaFor('_4228e4a00331b5...')
#1 /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/event-store/src/ActionEventEmitterEventStore.php(74): Prooph\EventStore\Pdo\MySqlEventStore->create(Object(Prooph\EventStore\Stream))
#2 /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/common/src/Event/ProophActionEventEmitter.php(57): Prooph\EventStore\ActionEventEmitterEventStore-> in /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/pdo-event-store/src/MySqlEventStore.php on line 805

Fatal error: Uncaught Prooph\EventStore\Pdo\Exception\RuntimeException: Error during createSchemaFor: 42000; 1064; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,
    `aggregate_id` CHAR(36) CHARACTER SET utf8 COLLATE utf8_bin GENERA' at line 8 in /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/pdo-event-store/src/MySqlEventStore.php:805
Stack trace:
#0 /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/pdo-event-store/src/MySqlEventStore.php(180): Prooph\EventStore\Pdo\MySqlEventStore->createSchemaFor('_4228e4a00331b5...')
#1 /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/event-store/src/ActionEventEmitterEventStore.php(74): Prooph\EventStore\Pdo\MySqlEventStore->create(Object(Prooph\EventStore\Stream))
#2 /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/common/src/Event/ProophActionEventEmitter.php(57): Prooph\EventStore\ActionEventEmitterEventStore-> in /Users/sebastianblum/PhpstormProjects/proophessor-do/vendor/prooph/pdo-event-store/src/MySqlEventStore.php on line 805

My system is

any ideas to fix that problem?

sebastianblum commented 6 years ago

I found now the mariadb folder and will create a pull request