nextcloud / polls

🗳️ Polls app for Nextcloud
https://apps.nextcloud.com/apps/polls
GNU Affero General Public License v3.0
256 stars 73 forks source link

[Bug]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'polls_polls..deleted' in 'where clause' #3243

Closed kevinkuan1969 closed 9 months ago

kevinkuan1969 commented 9 months ago

⚠️ This issue respects the following points: ⚠️

Bug description

This error message has been displayed on and off related to the Poll table which currently not using the application.

Steps to reproduce

N/A

Expected behavior

The error message should not be displayed

Installation method

Community Manual installation with Archive

Nextcloud Server version

28

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "nextcloud.analytic360.biz"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "28.0.1.1",
        "overwrite.cli.url": "https:\/\/nextcloud.analytic360.biz",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "default_phone_region": "MY",
        "profile.enabled": true,
        "filelocking.enabled": true,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "dbindex": 0,
            "password": "***REMOVED SENSITIVE VALUE***",
            "timeout": 0
        },
        "memcache.local": "\\OC\\Memcache\\Redis",
        "allow_local_remote_servers": true,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "apporder",
            "libresign",
            "dicomviewer",
            "appointments",
            "files_fulltextsearch_tesseract",
            "files_bpm",
            "memories",
            "metadata",
            "login_notes",
            "pdf_downloader",
            "unsplash",
            "gestion",
            "ncdownloader",
            "extract",
            "occweb"
        ],
        "enable_previews": true,
        "enabledPreviewProviders": [
            "OC\\Preview\\TXT",
            "OC\\Preview\\MarkDown",
            "OC\\Preview\\OpenDocument",
            "OC\\Preview\\PDF",
            "OC\\Preview\\MSOffice2003",
            "OC\\Preview\\MSOfficeDoc",
            "OC\\Preview\\Image",
            "OC\\Preview\\Photoshop",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\SVG",
            "OC\\Preview\\Font",
            "OC\\Preview\\MP3",
            "OC\\Preview\\Movie",
            "OC\\Preview\\MKV",
            "OC\\Preview\\MP4",
            "OC\\Preview\\AVI",
            "OC\\Preview\\PNG",
            "OC\\Preview\\JPEG",
            "OC\\Preview\\GIF",
            "OC\\Preview\\HEIC",
            "OC\\Preview\\BMP",
            "OC\\Preview\\XBitMap",
            "OC\\Preview\\Illustrator",
            "OC\\Preview\\MSOffice2007",
            "OC\\Preview\\Postscript",
            "OC\\Preview\\StarOffice",
            "OC\\Preview\\TIF"
        ],
        "memories.exiftool": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/exiftool-amd64-glibc",
        "memories.vod.path": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
        "maintenance": false,
        "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
        "memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
        "memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
        "updater.release.channel": "stable",
        "loglevel": 2,
        "ncd_admin_settings": {
            "disallow_aria2_settings": "0",
            "ncd_yt_binary": "",
            "ncd_aria2_binary": "\/usr\/bin\/aria2c",
            "ncd_aria2_rpc_host": "127.0.01",
            "ncd_aria2_rpc_port": "6800",
            "ncd_aria2_rpc_token": "ncdownloader1"
        },
        "defaultapp": "dashboard,files,spreed,mail",
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [
            "Demo Purpose"
        ],
        "twofactor_enforced_excluded_groups": []
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - admin_audit: 1.18.0
  - analytics: 4.12.0
  - analytics_sourcepack: 0.0.2
  - announcementcenter: 6.7.0
  - app_api: 1.4.6
  - appointments: 1.15.5
  - apporder: 0.15.0
  - approval: 1.2.0
  - assistant: 1.0.3
  - audioplayer: 3.4.1
  - auto_groups: 1.5.2
  - bookmarks: 13.1.3
  - bruteforcesettings: 2.8.0
  - calendar: 4.6.2
  - calendar_resource_management: 0.6.0
  - call_summary_bot: 1.0.1
  - camerarawpreviews: 0.8.4
  - circles: 28.0.0-dev
  - cloud_federation_api: 1.11.0
  - cloud_py_api: 0.1.9
  - collectives: 2.9.2
  - comments: 1.18.0
  - contacts: 5.5.1
  - contactsinteraction: 1.9.0
  - cospend: 1.5.14
  - dashboard: 7.8.0
  - dav: 1.29.1
  - deck: 1.12.0
  - drawio: 3.0.2
  - drop_account: 2.4.0
  - duplicatefinder: 1.1.4
  - event_update_notification: 2.3.0
  - external: 5.3.1
  - federatedfilesharing: 1.18.0
  - federation: 1.18.0
  - files: 2.0.0
  - files_3dmodelviewer: 0.0.12
  - files_accesscontrol: 1.18.0
  - files_antivirus: 5.4.0
  - files_automatedtagging: 1.18.0
  - files_bpm: 1.2.0
  - files_confidential: 2.0.1
  - files_external: 1.20.0
  - files_fulltextsearch: 28.0.0
  - files_fulltextsearch_tesseract: 27.0.0
  - files_lock: 28.0.1
  - files_mindmap: 0.0.30
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - files_zip: 1.5.0
  - firstrunwizard: 2.17.0
  - flow_notifications: 1.8.0
  - forms: 4.0.0
  - fulltextsearch: 28.0.0
  - fulltextsearch_elasticsearch: 28.0.0
  - gestion: 2.4.1
  - gptfreeprompt: 1.0.2
  - gpxpod: 5.0.14
  - group_default_quota: 0.1.8
  - group_everyone: 0.1.14
  - groupquota: 0.1.12
  - guests: 3.0.1
  - health: 2.2.2
  - integration_alephalpha: 1.0.0
  - integration_docusign: 1.0.0
  - integration_dropbox: 2.1.0
  - integration_giphy: 1.0.10
  - integration_google: 2.1.0
  - integration_libretranslate: 1.1.1
  - integration_onedrive: 3.1.0
  - integration_openai: 1.2.0
  - integration_openstreetmap: 1.0.11
  - integration_replicate: 1.0.8
  - integration_twitter: 1.0.7
  - libresign: 7.1.1
  - limit_login_to_ip: 4.0.0
  - llm: 1.2.1
  - login_notes: 1.4.0
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - mail: 3.5.1
  - maps: 1.3.1
  - mediadc: 0.3.8
  - memegen: 1.0.6
  - memories: 6.2.0
  - money: 0.24.0
  - ncdownloader: 1.0.20
  - nextcloud_announcements: 1.17.0
  - notes: 4.9.2
  - notifications: 2.16.0
  - oauth2: 1.16.3
  - openincryptpad: 0.3.0
  - password_policy: 1.18.0
  - passwords: 2023.12.32
  - pdf_downloader: 1.1.3
  - phonetrack: 0.7.7
  - photos: 2.4.0
  - picker: 1.0.7
  - polls: 6.0.1
  - previewgenerator: 5.4.0
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - quota_warning: 1.18.0
  - recognize: 6.0.1
  - recommendations: 2.0.0
  - registration: 2.3.0
  - related_resources: 1.3.0
  - richdocuments: 8.3.0
  - richdocumentscode: 23.5.604
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - side_menu: 3.11.2
  - sketch_picker: 1.0.1
  - smb_test: 0.3.8
  - socialsharing_email: 3.0.1
  - socialsharing_facebook: 3.0.1
  - socialsharing_telegram: 3.0.1
  - socialsharing_twitter: 3.0.1
  - spreed: 18.0.1
  - stt_helper: 1.0.0
  - stt_whisper: 1.0.7
  - suspicious_login: 6.0.0
  - systemtags: 1.18.0
  - tables: 0.6.5
  - tasks: 0.15.0
  - terms_of_service: 2.3.2
  - text: 3.9.1
  - text2image_helper: 1.0.2
  - text2image_stablediffusion: 1.0.2
  - text_templates: 1.0.4
  - theming: 2.3.0
  - timemanager: 0.3.11
  - transfer: 0.6.3
  - twofactor_admin: 4.4.0
  - twofactor_backupcodes: 1.17.0
  - twofactor_totp: 10.0.0-beta.2
  - unsplash: 2.2.1
  - updatenotification: 1.18.0
  - user_migration: 5.0.0
  - user_retention: 1.11.0
  - user_status: 1.8.1
  - user_usage_report: 1.12.0
  - viewer: 2.2.0
  - weather_status: 1.8.0
  - welcome: 1.0.10
  - workflow_media_converter: 1.9.0
  - workflow_ocr: 1.28.0
  - workflow_pdf_converter: 1.13.0
  - workflowengine: 2.10.0
