• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • This community is user driven. Be polite with other users.
    • We recommend purchasing a Chevereto license to participate in this community.
    • Purchase a Community Subscription to get even faster ticket response times.

PDOException: SQLSTATE[42000] (Installing Chevereto)

Status
Not open for further replies.
I

imgius

Chevereto Member

I encountered a problem when installing Chevereto. The error says:
There is a problem regarding your config setup. This means that Chevereto won't run because the config is not valid:
  • PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'CREATE TABLE chv_images ( image_id bigint(20) NOT NULL AUTO_INCREMENT, ' at line 2
Please double-check your settings in the includes/config.php file.

I double checked all the details in the config (inputted the db name, db user, db pass). The user has all permissions. I already updated my MySQL version to 5.5.27.
 
Are you sure that the mysql user has privileges over that database? It seems to me that the user can't create the table.
 
Hi, is this problem solved? Please let me know if you need more help. 😉
 
Status
Not open for further replies.
Back
Top