please am sorry to be the one with an issue here may be am not getting it right but on the documentaion you listed commands that i have run and am getting an error and dont see how to get over it. here is the error:----

$ composer create-project aimeos/aimeos myshoppingsite Installing aimeos/aimeos (2017.10.1)

• Installing aimeos/aimeos (2017.10.1): Loading from cache Created project in myshoppingsite

@php -r "file_exists('.env') || copy('.env.example', '.env');" mkdir public/files public/preview public/uploads The syntax of the command is incorrect. Script mkdir public/files public/preview public/uploads handling the post-root-package-install event returned with error code 1

checked all the prerequisites and i have them thanks i would love to check this app and integrate it on my site

Hi, I find it's a fantastic project. When I want to install it on my localhost with code: composer create-project aimeos/aimeos myshop, I get an error as below: [Composer\Downloader\TransportException] curl error 60 while downloading https://packages.aimeos.org/aimeoscom/packa ges.json: SSL certificate problem: certificate has expired I also tried to download the master package and upload to my server then I run the command: composer update, and I got same error. My server is Debian+LAMP. All the versions meet the requirement. Could someone help me on this? thank you.

Hello,

I did a fresh install of Aimeos package and all works fine apparenly but when I want filter products in front, I've got this error:

Version PHP 8

My requires in composer.json

    "require": {
        "php": "^7.3||^8.0",
        "aimeos-themes/rvdtheme": "dev-master",
        "aimeos/ai-cms-grapesjs": "2021.10.*",
        "aimeos/aimeos-laravel": "2021.10.*",
        "fruitcake/laravel-cors": "^2.0",
        "guzzlehttp/guzzle": "^7.0.1",
        "laravel/framework": "^8.54",
        "laravel/sanctum": "^2.11",
        "laravel/tinker": "^2.5",
        "laravel/ui": "^3.0"
    },

ErrorException
Array to string conversion
http://127.0.0.1:8000/shop?f_supid%5B0%5D=2 

Illuminate\Foundation\Bootstrap\HandleExceptions::handleError
vendor/aimeos/aimeos-core/lib/mwlib/src/MW/View/Helper/Link/Standard.php:43

Can you tell me how to fix this error, please? Thank you.

Regards.

Generating optimized autoload files

Illuminate\Foundation\ComposerScripts::postAutoloadDump @php artisan package:discover --ansi

Aimeos\MW\DB\Exception : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel.mshop_locale_site' doesn't exist: SELECT mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid", mlocsi."code" AS "locale.site.code", mlocsi."label" AS "locale.site.label", mlocsi."config" AS "locale.site.config", mlocsi."status" AS "locale.site.status", mlocsi."editor" AS "locale.site.editor", mlocsi."mtime" AS "locale.site.mtime", mlocsi."ctime" AS "locale.site.ctime" FROM "mshop_locale_site" AS mlocsi WHERE mlocsi."level" = 0 AND ( mlocsi."code" = 'default' ) ORDER BY mlocsi."id" ASC LIMIT 1 OFFSET 0

at path-to-project\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:75 71| { 72| try { 73| $result = $this->exec(); 74| } catch( \PDOException $e ) {

75| throw new \Aimeos\MW\DB\Exception( $e->getMessage() . ': ' . $this->sql, $e->getCode() ); 76| } 77| 78| return new \Aimeos\MW\DB\Result\PDO( $result ); 79| }

Exception trace:

1 Aimeos\MW\DB\Statement\DBAL\Simple::execute() path-to-project\vendor\aimeos\aimeos-core\lib\mshoplib\src\MShop\Locale\Manager\Site\Standard.php:947

