Flow 4.3/doctrine version mismatch?

Using Neos & Flow Flow App Development
1

Hello! Me again … :wink:

After solving last problem, I stuck again after upgrading our Flow 4.2 application to Flow 4.3.14.
This time we get this exception for example (others are alike):

Exception in line 128 of Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: 
An exception occurred while executing 
'INSERT INTO neos_party_domain_model_electronicaddress (persistence_object_identifier, identifier, type, usagetype, approved, dtype) VALUES (?, ?, ?, ?, ?, ?)' 
with params ["92e02bbb-c656-4b9d-9e85-3e062ebfc9bc", "neos_party_electronicaddress"]:
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Obviously that’s right: six columns and only two data …
Maybe there is a version mismatch between flow and doctrine?
composer info:

doctrine/annotations  v1.6.0  
doctrine/cache        v1.8.0  
doctrine/collections  v1.5.0  
doctrine/common       v2.7.3  
doctrine/dbal         v2.5.13 
doctrine/inflector    v1.3.0  
doctrine/instantiator 1.1.0   
doctrine/lexer        v1.0.1  
doctrine/migrations   v1.3.1  
doctrine/orm          v2.5.14

Are these the right doctine versions for flow 4.3.14?

Thank’s
Frank

2

Hello together!

Here is one more infos.
After trying several things, I did a totally fresh flow 4.3.14 installation.
Again the annoying error by doing first “doctrine:migrate”

user@server:$ ./flow doctrine:migrate
Warning: "continue" targeting switch is equivalent to "break".
Did you mean to use "continue 2"? in
Packages/Libraries/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php
line 2636

Yes I know, doctrine is not part of flow …

Switching back now from php7.3 to php7.2 and all is fine!

Greetings
Frank

3

Hi
most probably, my experience is not related to your issue …

  • but I encountered such error-message by updating my flow installation on a server with php 7.3 …
  • I had such error-message during updating process with composer (version 1.4)
  • I’m quite sure (as I remember …), that “composer self-update” (to composer version 1.8) did resolve my problem …
  • after re-updating the flow installation all went fine …

As I mentioned, - I don’t really understand the background, - just “share my experience” due to the similar error-message …
(… easily possible that it is not related to your’s !! … but could give a hint …)

Greetings Christoph

4

Hi Christoph,
thank’s for sharing!
What is your oprating system?
We have ubuntu 16.04.6 with ppa:ondrej/php

composer ran in the same issue (s. my last post).
There I have to remove “composer” first (as part of ubunto disto) and re-install it by using the version from getcomposer.org.

5

Hi Frank
as I understand

So, if you think the reason of your problem might be the composer version …

  • may check your version by “composer -V”

The latest composer version is 1.8.4 … so if you want to update to latest version

  • “composer self-update” would be the way to go …

This issue would NOT have been related to the operating system (server environment), but apparently to the composer/phpVersion … (no ?)

Good luck !