Quicknotes not working!

[tomise]

Quicknotes not working!

[tomise]

The patch has helped.
Thanks for the support.
Quicknotes works again.

[matiasdelellis]

Hi @tomise

😞
You say you don't see anything in the Nextcloud logs??
You can open the inspector (Ctrl+shift+I in firefox) and see if there is any js log in console tab and see the notes query in the Net tab,,?

Thanks..

[tomise]

Hello, thanks for your support. I made a screenshot and a log when accessing new notes. I hope you can find a problem. Tomise 28. Oktober 2020 13:16, "matiasdelellis" <[email protected] (mailto:[email protected]?to=%22matiasdelellis%22%20<[email protected]>)> schrieb: Hi @tomise (https://github.com/tomise) https://github.githubassets.com/images/icons/emoji/unicode/1f61e.png">😞 You say you don't see anything in the Nextcloud logs?? You can open the inspector (Ctrl+shift+I in firefox) and see if there is any js log in console tab and see the notes query in the Net tab,,? Thanks.. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub (#47 (comment)), or unsubscribe (https://github.com/notifications/unsubscribe-auth/AK2BTH5JCODI2ZHS4GMXLNTSNADQJANCNFSM4TB4DYAA).

[matiasdelellis]

Hi @tomise
There is no attachment on your answer. Please, reply directly to github and make sure everything is visible. 😅

[tomise]

Screenshot

Netxcloud Log!
nextcloud.log.quicknotes.zip

[matiasdelellis]

Ok.. Formating that log:

{
   "reqId":"X5luMOSItAWq6d1-l@6aYAAAAIs",
   "level":3,
   "time":"2020-10-28T13:12:16+00:00",
   "remoteAddr":"212.114.206.174",
   "user":"Thomas",
   "app":"index",
   "method":"POST",
   "url":"/nextcloud/index.php/apps/quicknotes/notes",
   "message":{
      "Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
      "Message":"An exception occurred while executing 'INSERT INTO `oc_quicknotes_notes` (`title`, `content`, `pinned`, `timestamp`, `color_id`, `user_id`) VALUES(?, ?, ?, ?, ?, ?)' with params [\"Neue Notiz\", \"\", 0, 1603890736, 9, \"Thomas\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinned' in 'field list'",
      "Code":0,
      "Trace":[
         {
            "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",
            "line":169,
            "function":"convertException",
            "class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",
            "line":145,
            "function":"wrapException",
            "class":"Doctrine\\DBAL\\DBALException",
            "type":"::"
         },
         {
            "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",
            "line":1063,
            "function":"driverExceptionDuringQuery",
            "class":"Doctrine\\DBAL\\DBALException",
            "type":"::"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/DB/Connection.php",
            "line":214,
            "function":"executeUpdate",
            "class":"Doctrine\\DBAL\\Connection",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",
            "line":203,
            "function":"executeUpdate",
            "class":"OC\\DB\\Connection",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line":216,
            "function":"execute",
            "class":"Doctrine\\DBAL\\Query\\QueryBuilder",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
            "line":129,
            "function":"execute",
            "class":"OC\\DB\\QueryBuilder\\QueryBuilder",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/apps/quicknotes/lib/Service/NoteService.php",
            "line":194,
            "function":"insert",
            "class":"OCP\\AppFramework\\Db\\QBMapper",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/apps/quicknotes/lib/Controller/NoteController.php",
            "line":108,
            "function":"create",
            "class":"OCA\\QuickNotes\\Service\\NoteService",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
            "line":170,
            "function":"create",
            "class":"OCA\\QuickNotes\\Controller\\NoteController",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
            "line":100,
            "function":"executeController",
            "class":"OC\\AppFramework\\Http\\Dispatcher",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php",
            "line":137,
            "function":"dispatch",
            "class":"OC\\AppFramework\\Http\\Dispatcher",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",
            "line":47,
            "function":"main",
            "class":"OC\\AppFramework\\App",
            "type":"::"
         },
         {
            "function":"__invoke",
            "class":"OC\\AppFramework\\Routing\\RouteActionHandler",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/lib/private/Route/Router.php",
            "line":297,
            "function":"call_user_func"
         },
         {
            "file":"/var/www/html/nextcloud/lib/base.php",
            "line":1011,
            "function":"match",
            "class":"OC\\Route\\Router",
            "type":"->"
         },
         {
            "file":"/var/www/html/nextcloud/index.php",
            "line":37,
            "function":"handleRequest",
            "class":"OC",
            "type":"::"
         }
      ],
      "File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",
      "Line":60,
      "Previous":{
         "Exception":"Doctrine\\DBAL\\Driver\\PDOException",
         "Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinned' in 'field list'",
         "Code":"42S22",
         "Trace":[
            {
               "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",
               "line":1054,
               "function":"execute",
               "class":"Doctrine\\DBAL\\Driver\\PDOStatement",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/DB/Connection.php",
               "line":214,
               "function":"executeUpdate",
               "class":"Doctrine\\DBAL\\Connection",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",
               "line":203,
               "function":"executeUpdate",
               "class":"OC\\DB\\Connection",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
               "line":216,
               "function":"execute",
               "class":"Doctrine\\DBAL\\Query\\QueryBuilder",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
               "line":129,
               "function":"execute",
               "class":"OC\\DB\\QueryBuilder\\QueryBuilder",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/apps/quicknotes/lib/Service/NoteService.php",
               "line":194,
               "function":"insert",
               "class":"OCP\\AppFramework\\Db\\QBMapper",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/apps/quicknotes/lib/Controller/NoteController.php",
               "line":108,
               "function":"create",
               "class":"OCA\\QuickNotes\\Service\\NoteService",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
               "line":170,
               "function":"create",
               "class":"OCA\\QuickNotes\\Controller\\NoteController",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
               "line":100,
               "function":"executeController",
               "class":"OC\\AppFramework\\Http\\Dispatcher",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php",
               "line":137,
               "function":"dispatch",
               "class":"OC\\AppFramework\\Http\\Dispatcher",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",
               "line":47,
               "function":"main",
               "class":"OC\\AppFramework\\App",
               "type":"::"
            },
            {
               "function":"__invoke",
               "class":"OC\\AppFramework\\Routing\\RouteActionHandler",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/lib/private/Route/Router.php",
               "line":297,
               "function":"call_user_func"
            },
            {
               "file":"/var/www/html/nextcloud/lib/base.php",
               "line":1011,
               "function":"match",
               "class":"OC\\Route\\Router",
               "type":"->"
            },
            {
               "file":"/var/www/html/nextcloud/index.php",
               "line":37,
               "function":"handleRequest",
               "class":"OC",
               "type":"::"
            }
         ],
         "File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
         "Line":119,
         "Previous":{
            "Exception":"PDOException",
            "Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinned' in 'field list'",
            "Code":"42S22",
            "Trace":[
               {
                  "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
                  "line":117,
                  "function":"execute",
                  "class":"PDOStatement",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",
                  "line":1054,
                  "function":"execute",
                  "class":"Doctrine\\DBAL\\Driver\\PDOStatement",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/DB/Connection.php",
                  "line":214,
                  "function":"executeUpdate",
                  "class":"Doctrine\\DBAL\\Connection",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",
                  "line":203,
                  "function":"executeUpdate",
                  "class":"OC\\DB\\Connection",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
                  "line":216,
                  "function":"execute",
                  "class":"Doctrine\\DBAL\\Query\\QueryBuilder",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
                  "line":129,
                  "function":"execute",
                  "class":"OC\\DB\\QueryBuilder\\QueryBuilder",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/apps/quicknotes/lib/Service/NoteService.php",
                  "line":194,
                  "function":"insert",
                  "class":"OCP\\AppFramework\\Db\\QBMapper",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/apps/quicknotes/lib/Controller/NoteController.php",
                  "line":108,
                  "function":"create",
                  "class":"OCA\\QuickNotes\\Service\\NoteService",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                  "line":170,
                  "function":"create",
                  "class":"OCA\\QuickNotes\\Controller\\NoteController",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                  "line":100,
                  "function":"executeController",
                  "class":"OC\\AppFramework\\Http\\Dispatcher",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php",
                  "line":137,
                  "function":"dispatch",
                  "class":"OC\\AppFramework\\Http\\Dispatcher",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",
                  "line":47,
                  "function":"main",
                  "class":"OC\\AppFramework\\App",
                  "type":"::"
               },
               {
                  "function":"__invoke",
                  "class":"OC\\AppFramework\\Routing\\RouteActionHandler",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/private/Route/Router.php",
                  "line":297,
                  "function":"call_user_func"
               },
               {
                  "file":"/var/www/html/nextcloud/lib/base.php",
                  "line":1011,
                  "function":"match",
                  "class":"OC\\Route\\Router",
                  "type":"->"
               },
               {
                  "file":"/var/www/html/nextcloud/index.php",
                  "line":37,
                  "function":"handleRequest",
                  "class":"OC",
                  "type":"::"
               }
            ],
            "File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
            "Line":117
         }
      },
      "CustomMessage":"--"
   },
   "userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36",
   "version":"19.0.4.2"
}

...the problem is:

      "Message":"An exception occurred while executing 'INSERT INTO `oc_quicknotes_notes` (`title`, `content`, `pinned`, `timestamp`, `color_id`, `user_id`) VALUES(?, ?, ?, ?, ?, ?)' with params [\"Neue Notiz\", \"\", 0, 1603890736, 9, \"Thomas\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinned' in 'field list'",

The pinned colum was added on Quicknotes v0.3.0 (Released 2020-06-08). So, did you update from 0.6.1 or an older version ???

Please verify that this column exists in your database.

[tomise]

Yes I have.

[tomise]

Do you mean sql-database?

[matiasdelellis]

Do you mean sql-database?

YES

[tomise]

I cannot find in the database?

[matiasdelellis]

So, again..

The pinned colum was added on Quicknotes v0.3.0 (Released 2020-06-08). So, did you update from 0.6.1 or an older version ???

[tomise]

I restored a backup from the database, unfortunately the backup was a bit older!

[matiasdelellis]

I restored a backup from the database, unfortunately the backup was a bit older!

OK .. You have to migrate the databases..

See: https://docs.nextcloud.com/server/latest/developer_manual/basics/storage/migrations.html#console-commands

In mi case:

[matias@nube nextcloud]$ sudo -u apache php occ migrations:status quicknotes
    >> App:                                                quicknotes
    >> Version Table Name:                                 oc_migrations
    >> Migrations Namespace:                               OCA\QuickNotes\Migration
    >> Migrations Directory:                               /var/www/html/nextcloud/apps/quicknotes/lib/Migration
    >> Previous Version:                                   000205Date20200604122312
    >> Current Version:                                    000301Date20200613151711
    >> Next Version:                                       Already at latest migration step
    >> Latest Version:                                     000301Date20200613151711
    >> Executed Migrations:                                3
    >> Executed Unavailable Migrations:                    3
    >> Available Migrations:                               3
    >> New Migrations:                                     3
    >> Pending Migrations:                                 None

In your case maybe you just need to update with occ migrations:migrate quicknotes

[tomise]

The current status of quicknote is:
sudo -u apache php occ migrations:status quicknotes
>> App: quicknotes
>> Version Table Name: oc_migrations
>> Migrations Namespace: OCA\QuickNotes\Migration
>> Migrations Directory: /var/www/html/nextcloud/apps/quicknotes/lib/Migration
>> Previous Version: 000205Date20200604122312
>> Current Version: 000301Date20200613151711
>> Next Version: Already at latest migration step
>> Latest Version: 000301Date20200613151711
>> Executed Migrations: 3
>> Executed Unavailable Migrations: 3
>> Available Migrations: 3
>> New Migrations: 3
>> Pending Migrations: None

I have executed the command: sudo -u apache php occ migrations:status quicknotes
Unfortunately no improvement

[tomise]

I mean sudo -u apache php occ migrations:migrate quicknotes 0.6.2

[matiasdelellis]

try:

sudo -u apache php occ migrations:execute quicknotes 000205Date20200604122312

[tomise]

The last order was worth its weight in gold! It's working again!
Thanks a lot.
What do I have to consider next time I play back the database?

[matiasdelellis]

The last order was worth its weight in gold! It's working again!.

Great.. 🎉 😄 😃

What do I have to consider next time I play back the database?.

Honestly, I don't know what was wrong here. But in general, try to restore with the same versions and then update.

NOTE: If it still fails to save attachments, maybe you need to migrate again with other version:
sudo -u apache php occ migrations:execute quicknotes 000301Date20200613151711

Please, check that the rest works, and close the report yourself..
Thanks..

[tomise]

The attachments are saved but not displayed. I then migrated with the other command, unfortunately no difference. Pictures are only shown when editing.
As soon as you close the note, the image is no longer displayed.

[matiasdelellis]

The attachments are saved but not displayed. I then migrated with the other command, unfortunately no difference. Pictures are only shown when editing.
As soon as you close the note, the image is no longer displayed.

About this, I'm 99% sure it's just some cache problem.. Try on another computer (Maybe the phone).

[matiasdelellis]

Also check that there is no relevant in nextcloud or the browser!

[tomise]

I did everything, unfortunately the attachments are not displayed!

[matiasdelellis]

Logs!?

[matiasdelellis]

Maybe we have an confirmaron.. #48
You can create an user and send me the credencials to mati86dl at gmal com to test?

Thanks

[matiasdelellis]

D'Oh!. mati86dl at gmail com

[matiasdelellis]

Hi @tomise
Test this patch:
85c9bfa