Error on Installation with PrestaShop 8.20.0

wolfomat · March 22

Hi There, i am trying to install a PrestaShop. It's the 2nd time i am doing this. The Version 8.1.5 installed perfectly and the shop is running - great.

Now, i tried to install the latest version 8.20.0 on the same server, but now it gives me folling error:

1: 0
2: 1
[WARNING] Some commands could not be registered:
3: 2
4: 3
In Configuration.php line 331:
5: 4
6: 5
PrestaShop\PrestaShop\Adapter\Configuration::restrictUpdatesTo(): Argument
7: 6
#1 ($shop) must be of type Shop, null given, called in /var/www/web194/html
8: 7
/prestashop/src/Core/Addon/Theme/ThemeManagerBuilder.php on line 61
9: 8
10: 9
11: 10
12: 11
[WARNING] Some commands could not be registered:
13: 12
14: 13
In Configuration.php line 331:
15: 14
16: 15
PrestaShop\PrestaShop\Adapter\Configuration::restrictUpdatesTo(): Argument
17: 16
#1 ($shop) must be of type Shop, null given, called in /var/www/web194/html
18: 17
/prestashop/src/Core/Addon/Theme/ThemeManagerBuilder.php on line 61
19: 18
20: 19
21: 20
Updating database schema...
22: 21
22:19:05 CRITICAL [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "Unknown column type "binary_string" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information." ["exception" => Doctrine\DBAL\Exception { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => "Unknown column type "binary_string" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information."]
23: 22
24: 23
In DBALException.php line 282:
25: 24
26: 25
Unknown column type "binary_string" requested. Any Doctrine type that you u
27: 26
se has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can
28: 27
get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesM
29: 28
ap(). If this error occurs during database introspection then you might hav
30: 29
e forgotten to register all database types for a Doctrine Type. Use Abstrac
31: 30
tPlatform#registerDoctrineTypeMapping() or have your custom types implement
32: 31
Type#getMappedDatabaseTypes(). If the type name is empty you might have a
33: 32
problem with the cache or forgot some mapping information.
34: 33
35: 34
36: 35
prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--]
37: 36
38: 37

What can i do to fix this issue?

Database:

Server-Typ: MySQL

Server-Version: 5.7.25 - MySQL Community Server (GPL)

Protokoll-Version: 10

PHP-Version: PHP 8.2

Edited March 22 by wolfomat (see edit history)

Nickz · March 22

30 minutes ago, wolfomat said:

Now, i tried to install the latest version 8.20.0 on the same server, but now it gives me folling error:

Does the 8.2 use the same settings, dependencies and php version?

Edited March 22 by Nickz (see edit history)

wolfomat · March 23

Hi Nickz,

it is the Same Server. However, somehow phpinfo() Prints a 7.2 php Version.

Greetings

Nickz · March 23

Ok

You need to read a little: https://royalitsolution.org/managing-php-versions-on-your-server-guide/

wolfomat · March 23

Thanks, i‘ll give it a Shot and come back After working through

wolfomat · March 27

Hi Nick, thanks for the good read, i've managed to achieve this one:

PHP Version 8.2.6 (as shown from <?php phpinfo(); ?> in an info.php file besides the folder).

However, on retry this error messages was shown, looks like the error shown before.

1: 0
2: 1
[WARNING] Some commands could not be registered:
3: 2
4: 3
In Configuration.php line 331:
5: 4
6: 5
PrestaShop\PrestaShop\Adapter\Configuration::restrictUpdatesTo(): Argument
7: 6
#1 ($shop) must be of type Shop, null given, called in /var/www/web194/html
8: 7
/prestashop/src/Core/Addon/Theme/ThemeManagerBuilder.php on line 61
9: 8
10: 9
11: 10
12: 11
[WARNING] Some commands could not be registered:
13: 12
14: 13
In Configuration.php line 331:
15: 14
16: 15
PrestaShop\PrestaShop\Adapter\Configuration::restrictUpdatesTo(): Argument
17: 16
#1 ($shop) must be of type Shop, null given, called in /var/www/web194/html
18: 17
/prestashop/src/Core/Addon/Theme/ThemeManagerBuilder.php on line 61
19: 18
20: 19
21: 20
Updating database schema...
22: 21
21:28:33 CRITICAL [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "Unknown column type "binary_string" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information." ["exception" => Doctrine\DBAL\Exception { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => "Unknown column type "binary_string" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information."]
23: 22
24: 23
In DBALException.php line 282:
25: 24
26: 25
Unknown column type "binary_string" requested. Any Doctrine type that you u
27: 26
se has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can
28: 27
get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesM
29: 28
ap(). If this error occurs during database introspection then you might hav
30: 29
e forgotten to register all database types for a Doctrine Type. Use Abstrac
31: 30
tPlatform#registerDoctrineTypeMapping() or have your custom types implement
32: 31
Type#getMappedDatabaseTypes(). If the type name is empty you might have a
33: 32
problem with the cache or forgot some mapping information.
34: 33
35: 34
36: 35
prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--]
37: 36
38: 37

Edited March 27 by wolfomat (see edit history)

Nickz · March 27

Warnings you could just ignore.

wolfomat · March 27

I can‘t Finish the setup.

I suspect that the DBALException is the true error Herr, which does not allow me to finish the setup.

wolfomat · March 27

This one:

22:19:05 CRITICAL [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "Unknown column type "binary_string" requested

Knowband Plugins · March 28

You have mentioned PHP version 8.2. I don't think PHP 8.2 is supported with Prestashop 8.2

Trying switching PHP8.1

https://devdocs.prestashop-project.org/8/basics/installation/system-requirements/

wolfomat · March 31

ok. my setup is now:

Server-Typ: MySQL Server-Version: 5.7.25 - MySQL Community Server (GPL)

Protokoll-Version: 10

Server-Zeichensatz: UTF-8 Unicode (utf8)

and:

PHP Version 8.1.19

i execude phppsinfo.php, with result:
var | required | recommended | current
ax_input_vars 1000 5000 1000

PHP Extensions

setting | required | recommended | current
Memcached No Yes No

app/Resources/translations Directory not exists

The only red point is app/Resources/translations, which does not exists.

everything is green, and at least set to where it's recommended....

wolfomat · March 31

pdating database schema...

22: 21

21:55:39 CRITICAL [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "Unknown column type "binary_string" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information." ["exception" => Doctrine\DBAL\Exception { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => "Unknown column type "binary_string" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information."]

23: 22

24: 23

In DBALException.php line 282:

25: 24

26: 25

Unknown column type "binary_string" requested. Any Doctrine type that you u

27: 26

se has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can

28: 27

get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesM

29: 28

ap(). If this error occurs during database introspection then you might hav

30: 29

e forgotten to register all database types for a Doctrine Type. Use Abstrac

31: 30

tPlatform#registerDoctrineTypeMapping() or have your custom types implement

32: 31

Type#getMappedDatabaseTypes(). If the type name is empty you might have a

33: 32

problem with the cache or forgot some mapping information.

Still this issue, i am not sure what i can do here....

do i need to replace "binary_string" to "binary" by hand somewhere ?

Edited March 31 by wolfomat (see edit history)

Nickz · June 27

On 3/31/2025 at 9:01 PM, wolfomat said:
 DBALException.php line 282:

A solution was offered here https://stackoverflow.com/questions/66877263/error-uncaught-php-exception-doctrine-dbal-dbalexception

Clear the cache.

Error on Installation with PrestaShop 8.20.0

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in