Error #1064 setting up suitecrm database

English Language - Forum
1

Trying to install this software for a tryout and it will not connect to database. Following a youtube video for setup i created a database and input some sql statements for user and password and i get this error.

Any program that is this complicated an install makes me wonder if it is any good from the start. What a seemless install could not be created to work

Thanks for any assistance any member can give me. Robert

Error SQL query:
CREATE DATABASE’suitecrm’
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘‘suitecrm’ DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1

2

Hi @ryerex,

Welcome to the community!

Could you please let me know what version of SuiteCRM you are trying to install?

Also during installation under the database section ensure the fields have the correct values as exampled below;

Database Name: unique_database_name 
Host Name: mariadb or mysql or mssql
User: valid_db_name (Ensure user has access to the database)
Password: valid_db_pass
3

Hello m.rae,

Thank you for the welcome message.

I downloaded the latest version SuiteCRM 7.11.10 ZIP. I extracted the zip file and made it to the setup wizard. Filled out the user and database info and attempted to complete but did not work.

Watched a video on youtube that explained setup. Created the suitecrm database in phpadmin, created the user and granted privileges based on video instructions and could not complete the setup, got the sql error #1064.

4

Sure, lets have a look. Can you confirm whether you run the following;

Required Prerequisites
Copy the installer package to the installation directory
Unzip the installation package
Run composer Install in the root directory
Set permissions & ownership;

sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload
sudo chmod 775 config_override.php 2>/dev/null
5

Yes i can confirm your required prerequisites were followed.

Copy the installer package to the installation directory - YES
Unzip the installation package - YES
Run composer Install in the root directory - YES
Set permissions & ownership; - YES

6

Great, next we’ll look at the database. Are you able to make a connection to the database from the SuiteCRM installation location using mysql -u $user -p $pass -h $host (Only needed when on a different host) from the command line?

When you successfully connect try typing show databases; and ensure you see the database for SuiteCRM.

If you can’t connect try updating the DB users password to ensure you are using the correct one.

If you can’t see the database within the list ensure you have given the correct permissions to the DB user

7

That video is no good. You shouldn’t create the database manually, you should let the installer create it. Just follow the official instructions.

8

Thank you gentlemen but i have decoded to review other software. Robert