search

siara-cc / esp_arduino_sqlite3_lib

Sqlite3 library for ESP8266 Arduino core
Apache License 2.0
89 stars 19 forks source link

Error Compile ESP 8266 CORE 2.6.3 #13

Open laercionit opened 4 years ago

laercionit commented 4 years ago

Hello, I'm having trouble compiling the example (sqlite3_sdfat) using ESP8266 on ArduinoIDE with core 2..6.3. someone with the same problem?

siara-cc commented 4 years ago

Hi, I just upgraded to 2.6.3 and tried.. I am able to compile and run it. You probably may have to get the SdFat library which is causing this problem. Be sure to get 1.0.7 of SdFat because the latest version causes trouble. See https://github.com/siara-cc/esp_arduino_sqlite3_lib/issues/5#issuecomment-487456337

laercionit commented 4 years ago

Core ESP 2.6.3 integrated SDFAT into its core, it now uses the latest version. I had problems here, it does not compile if used together with FS. I think we need to work on SQLite to support the latest version of SDFAT.

Laercio Junior Cel./Pessoal: (21) 99162-7440 Email Pessoal: laercionit@gmail.com Skype: laercionit

Em dom., 8 de mar. de 2020 às 05:53, Arun notifications@github.com escreveu:

Hi, I just upgraded to 2.6.3 and tried.. I am able to compile and run it. You probably may have to get the SdFat library which is causing this problem. Be sure to get 1.0.7 of SdFat because the latest version causes trouble. See #5 (comment) https://github.com/siara-cc/esp_arduino_sqlite3_lib/issues/5#issuecomment-487456337

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/siara-cc/esp_arduino_sqlite3_lib/issues/13?email_source=notifications&email_token=AACPQHQTLM2GUEI7ZH7RQ6LRGNMJFA5CNFSM4K2THVQ2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEOEQD5I#issuecomment-596181493, or unsubscribe https://github.com/notifications/unsubscribe-auth/AACPQHSFMDTWVM27B5R3RBTRGNMJFANCNFSM4K2THVQQ .

laercionit commented 4 years ago

In this example I am using SD....

Using the ESP8266 Nodemcu 12-E with CORE 2.6.3 I am getting the errors below to compile.

I do not even know where to begin with. Today I use EDB as a database in SD, I want to replace it with SQLite in SD.

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:6:8: error: 'SdFat' does not name a type

static SdFat *sdFats[] = {NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL};

    ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'vfs_vol sdfat_mount(const char, int)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:15:5: error: 'SdFat' was not declared in this scope

 SdFat *sdFat = new SdFat();

 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:15:5: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:0:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:313:7: note: 'sdfat::SdFat'

class SdFat : public SdFileSystem {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:15:12: error: 'sdFat' was not declared in this scope

 SdFat *sdFat = new SdFat();

        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:15:24: error: expected type-specifier before 'SdFat'

 SdFat *sdFat = new SdFat();

                    ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:15:24: error: expected ';' before 'SdFat'

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:18:5: error: 'sdFats' was not declared in this scope

 sdFats[sd_idx] = sdFat;

 ^

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatFile.h:36:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'vfs_file sdfat_open(const char, const char*)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:104:19: error: 'O_RDONLY' was not declared in this scope

define O_READ O_RDONLY

               ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:36:18: note: in expansion of macro 'O_READ'

     imode |= O_READ;

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:104:19: note: suggested alternative:

define O_READ O_RDONLY

               ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:36:18: note: in expansion of macro 'O_READ'

     imode |= O_READ;

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:67:15: note: 'sdfat::O_RDONLY'

const uint8_t O_RDONLY = O_READ;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:105:19: error: 'O_WRONLY' was not declared in this scope

define O_WRITE O_WRONLY

               ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:38:21: note: in expansion of macro 'O_WRITE'

        imode |= O_WRITE;

                 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:105:19: note: suggested alternative:

define O_WRITE O_WRONLY

               ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:38:21: note: in expansion of macro 'O_WRITE'

        imode |= O_WRITE;

                 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:71:15: note: 'sdfat::O_WRONLY'

const uint8_t O_WRONLY = O_WRITE;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:105:19: error: 'O_WRONLY' was not declared in this scope

define O_WRITE O_WRONLY

               ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:41:18: note: in expansion of macro 'O_WRITE'

     imode |= O_WRITE;

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:105:19: note: suggested alternative:

define O_WRITE O_WRONLY

               ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:41:18: note: in expansion of macro 'O_WRITE'

     imode |= O_WRITE;

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:71:15: note: 'sdfat::O_WRONLY'

const uint8_t O_WRONLY = O_WRITE;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:43:22: error: 'O_CREAT' was not declared in this scope

         imode |= O_CREAT;

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:43:22: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatFile.h:36:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:85:15: note: 'sdfat::O_CREAT'

const uint8_t O_CREAT = 0X40;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:45:22: error: 'O_TRUNC' was not declared in this scope

         imode |= O_TRUNC;

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:45:22: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatFile.h:36:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:81:15: note: 'sdfat::O_TRUNC'

const uint8_t O_TRUNC = 0X10;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:48:18: error: 'O_AT_END' was not declared in this scope

     imode |= O_AT_END;

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:48:18: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatFile.h:36:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:83:15: note: 'sdfat::O_AT_END'

const uint8_t O_AT_END = 0X20;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:49:18: error: 'O_CREAT' was not declared in this scope

     imode |= O_CREAT;

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:49:18: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatFile.h:36:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatApiConstants.h:85:15: note: 'sdfat::O_CREAT'

const uint8_t O_CREAT = 0X40;

           ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:51:5: error: 'File' was not declared in this scope

 File file = sdFats[sd_idx]->open(name + 5, imode);

 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:51:5: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:51:10: error: expected ';' before 'file'

 File file = sdFats[sd_idx]->open(name + 5, imode);

      ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:52:10: error: 'file' was not declared in this scope

 if (!file)

      ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:55:28: error: 'file' was not declared in this scope

 memcpy(ret->file_obj, &file, sizeof(File));

                        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_remove(const char*)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:63:5: error: 'SdFat' was not declared in this scope

 SdFat *sdFat = sdFats[sd_idx];

 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:63:5: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:0:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:313:7: note: 'sdfat::SdFat'

class SdFat : public SdFileSystem {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:63:12: error: 'sdFat' was not declared in this scope

 SdFat *sdFat = sdFats[sd_idx];

        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:63:20: error: 'sdFats' was not declared in this scope

 SdFat *sdFat = sdFats[sd_idx];

                ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_exists(const char*)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:73:5: error: 'SdFat' was not declared in this scope

 SdFat *sdFat = sdFats[sd_idx];

 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:73:5: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:0:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:313:7: note: 'sdfat::SdFat'

class SdFat : public SdFileSystem {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:73:12: error: 'sdFat' was not declared in this scope

 SdFat *sdFat = sdFats[sd_idx];

        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:73:20: error: 'sdFats' was not declared in this scope

 SdFat *sdFat = sdFats[sd_idx];

                ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_close(vfs_file*)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:81:11: error: 'File' was not declared in this scope

     ((File *)fd->file_obj)->close();

       ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:81:11: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:81:17: error: expected primary-expression before ')' token

     ((File *)fd->file_obj)->close();

             ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:81:18: error: expected ')' before 'fd'

     ((File *)fd->file_obj)->close();

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_read(vfs_file, void, size_t)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:89:22: error: 'File' was not declared in this scope

 sint32_t ret = ((File *)fd->file_obj)->read(ptr, len);

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:89:22: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:89:28: error: expected primary-expression before ')' token

 sint32_t ret = ((File *)fd->file_obj)->read(ptr, len);

                        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:89:29: error: expected ')' before 'fd'

 sint32_t ret = ((File *)fd->file_obj)->read(ptr, len);

                         ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_write(vfs_file, const void, size_t)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:96:22: error: 'File' was not declared in this scope

 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len);

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:96:22: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:96:28: error: expected primary-expression before ')' token

 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len);

                        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:96:29: error: expected ')' before 'fd'

 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len);

                         ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_lseek(vfs_file*, sint32_t, int)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:105:16: error: 'File' was not declared in this scope

     if ( ((File *)fd->file_obj)->seekSet(off) )

            ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:105:16: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:105:22: error: expected primary-expression before ')' token

     if ( ((File *)fd->file_obj)->seekSet(off) )

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:105:23: error: expected ')' before 'fd'

     if ( ((File *)fd->file_obj)->seekSet(off) )

                   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:106:23: error: expected ')' before ';' token

         return off;

                   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:108:16: error: 'File' was not declared in this scope

     if ( ((File *)fd->file_obj)->seekCur(off) )

            ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:108:16: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:108:22: error: expected primary-expression before ')' token

     if ( ((File *)fd->file_obj)->seekCur(off) )

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:108:23: error: expected ')' before 'fd'

     if ( ((File *)fd->file_obj)->seekCur(off) )

                   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:109:23: error: expected ')' before ';' token

         return off;

                   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:111:16: error: 'File' was not declared in this scope

     if ( ((File *)fd->file_obj)->seekEnd(off) )

            ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:111:16: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:111:22: error: expected primary-expression before ')' token

     if ( ((File *)fd->file_obj)->seekEnd(off) )

                  ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:111:23: error: expected ')' before 'fd'

     if ( ((File *)fd->file_obj)->seekEnd(off) )

                   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:112:23: error: expected ')' before ';' token

         return off;

                   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'sint32_t sdfat_flush(vfs_file*)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:118:5: error: 'File' was not declared in this scope

((File *)fd->file_obj)->sync();

 ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:118:5: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:118:11: error: expected primary-expression before ')' token

((File *)fd->file_obj)->sync();

       ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:118:12: error: expected ')' before 'fd'

((File *)fd->file_obj)->sync();

        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp: In function 'uint32_t sdfat_size(vfs_file*)':

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:123:12: error: 'File' was not declared in this scope

return ((File *)fd->file_obj)->fileSize();

        ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:123:12: note: suggested alternative:

In file included from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/FatLib.h:27:0,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/SdFat.h:33,

             from D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:3:

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\packages\esp8266\hardware\esp8266\2.6.3\libraries\ESP8266SdFat\src/FatLib/ArduinoFiles.h:125:7: note: 'sdfat::File'

class File : public FatFile, public Stream {

   ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:123:18: error: expected primary-expression before ')' token

return ((File *)fd->file_obj)->fileSize();

              ^

D:\SETUP\Programas\Desenvolvimento\ArduinoCoreTest\portable\sketchbook\libraries\Sqlite3\src\sdfat_fns.cpp:123:19: error: expected ')' before 'fd'

return ((File *)fd->file_obj)->fileSize();

               ^
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
#include <vfs.h>
#include <SPI.h>
#include <FS.h>
extern "C" {
#include "user_interface.h"
}
#include <ESP8266WiFi.h>

const char* data = "Callback function called";
static int callback(void *data, int argc, char **argv, char **azColName){
   int i;
   Serial.printf("%s: ", (const char*)data);
   for (i = 0; i<argc; i++){
       Serial.printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
   }
   Serial.printf("\n");
   return 0;
}

int openDb(char *filename, sqlite3 **db) {
   int rc = sqlite3_open(filename, db);
   if (rc) {
       Serial.printf("Can't open database: %s\n", sqlite3_errmsg(*db));
       return rc;
   } else {
       Serial.printf("Opened database successfully\n");
   }
   return rc;
}

char *zErrMsg = 0;
int db_exec(sqlite3 *db, const char *sql) {
   Serial.println(sql);
   long start = micros();
   int rc = sqlite3_exec(db, sql, callback, (void*)data, &zErrMsg);
   if (rc != SQLITE_OK) {
       Serial.printf("SQL error: %s\n", zErrMsg);
       sqlite3_free(zErrMsg);
   } else {
       Serial.printf("Operation done successfully\n");
   }
   Serial.print(F("Time taken:"));
   Serial.println(micros()-start);
   return rc;
}

void setup() {
   Serial.begin(115200);
   sqlite3 *db1;
   char *zErrMsg = 0;
   int rc;
   char *sql;

   system_update_cpu_freq(SYS_CPU_160MHZ);

   SPI.begin();
   vfs_mount("/SD0", SS);

   sqlite3_initialize();

   // Open database 1
   if (openDb("/SD0/census2000names.db", &db1))  return;

   rc = db_exec(db1, "Select * from surnames where name = 'MICHELLE'");
   if (rc != SQLITE_OK) {
       sqlite3_close(db1);
       return;
   }

   sqlite3_close(db1);

}

void loop() {
}
siara-cc commented 4 years ago

Like I said, I think temporarily you can get it working with SdFat 1.0.7 downloaded using Library Manager till I fix it?

laercionit commented 4 years ago

@siara-cc

Unfortunately this is not possible. In CORE 2.6.3 of ESP8266 (Arduino) he incorporated SDFAT, this is in the core of esp8266, there is no way to downgrade.

So I looked for help to try to put SQLite to run on this core, it would be a great replacement for EDB (SLOW)

bhullar89 commented 10 months ago

Is this issue resolved, as i am still getting below errors

`C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:6:8: error: 'SdFat' does not name a type 6 static SdFat *sdFats[] = {NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL}; ^~~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'vfs_vol sdfat_mount(const char, int)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:15:5: error: 'SdFat' was not declared in this scope; did you mean 'sdfat::SdFat'? 15 SdFat *sdFat = new SdFat(); ^~~~~ sdfat::SdFat In file included from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:402:17: note: 'sdfat::SdFat' declared here 402 typedef SdFat32 SdFat; ^~~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:15:12: error: 'sdFat' was not declared in this scope; did you mean 'sdfat'? 15 SdFat *sdFat = new SdFat(); ^~~~~ sdfat C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:15:24: error: expected type-specifier before 'SdFat' 15 SdFat *sdFat = new SdFat(); ^~~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:18:5: error: 'sdFats' was not declared in this scope; did you mean 'sdfat'? 18 sdFats[sd_idx] = sdFat; ^~ sdfat In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'vfs_file sdfat_open(const char, const char*)': c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:122:19: error: 'O_RDONLY' was not declared in this scope; did you mean 'sdfat::O_RDONLY'? 122 #define O_READ O_RDONLY ^~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:36:18: note: in expansion of macro 'O_READ' 36 imode = O_READ; ^~ c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:76:15: note: 'sdfat::O_RDONLY' declared here 76 const uint8_t O_RDONLY = O_READ; ^~~~ c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:123:19: error: 'O_WRONLY' was not declared in this scope; did you mean 'sdfat::O_WRONLY'? 123 #define O_WRITE O_WRONLY ^~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:38:21: note: in expansion of macro 'O_WRITE' 38 imode = O_WRITE; ^~~ c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:80:15: note: 'sdfat::O_WRONLY' declared here 80 const uint8_t O_WRONLY = O_WRITE; ^~~~ c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:123:19: error: 'O_WRONLY' was not declared in this scope; did you mean 'sdfat::O_WRONLY'? 123 #define O_WRITE O_WRONLY ^~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:41:18: note: in expansion of macro 'O_WRITE' 41 imode = O_WRITE; ^~~ c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:80:15: note: 'sdfat::O_WRONLY' declared here 80 const uint8_t O_WRONLY = O_WRITE; ^~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:43:22: error: 'O_CREAT' was not declared in this scope; did you mean 'sdfat::O_CREAT'? 43 imode = O_CREAT; ^~~ sdfat::O_CREAT In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:94:15: note: 'sdfat::O_CREAT' declared here 94 const uint8_t O_CREAT = 0X40; ^~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:45:22: error: 'O_TRUNC' was not declared in this scope; did you mean 'sdfat::O_TRUNC'? 45 imode = O_TRUNC; ^~~ sdfat::O_TRUNC In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:90:15: note: 'sdfat::O_TRUNC' declared here 90 const uint8_t O_TRUNC = 0X10; ^~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:48:18: error: 'O_AT_END' was not declared in this scope; did you mean 'sdfat::O_AT_END'? 48 imode = O_AT_END; ^~~~ sdfat::O_AT_END In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:92:15: note: 'sdfat::O_AT_END' declared here 92 const uint8_t O_AT_END = 0X20; ^~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:49:18: error: 'O_CREAT' was not declared in this scope; did you mean 'sdfat::O_CREAT'? 49 imode = O_CREAT; ^~~ sdfat::O_CREAT In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:94:15: note: 'sdfat::O_CREAT' declared here 94 const uint8_t O_CREAT = 0X40; ^~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:51:17: error: 'sdFats' was not declared in this scope; did you mean 'sdfat'? 51 File file = sdFats[sd_idx]->open(name + 5, imode); ^~ sdfat C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'sint32_t sdfat_remove(const char*)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:63:5: error: 'SdFat' was not declared in this scope; did you mean 'sdfat::SdFat'? 63 SdFat *sdFat = sdFats[sd_idx]; ^~~~~ sdfat::SdFat In file included from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:402:17: note: 'sdfat::SdFat' declared here 402 typedef SdFat32 SdFat; ^~~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:63:12: error: 'sdFat' was not declared in this scope; did you mean 'sdfat'? 63 SdFat *sdFat = sdFats[sd_idx]; ^~~~~ sdfat C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:63:20: error: 'sdFats' was not declared in this scope; did you mean 'sdfat'? 63 SdFat *sdFat = sdFats[sd_idx]; ^~ sdfat C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'sint32_t sdfat_exists(const char*)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:73:5: error: 'SdFat' was not declared in this scope; did you mean 'sdfat::SdFat'? 73 SdFat *sdFat = sdFats[sd_idx]; ^~~~~ sdfat::SdFat In file included from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:402:17: note: 'sdfat::SdFat' declared here 402 typedef SdFat32 SdFat; ^~~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:73:12: error: 'sdFat' was not declared in this scope; did you mean 'sdfat'? 73 SdFat *sdFat = sdFats[sd_idx]; ^~~~~ sdfat C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:73:20: error: 'sdFats' was not declared in this scope; did you mean 'sdfat'? 73 SdFat *sdFat = sdFats[sd_idx]; ^~ sdfat C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'sint32_t sdfat_read(vfs_file, void, size_t)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:89:49: error: invalid conversion from 'void' to 'uint8_t' {aka 'unsigned char*'} [-fpermissive] 89 sint32_t ret = ((File *)fd->file_obj)->read(ptr, len); ^~~
void*
In file included from c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:58, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:70:23: note: initializing argument 1 of 'virtual int fs::File::read(uint8_t*, size_t)' 70 int read(uint8_t* buf, size_t size) override; ~~~^ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'sint32_t sdfat_write(vfs_file, const void, size_t)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:96:58: error: no matching function for call to 'fs::File::write(const void*&, size_t&)' 96 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len); ^ In file included from c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:58, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:59:12: note: candidate: 'virtual size_t fs::File::write(const uint8_t*, size_t)' (near match) 59 size_t write(const uint8_t *buf, size_t size) override; ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:59:12: note: conversion of argument 1 would be ill-formed: C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:96:50: error: invalid conversion from 'const void' to 'const uint8_t' {aka 'const unsigned char*'} [-fpermissive] 96 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len); ^~~
const void*
In file included from c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\common\fsapiconstants.h:58, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatFile.h:36, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatVolume.h:28, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/ExFatLib/ExFatLib.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:33, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:58:12: note: candidate: 'virtual size_t fs::File::write(uint8_t)' 58 size_t write(uint8_t) override; ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:58:12: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:89:33: note: candidate: 'template size_t fs::File::write(T&)' 89 template size_t write(T &src){ ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/FS.h:89:33: note: template argument deduction/substitution failed: C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:96:58: note: candidate expects 1 argument, 2 provided 96 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len); ^ In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Stream.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/HardwareSerial.h:32, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Arduino.h:288, from c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\sdfatconfig.h:46, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/common/SysCall.h:33, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:31, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:76:23: note: candidate: 'size_t Print::write(int8_t)' 76 inline size_t write(int8_t c) { return write((uint8_t) c); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:76:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:75:23: note: candidate: 'size_t Print::write(char)' 75 inline size_t write(char c) { return write((uint8_t) c); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:75:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:73:23: note: candidate: 'size_t Print::write(long long unsigned int)' 73 inline size_t write(unsigned long long t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:73:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:72:23: note: candidate: 'size_t Print::write(long long int)' 72 inline size_t write(long long t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:72:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:71:23: note: candidate: 'size_t Print::write(long unsigned int)' 71 inline size_t write(unsigned long t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:71:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:70:23: note: candidate: 'size_t Print::write(long int)' 70 inline size_t write(long t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:70:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:69:23: note: candidate: 'size_t Print::write(unsigned int)' 69 inline size_t write(unsigned int t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:69:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:68:23: note: candidate: 'size_t Print::write(int)' 68 inline size_t write(int t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:68:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:67:23: note: candidate: 'size_t Print::write(short unsigned int)' 67 inline size_t write(unsigned short t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:67:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:66:23: note: candidate: 'size_t Print::write(short int)' 66 inline size_t write(short t) { return write((uint8_t)t); } ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:66:23: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:62:16: note: candidate: 'size_t Print::write(const char*, size_t)' (near match) 62 size_t write(const char *buffer, size_t size) { ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:62:16: note: conversion of argument 1 would be ill-formed: C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:96:50: error: invalid conversion from 'const void' to 'const char' [-fpermissive] 96 sint32_t ret = ((File *)fd->file_obj)->write(ptr, len); ^~~
const void*

In file included from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Stream.h:27, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/HardwareSerial.h:32, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Arduino.h:288, from c:\users\pushe\onedrive\documents\arduinodata\packages\esp8266\hardware\esp8266\3.0.0\libraries\esp8266sdfat\src\sdfatconfig.h:46, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/common/SysCall.h:33, from C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\libraries\ESP8266SdFat\src/SdFat.h:31, from C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:3: C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:56:16: note: candidate: 'size_t Print::write(const char)' 56 | size_t write(const char str) { | ^~~~~ C:\Users\pushE\OneDrive\Documents\ArduinoData\packages\esp8266\hardware\esp8266\3.0.0\cores\esp8266/Print.h:56:16: note: candidate expects 1 argument, 2 provided C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'sint32_t sdfat_lseek(vfs_file, sint32_t, int)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:105:38: error: 'class fs::File' has no member named 'seekSet'; did you mean 'seek'? 105 | if ( ((File )fd->file_obj)->seekSet(off) ) | ^~~ | seek C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:108:38: error: 'class fs::File' has no member named 'seekCur'; did you mean 'seek'? 108 | if ( ((File )fd->file_obj)->seekCur(off) ) | ^~~ | seek C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:111:38: error: 'class fs::File' has no member named 'seekEnd'; did you mean 'seek'? 111 | if ( ((File )fd->file_obj)->seekEnd(off) ) | ^~~ | seek C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'sint32_t sdfat_flush(vfs_file)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:118:27: error: 'class fs::File' has no member named 'sync' 118 | ((File )fd->file_obj)->sync(); | ^~~~ C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp: In function 'uint32_t sdfat_size(vfs_file)': C:\Users\pushE\OneDrive\Documents\Arduino\libraries\Sqlite3_for_ESP8266\src\sdfat_fns.cpp:123:34: error: 'class fs::File' has no member named 'fileSize' 123 | return ((File )fd->file_obj)->fileSize(); | ^~~~ exit status 1 Error compiling for board Generic ESP8266 Module. Board at COM5 is not available `

siara-cc commented 10 months ago

I think SdFat is not installed. Please download and installed the library v1.0.7 from https://github.com/greiman/SdFat and try compiling again

bhullar89 commented 10 months ago

@siara-cc is sdfat 2.2.2 ( latest ) version not supported ? Do we have any plans to support that ?

siara-cc commented 9 months ago

@bhullar89 There was some issue quite some time back with a later version. I don't remember what the issue was. If that issue has been fixed with sdfat 2.2.2, it may work. If you find it working please let me know so I can remove the note on restriction :-)

Elidlt commented 7 months ago

I think SdFat is not installed. Please download and installed the library v1.0.7 from https://github.com/greiman/SdFat and try compiling again

i had the same problem and install SdFat v 1.0.7 and My problem Solved. by the way for those wanna use inside flash memory insted of sdcard This will confusing its be good if seprate sd users from flash users. thanks.