Fresh install with Symfony 4 not working

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)
Spam and unrelated posts will be removed immediately!
Nicolas
Posts: 3
Joined: 16 Dec 2018, 09:08

Fresh install with Symfony 4 not working

Post 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 all

In 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.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Fresh install with Symfony 4 not working

Post by aimeos » 16 Dec 2018, 13:31

That's a bug in the current Doctrine DBAL library (2.9.1):
https://github.com/doctrine/dbal/issues/3410

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"
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Nicolas
Posts: 3
Joined: 16 Dec 2018, 09:08

Re: Fresh install with Symfony 4 not working

Post by Nicolas » 16 Dec 2018, 16:34

Thanks ! Now it's better... but now, it looks like data are inconsistent :

Code: Select all

In 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'    

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Fresh install with Symfony 4 not working

Post 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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Nicolas
Posts: 3
Joined: 16 Dec 2018, 09:08

Re: Fresh install with Symfony 4 not working

Post 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.

Cordially.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Fresh install with Symfony 4 not working

Post by aimeos » 28 Dec 2018, 18:29

Problem has been fixed in latest Aimeos core release
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply