Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
projectsend pdo error
There seems to be an error. Please try again.
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'expiry_date'' in /var/www/html/install/index.php:31 Stack trace: #0 /var/www/html/install/index.php(31): PDOStatement->execute(Array) #1 /var/www/html/install/index.php(108): try_query(Array) #2 {main}
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint' in /var/www/html/install/index.php:31 Stack trace: #0 /var/www/html/install/index.php(31): PDOStatement->execute(Array) #1 /var/www/html/install/index.php(108): try_query(Array) #2 {main}
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint' in /var/www/html/install/index.php:31 Stack trace: #0 /var/www/html/install/index.php(31): PDOStatement->execute(Array) #1 /var/www/html/install/index.php(108): try_query(Array) #2 {main}
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint' in /var/www/html/install/index.php:31 Stack trace: #0 /var/www/html/install/index.php(31): PDOStatement->execute(Array) #1 /var/www/html/install/index.php(108): try_query(Array) #2 {main}
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'' in /var/www/html/install/index.php:31 Stack trace: #0 /var/www/html/install/index.php(31): PDOStatement->execute(Array) #1 /var/www/html/install/index.php(108): try_query(Array) #2 {main}
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint' in /var/www/html/install/index.php:31 Stack trace: #0 /var/www/html/install/index.php(31): PDOStatement->execute(Array) #1 /var/www/html/install/index.php(108): try_query(Array) #2 {main}
@mplattu

This comment has been minimized.

Copy link

commented Oct 6, 2017

I got the same error while trying to install ProjectSend. Did you get around this?

@mplattu

This comment has been minimized.

Copy link

commented Oct 6, 2017

Answering to myself: projectsend/projectsend#429

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.