[mythtv-users] DB weirdness with initial 0.27 install?

[Paul B. Henson]

So I recently installed mythtv 0.27 under gentoo (version
mythtv-0.27_p20131124 specifically), and started mythsetup for the first
time. It asked me to configure the database, which I did, and then it
logged:

2014-02-16 19:49:25.927290 E  SaveSettingOnHost('Country') - No database yet
2014-02-16 19:49:25.927295 E  SaveSettingOnHost('FreqTable') - No database yet
2014-02-16 19:49:25.927298 E  SaveSettingOnHost('ISO639Language0') - No databas
e yet
2014-02-16 19:49:25.927302 E  SaveSettingOnHost('ISO639Language1') - No databas
e yet
2014-02-16 19:49:25.927305 E  SaveSettingOnHost('Language') - No database yet
2014-02-16 19:49:25.927308 E  SaveSettingOnHost('TVFormat') - No database yet
2014-02-16 19:49:25.927311 E  SaveSettingOnHost('VbiFormat') - No database yet
2014-02-16 19:49:25.927318 E  SaveSettingOnHost('DateFormat') - No database yet2014-02-16 19:49:25.927323 E  SaveSettingOnHost('MythArchiveDateFormat') - No d
atabase yet
2014-02-16 19:49:25.927327 E  SaveSettingOnHost('MythArchiveTimeFormat') - No database yet
2014-02-16 19:49:25.927332 E  SaveSettingOnHost('MythArchiveVideoFormat') - No database yet
2014-02-16 19:49:25.927337 E  SaveSettingOnHost('ShortDateFormat') - No databas
e yet
2014-02-16 19:49:25.927341 E  SaveSettingOnHost('TimeFormat') - No database yet
2014-02-16 19:49:25.967011 I  ScreenSaverX11Private: DPMS is active.
2014-02-16 19:49:25.979339 E  Error preparing query: SELECT DISTINCT dirname FR
OM storagegroup WHERE groupname = :GROUP AND hostname = :HOSTNAME
2014-02-16 19:49:25.979360 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.storagegroup' doesn't exist
2014-02-16 19:49:25.979539 E  DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND hostname
 = :HOSTNAME
Bindings were:
:GROUP="Themes", :HOSTNAME="mythtv"
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your
 MariaDB server version for the right syntax to use near ':GROUP AND hostname =
 :HOSTNAME' at line 1

2014-02-16 19:49:25.979640 N  Setting 'RunFrontendInWindow' being forced to '1'
2014-02-16 19:49:25.980051 N  Inserting MythTV initial database information.
2014-02-16 19:49:25.980071 C  Upgrading to MythTV schema version 1307
2014-02-16 19:49:28.371202 I  Loading en_us translation for module mythfrontend
2014-02-16 19:49:28.371290 I  UDPListener: Enabling
2014-02-16 19:49:28.372320 I  Binding to UDP 127.0.0.1:0
2014-02-16 19:49:28.372401 I  Binding to UDP 10.128.50.38:0
2014-02-16 19:49:28.372453 I  Binding to UDP 10.128.50.255:0
2014-02-16 19:49:28.436559 I  Using the Qt painter
2014-02-16 19:49:28.771211 I  MythUIWebBrowser: Loading css from - file:///usr/
share/mythtv/themes/default/htmls/mythbrowser.css
2014-02-16 19:49:28.771543 E  MythUIWebBrowser: failed to find our parent scree
n
2014-02-16 19:49:28.772654 I  MythUIWebBrowser: enabling plugins
2014-02-16 19:49:29.356533 I  System Locale (en_US), Country (US), Language (en
)
2014-02-16 19:49:41.847878 I  Loading en_us translation for module mythfrontend
2014-02-16 19:49:41.937810 I  Using the Qt painter
share/mythtv/themes/default/htmls/mythbrowser.css
2014-02-16 19:49:41.997658 E  MythUIWebBrowser: failed to find our parent scree
n
2014-02-16 19:49:41.997715 I  MythUIWebBrowser: enabling plugins
2014-02-16 19:49:42.022778 W  MythPainter: 17 images not yet de-allocated.
2014-02-16 19:49:42.260502 I  Removing syslogging

and then it just died. When I restarted it, it said it wanted to update
the schema version from 1307 to 1317. After this, it popped up the mythsetup
configuration menus and seems to be working ok.

But it's kinda odd it bootstrapped the db from empty to version 1307, then
just died. Is that expected? As I said, while I haven't finished configuring
it, it seems to be working now, I'm just a little leery there might be
some database issue hiding that will pop up later.

Thanks...