Questions around the Aimeos bundle for the Symfony framework
Forum rules: Always add your Symfony, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#7382 by Nicolas
16 Dec 2018, 09:20
Hi everybody !

Following the official installation instructions, I'm getting this error message after running the last command ("composer update") :
Code: Select allIn MySqlSchemaManager.php line 315:
Argument 1 passed to Doctrine\DBAL\Schema\MySqlSchemaManager::parseCreateOptions() must be of the type string, null given, called in /home/nicolas/public_html/aimeos/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php on line 307

So what's wrong (or missing) with the installation instructions ?

Thanks a lot.
#7385 by aimeos
16 Dec 2018, 13:31
That's a bug in the current Doctrine DBAL library (2.9.1):

You can add this to your composer.json file to use the previous version instead until a new one is released:
Code: Select all"doctrine/dbal": "v2.9.0"
#7386 by Nicolas
16 Dec 2018, 16:34
Thanks ! Now it's better... but now, it looks like data are inconsistent :
Code: Select allIn Simple.php line 91:                                                     
  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-pr 
  oduct-custom-8' for key 'unq_msattr_sid_dom_cod_tid'   
#7392 by aimeos
17 Dec 2018, 22:27
That's a problem of the current demo data setup. If you already have the the custom price entry in the mshop_attribute table, trying to add it again results in this error. Please remove the entries from the mshop_attribute table, then it will work to run the setup again incl. to add the demo data.
#7407 by Nicolas
20 Dec 2018, 07:18
Thanks a lot

Your solution did not work. I had to disable the creation of the unique index 'unq_msattr_sid_dom_cod_tid' in MShopAddAttributeData.php (line 52), then run setup, remove the first duplicate entry from 'mshop_attribute' table, then (re)generate manually the four columns based unique index. Now it works fine.