search

Cocolabs-SAS / cocorico

👐 Cocorico is an open source marketplace solution for services and rentals. More information right here: https://www.cocorico.io/ 🚀 Cocorico is also available in an off-the-shelf SaaS package, check out https://www.hatch.li to launch your platform today. 😍 We are hiring (telecommute welcome 🏡): https://www.welcometothejungle.com/en/companies/cocorico/jobs/candidatures-spontanees#apply
https://www.cocolabs.com
MIT License
857 stars 610 forks source link

SQL error on first access to app_dev.php - but admin backend working #517

Closed bpiltz closed 3 years ago

bpiltz commented 3 years ago
Q A
Bug report? [ Yes]
Feature request? [ ]
Support request? [ ]

Hi, so far it makes a very good impression to me, though I also had issues during instalation due to a lack of details in the documentation. However I got it all running and access the backend fluently, but have issues calling the front end. It seems there is a problem in some SQL syntax where the 'Select' is empty:

A`n exception occurred while executing 'SELECT DISTINCT id_1 FROM (SELECT '' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6' with params ["en", "en", 2]:`

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dctrn_result.createdAt_6' which is not in SELECT list; this is incompatible with DISTINCT
parameters:
    database_host: 127.0.0.1
    database_port: 3306
    database_name: COCORICO
    database_user: root
    database_password: XXXXXXXX
    mongodb_server: 'mongodb://localhost:27017'
    mongodb_database_name: COCORICO
    mailer_transport: smtp
    mailer_host: 127.0.0.1
    mailer_user: null
    mailer_password: null
    mailer_port: null
    secret: ThisTokenIsNotSoSecretChangeIt
    use_assetic_controller: false
    cocorico.assets_base_urls: 'http://localhost/cocorico.local/Symfony/web/'
    router.request_context.host: localhost
    router.request_context.scheme: http
    router.request_context.base_url: 'cocorico.local/Symfony/web/'
    cocorico.admin: admin
    cocorico.admin_translation: false
    cocorico.check_translation: false
    cocorico.translator.secret.key: null
    cocorico.facebook.app_id: '23412341234123412341234'
    cocorico.facebook.secret: '123412341234123412341234'
    cocorico.image_driver: imagick
    cocorico.google_analytics: UA-64445856-1
    cocorico.google_tag_manager: false
    cocorico_geo.google_place_api_key: null
    cocorico_geo.google_place_server_api_key: null
    cocorico_geo.ipinfodb_api_key: null
    cocorico.deploy.host: fake.cocorico.prod
    cocorico.deploy.dir: /fake/path
    cocorico.deploy.user: fakeuser
    cocorico.booking.expiration_delay: 2880
    cocorico.booking.acceptation_delay: 240
    cocorico.booking.alert_expiration_delay: 120
    cocorico.booking.alert_imminent_delay: 1440
    cocorico.booking.validated_moment: start
    cocorico.booking.validated_delay: 0
    cocorico.bankwire_checking_simulation: false

All the other checks from the installation guide work well and I followed them strictly.

Here is the full stack trace of the error:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing 'SELECT DISTINCT id_1 FROM (SELECT '' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6' with params ["en", "en", 2]:

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dctrn_result.createdAt_6' which is not in SELECT list; this is incompatible with DISTINCT

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:121
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT DISTINCT id_1 FROM (SELECT \'\' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6\' with params ["en", "en", 2]:SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column \'dctrn_result.createdAt_6\' which is not in SELECT list; this is incompatible with DISTINCT', object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:176)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT DISTINCT id_1 FROM (SELECT \'\' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6\' with params ["en", "en", 2]:SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column \'dctrn_result.createdAt_6\' which is not in SELECT list; this is incompatible with DISTINCT')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:150)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT DISTINCT id_1 FROM (SELECT \'\' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6', array('en', 'en', 2))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:915)
  at Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT id_1 FROM (SELECT \'\' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6', array('en', 'en', 2), array(2, 2, 'integer'))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:959)
  at Doctrine\DBAL\Connection->executeCacheQuery('SELECT DISTINCT id_1 FROM (SELECT \'\' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6', array('en', 'en', 2), array(2, 2, 'integer'), object(QueryCacheProfile))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:890)
  at Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT id_1 FROM (SELECT \'\' AS sclr_0, l0_.id AS id_1, l0_.price AS price_2, l0_.certified AS certified_3, l0_.average_rating AS average_rating_4, l0_.comment_count AS comment_count_5, l0_.createdAt AS createdAt_6, l1_.title AS title_7, l1_.description AS description_8, l1_.locale AS locale_9, l1_.id AS id_10, l1_.slug AS slug_11, l2_.id AS id_12, l3_.id AS id_13, l3_.lft AS lft_14, l3_.lvl AS lvl_15, l3_.rgt AS rgt_16, l3_.root AS root_17, l4_.name AS name_18, l4_.locale AS locale_19, l4_.id AS id_20, l5_.id AS id_21, l5_.name AS name_22, u6_.id AS id_23, u6_.first_name AS first_name_24, u7_.id AS id_25, u7_.name AS name_26, l8_.id AS id_27, l8_.country AS country_28, l8_.city AS city_29, l8_.route AS route_30, g9_.id AS id_31, g9_.lat AS lat_32, g9_.lng AS lng_33, l4_.locale AS locale_34, u7_.position AS position_35, l1_.locale AS locale_36, l0_.status AS status_37, l0_.createdAt AS createdAt_38 FROM listing l0_ LEFT JOIN listing_translation l1_ ON l0_.id = l1_.translatable_id LEFT JOIN listing_listing_category l2_ ON l0_.id = l2_.listing_id LEFT JOIN listing_category l3_ ON l2_.listing_category_id = l3_.id LEFT JOIN listing_category_translation l4_ ON l3_.id = l4_.translatable_id AND (l4_.locale = ?) LEFT JOIN listing_image l5_ ON l0_.id = l5_.listing_id LEFT JOIN `user` u6_ ON l0_.user_id = u6_.id LEFT JOIN user_image u7_ ON u6_.id = u7_.user_id AND (u7_.position = 1) LEFT JOIN listing_location l8_ ON l0_.location_id = l8_.id LEFT JOIN geo_coordinate g9_ ON l8_.coordinate_id = g9_.id WHERE l1_.locale = ? AND l0_.status = ? ORDER BY l5_.position asc, u7_.position asc) dctrn_result ORDER BY createdAt_6 DESC LIMIT 6', array('en', 'en', 2), array(2, 2, 'integer'), object(QueryCacheProfile))
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array('en', 'en', 2), array(2, 2, 'integer'))
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:321)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:962)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 3)
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:917)
  at Doctrine\ORM\AbstractQuery->execute(null, 3)
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:744)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:151)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (src/Cocorico/CoreBundle/Controller/Frontend/HomeController.php:42)
  at Cocorico\CoreBundle\Controller\Frontend\HomeController->indexAction(object(Request))
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:28)

Any hlep appreciated! Thank you!

cocolabssas commented 3 years ago

Hello @bpiltz,

Look at the solution here: https://github.com/Cocolabs-SAS/cocorico/issues/124#issuecomment-353704451