mr-wiggle

This is an issue with the SPIFFS file system. I started out using this library on SPIFFS and was getting Disk Image Malformed errors all over the place. I switched...

Wow, thanks for the super fast response! I'm unfortunately not very well read when it comes to VFS layers and how they operate. The literature suggests that you can choose...

Not sure if this is a clue or completely unrelated: I can't get the library to compile in Sloeber (basically Eclipse but uses the Arduino ESP32 core). Just including the...

I too am having issues with the updated library. I updated the Sqlite3Esp32 Library to 2.1.0 in Arduino IDE. I still get the i/o error (code 10) when creating a...

I tested using V2.3 and have the same issues (both with the Unique constraint causing the disk I/O error and with the memory issues ( malloc failed in Sqlite and...

I have a bit of info that I've found which might be helpful. I recently switched over to LittleFS from SPIFFS and I've found that I can successfully use things...

I've had success running this on LittleFS. There is one main behavior that is different than in SPIFFS that I've found: In SPIFFS, if you try to open a database...

Can you post your code? one thing you can check too is to have the "/littlefs" prefix included in all the sqlite calls, but don't include it when you're working...

Looks like the issue is that you're not creating the journal file. That will allow you to open the database, but not do anything to it, which appears to be...

this is a SPIFFS error. Change your filesystem to LITTLEFS and you should be good to go.