[kmail2] [Bug 406803] If I want to add an yahoo account to kmail I was asked for an google account
https://bugs.kde.org/show_bug.cgi?id=406803 mcadoo.c...@gmail.com changed: What|Removed |Added CC||mcadoo.c...@gmail.com --- Comment #2 from mcadoo.c...@gmail.com --- Problem still existed. Please take it into account. Thanks -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 412629] Akonadi refuses to start after upgrade to PostgreSQL 12: column "version" of relation "schemaversiontable" already exists
https://bugs.kde.org/show_bug.cgi?id=412629 Christophe Giboudeaux changed: What|Removed |Added CC||sfbar...@gmail.com --- Comment #1 from Christophe Giboudeaux --- *** Bug 412818 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 412818] Akonadi query on SchemaVersionTable is broken in PostgreSQL Version 12
https://bugs.kde.org/show_bug.cgi?id=412818 stuart changed: What|Removed |Added CC||sfbar...@gmail.com Keywords||reproducible URL||https://www.postgresql.org/ ||docs/12/release-12.html#id- ||1.11.6.5.5 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 412818] New: Akonadi query on SchemaVersionTable is broken in PostgreSQL Version 12
https://bugs.kde.org/show_bug.cgi?id=412818 Bug ID: 412818 Summary: Akonadi query on SchemaVersionTable is broken in PostgreSQL Version 12 Product: Akonadi Version: unspecified Platform: unspecified OS: Linux Status: REPORTED Severity: major Priority: NOR Component: server Assignee: kdepim-bugs@kde.org Reporter: sfbar...@gmail.com Target Milestone: --- SUMMARY When backed by the postgres db, Akonadi executes the query; "SELECT pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.attnotnull, pg_attribute.attlen, pg_attribute.atttypmod, pg_attrdef.adsrc FROM pg_class, pg_attribute LEFT JOIN pg_attrdef ON (pg_attrdef.adrelid = pg_attribute.attrelid AND pg_attrdef.adnum = pg_attribute.attnum) WHERE pg_table_is_visible(pg_class.oid) AND pg_class.relname = 'schemaversiontable' AND pg_attribute.attnum > 0 AND pg_attribute.attrelid = pg_class.oid AND pg_attribute.attisdropped = false ORDER BY pg_attribute.attnum ;" In versions of PostGreSQL before 12, this query succeeds. Due to the changes to the informationschema, as identified in PostGreSQL PostgreSQL release notes: E.1. Release 12 https://www.postgresql.org/docs/12/release-12.html#id-1.11.6.5.5 PostgreSQL Version 12 removes: obsolete pg_constraint.consrc column obsolete pg_attrdef.adsrc column STEPS TO REPRODUCE 1. Upgrade PostGreSQL backend database to 12.x 2. Restart with Akonadictl start 3. OBSERVED RESULT This causes the query to fail and Akonadi quits with the error. org.kde.pim.akonadiserver: Starting up the Akonadi Server... org.kde.pim.akonadiserver: Running DB initializer org.kde.pim.akonadiserver: "\nSql error: ERROR: column \"version\" of relation \"schemaversiontable\" already exists\n(42701) QPSQL: Unable to create query\nQuery: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0" org.kde.pim.akonadiserver: Unable to initialize database. org.kde.pim.akonadiserver: Shutting down AkonadiServer... EXPECTED RESULT When the query succeeds, Akonadi continues to process emails. SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: ANY (available in About System) KDE Plasma Version: ANY KDE Frameworks Version: ANY Qt Version: ANY ADDITIONAL INFORMATION The schema information for these dropped columns can be obtained using the functions, pg_constraint.consrc pg_get_constraintdef(pg_constraint.oid) pg_attrdef.adsrc pg_get_expr(pg_attrdef.adbin, pg_class.oid) So the Akonadi query: SELECT pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.attnotnull, pg_attribute.attlen, pg_attribute.atttypmod, pg_attrdef.adsrc FROM pg_class, pg_attribute LEFT JOIN pg_attrdef ON (pg_attrdef.adrelid = pg_attribute.attrelid AND pg_attrdef.adnum = pg_attribute.attnum) WHERE pg_table_is_visible(pg_class.oid) AND pg_class.relname = 'schemaversiontable' AND pg_attribute.attnum > 0 AND pg_attribute.attrelid = pg_class.oid AND pg_attribute.attisdropped = false ORDER BY pg_attribute.attnum ; should probably be changed to something like: SELECT pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.attnotnull, pg_attribute.attlen, pg_attribute.atttypmod, pg_get_expr(pg_attrdef.adbin, pg_class.oid) AS adsrc FROM pg_class LEFT JOIN pg_attribute ON ( pg_attribute.attrelid = pg_class.oid ) LEFT JOIN pg_attrdef ON ( pg_attrdef.adrelid = pg_attribute.attrelid AND pg_attrdef.adnum = pg_attribute.attnum ) WHERE pg_table_is_visible(pg_class.oid) AND pg_class.relname = 'schemaversiontable' AND pg_attribute.attnum > 0 AND pg_attribute.attisdropped = false ORDER BY pg_attribute.attnum; This will produce something like the following table: attname | atttypid | attnotnull | attlen | atttypmod | adsrc +--+++---+--- version| 23 | t | 4 |-1 | 0 generation | 23 | t | 4 |-1 | 0 (2 rows) -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 412818] Akonadi query on SchemaVersionTable is broken in PostgreSQL Version 12
https://bugs.kde.org/show_bug.cgi?id=412818 Christophe Giboudeaux changed: What|Removed |Added Status|REPORTED|RESOLVED Resolution|--- |DUPLICATE --- Comment #1 from Christophe Giboudeaux --- *** This bug has been marked as a duplicate of bug 412629 *** -- You are receiving this mail because: You are the assignee for the bug.
[kmail2] [Bug 412830] New: The key sequence 'U' is ambiguous
https://bugs.kde.org/show_bug.cgi?id=412830 Bug ID: 412830 Summary: The key sequence 'U' is ambiguous Product: kmail2 Version: 5.9.3 Platform: Debian testing OS: Linux Status: REPORTED Severity: normal Priority: NOR Component: general Assignee: kdepim-bugs@kde.org Reporter: luca-...@llucax.com Target Milestone: --- SUMMARY Out of the blue, without touching anyting (although it might have been after some upgrade of some KDE component, not KMail), I started to get this message when trying to use the 'U' shortcut to mark messages as unread: The key sequence 'U' is ambiguous. Use 'Configure Shortcuts' from the 'Settings' menu to solve the ambiguity. No action will be triggered. I looked in the shortcuts configuration and there is nothing else bound to `U`, not even in the global KDE shortcuts defined in the KDE Settings. STEPS TO REPRODUCE 1. Open KMail 2. Select an e-mail 3. Press the "U" letter in the keyboard OBSERVED RESULT A dialog with this message is shown: The key sequence 'U' is ambiguous. Use 'Configure Shortcuts' from the 'Settings' menu to solve the ambiguity. No action will be triggered. EXPECTED RESULT The message is marked as unread. SOFTWARE/OS VERSIONS Linux/KDE Plasma: Debian unstable, kde version 5:104 (from the debian package) KDE Plasma Version: 5.14.5.1 (?). Is the version of the plasma-desktop package KDE Frameworks Version: ? Qt Version: ? ADDITIONAL INFORMATION If I remove the binding for 'U' from the shortcuts config and then press 'U', there is no visible effect. -- You are receiving this mail because: You are the assignee for the bug.
[korganizer] [Bug 412833] New: Monthview shows comma in year
https://bugs.kde.org/show_bug.cgi?id=412833 Bug ID: 412833 Summary: Monthview shows comma in year Product: korganizer Version: 5.12.2 Platform: Archlinux Packages OS: Linux Status: REPORTED Severity: minor Priority: NOR Component: monthview Assignee: kdepim-bugs@kde.org Reporter: kdeb...@trevorparsons.com Target Milestone: --- Created attachment 123140 --> https://bugs.kde.org/attachment.cgi?id=123140=edit Screenshot of part of korganizer window showing comma in year in monthview SUMMARY In the month view of Korganizer, the year contains a comma, as if it were a normal numeral. STEPS TO REPRODUCE 1. Start Korganizer 2. Switch to month view OBSERVED RESULT The year contains a comma. For example, at the time of reporting the month and year are shown as "October 2,019". EXPECTED RESULT The year should not contain a comma. SOFTWARE/OS VERSIONS Linux/KDE Plasma: 5.3.5-arch1-1-ARCH (available in About System) KDE Plasma Version: 5.16.90 KDE Frameworks Version: 5.62.0 Qt Version: 5.14.0 (built against 5.13.1) ADDITIONAL INFORMATION -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 412629] Akonadi refuses to start after upgrade to PostgreSQL 12: column "version" of relation "schemaversiontable" already exists
https://bugs.kde.org/show_bug.cgi?id=412629 Sandro Knauß changed: What|Removed |Added CC||skna...@kde.org Status|REPORTED|CONFIRMED Ever confirmed|0 |1 --- Comment #2 from Sandro Knauß --- Keep in mind, that even Qt does not support Postgres 12 atm, so in first glance there needs to be a bug filed against Qt: https://code.qt.io/cgit/qt/qtbase.git/tree/src/plugins/sqldrivers/psql/qsql_psql.cpp#n1080 also in Debian this bug is reported: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=941763 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 412629] Akonadi refuses to start after upgrade to PostgreSQL 12: column "version" of relation "schemaversiontable" already exists
https://bugs.kde.org/show_bug.cgi?id=412629 --- Comment #3 from stuart --- Ok, I didn't suspect that since it is communicating with the database. Just that the query fails and Akonadi shuts down. On Thu, Oct 10, 2019 at 9:20 PM Sandro Knauß wrote: > https://bugs.kde.org/show_bug.cgi?id=412629 > > Sandro Knauß changed: > >What|Removed |Added > > > CC||skna...@kde.org > Status|REPORTED|CONFIRMED > Ever confirmed|0 |1 > > --- Comment #2 from Sandro Knauß --- > Keep in mind, that even Qt does not support Postgres 12 atm, so in first > glance > there needs to be a bug filed against Qt: > > > https://code.qt.io/cgit/qt/qtbase.git/tree/src/plugins/sqldrivers/psql/qsql_psql.cpp#n1080 > > also in Debian this bug is reported: > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=941763 > > -- > You are receiving this mail because: > You are on the CC list for the bug. -- You are receiving this mail because: You are the assignee for the bug.
