Jump to content

Installation Process: error at step 1


Recommended Posts

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.

Link to post

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.

Link to post

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?!

Link to post

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.

 

Link to post

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...

 

Link to post

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

 

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use