Installation Process: error at step 1

[MG86]

Hi,

At step 1 of the installation process I get the following error message:

"There was a problem importing the database. The following error occured:

SQLSTATE[42000]: Syntax error or access violation: 1064. You have an error in your SQL syntax. check the manual corresponding to your MySQL server version  for the right syntax to use near ')' at line 3.

Please verify the connection parameters and try again."

The server MySQL I'm using is v5.7.

I get this message with Demo and Normal database installation, in French and English.

 

Has someone had this error aready?

Thanks for your help.

[Patrick]

I just tested the latest Github;

My test was on my server with IspConfig php 7 / maria Db;

French / English normal and demo work fine for me and everything is uploaded inside the Db;

That I know, if you are on Cpanel, maybe you must activate some options.

Look if mysqli, curl ... are activated .

I do not use Cpanel, I can not help you a lot on that.

[Drack]

Are you on a server (linux, windows) or local (linux, windows) ?

[Patrick]

Just in case, Do yo you have created a Database ?

Could you look your Db ans see if you have the table created.

 

[Monkey]

I just installed ClicShopping on my server, no problem everything works fine for me.

[MG86]

@Patrick The Database was created with 10 tables.

@Drack I work on a shared server from my webhosting company.

[MG86]

Could it be that I did nothing in step "permissions on files" with regards to the instruction "Make this action the titles configure.php files"...

I don't understand what must be done here...

Maybe it's the reason why I get this error?!

[Patrick]

10 table is weird, I think you must remove your table and re try.

If you have the same problem

look your db in phpmyadmin clic_configuration table (10);

it must be created and populated in part.

Look the last data and  put on the forum the last line.

If there is a problem, it's possible to idenfied it.

 

About the permissions, when you make a new install, it must be in 777 to allow to write inside. (see with your ftp for that) and after installation, it must be in 444 for security.

note : I come back in arround 3 hr.

 

[MG86]

I removed all tables and started the installation anew.

I'm still getting 10 tables and clic_configuration is not one of them.

The 10 tables are: clic_action_recorder / clic_address_book / clic_address_format / clic_administrators / clic_administrator_menu / clic_administrator_menu_description / clic_banners / clic_banners_history / clic_categories / clic_categories_description.

I guess it stops just before creating this table clic_configuration.

 

About the permissions, I set the 777 rights in FileZilla to all listed files in the procedure, but the last sentence of the process "Make this action the titles configure.php files" I don't understand...

 

[Patrick]

clic_configuration is not created. Ok !!!

Look this directory /shop/includes/schema/configuration.txt

Do you have exactly this :

 

configuration_id int not_null auto_increment
configuration_title varchar(255) not_null
configuration_key varchar(255) not_null
configuration_value text not_null
configuration_description text not_null
configuration_group_id int not_null
sort_order int(5)
last_modified datetime
date_added datetime not_null
use_function varchar(255)
set_function varchar(255)
--
primary configuration_id
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci

 

[Julie]

"Make this action the titles configure.php files ==> I think there is an error.

Send this point to the admin to look.