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

SimpleCC · 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 · July 25, 2024

(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 · September 16, 2024

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 · September 16, 2024

@zrbs: See above.

liyany · 2024-11-06T07:21:29+00:00

Is that1330990978? I tried, but the debug ID did not appear. I clicked on "Report Error." please help me，thank you!

dstillman · 2024-11-06T07:24:40+00:00

@liyany: Please re-read what I say above — I say exactly what we need.

liyany · 2024-11-06T07:27:23+00:00

D56715421, I am sorry , this one.

dstillman · 2024-11-06T07:35:47+00:00

@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 · 2024-11-06T07:41:05+00:00

D1995561489

dstillman · 2024-11-06T09:12:24+00:00

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 · 2024-11-06T10:21:56+00:00

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 · 2024-11-06T10:46:42+00:00

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.