Help for integrating the Laravel package
Forum rules: Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#3761 by JeroenVdB
24 Dec 2016, 15:24
Hi I just tried to install the Aimeos package for Laravel but I'm having a problem going to the /list page in the example to test if it's working or not. I'm getting the folowing error:

Code: Select allException in Standard.php line 126: Site for code "default" not found

    in Standard.php line 126
    at Standard->bootstrap('default', '', '', true)
    at call_user_func_array(array(object(Standard), 'bootstrap'), array('default', '', '', true)) in Base.php line 51
    at Base->__call('bootstrap', array('default', '', '', true)) in Locale.php line 64
    at Sitecheck->bootstrap('default', '', '', true) in Locale.php line 64
    at Locale->get(object(Standard)) in Context.php line 100
    at Context->get() in Page.php line 76
    at Page->getSections('catalog-list') in CatalogController.php line 62
    at CatalogController->listAction()
    at call_user_func_array(array(object(CatalogController), 'listAction'), array()) in Controller.php line 55
    at Controller->callAction('listAction', array()) in ControllerDispatcher.php line 44
    at ControllerDispatcher->dispatch(object(Route), object(CatalogController), 'listAction') in Route.php line 190
    at Route->runController() in Route.php line 144
    at Route->run(object(Request)) in Router.php line 653
    at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
    at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
    at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
    at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
    at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
    at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
    at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
    at Pipeline->then(object(Closure)) in Router.php line 655
    at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
    at Router->dispatchToRoute(object(Request)) in Router.php line 607
    at Router->dispatch(object(Request)) in Kernel.php line 268
    at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
    at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
    at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
    at Pipeline->then(object(Closure)) in Kernel.php line 150
    at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
    at Kernel->handle(object(Request)) in index.php line 54


Does this have to do with my Laravel project or rather apache?
I'm using Wamp and the routes work, if i go to localhost I get the Laravel default welcome page.
#3763 by JeroenVdB
26 Dec 2016, 11:04
No I don't think it's the same error, because my aimeos-core version is 2016.10.6.
However I did notice that my database didn't contain data, the tables were build but there's no example data inserted I don't know if this is maybe causing the problem?

And this is my 'composer show -i' output:

