Datenbankfehler nach Erstinstallation

Shopware 5 Installation/Einstieg
1

Hallo,
ich habe die aktuelle Version inkl. Datenbank auf meinem Webspace installiert. Grundsätzlich scheint die Installation geklappt zu haben.
Aber schon bei der Eingabe der Stammdaten im Backend kommt schon der erste Datenbankfehler.

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. Could not convert database value „s:18:"info@pyroatelier.de“;" to Doctrine Type object in vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php on line 46 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ObjectType.php(59): Doctrine\DBAL\Types\ConversionException::conversionFailed(‚s:18:"info@pyro…‘, ‚object‘) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(303): Doctrine\DBAL\Types\ObjectType->convertToPHPValue(‚s:18:"info@pyro…‘, Object(Doctrine\DBAL\Platforms\MySqlPlatform)) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ArrayHydrator.php(101): Doctrine\ORM\Internal\Hydration\AbstractHydrator->gatherRowData(Array, Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ArrayHydrator.php(87): Doctrine\ORM\Internal\Hydration\ArrayHydrator->hydrateRowData(Array, Array) #4 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(150): Doctrine\ORM\Internal\Hydration\ArrayHydrator->hydrateAllData() #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(971): Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll(Object(PDOStatement), Object(Doctrine\ORM\Query\ResultSetMapping), Array) #6 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 2) #7 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(759): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #8 engine/Shopware/Controllers/Backend/Config.php(154): Doctrine\ORM\AbstractQuery->getOneOrNullResult(2) #9 engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_Config->getFormAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‚getFormAction‘) #11 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #13 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main}  

 

 

 

Kann mir hier einer helfen wo der Fehler steckt?

 

Gruß Andreas

 

 

2

Hallo @Mercant‍,

schaue mal:

https://forum.shopware.com/discussion/comment/237494/#Comment_237494

VG,

Tel.: +49 755 - 183 990 00 | Web: http://enbit.de/

3

Das ist doch nen ganz anderer Fehler oder? Schuldigung, ich kenne mich hiermit noch nicht wirklich aus.

Gruß Andreas

 

4

Hier ist der Inhalt dieser php Datei.
Vielleicht hilft das weiter?

<?php
/\*  \* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS  \* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT  \* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR  \* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT  \* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,  \* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT  \* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,  \* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY  \* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT  \* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE  \* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.  \*  \* This software consists of voluntary contributions made by many individuals  \* and is licensed under the MIT license. For more information, see  \* .
*/ /\*\*  \* Conversion Exception is thrown when the database to PHP conversion fails.  \*  \* @link   www.doctrine-project.org  \* @since  2.0  \* @author Benjamin Eberlei
* @author Guilherme Blanco
* @author Jonathan Wage
* @author Roman Borschel
*/
namespace Doctrine\DBAL\Types; class ConversionException extends \Doctrine\DBAL\DBALException {     /\*\*      \* Thrown when a Database to Doctrine Type Conversion fails.      \*      \* @param string $value      \* @param string $toType      \*      \* @return \Doctrine\DBAL\Types\ConversionException      \*/     static public function conversionFailed($value, $toType)     {         $value = (strlen($value) \> 32) ? substr($value, 0, 20) . "..." : $value;         return new self('Could not convert database value "' . $value . '" to Doctrine Type ' . $toType);     }     /\*\*      \* Thrown when a Database to Doctrine Type Conversion fails and we can make a statement      \* about the expected format.      \*      \* @param string $value      \* @param string $toType      \* @param string $expectedFormat      \*      \* @return \Doctrine\DBAL\Types\ConversionException      \*/     static public function conversionFailedFormat($value, $toType, $expectedFormat)     {         $value = (strlen($value) \> 32) ? substr($value, 0, 20) . "..." : $value;         return new self(             'Could not convert database value "' . $value . '" to Doctrine Type ' .             $toType . '. Expected format: ' . $expectedFormat         );     } }  
5 
.
 */

/**
 * Conversion Exception is thrown when the database to PHP conversion fails.
 *
 * @link www.doctrine-project.org
 * @since 2.0
 * @author Benjamin Eberlei 
 * @author Guilherme Blanco 
 * @author Jonathan Wage 
 * @author Roman Borschel 
 */
namespace Doctrine\DBAL\Types;

class ConversionException extends \Doctrine\DBAL\DBALException
{
    /**
     * Thrown when a Database to Doctrine Type Conversion fails.
     *
     * @param string $value
     * @param string $toType
     *
     * @return \Doctrine\DBAL\Types\ConversionException
     */
    static public function conversionFailed($value, $toType)
    {
        $value = (strlen($value) > 32) ? substr($value, 0, 20) . "..." : $value;

        return new self('Could not convert database value "' . $value . '" to Doctrine Type ' . $toType);
    }

    /**
     * Thrown when a Database to Doctrine Type Conversion fails and we can make a statement
     * about the expected format.
     *
     * @param string $value
     * @param string $toType
     * @param string $expectedFormat
     *
     * @return \Doctrine\DBAL\Types\ConversionException
     */
    static public function conversionFailedFormat($value, $toType, $expectedFormat)
    {
        $value = (strlen($value) > 32) ? substr($value, 0, 20) . "..." : $value;

        return new self(
            'Could not convert database value "' . $value . '" to Doctrine Type ' .
            $toType . '. Expected format: ' . $expectedFormat
        );
    }
}

 

6

Die Dateien haben damit nichts zu tun.

Öffne mal die s_core_config_values in der Datenbank und suche dir den Eintrag raus, wo “s:18:"info@pyroatelier.de”;"  drin steht. Ändere dann die 18 auf 19 um. Dann nochmal testen. Wenn dasnicht hilft, den Eintrag einfach aus der Tabelle löschen.

 

7

Super. Danke.