instalation problem

[NGS_T]

Hello i am trying to install the software on my vps but i cant i get this error


Error while inserting data into the database:
'SET NAMES ''''utf8'''''
Unknown character set: ''''(Error: : 1115)

any idea what this is ?
and how to fix it

thank youfor your time

[San Diego]

hi
thats a nice error, but what have you done, would help
is your php version right
did you ask for the install ad first start
did you turn global on
did you set chmod right

check out the wiki for further infos

sd

[NGS_T]

i have fixt all the error on instalation with chmod and others
server can conect to my database but i get this how must be my database
what charset

my PHP Version 5.2.6

[San Diego]

there you got it sir
what do you think does the word recommended mean hä

your host needs to help you with that

nobody of us can from far away
normally from backend php settings or how ever your host loves to call it
there is a script flying arround in the forum, don´t ask me where i saw it
where you can enter your settings as a description.
just look a bit arround

sd

[San Diego]

i´m confused
did you edit your answer while i wrote mine

sd

[NGS_T]

yes i edit my post becouse i fout the first error but the error of the database not
can you tell me
what charset i must have on my database
my currect charset is utf8_unicode_ci is this corect sect

here is detailed mysql charset
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/



collation_connection utf8_unicode_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

a fast search on this forum i found 2 topic with this error but none of them had the solution for that i made a post
i am serching for that error i have never seen somthing like that

[San Diego]

you can´t change settings afterwards
charsetlooks right to me but is not my favorit subject

you need to install new from scratch via fireftp works best sofar binarymode
all settings green and name your next database shop_ or NGS or what ever not ps_ anymore to avoid conflicts

but first delete all files from the server and double check if your ht access file is uploaded.

sd

[Psychodays]

what si the charset of your database? see the structure of the tables, you shoul have a clue on this.

[NGS_T]

if i change those

character_set_database latin1
character_set_server latin1

will thes work ?
is strange no unser from a mondarator

[NGS_T]

these error is coming from file db.sql


SET NAMES 'utf8'; <---- error i changet with character set 'utf8';

after that i get this error
Error while inserting data into the database:
'character set ''''utf8'''' CREATE TABLE `ps_access` ( `id_profile` int(10) unsigned NOT NULL, `id_tab` int(10) unsigned NOT NULL, `view` int(11) NOT NULL, `add` int(11) NOT NULL, `edit` int(11) NOT NULL, `delete` int(11) NOT NULL, PRIMARY KEY (`id_profile`,`id_tab`) ) ENGINE=MyISAM DEFAULT CHARSET=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 ''character set ''''utf8'''' CREATE TABLE `ps_access` ( `id_profile` int(10) unsign'' at line 1(Error: : 1064)

[San Diego]

hi

you through your stuff in the forum but i don´t get a clue what you want and what you are going to do

you mass arround with the code not knowing what you do i guess
and there is no moderator who is taking you by the hand and is leading you through all steps
of your installation thats what the wiki is made for.

what you do is like: help please! in china a bycicle had an accident can anybody tell me why.

sd

[NGS_T]

i am writting that i cant install it i will explain it with pictures then

see the picture on the atachments is clear what i am trying to do

[San Diego]

ok
did you ask your provider
they should help you this is not a presta problem

i told you also if you install new don´t use ps_ as database name again
to avoid conflicts

i´m on the way to the airport can´t dive in it right now
sorry

[NGS_T]

there is no provider my vps is self manage and i don't have problem with any other script only with these

[NGS_T]

thank you guys i see no answer from your part

is there is no help hen i am not continue with this script thank you very much

[shacker]

the solution is here:

http://www.rsi-sistemas.com.ar/presta/sql.rar

reemplace the sql files in your install/sql files of your prestashop store.

[gociak]

I have same problem. After 2 step, when im tryin to install database i get this:

Error while inserting data into 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)

1. and 2. step no preblems...database connected.
Can somebody help me???

[shacker]

I have same problem. After 2 step, when im tryin to install database i get this:

Error while inserting data into 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)

1. and 2. step no preblems...database connected.
Can somebody help me???

Is a server problem. Check the latest version 1.4 beta, maybe this works fine. If not, change for a linux server hosting