2 Aimeos\MShop\Locale\Manager\Site\Standard::getSearchResults(Object(Aimeos\MW\DB\Connection\DBAL), " SELECT mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid", mlocsi."code" AS "locale.site.code", mlocsi."label" AS "locale.site.label", mlocsi."config" AS "locale.site.config", mlocsi."status" AS "locale.site.status", mlocsi."editor" AS "locale.site.editor", mlocsi."mtime" AS "locale.site.mtime", mlocsi."ctime" AS "locale.site.ctime" FROM "mshop_locale_site" AS mlocsi WHERE mlocsi."level" = 0 AND ( mlocsi."code" = 'default' ) ORDER BY mlocsi."id" ASC LIMIT 1 OFFSET 0 ") path-to-project\vendor\aimeos\aimeos-core\lib\mshoplib\src\MShop\Locale\Manager\Site\Standard.php:659

Please use the argument -v to see more details. Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1

When adding a custom URL slug to a product for all languages, the shop doesn't find the product.

How to reproduce:

1. Fresh shop installation. Make sure, there are multiple languages activated.
2. Create a new product named "My Product". The product appears on the list of products in the frontend and links to /My_Product(correct)
3. Edit the product, go to "Text" and add a new "URL segment", select "All" for language and enter "new-name" as value. On the lists of products in the frontend, the product now links to /new-name(still correct, that's what is expected)
4. Click this product to view the product detail page. Now there is an error: Product "new-name" not found

By manually entering the URL /My_Product, the product can still be accessed.

I noticed, that the DB contains by default a URL for each language of the product. Adding the "URL segment" text adds just a row with an empty language ID to the DB.

By specifying a "URL segment" for each language, the problem is solved. It's just the "All" option that doesn't work. It seems like there is a priority problem, when fetching the data from the DB.

I have run the code "composer create-project -s dev aimeos/aimeos myshoppingsite". Following there is an error that I can not find a solution to to it.

Please suggest how can I create my project "myshoppingsite".

I deploy an aimeos website(work perfectyly) online with cPanel, when I go to link, on terminal i see 14 error, 7 with stylesheet problem and 7 with script problema, initially i though it may be because i did't put the correct url everywhere in replace of localhost, but when i finish to replace everything, i continue to see these problem with localhost url, but if i search inside the project it can't find a single localhost

Hello Team,

when I created extension and copied files which i need to overwrite. but after that some of menus are not working for eg sales menu. I have attached the issue image as well... please help why this is caused.

I want to run aimoes in my dev machine (Linux Mint 21) using sail but unfortunately you didn't ship the source code with docker-compose.yml so running ./sail up will fail!

I made a tiny trick to find out a way to running it using sail as following:

1. Created a clean Laravel sail project: curl -s https://laravel.build/aimeos-test | bash
2. Cloned aimeos: git clone https://github.com/aimeos/aimeos.git
3. Copied the missing file: cp aimeos-test/docker-compose.yml aimeos
4. Replaced the old Dockerfile: cp aimeos-test/vendor/laravel/sail/runtimes/8.1/Dockerfile aimeos/docker/8.1
5. Enabled sail: cd aimeos && chmod u+x sail
6. Run it: ./sail up
7. Laravel throw this error message (detailed):

Aimeos\Base\DB\Exception
An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused: SET SESSION sort_buffer_size=2097144; SET NAMES 'utf8mb4'; SET SESSION sql_mode='ANSI'

How can I run aimeos?

docker-compose.yml

# For more information: https://laravel.com/docs/sail
version: '3'
services:
    aimeos.test:
        build:
            context: ./docker/8.1
            dockerfile: Dockerfile
            args:
                WWWGROUP: '${WWWGROUP}'
        image: sail-8.1/app
        extra_hosts:
            - 'host.docker.internal:host-gateway'
        ports:
            - '${APP_PORT:-80}:80'
            - '${VITE_PORT:-5173}:${VITE_PORT:-5173}'
        environment:
            WWWUSER: '${WWWUSER}'
            LARAVEL_SAIL: 1
            XDEBUG_MODE: '${SAIL_XDEBUG_MODE:-off}'
            XDEBUG_CONFIG: '${SAIL_XDEBUG_CONFIG:-client_host=host.docker.internal}'
        volumes:
            - '.:/var/www/html'
        networks:
            - sail
        depends_on:
            - mysql
            - redis
            - meilisearch
            - selenium
    mysql:
        image: 'mysql/mysql-server:8.0'
        ports:
            - '${FORWARD_DB_PORT:-3306}:3306'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ROOT_HOST: "%"
            MYSQL_DATABASE: '${DB_DATABASE}'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 1
        volumes:
            - 'sail-mysql:/var/lib/mysql'
            - './vendor/laravel/sail/database/mysql/create-testing-database.sh:/docker-entrypoint-initdb.d/10-create-testing-database.sh'
        networks:
            - sail
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
            retries: 3
            timeout: 5s
    redis:
        image: 'redis:alpine'
        ports:
            - '${FORWARD_REDIS_PORT:-6379}:6379'
        volumes:
            - 'sail-redis:/data'
        networks:
            - sail
        healthcheck:
            test: ["CMD", "redis-cli", "ping"]
            retries: 3
            timeout: 5s
    meilisearch:
        image: 'getmeili/meilisearch:latest'
        ports:
            - '${FORWARD_MEILISEARCH_PORT:-7700}:7700'
        volumes:
            - 'sail-meilisearch:/meili_data'
        networks:
            - sail
        healthcheck:
            test: ["CMD", "wget", "--no-verbose", "--spider",  "http://localhost:7700/health"]
            retries: 3
            timeout: 5s
    mailhog:
        image: 'mailhog/mailhog:latest'
        ports:
            - '${FORWARD_MAILHOG_PORT:-1025}:1025'
            - '${FORWARD_MAILHOG_DASHBOARD_PORT:-8025}:8025'
        networks:
            - sail
    selenium:
        image: 'selenium/standalone-chrome'
        volumes:
            - '/dev/shm:/dev/shm'
        networks:
            - sail
networks:
    sail:
        driver: bridge
volumes:
    sail-mysql:
        driver: local
    sail-redis:
        driver: local
    sail-meilisearch:
        driver: local

aimeos/docker/8.1/Dockerfile

FROM ubuntu:22.04

LABEL maintainer="Taylor Otwell"

ARG WWWGROUP
ARG NODE_VERSION=16
ARG POSTGRES_VERSION=14

WORKDIR /var/www/html

ENV DEBIAN_FRONTEND noninteractive
ENV TZ=UTC

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update \
    && apt-get install -y gnupg gosu curl ca-certificates zip unzip git supervisor sqlite3 libcap2-bin libpng-dev python2 \
    && mkdir -p ~/.gnupg \
    && chmod 600 ~/.gnupg \
    && echo "disable-ipv6" >> ~/.gnupg/dirmngr.conf \
    && echo "keyserver hkp://keyserver.ubuntu.com:80" >> ~/.gnupg/dirmngr.conf \
    && gpg --recv-key 0x14aa40ec0831756756d7f66c4f4ea0aae5267a6c \
    && gpg --export 0x14aa40ec0831756756d7f66c4f4ea0aae5267a6c > /usr/share/keyrings/ppa_ondrej_php.gpg \
    && echo "deb [signed-by=/usr/share/keyrings/ppa_ondrej_php.gpg] https://ppa.launchpadcontent.net/ondrej/php/ubuntu jammy main" > /etc/apt/sources.list.d/ppa_ondrej_php.list \
    && apt-get update \
    && apt-get install -y php8.1-cli php8.1-dev \
       php8.1-pgsql php8.1-sqlite3 php8.1-gd \
       php8.1-curl \
       php8.1-imap php8.1-mysql php8.1-mbstring \
       php8.1-xml php8.1-zip php8.1-bcmath php8.1-soap \
       php8.1-intl php8.1-readline \
       php8.1-ldap \
       php8.1-msgpack php8.1-igbinary php8.1-redis php8.1-swoole \
       php8.1-memcached php8.1-pcov php8.1-xdebug \
    && php -r "readfile('https://getcomposer.org/installer');" | php -- --install-dir=/usr/bin/ --filename=composer \
    && curl -sLS https://deb.nodesource.com/setup_$NODE_VERSION.x | bash - \
    && apt-get install -y nodejs \
    && npm install -g npm \
    && curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | gpg --dearmor | tee /usr/share/keyrings/yarn.gpg >/dev/null \
    && echo "deb [signed-by=/usr/share/keyrings/yarn.gpg] https://dl.yarnpkg.com/debian/ stable main" > /etc/apt/sources.list.d/yarn.list \
    && curl -sS https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | tee /usr/share/keyrings/pgdg.gpg >/dev/null \
    && echo "deb [signed-by=/usr/share/keyrings/pgdg.gpg] http://apt.postgresql.org/pub/repos/apt jammy-pgdg main" > /etc/apt/sources.list.d/pgdg.list \
    && apt-get update \
    && apt-get install -y yarn \
    && apt-get install -y mysql-client \
    && apt-get install -y postgresql-client-$POSTGRES_VERSION \
    && apt-get -y autoremove \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

RUN setcap "cap_net_bind_service=+ep" /usr/bin/php8.1

RUN groupadd --force -g $WWWGROUP sail
RUN useradd -ms /bin/bash --no-user-group -g $WWWGROUP -u 1337 sail

COPY start-container /usr/local/bin/start-container
COPY supervisord.conf /etc/supervisor/conf.d/supervisord.conf
COPY php.ini /etc/php/8.1/cli/conf.d/99-sail.ini
RUN chmod +x /usr/local/bin/start-container

EXPOSE 8000

ENTRYPOINT ["start-container"]

I try to create a new project but no asked to enter any parameters for the database so it thrown an error with database laravel not found please advise

Super excited to use your shop, but ran into an issue. I went through the installation process, set up the .env file, then checked the serve, it showed http://127.0.0.1:8000 as expected. However upon opening this on the browser I got the following error:

Haven't figured out how to get around this. Any help you can give would be great, thanks!

Hi, I encountered two tables do not exists when installing version 2022.04.2.

1. users_property
2. mshop_locale_site

This is the screenshot during my setup.

Hello,

I add the LaravelDebugBar in my project. The debug bar is show on the page but in the tab "Queries" I can see just one query. select * from users where id = 2 limit 1

Do you know why I can't see all the queries on the shop? Thank you.

Regards.