7 replies to this topic

[akboselk]

Hi

PS 1.4.4 installation error as below. I am on cpanel server

Initial steps (1 & 2 ) OK with ALL recommendation settings accepted. Folder permision also Correct

On STEP 3 >> DB connection Fine. also mail delivery OK

Now here the issue,
===================

On STEP 3 >> Installation type >> Simple Mode , giving below error

----------------
Error while inserting data in the database:
'SET NAMES \\\'utf8\\\''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'\\\'utf8\\\'\' at line 1(Error: : 1064)
----------------

On STEP 3 >> Installation type >> Full mode , giving below error

----------------
Error while inserting data in the database:
'SET NAMES \\\'utf8\\\''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'\\\'utf8\\\'\' at line 1(Error: : 1064)
----------------


So How we goto Next step and complete the installation ? How to Fix this installation problem on STABLE 1.4.4 ?


thanks

[Kerm]

DB user has all privileges? U create new DB with UTF8 encoding?

I think here some thing wrong with mysql

[akboselk]

Hi Kerm

DB user has all privileges? YES, DB Connection is OK

U create new DB with UTF8 encoding? >> There is no place to select on cPanel >> MySQL when it create. But phpMyAdmin I can see utf8_general_ci

--------- MySQL settings as below ---------------------

MySQL connection collation : utf8_general_ci


MYSQL
Server: Localhost via UNIX socket
Server version: 5.0.92-community-log
Protocol version: 10
User: multilan@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web SERVER
cpsrvd 11.30.2.1
MySQL client version: 4.1.22
PHP extension: mysql Documentation


phpMyAdmin
Version information: 3.4.3.2
Documentation
Wiki
Official Homepage
Contribute
Get support
List of changes

------------------------------------------
My settings as above and please check it and let me now how to solve it ?


Note : I have another PS installation (Ver 1.4.0.17 ) working on same hosting account)

[Kerm]

Try turn off "Magic Quotes"

[akboselk]

Hi Kerm

Thank you so much for the help , now it is working fine.

And one more thing, will there be any BO or FO functioning problem due to this Magic Quotes OFF ?

Thanks

[Kerm]

Prestashop requires turn off this function for normal installation and normal site work.

[liudas]

Hello guys. This is the way I managed to solve this problem:

Symptoms:

1. installation stuck on step 3 (DB connection – OK; Installation progress animation; but no success to move to step 4);
2. my mysql database engine is set to MyISAM;
3. default PS installation engine is selected as InnoDB;

Solution:

in step 3 choosing MyISAM DB engine helped me successfully move to step 4

Hope my experience will help you.

[Kerm]

Solve in my last post...change to MyISAM help u mb, but if u turn off magic quotes...u can use InnoDB and it's more better then MyISAM