Skip to content

Instantly share code, notes, and snippets.

@kylegordon
Created November 3, 2016 17:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kylegordon/f7bc8d161485e523d6ba127d7aba7c4c to your computer and use it in GitHub Desktop.
Save kylegordon/f7bc8d161485e523d6ba127d7aba7c4c to your computer and use it in GitHub Desktop.
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
Copy link

mplattu commented Oct 6, 2017

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

@mplattu
Copy link

mplattu 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