Error(s) encountered during statement execution: column index out of range

SimpleCC
edited July 25, 2024
ID:574682951

[JavaScript Error: "Error(s) encountered during statement execution: column index out of range [QUERY: SELECT DISTINCT itemID
FROM itemDataValues
JOIN itemData USING (valueID)
JOIN items USING (itemID)
LEFT JOIN deletedItems USING (itemID)
WHERE deletedItems.itemID IS NULL
AND libraryID = ?
AND itemTypeID = ?
AND fieldID IN (?, ?, ?, ?)
AND SUBSTR(value, 1, 4) >= '?'
AND SUBSTR(value, 1, 4) <= '?'
AND itemID IN (?, ?, ?, ?);] [PARAMS: 1, 37, 48, 91, 109, 6, 2021, 2023, 11, 78, 90, 99] [ERROR: column index out of range]" {file: "chrome://zotero/content/xpcom/db.js" line: 686}]


[additional errors removed — D.S.]
  • dstillman
    (We only ever want Report IDs and Debug IDs here. We'll excerpt relevant output as necessary.)

    Can you reproduce this in Troubleshooting Mode (Help → "Restart in Troubleshooting Mode…”), which temporarily disables all plugins? If so, can you provide a Debug ID for Zotero startup through getting this error, using the "Restart with Logging Enabled…" option?
  • zrbs
    I encountered similar issue when sygn file to Koofr.

    Error(s) encountered during statement execution: column index out of range [QUERY: SELECT DISTINCT itemID
    FROM itemDataValues
    JOIN itemData USING (valueID)
    JOIN items USING (itemID)
    LEFT JOIN deletedItems USING (itemID)
    WHERE deletedItems.itemID IS NULL
    AND libraryID = ?
    AND itemTypeID = ?
    AND fieldID IN (?, ?, ?, ?)
    AND SUBSTR(value, 1, 4) >= '?'
    AND SUBSTR(value, 1, 4) <= '?'
    AND itemID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
  • dstillman
    @zrbs: See above.
  • liyany
    Is that1330990978? I tried, but the debug ID did not appear. I clicked on "Report Error." please help me，thank you!
  • dstillman
    @liyany: Please re-read what I say above — I say exactly what we need.
  • liyany
    D56715421, I am sorry , this one.
  • dstillman
    @liyany: That's not from Zotero startup and doesn't show the error occurring. Can you 1) disable all plugins in Tools → Plugins and 2) use Help → Debug Output Logging → "Restart from Logging Enabled…" to provide a Debug ID for reproducing the error from Zotero startup?
  • liyany
    D1995561489
  • dstillman
    That’s still not from Zotero startup, still isn’t with all plugins disabled, and still doesn’t show you reproducing that actual error you’re reporting above. If you’re having trouble understanding us, please ask someone to read what we’ve asked for and help you provide it, but as it is, we can’t help you with what you’ve provided.
  • liyany
    I followed the steps you mentioned, except for the first time. All of my plugins have been disabled, and none are running now. After clicking on the troubleshooting mode to restart, I didn't get the error message anymore; perhaps the system had already fixed it for me. Thanks again for your response.
  • dstillman
    No, all the things I said in my last message about the last Debug ID you provided are true. But if you can't reproduce the problem in Troubleshooting Mode, you should restart in normal mode and see if the problem comes back. If it does, you'll need to identify the plugin that's causing it and then report the problem to the plugin's developer.
Sign In or Register to comment.