Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.This was done on SimplyTest.me with the Devel module added:
Drupal\Core\Database\DatabaseExceptionWrapper: 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 ' '1373704617', '0', '1373704617')' at line 1: INSERT INTO {forum_index} (nid, title, tid, sticky, created, comment_count, last_comment_timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, , :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 207 [:db_insert_placeholder_1] => Rusticus [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_4] => 1373704617 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 1373704617 ) in Drupal\Core\Database\Connection->query() (line 571 of /home/s4465d8fbc820c87/www/core/lib/Drupal/Core/Database/Connection.php).
Drupal\Core\Entity\EntityStorageException: 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 ' '1373704617', '0', '1373704617')' at line 1: INSERT INTO {forum_index} (nid, title, tid, sticky, created, comment_count, last_comment_timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, , :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 207 [:db_insert_placeholder_1] => Rusticus [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_4] => 1373704617 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 1373704617 ) in Drupal\Core\Entity\DatabaseStorageControllerNG->save() (line 404 of /home/s4465d8fbc820c87/www/core/lib/Drupal/Core/Entity/DatabaseStorageControllerNG.php).
Comments
Comment #1
mgiffordOh ya, somewhat related issue #1997936: Enabling Token throws additional uncaught exception while handling exception
Comment #2
ryandamiencarter@gmail.com CreditAttribution: ryandamiencarter@gmail.com commentedI also get this error when trying to POST a node using the rest module:
node
DATE Friday, August 2, 2013 - 09:11
USER admin
LOCATION http://drupal8-ryry.rhcloud.com/entity/node
REFERRER
MESSAGE Drupal\Core\Database\DatabaseExceptionWrapper: 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 ' '0')' at line 1: INSERT INTO {node_comment_statistics} (nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, , :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 11 [:db_insert_placeholder_1] => 0 [:db_insert_placeholder_2] => 1375434666 [:db_insert_placeholder_3] => [:db_insert_placeholder_5] => 0 ) in Drupal\Core\Database\Connection->query() (line 571 of /var/lib/openshift/51dfb9e150044688dd0002a7/app-root/data/downloads/drupal-8.x-dev/core/lib/Drupal/Core/Database/Connection.php).
SEVERITY Error
Using the following request:
curl -i -v -X POST --cookie "SESSe46efe7dc225d1653f1a20e490c9ca3c=tq3Sgcxd-JV54d1VOb45W-E5zV08rs_MH5sC79fvQpI" -H "Content-Type: application/hal+json" -H "Accept: application/hal+json" -H "X-CSRF-Token: HNIl-DvX-alKT7oTMLCqnBMHnASmU8-QSPlKnkpdrRc" -d '{"type":[{"value":"article"}],"title":[{"value":"New Article"}],"_links":{"type":{"href":"http://drupal8-ryry.rhcloud.com/rest/type/node/article"}}}' http://drupal8-ryry.rhcloud.com/entity/node
Comment #3
ryandamiencarter@gmail.com CreditAttribution: ryandamiencarter@gmail.com commentedComment #12
quietone CreditAttribution: quietone as a volunteer commentedNot sure if this issue belongs in Devel or not. In either case, I cannot reproduce the error.
On Drupal 8.9.0 I did a standard install, enabled book and forum and devel_generate. I generated 5 users and then content for all content types. There were no errors.
The error in #2 is about an error when trying to POST a node using the rest module. There are no steps to reproduce provided. If you are experiencing that error, create a new issue.
Therefore, closing as cannot reproduce. If you are experiencing this problem reopen the issue, by setting the status to 'Active', and provide complete steps to reproduce the issue (starting from "Install Drupal core").
Thanks!