What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hi, another Database Question: When I try to edit an atribute of a product I get following exception

Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet
edited October 2019 in Help

Hi, another Database Question: When I try to edit an atribute of a product I get following exception:

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet

    [2019-10-17 14:40:15] Zed.CRITICAL: Propel\Runtime\Exception\PropelException - Unable to get sequence id. in "/var/www/html/public/spryker/src/Orm/Zed/EventBehavior/Persistence/Base/SpyEventBehaviorEntityChange.php::720" {"exception":"[object] (Propel\Runtime\Exception\PropelException(code: 0): Unable to get sequence id. at /var/www/html/public/spryker/src/Orm/Zed/EventBehavior/Persistence/Base/SpyEventBehaviorEntityChange.php:720, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION helukabel.nextval does not exist at /var/www/html/public/spryker/vendor/propel/propel/src/Propel/Runtime/Connection/PdoConnection.php:109)

  • Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet

    What is missing there? I assume it tries to call a stored procedure for nextval since MySQL doesn't support sequence IMHO

  • Posts: 463 πŸ§‘πŸ»β€πŸš€ - Cadet

    You are using MySQL or PostgreSQL?

  • Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet

    MySQL

  • Solution Architect Posts: 28 πŸ§‘πŸ»β€πŸš€ - Cadet
    edited October 2019

    Try to get the actuall sql and execute manual in MySQL. Sometimes you see this error - even if he cannot write in propel.log file due the reason prev exception is not passed correctly.

  • Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet

    Hi, so I solved this:

  • Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet

    Problem was that PHP used ist OPSCache which was filled with the postgres classes.

  • Posts: 44 πŸ§‘πŸ»β€πŸš€ - Cadet

    Since I’m running a Docker setup (not the SDK) the cache wasn’t flushed correctly. After restarting all php processes, this Bug went away.

Welcome!

It looks like you're new here. Sign in or register to get started.