[Openlp-core] [Bug 1844044] Re: Dev build (2.5) MySQL error during boot, some tables created but not all
And subsequently, I re-ran the 1st-time wizard, with MySQL mode still enabled of course. I selected all plugins for enablement. Caused the following error: Traceback (most recent call last): File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/core/ui/mainwindow.py", line 700, in on_first_time_wizard_clicked self.first_time() File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/core/common/mixins.py", line 69, in wrapped raise e File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/core/common/mixins.py", line 64, in wrapped return func(*args) File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/core/ui/mainwindow.py", line 672, in first_time plugin.first_time() File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/plugins/songs/songsplugin.py", line 373, in first_time self.on_tools_reindex_item_triggered() File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/plugins/songs/songsplugin.py", line 257, in on_tools_reindex_item_triggered max_songs = self.manager.get_object_count(Song) File "/home/bevand10/Documents/fbc/git/digial-music-stand/OpenLP-2.5.dev2902/openlp/core/lib/db.py", line 519, in get_object_count query = self.session.query(object_class) AttributeError: 'NoneType' object has no attribute 'query' -- You received this bug notification because you are a member of OpenLP Core, which is subscribed to OpenLP. https://bugs.launchpad.net/bugs/1844044 Title: Dev build (2.5) MySQL error during boot, some tables created but not all Status in OpenLP: New Bug description: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1844044/+subscriptions ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Bug 1844044] Re: Dev build (2.5) MySQL error during boot, some tables created but not all
I should have added: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | media_files | | metadata | | song_books | | songs| | topics | +--+ 6 rows in set (0.00 sec) -- You received this bug notification because you are a member of OpenLP Core, which is subscribed to OpenLP. https://bugs.launchpad.net/bugs/1844044 Title: Dev build (2.5) MySQL error during boot, some tables created but not all Status in OpenLP: New Bug description: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1844044/+subscriptions ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Bug 1844044] Re: Dev build (2.5) MySQL error during boot, some tables created but not all
And also, there's a Database Error dialog box appearing during launch: OpenLP cannot load your database. Database: sqlite:home/bevand10/.local/share/openlp/songs/songs.sqlite This is despite it knowing it's in MySQL mode. -- You received this bug notification because you are a member of OpenLP Core, which is subscribed to OpenLP. https://bugs.launchpad.net/bugs/1844044 Title: Dev build (2.5) MySQL error during boot, some tables created but not all Status in OpenLP: New Bug description: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1844044/+subscriptions ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Bug 1844044] Re: Dev build (2.5) MySQL error during boot, some tables created but not all
Hi Tomas. Patch applied. Different error now. Latest log attached. ** Attachment added: "openlp-post-UnicodeText-patch.log" https://bugs.launchpad.net/openlp/+bug/1844044/+attachment/5288872/+files/openlp-post-UnicodeText-patch.log -- You received this bug notification because you are a member of OpenLP Core, which is subscribed to OpenLP. https://bugs.launchpad.net/bugs/1844044 Title: Dev build (2.5) MySQL error during boot, some tables created but not all Status in OpenLP: New Bug description: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1844044/+subscriptions ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Merge] lp:~ic90/openlp/animated-alerts into lp:openlp
The proposal to merge lp:~ic90/openlp/animated-alerts into lp:openlp has been updated. Status: Needs review => Merged For more details, see: https://code.launchpad.net/~ic90/openlp/animated-alerts/+merge/369540 -- Your team OpenLP Core is subscribed to branch lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Merge] lp:~tomasgroth/openlp/reveal-css into lp:openlp
The proposal to merge lp:~tomasgroth/openlp/reveal-css into lp:openlp has been updated. Status: Needs review => Merged For more details, see: https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798 -- Your team OpenLP Core is subscribed to branch lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
Re: [Openlp-core] [Merge] lp:~raoul-snyman/openlp/animated-alerts into lp:openlp
Review: Approve -- https://code.launchpad.net/~raoul-snyman/openlp/animated-alerts/+merge/372792 Your team OpenLP Core is subscribed to branch lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
Re: [Openlp-core] [Merge] lp:~tomasgroth/openlp/reveal-css into lp:openlp
Review: Approve -- https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798 Your team OpenLP Core is subscribed to branch lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
Re: [Openlp-core] [Merge] lp:~raoul-snyman/openlp/animated-alerts into lp:openlp
Review: Approve Looks ok to me. -- https://code.launchpad.net/~raoul-snyman/openlp/animated-alerts/+merge/372792 Your team OpenLP Core is subscribed to branch lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] Linting: Passed
Linting passed! -- https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798 Your team OpenLP Core is requested to review the proposed merge of lp:~tomasgroth/openlp/reveal-css into lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] macOS Test Results: Passed
macOS tests passed! -- https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798 Your team OpenLP Core is requested to review the proposed merge of lp:~tomasgroth/openlp/reveal-css into lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] Linux Test Results: Passed
Linux tests passed! -- https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798 Your team OpenLP Core is requested to review the proposed merge of lp:~tomasgroth/openlp/reveal-css into lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] JavaScript Test Results: Passed
JavaScript tests passed! -- https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798 Your team OpenLP Core is requested to review the proposed merge of lp:~tomasgroth/openlp/reveal-css into lp:openlp. ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Merge] lp:~tomasgroth/openlp/reveal-css into lp:openlp
Tomas Groth has proposed merging lp:~tomasgroth/openlp/reveal-css into
lp:openlp.
Commit message:
Forgot to update to latest CSS when updating RevealJS to 3.8.0.
Requested reviews:
OpenLP Core (openlp-core)
For more details, see:
https://code.launchpad.net/~tomasgroth/openlp/reveal-css/+merge/372798
--
Your team OpenLP Core is requested to review the proposed merge of
lp:~tomasgroth/openlp/reveal-css into lp:openlp.
=== modified file 'openlp/core/display/html/reveal.css'
--- openlp/core/display/html/reveal.css 2019-02-11 20:34:20 +
+++ openlp/core/display/html/reveal.css 2019-09-15 12:54:31 +
@@ -3,47 +3,24 @@
* http://revealjs.com
* MIT licensed
*
- * Copyright (C) 2018 Hakim El Hattab, http://hakim.se
+ * Copyright (C) 2019 Hakim El Hattab, http://hakim.se
*/
/*
- * RESET STYLES
- */
-html, body, .reveal div, .reveal span, .reveal applet, .reveal object, .reveal iframe,
-.reveal h1, .reveal h2, .reveal h3, .reveal h4, .reveal h5, .reveal h6, .reveal p, .reveal blockquote, .reveal pre,
-.reveal a, .reveal abbr, .reveal acronym, .reveal address, .reveal big, .reveal cite, .reveal code,
-.reveal del, .reveal dfn, .reveal em, .reveal img, .reveal ins, .reveal kbd, .reveal q, .reveal s, .reveal samp,
-.reveal small, .reveal strike, .reveal strong, .reveal sub, .reveal sup, .reveal tt, .reveal var,
-.reveal b, .reveal u, .reveal center,
-.reveal dl, .reveal dt, .reveal dd, .reveal ol, .reveal ul, .reveal li,
-.reveal fieldset, .reveal form, .reveal label, .reveal legend,
-.reveal table, .reveal caption, .reveal tbody, .reveal tfoot, .reveal thead, .reveal tr, .reveal th, .reveal td,
-.reveal article, .reveal aside, .reveal canvas, .reveal details, .reveal embed,
-.reveal figure, .reveal figcaption, .reveal footer, .reveal header, .reveal hgroup,
-.reveal menu, .reveal nav, .reveal output, .reveal ruby, .reveal section, .reveal summary,
-.reveal time, .reveal mark, .reveal audio, .reveal video {
- margin: 0;
- padding: 0;
- border: 0;
- font-size: 100%;
- font: inherit;
- vertical-align: baseline; }
-
-.reveal article, .reveal aside, .reveal details, .reveal figcaption, .reveal figure,
-.reveal footer, .reveal header, .reveal hgroup, .reveal menu, .reveal nav, .reveal section {
- display: block; }
-
-/*
* GLOBAL STYLES
*/
-html,
-body {
+html {
width: 100%;
height: 100%;
+ height: 100vh;
+ height: calc( var(--vh, 1vh) * 100);
overflow: hidden; }
body {
+ height: 100%;
+ overflow: hidden;
position: relative;
line-height: 1;
+ margin: 0;
background-color: #fff;
color: #000; }
@@ -272,7 +249,7 @@
visibility: hidden;
opacity: 0;
-webkit-appearance: none;
--webkit-tap-highlight-color: transparent; }
+-webkit-tap-highlight-color: rgba(0, 0, 0, 0); }
.reveal .controls .controls-arrow:before,
.reveal .controls .controls-arrow:after {
content: '';
@@ -366,10 +343,16 @@
.reveal .controls .enabled.fragmented:hover {
opacity: 1; }
+.reveal[data-navigation-mode="linear"].has-horizontal-slides .navigate-up,
+.reveal[data-navigation-mode="linear"].has-horizontal-slides .navigate-down {
+ display: none; }
+
+.reveal[data-navigation-mode="linear"].has-horizontal-slides .navigate-left,
.reveal:not(.has-vertical-slides) .controls .navigate-left {
bottom: 1.4em;
right: 5.5em; }
+.reveal[data-navigation-mode="linear"].has-horizontal-slides .navigate-right,
.reveal:not(.has-vertical-slides) .controls .navigate-right {
bottom: 1.4em;
right: 0.5em; }
@@ -486,12 +469,8 @@
width: 100%;
height: 100%;
overflow: hidden;
- -ms-touch-action: none;
- touch-action: none; }
-
-@media only screen and (orientation: landscape) {
- .reveal.ua-iphone {
-position: fixed; } }
+ -ms-touch-action: pinch-zoom;
+ touch-action: pinch-zoom; }
.reveal .slides {
position: absolute;
@@ -512,7 +491,8 @@
perspective-origin: 50% 40%; }
.reveal .slides > section {
- -ms-perspective: 600px; }
+ -webkit-perspective: 600px;
+ perspective: 600px; }
.reveal .slides > section,
.reveal .slides > section > section {
@@ -544,7 +524,8 @@
.reveal .slides > section.stack {
padding-top: 0;
padding-bottom: 0;
- pointer-events: none; }
+ pointer-events: none;
+ height: 100%; }
.reveal .slides > section.present,
.reveal .slides > section > section.present {
@@ -761,14 +742,14 @@
.reveal .slides > section > section[data-transition=zoom].past,
.reveal .slides > section > section[data-transition~=zoom-out].past,
.reveal.zoom .slides > section > section:not([data-transition]).past {
- -webkit-transform: translate(0, -150%);
- transform: translate(0, -150%); }
+ -webkit-transform: scale(16);
+ transform: scale(16); }
.reveal .slides > section > section[data-transition=zoom].future,
[Openlp-core] [Bug 1844044] Re: Dev build (2.5) MySQL error during boot, some tables created but not all
Looking at the logs, this seems to be the issue: sqlalchemy.exc.CompileError: (in table 'media_files', column 'file_path'): VARCHAR requires a length on dialect mysql We should probably also test is postgresql works. -- You received this bug notification because you are a member of OpenLP Core, which is subscribed to OpenLP. https://bugs.launchpad.net/bugs/1844044 Title: Dev build (2.5) MySQL error during boot, some tables created but not all Status in OpenLP: New Bug description: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1844044/+subscriptions ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
[Openlp-core] [Bug 1844044] [NEW] Dev build (2.5) MySQL error during boot, some tables created but not all
Public bug reported: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) ** Affects: openlp Importance: Undecided Status: New ** Attachment added: "openlp.log" https://bugs.launchpad.net/bugs/1844044/+attachment/5288820/+files/openlp.log -- You received this bug notification because you are a member of OpenLP Core, which is subscribed to OpenLP. https://bugs.launchpad.net/bugs/1844044 Title: Dev build (2.5) MySQL error during boot, some tables created but not all Status in OpenLP: New Bug description: OpenLP 2.5 dev2902 Ubuntu 18.04.3 LTS Configured for MySQL (happens to be MariaDB 10.1.41-MariaDB- 0ubuntu0.18.4.1) Debug log: (full is attached) MySQL tables after the error: MariaDB [openlp]> show tables; +--+ | Tables_in_openlp | +--+ | authors | | metadata | | song_books | | songs| | topics | +--+ 5 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1844044/+subscriptions ___ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp
