August 10, 20196 yr 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.
August 10, 20196 yr 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.
August 10, 20196 yr Just in case, Do yo you have created a Database ? Could you look your Db ans see if you have the table created.
August 11, 20196 yr I just installed ClicShopping on my server, no problem everything works fine for me.
August 11, 20196 yr Author @Patrick The Database was created with 10 tables. @Drack I work on a shared server from my webhosting company.
August 11, 20196 yr Author 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?!
August 11, 20196 yr 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.
August 11, 20196 yr Author 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...
August 11, 20196 yr 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
August 11, 20196 yr "Make this action the titles configure.php files ==> I think there is an error. Send this point to the admin to look.
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.