install error at 45% "Cannot create admin account"

[hybridsas]

Hello, installing PS on a new cloud server I have constantly an install error at 45% explained as "unidentified error". From the log of PS I see that the error says "cannot create user account".

The strange thing is that I use the root user of MySql, infact the tables are correctly created on the db schema but probably when the install procedure try to insert the admin data on the Employee table, the operation fails.

my webserver is Windows 208R2 with all the latest patch, iis 7with PHP 5.6 and MySql server 5.7.

With previous webserver with the same configuration I never got a problem in installing PS.

Thanks for your help.

Davide

[Appwards]

I'm afraid there is some changes in MySQL 5.7 that do not sit well with Prestashop.

I just ran into an error too that suddenly arises after I upgraded from MySQL 5.2 to 5.7

 

This query is not legal anymore, which completely breaks the order importing feature.

 

UPDATE 
`ps_order_invoice` 
SET number = (
SELECT 
new_number 
FROM (
SELECT 
(MAX(`number`) + 1) AS new_number
FROM 
`ps_order_invoice`
) AS result) 
WHERE `id_order_invoice` = 10

[Kerm]

Hello, try this:

http://stackoverflow.com/questions/20373532/mysql-setting-sql-mode-permanently/20373628