Re: [RCU] Upgrade RCU from 1.4.13 to 1.5.3 and DB schema update error
Hi, thanks for tip - I deleted them, all is fine. I also found another upgrade issues - there were some account (table "users") that were with upper/lower case. Like johndoe/Johndoe ... Error : ERROR: Error in DDL upgrade 2020020101: [1062] Duplicate entry '' for key 'username" -or- ERROR: Error in DDL upgrade 2020020101: [1062] Duplicate entry 'Johndoe-server.example.com' for key 'username' Deleting this records solved the problem and DB schema was succesfully updated. Dne 2023-07-10 14:38, Zhang Huangbin napsal: On Jul 10, 2023, at 5:58 PM, Josef Karliak wrote: ERROR: Error in DDL upgrade 2020020101: [1834] Cannot delete rows from table which is parent in a foreign key constraint 'fk_calendars_user_id' of table 'calendars' Updating database schema (2020020101)... [FAILED] ... But I do not see any SQL query for table "calendars" in "2020020101.sql" file. Seems this foreign key was created by a third-party plugin. Zhang Huangbin, founder of: - iRedMail: Open source email server solution: https://www.iredmail.org/ - Spider: Lightweight, on-premises Email Archiving Software: https://spiderd.io ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
[RCU] Upgrade RCU from 1.4.13 to 1.5.3 and DB schema update error
Good morning, install script fails when updating DB schema from 1.4.13 to 1.5.3 : ... ... Running update script at target... Executing database schema update. Updating database schema (2020020100)... [OK] ERROR: Error in DDL upgrade 2020020101: [1834] Cannot delete rows from table which is parent in a foreign key constraint 'fk_calendars_user_id' of table 'calendars' Updating database schema (2020020101)... [FAILED] ... ... But I do not see any SQL query for table "calendars" in "2020020101.sql " file. Any ideas? Previous upgrading from 1.4.11 to 1.4.13 passed OK. Thanks and best regards J.Karliak___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Re: [RCU] RC 1.4.11 and Sabre/Vobject 4 do not display/import ical [SOLVED]
Good afternoon, now solved by downgrade Sabre/Vobject do 3.5.x version. JK Dne 2021-04-29 11:45, Josef Karliak napsal: Good morning, after upgrading to RC 1.4.11 and had to install over composer Sabre/Vobject, the RC do not display and ask to import iCal attached in the email. In the RC log I see : PHP Error: iCal data parse error: Starting sabre/vobject 4.0 the children property is now protected. You should use the children() method instead in What did I missed ? Thanks and best regards J.Karliak ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
[RCU] RC 1.4.11 and Sabre/Vobject 4 do not display/import ical
Good morning, after upgrading to RC 1.4.11 and had to install over composer Sabre/Vobject, the RC do not display and ask to import iCal attached in the email. In the RC log I see : PHP Error: iCal data parse error: Starting sabre/vobject 4.0 the children property is now protected. You should use the children() method instead in What did I missed ? Thanks and best regards J.Karliak ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
[RCU] Roundcube 1.4 do not display body of vcf invitation
Good morning, I found that I cannot see vcf file - invitation to some meeting (Outlook). When I receive it in Roundcube, I can accept it, decline it, ... but I cannot see text of this invitation in the email. When I accept it, all is fine in the calendar. But not while viewving email. What did I missed ? composer.json: { "name": "roundcube/roundcubemail", "description": "The Roundcube Webmail suite", "license": "GPL-3.0+", "repositories": [ { "type": "composer", "url": "https://plugins.roundcube.net; }, { "type": "vcs", "url": "https://git.kolab.org/diffusion/PNL/php-net_ldap.git; } ], "require": { "php": ">=5.4.0", "pear/pear-core-minimal": "~1.10.1", "pear/auth_sasl": "~1.1.0", "pear/net_idna2": "~0.2.0", "pear/mail_mime": "~1.10.0", "pear/net_smtp": "~1.8.1", "pear/crypt_gpg": "~1.6.3", "pear/net_sieve": "~1.4.3", "roundcube/plugin-installer": "~0.1.6", "masterminds/html5": "~2.5.0", "endroid/qr-code": "~1.6.5", "kolab/net_ldap3": "~1.1.1", "sabre/vobject": "~3.5.3", "kolab/calendar": "^3.5" }, "require-dev": { "phpunit/phpunit": "^4.8.36 || ^5.7.21" }, "suggest": { "mkopinsky/zxcvbn-php": "^4.4.2 required for Zxcvbn password strength driver" } } Thanks and best regards J.Karliak ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
[RCU] RC 1.3.x and changing name of the downloaded emails in zip archive (Subject->Sender)
Good morning, where is an option to set file names of the downloaded email. Name by Subject is not good option, file name by sender should be better. Thanks and best regards J.Karliak -- Ma domena pouziva zabezpeceni a kontrolu SPF (www.openspf.org) a DomainKeys/DKIM (s ADSP) a implementaci DMARC. Pokud mate problemy s dorucenim emailu, zacnete pouzivat metody overeni puvody emailu zminene vyse. Dekuji. My domain use SPF (www.openspf.org) and DomainKeys/DKIM (with ADSP) policy and implementation of the DMARC. If you've problem with sending emails to me, start using email origin methods mentioned above. Thank you. ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
[RCU] RC 1.4 and missing Elastic skin for some plugins
Good morning, we tried 1.4 RC, all works fine, great work, but some plugins are missing elastic skins, so it did not work (primitivenotes, calendar). For example: FILE NOT FOUND The requested resource was not found! Please contact your server-administrator. Failed request: mail.domain.cz/mail/?_task=calendar What is needed to do ? Thanks and best regards J.Karliak -- Ma domena pouziva zabezpeceni a kontrolu SPF (www.openspf.org) a DomainKeys/DKIM (s ADSP) a implementaci DMARC. Pokud mate problemy s dorucenim emailu, zacnete pouzivat metody overeni puvody emailu zminene vyse. Dekuji. My domain use SPF (www.openspf.org) and DomainKeys/DKIM (with ADSP) policy and implementation of the DMARC. If you've problem with sending emails to me, start using email origin methods mentioned above. Thank you. ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
[RCU] Roundcube 1.3.6 and set first time user email to domain, not imap host
Good evening, it is able to set somehow RC to us as a domain for new user only domain ? we use imap host (mail_host) "email.domain.cz". user put username for example "johny" as an username, put password in his profile setting in the roundcube he get email setting "jo...@email.domain.cz". How do I set "creating" of the email addres for a new users. We must preserve imap host "email.domain.cz", but the user must have set up @domain.cz Thanks and best regards J.Karliak -- Ma domena pouziva zabezpeceni a kontrolu SPF (www.openspf.org) a DomainKeys/DKIM (s ADSP) a implementaci DMARC. Pokud mate problemy s dorucenim emailu, zacnete pouzivat metody overeni puvody emailu zminene vyse. Dekuji. My domain use SPF (www.openspf.org) and DomainKeys/DKIM (with ADSP) policy and implementation of the DMARC. If you've problem with sending emails to me, start using email origin methods mentioned above. Thank you. 0x497D46BD.asc Description: application/pgp-keys ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users