Code: Select allYou are using the deprecated option "installed". Only installed packages are shown by default now. The --all option can be used to show all packages.
aimeos/ai-admin-extadm                2016.10.2  Aimeos ai-admin-extadm extension
aimeos/ai-admin-jqadm                 2016.10.3  Aimeos ai-admin-jqadm extension
aimeos/ai-admin-jsonadm               2016.10.1  Aimeos ai-admin-jsonadm extension
aimeos/ai-client-html                 2016.10.12 Aimeos ai-client-html extension
aimeos/ai-controller-frontend         2016.10.6  Aimeos ai-controller-frontend extension
aimeos/ai-controller-jobs             2016.10.3  Aimeos ai-controller-jobs extension
aimeos/ai-gettext                     2016.10.1  Aimeos Gettext extension
aimeos/ai-laravel                     2016.10.2  Laravel adapter for Aimeos web shops and e-commerce solutions
aimeos/ai-swiftmailer                 2016.10.1  SwiftMailer adapter for Aimeos web shops and e-commerce solutions
aimeos/aimeos-core                    2016.10.6  Full-featured e-commerce components for high performance online shops
aimeos/aimeos-laravel                 2016.10.3  Full-featured Laravel web shop package and e-commerce solution for high performance shops
classpreloader/classpreloader         3.1.0      Helps class loading performance by generating a single PHP file containing all of the autoloaded files for a specific use case
composer/installers                   v1.2.0     A multi-framework Composer library installer
dnoegel/php-xdg-base-dir              0.1        implementation of xdg base directory specification for php
doctrine/annotations                  v1.3.0     Docblock Annotations Parser
doctrine/cache                        v1.6.1     Caching library offering an object-oriented API for many cache backends
doctrine/collections                  v1.3.0     Collections Abstraction library
doctrine/common                       v2.6.2     Common Library for Doctrine projects
doctrine/dbal                         v2.5.5     Database Abstraction Layer
doctrine/inflector                    v1.1.0     Common String Manipulations with regard to casing and singular/plural rules.
doctrine/instantiator                 1.0.5      A small, lightweight utility to instantiate objects in PHP without invoking their constructors
doctrine/lexer                        v1.0.1     Base library for a lexer that can be used in Top-Down, Recursive Descent Parsers.
fzaninotto/faker                      v1.6.0     Faker is a PHP library that generates fake data for you.
hamcrest/hamcrest-php                 v1.2.2     This is the PHP port of Hamcrest Matchers
jakub-onderka/php-console-color       0.1
jakub-onderka/php-console-highlighter v0.3.2
jeremeamia/SuperClosure               2.3.0      Serialize Closure objects, including their context and binding
laravel/framework                     v5.3.28    The Laravel Framework.
league/flysystem                      1.0.32     Filesystem abstraction: Many filesystems, one API.
mockery/mockery                       0.9.7      Mockery is a simple yet flexible PHP mock object framework for use in unit testing with PHPUnit, PHPSpec or any other testing framework. Its core goal is to offer a test double framewor...
monolog/monolog                       1.22.0     Sends your logs to files, sockets, inboxes, databases and various web services
mtdowling/cron-expression             v1.1.0     CRON for PHP: Calculate the next or previous run date and determine if a CRON expression is due
myclabs/deep-copy                     1.5.5      Create deep copies (clones) of your objects
nesbot/carbon                         1.21.0     A simple API extension for DateTime.
nikic/php-parser                      v3.0.2     A PHP parser written in PHP
paragonie/random_compat               v2.0.4     PHP 5.x polyfill for random_bytes() and random_int() from PHP 7
phpdocumentor/reflection-common       1.0        Common reflection classes used by phpdocumentor to reflect the code structure
phpdocumentor/reflection-docblock     3.1.1      With this component, a library can provide support for annotations via DocBlocks or otherwise retrieve information that is embedded in a DocBlock.
phpdocumentor/type-resolver           0.2.1
phpspec/prophecy                      v1.6.2     Highly opinionated mocking framework for PHP 5.3+
phpunit/php-code-coverage             4.0.4      Library that provides collection, processing, and rendering functionality for PHP code coverage information.
phpunit/php-file-iterator             1.4.2      FilterIterator implementation that filters files based on a list of suffixes.
phpunit/php-text-template             1.2.1      Simple template engine.
phpunit/php-timer                     1.0.8      Utility class for timing
phpunit/php-token-stream              1.4.9      Wrapper around PHP's tokenizer extension.
phpunit/phpunit                       5.7.4      The PHP Unit Testing framework.
phpunit/phpunit-mock-objects          3.4.3      Mock Object library for PHPUnit
psr/http-message                      1.0.1      Common interface for HTTP messages
psr/log                               1.0.2      Common interface for logging libraries
psy/psysh                             v0.8.0     An interactive shell for modern PHP.
ramsey/uuid                           3.5.2      Formerly rhumsaa/uuid. A PHP 5.4+ library for generating RFC 4122 version 1, 3, 4, and 5 universally unique identifiers (UUID).
sebastian/code-unit-reverse-lookup    1.0.0      Looks up which function or method a line of code belongs to
sebastian/comparator                  1.2.2      Provides the functionality to compare PHP values for equality
sebastian/diff                        1.4.1      Diff implementation
sebastian/environment                 2.0.0      Provides functionality to handle HHVM/PHP environments
sebastian/exporter                    2.0.0      Provides the functionality to export PHP variables for visualization
sebastian/global-state                1.1.1      Snapshotting of global state
sebastian/object-enumerator           2.0.0      Traverses array structures and object graphs to enumerate all referenced objects
sebastian/recursion-context           2.0.0      Provides functionality to recursively process PHP variables
sebastian/resource-operations         1.0.0      Provides a list of PHP built-in functions that operate on resources
sebastian/version                     2.0.1      Library that helps with managing the version number of Git-hosted PHP projects
swiftmailer/swiftmailer               v5.4.4     Swiftmailer, free feature-rich PHP mailer
symfony/console                       v3.1.8     Symfony Console Component
symfony/css-selector                  v3.1.8     Symfony CssSelector Component
symfony/debug                         v3.1.8     Symfony Debug Component
symfony/dom-crawler                   v3.1.8     Symfony DomCrawler Component
symfony/event-dispatcher              v3.2.1     Symfony EventDispatcher Component
symfony/finder                        v3.1.8     Symfony Finder Component
symfony/http-foundation               v3.1.8     Symfony HttpFoundation Component
symfony/http-kernel                   v3.1.8     Symfony HttpKernel Component
symfony/polyfill-mbstring             v1.3.0     Symfony polyfill for the Mbstring extension
symfony/polyfill-php56                v1.3.0     Symfony polyfill backporting some PHP 5.6+ features to lower PHP versions
symfony/polyfill-util                 v1.3.0     Symfony utilities for portability of PHP codes
symfony/process                       v3.1.8     Symfony Process Component
symfony/routing                       v3.1.8     Symfony Routing Component
symfony/translation                   v3.1.8     Symfony Translation Component
symfony/var-dumper                    v3.1.8     Symfony mechanism for exploring and dumping PHP variables
symfony/yaml                          v3.2.1     Symfony Yaml Component
twbs/bootstrap                        v3.3.7     The most popular front-end framework for developing responsive, mobile first projects on the web.
vlucas/phpdotenv                      v2.4.0     Loads environment variables from `.env` to `getenv()`, `$_ENV` and `$_SERVER` automagically.
webmozart/assert                      1.2.0      Assertions to validate method input/output with nice error messages.
zendframework/zend-diactoros          1.3.7      PSR HTTP Message implementations


Thanks for the quick reply! :)
Maybe it has to do something with Wamp? I'm not sure, I reinstalled the project 2 times and still the same error.
#3764 by JeroenVdB
26 Dec 2016, 11:55
Okey so I ran 'php artisan aimeos:setup --option=setup/default/demo:1' again and now I do have data.
Now I get the same error as the one on github but when I go to phpmyadmin the status column of the row is already 1 and I still get the error.

EDIT:
When I execute the aimeos:setup command I get the following error:
Code: Select all [Aimeos\MW\DB\Exception]
 Executing statement "CREATE INDEX users_status_address1_address2_index ON users (status, address1, address2)" failed: An exception occurred while executing 'CREATE INDEX users_status_address1_address2_index ON users (status, address1, address2)':
 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

I don't know if I can just edit the key or not?
#3766 by aimeos
27 Dec 2016, 11:01
In this case, you need to use aimeos/aimeos-laravel dev-master instead of ~2016.10. The MySQL team changed some restrictions regarding index lenghs in the newer versions.