• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

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