Disabled:
  - bbb: 2.5.0 (installed 2.5.0)
  - cadviewer: 9.20.5 (installed 9.20.5)
  - cfg_share_links: 4.2.0 (installed 4.2.0)
  - data_request: 1.14.0 (installed 1.14.0)
  - dicomviewer: 1.2.5 (installed 1.2.5)
  - emlviewer: 1.0.8 (installed 1.0.8)
  - encryption: 2.16.0
  - externalportal: 1.2.0 (installed 1.2.0)
  - extract: 1.3.6 (installed 1.3.6)
  - facerecognition: 0.9.31 (installed 0.9.31)
  - files_downloadlimit: 1.1.0 (installed 1.1.0)
  - files_linkeditor: 1.1.16 (installed 1.1.16)
  - files_photospheres: 1.28.0 (installed 1.28.0)
  - files_retention: 1.16.0 (installed 1.16.0)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - files_texteditor: 2.15.1 (installed 2.15.1)
  - groupfolders: 16.0.1 (installed 16.0.1)
  - imageconverter: 1.3.5 (installed 1.3.5)
  - metadata: 0.19.0 (installed 0.19.0)
  - secrets: 1.5.2 (installed 1.5.2)
  - shareimporter: 1.2.0 (installed 1.2.0)
  - social: 0.6.1 (installed 0.6.1)
  - support: 1.11.0 (installed 1.11.0)
  - survey_client: 1.16.0 (installed 1.16.0)
  - translate: 2.0.0 (installed 2.0.0)
  - user_ldap: 1.19.0
  - video_converter: 1.0.6 (installed 1.0.6)
  - workflow_script: 1.13.0 (installed 1.13.0)
  - workspace: 3.0.4 (installed 3.0.4)

Nextcloud Signing status

No response

Nextcloud Logs

Error   no app in context   
DbalException
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'polls_polls..deleted' in 'where clause'

Additional info

No response

dartcafe commented 9 months ago

https://github.com/nextcloud/polls/issues/3203

github-actions[bot] commented 5 months ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.