SQLSTATE[HY000]: General error: 1 too many SQL variables: INSERT OR REPLACE INTO {cache_content} (cid, expire, created, tags, checksum, data, serialized)

Created on 22 April 2019, over 5 years ago
Updated 2 May 2024, 8 months ago

Problem/Motivation

After importing content into a Drupal site (running on SQLite) I recieve the following error when I go to /admin/config/development/content

The website encountered an unexpected error. Please try again later.</br></br><em class="placeholder">Drupal\Core\Database\DatabaseExceptionWrapper</em>: SQLSTATE[HY000]: General error: 1 too many SQL variables: INSERT OR REPLACE INTO {cache_content} (cid, expire, created, tags, checksum, data, serialized) VALUES 

with hundreds of placeholders.

Proposed resolution

TBD

Remaining tasks

  1. Write Tests
  2. Write Patch

User interface changes

None

API changes

None

Data model changes

None

πŸ› Bug report
Status

Closed: cannot reproduce

Version

11.0 πŸ”₯

Component
DatabaseΒ  β†’

Last updated 2 days ago

  • Maintained by
  • πŸ‡³πŸ‡±Netherlands @daffie
Created by

πŸ‡ΊπŸ‡ΈUnited States davidwbarratt

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States Kristen Pol Santa Cruz, CA, USA

    Thanks for reporting this issue. We rely on issue reports like this one to resolve bugs and improve Drupal core.

    As part of the Bug Smash Initiative, we are triaging issues that are marked "Postponed (maintainer needs more info)". This issue was marked "Postponed (maintainer needs more info)" more than 6 months ago with a request for steps to reproduce and there has been no activity since that time.

    Since we need more information to move forward with this issue, I am tagging for Bug Smash Initiative and keeping the status at Postponed (maintainer needs more info). If we don't receive additional information to help with the issue, it may be closed after three months.

    Thanks!

  • Status changed to Closed: cannot reproduce 8 months ago
  • πŸ‡¦πŸ‡ΊAustralia pameeela
Production build 0.71.5 2024