nextcloud / text2image_helper

A Smart Picker for interfacing with text-to-image providers in Nextcloud
1 stars 1 forks source link

Column not found: 1054 Unknown column 'last_used_timestamp' in 'where clause' #23

Closed SystemKeeper closed 11 months ago

SystemKeeper commented 11 months ago

NC 28.0.1 text2image_helper: 1.0.1 text2image_stablediffusion: 1.0.2

{
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_used_timestamp' in 'where clause'",
    "Code": 1054,
    "Trace": [
        {
            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 295,
            "function": "wrap",
            "class": "OC\\DB\\Exceptions\\DbalException",
            "type": "::"
        },
        {
            "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
            "line": 335,
            "function": "executeQuery",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/apps/text2image_helper/lib/Db/ImageGenerationMapper.php",
            "line": 191,
            "function": "findEntities",
            "class": "OCP\\AppFramework\\Db\\QBMapper",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/apps/text2image_helper/lib/Service/CleanUpService.php",
            "line": 45,
            "function": "cleanupImageGenerations",
            "class": "OCA\\Text2ImageHelper\\Db\\ImageGenerationMapper",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/apps/text2image_helper/lib/Cron/CleanupImageGenerations.php",
            "line": 29,
            "function": "cleanupGenerationsAndFiles",
            "class": "OCA\\Text2ImageHelper\\Service\\CleanUpService",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/lib/public/BackgroundJob/Job.php",
            "line": 81,
            "function": "run",
            "class": "OCA\\Text2ImageHelper\\Cron\\CleanupImageGenerations",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
            "line": 102,
            "function": "start",
            "class": "OCP\\BackgroundJob\\Job",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
            "line": 92,
            "function": "start",
            "class": "OCP\\BackgroundJob\\TimedJob",
            "type": "->"
        },
        {
            "file": "/var/www/nextcloud/cron.php",
            "line": 152,
            "function": "execute",
            "class": "OCP\\BackgroundJob\\TimedJob",
            "type": "->"
        }
    ],
MB-Finski commented 11 months ago

Thanks! This has actually been fixed in main already it seems. Can't recall why I didn't create a new release right away; let me push a new release to app store in just a moment!

MB-Finski commented 11 months ago

V1.0.2 is up now and should fix this issue!

EDIT: .. and various other smaller issues that came up while we were porting this app under the assistant app. This app will be deprecated in January most probably as a result.

SystemKeeper commented 11 months ago

V1.0.2 is up now and should fix this issue!

Thank you for the quick help!

[...] porting this app under the assistant app. This app will be deprecated in January most probably as a result.

Very nice! Actually I was looking for it in the assistant first and only then discovered this app, so totally makes sense IMO.