problem during installation

[charles Pinoteau]

Hello , 

if someone could help me  i'm stuck  :(,

 

when I launch the installation I have the following problem :

ElasticSearch server index name (blank to autogenerate) : 

Phraseanet is going to be installed, continue ? (N/y)y

PHP Fatal error:  Uncaught Symfony\Component\Debug\Exception\UndefinedFunctionException: Attempted to call function "simplexml_load_file" from namespace "Alchemy\Phrasea\Setup". in /var/www/Phraseanet/lib/Alchemy/Phrasea/Setup/Installer.php:133

Stack trace:

#0 /var/www/Phraseanet/lib/Alchemy/Phrasea/Setup/Installer.php(35): Alchemy\Phrasea\Setup\Installer->rollbackInstall(Object(Doctrine\DBAL\Connection), Object(Doctrine\DBAL\Connection))

#1 /var/www/Phraseanet/lib/Alchemy/Phrasea/Command/Setup/Install.php(169): Alchemy\Phrasea\Setup\Installer->install('phraseanet@tv...', 'phraseat', Object(Doctrine\DBAL\Connection), 'phraseanet', Array, Object(Doctrine\DBAL\Connection), 'fr-simple', Array)

#2 /var/www/Phraseanet/lib/Alchemy/Phrasea/Command/Command.php(63): Alchemy\Phrasea\Command\Setup\Install->doExecute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

#3 /var/www/Phraseanet/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php(264): Alchemy\Phra in /var/www/Phraseanet/lib/Alchemy/Phrasea/Setup/Installer.php on line 133

[Moctar Diouf]

Hello,

Seems like you are facing a matter dealing with sql_mode.

What is the result of theses mysql requests ?

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

Regards

--
You received this message because you are subscribed to the Google Groups "phrasea-install-en" group.
To unsubscribe from this group and stop receiving emails from it, send an email to phrasea-install...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/phrasea-install-en/cde68bd9-ac07-4ce9-904d-8fc4151a628cn%40googlegroups.com.

[charles Pinoteau]

 thank you for your time  

 

here is the result of these commands :

mysql> SELECT @@GLOBAL.sql_mode;

+-------------------------------------------------------------------------------------------------------------------------------------------+

| @@GLOBAL.sql_mode                                                                                                                         |

+-------------------------------------------------------------------------------------------------------------------------------------------+

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+-------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

mysql> SELECT @@SESSION.sql_mode;

+-------------------------------------------------------------------------------------------------------------------------------------------+

| @@SESSION.sql_mode                                                                                                                        |

+-------------------------------------------------------------------------------------------------------------------------------------------+

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+-------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

[Moctar Diouf]

This is what is causing the problem

To fix this :

add a line 

sql_mode = 

under [mysqld] 

into the my.cnf or a mysql/conf.d/specific.conf file

restart mysql or mariadb and retry the installation.

Regards

To view this discussion on the web visit https://groups.google.com/d/msgid/phrasea-install-en/eb92c339-3644-440f-a2a3-e7c969b2c666n%40googlegroups.com.

[charles Pinoteau]

mysql> set global sql_mode='UNDER' ;            <----- ???

how can i do it under Mysql please , i don't know how to do that  :(

[Moctar Diouf]

I mean,

edit the mysql configuration file which can be her « /etc/mysq/my.cnf »

add the line below under the [mysqld] section

sql_mode=

To view this discussion on the web visit https://groups.google.com/d/msgid/phrasea-install-en/2460bae5-7f01-4463-a8ec-573b24e57bd4n%40googlegroups.com.

[charles Pinoteau]

ok I try that now

[charles Pinoteau]

root@ns319:/etc/mysql# cat my.cnf

#

# The MySQL database server configuration file.

#

# You can copy this to one of:

# - "/etc/mysql/my.cnf" to set global options,

# - "~/.my.cnf" to set user-specific options.

# 

# One can use all long options that the program supports.

# Run program with --help to get a list of available options and with

# --print-defaults to see which it would actually understand and use.

#

# For explanations see

# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#

# * IMPORTANT: Additional settings that can override those from this file!

#   The files must end with '.cnf', otherwise they'll be ignored.

#

[mysqld]

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

!includedir /etc/mysql/conf.d/

!includedir /etc/mysql/mysql.conf.d/

__________________________

i restarted mysql service but i still have the same problem :(   could you tell me if i was wrong in my.cnf  please ?  

thank you so much  

On Friday, November 20, 2020 at 6:06:13 PM UTC+1 MD wrote: