Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Error with sqlite QSqlError("10", "Unable to fetch row", "disk I/O error")

Error with sqlite QSqlError("10", "Unable to fetch row", "disk I/O error")

Scheduled Pinned Locked Moved Unsolved General and Desktop
6 Posts 3 Posters 789 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Charlie_BillyC Offline
    Charlie_BillyC Offline
    Charlie_Billy
    wrote on last edited by
    #1

    Hello, I'm trying to make a Discord guild saver, but there is this error ocurring "randomly" which prevent me from doing it.
    Here is my code : https://pastebin.com/KZiiwVtu
    Sometime the error only appear on guild, but it doesn't save all the channels to the db, and rows are inserted randomly : alt text

    QVariant(QString, "vérification")
    QSqlError("", "", "") channel
    QVariant(QString, "info")
    QSqlError("", "", "") channel
    QVariant(QString, "alertes??")
    QSqlError("", "", "") channel
    QVariant(QString, "Général ??")
    QSqlError("", "", "") channel
    QVariant(QString, "??annonces")
    QSqlError("", "", "") channel
    QVariant(QString, "général")
    QSqlError("", "", "") channel
    QVariant(QString, "partenaires??")
    QSqlError("", "", "") channel
    QVariant(QString, "report??")
    QSqlError("", "", "") channel
    QVariant(QString, "aide??")
    QSqlError("", "", "") channel
    QVariant(QString, "event")
    QSqlError("", "", "") channel
    QVariant(QString, "Autres ??")
    QSqlError("", "", "") channel
    QVariant(QString, "suggestions")
    QSqlError("", "", "") channel
    QVariant(QString, "shitpost??")
    QSqlError("", "", "") channel
    QVariant(QString, "commandes")
    QSqlError("", "", "") channel
    QVariant(QString, "Vocal")
    QSqlError("", "", "") channel
    QVariant(QString, "AFK??")
    QSqlError("", "", "") channel
    QVariant(QString, "Le Repaire")
    QSqlError("", "", "") channel
    QVariant(QString, "bla-bla")
    QSqlError("", "", "") channel
    QVariant(QString, "blacklist")
    QSqlError("", "", "") channel
    QVariant(QString, "preuves")
    QSqlError("", "", "") channel
    QVariant(QString, "serveurs-raid")
    QSqlError("", "", "") channel
    QVariant(QString, "Staff")
    QSqlError("", "", "") channel
    QVariant(QString, "annonces")
    QSqlError("", "", "") channel
    QVariant(QString, "général-staff")
    QSqlError("", "", "") channel
    QVariant(QString, "report-a-valider")
    QSqlError("", "", "") channel
    QVariant(QString, "reglement")
    QSqlError("", "", "") channel
    QVariant(QString, "vocal-sans-micro")
    QSqlError("", "", "") channel
    QVariant(QString, "Vocal Staff")
    QSqlError("", "", "") channel
    QVariant(QString, "Mail")
    QSqlError("", "", "") channel
    QVariant(QString, "modmail-logs")
    QSqlError("", "", "") channel
    QVariant(QString, "logs")
    QSqlError("", "", "") channel
    QVariant(QString, "altidentifier-logs")
    QSqlError("", "", "") channel
    QVariant(QString, "join-logs")
    QSqlError("", "", "") channel
    QVariant(QString, "logs")
    QSqlError("", "", "") channel
    QVariant(QString, "Bureau des directeurs")
    QSqlError("", "", "") channel
    QVariant(QString, "discussion")
    QSqlError("", "", "") channel
    QVariant(QString, "bot-config")
    QSqlError("", "", "") channel
    QVariant(QString, "gitlab-commits")
    QSqlError("", "", "") channel
    QVariant(QString, "Réunions")
    QSqlError("", "", "") channel
    QSqlError("10", "Unable to fetch row", "disk I/O error") guild
    QSqlQuery::value: not positioned on a valid record
    QSqlDatabasePrivate::removeDatabase: connection 'saveGuild' is still in use, all queries will cease to work.
    

    but most of the time saving the guild works but this error occurs with every channel :

    QSqlError("10", "Unable to fetch row", "disk I/O error") channel
    

    I have no idea of what's happening and why, could somebody help me pls ?

    1 Reply Last reply
    0
    • Christian EhrlicherC Offline
      Christian EhrlicherC Offline
      Christian Ehrlicher
      Lifetime Qt Champion
      wrote on last edited by
      #2

      disk i/o error sounds like you've some problems with your harddisk - you should check it.

      Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
      Visit the Qt Academy at https://academy.qt.io/catalog

      1 Reply Last reply
      1
      • Charlie_BillyC Offline
        Charlie_BillyC Offline
        Charlie_Billy
        wrote on last edited by
        #3

        It works fine with other requests, and my hard drives work well. The program is on D:, and the db in AppData/Roaming on C:

        1 Reply Last reply
        0
        • SGaistS Offline
          SGaistS Offline
          SGaist
          Lifetime Qt Champion
          wrote on last edited by
          #4

          Hi,

          Does it also happen if you put your database somewhere else ?

          Interested in AI ? www.idiap.ch
          Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

          1 Reply Last reply
          0
          • Charlie_BillyC Offline
            Charlie_BillyC Offline
            Charlie_Billy
            wrote on last edited by
            #5

            Yes, i tried in the program's folder

            1 Reply Last reply
            0
            • SGaistS Offline
              SGaistS Offline
              SGaist
              Lifetime Qt Champion
              wrote on last edited by
              #6

              I meant on a different physical disk like e.g. an USB key.

              Interested in AI ? www.idiap.ch
              Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

              1 Reply Last reply
              0

              • Login

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Users
              • Groups
              • Search
              • Get Qt Extensions
              • Unsolved