Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

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

    General and Desktop
    3
    6
    401
    Loading More Posts
    • 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_Billy
      Charlie_Billy last edited by

      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 Reply Quote 0
      • Christian Ehrlicher
        Christian Ehrlicher Lifetime Qt Champion last edited by

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

        Qt has to stay free or it will die.

        1 Reply Last reply Reply Quote 1
        • Charlie_Billy
          Charlie_Billy last edited by

          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 Reply Quote 0
          • SGaist
            SGaist Lifetime Qt Champion last edited by

            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 Reply Quote 0
            • Charlie_Billy
              Charlie_Billy last edited by

              Yes, i tried in the program's folder

              1 Reply Last reply Reply Quote 0
              • SGaist
                SGaist Lifetime Qt Champion last edited by

                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 Reply Quote 0
                • First post
                  Last post