tag:help.beatunes.com,2009-07-24:/discussions/problems/4121-ea4-installation-updating-db-failedbeaTunes: Discussion 2011-04-07T12:31:21Ztag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T04:24:49Z2009-11-21T04:24:58ZEA4 Installation - Updating DB Failed<div><p>EA4 Installation: Screenie 4 happens every boot.<br>
beaTunes EA4 continues to load, but slowly<br>
Screenie 06 is all I get, after that, half unpainted main window,
and only mouseover will show me text.<br>
Exit is very quick, as though there is no data loaded into
beaTunes, which is what the error from Screenie 4 is telling me at
least.<br>
There seems to be no logfiles written in ~/.beatunes/ at all in the
whole process of opening and closing this failed EA4 process.<br>
I'm going to backup my .beaTunes directory and try it without a
DB.</p></div>Tim Ltag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T07:52:29Z2009-11-21T07:52:31ZEA4 Installation - Updating DB Failed<div><p>OK, so its' not just EA4, it's any EA installation over an old
or brand new 2.0.18 installation/database.<br>
Upon installing the EAx each time, it fails requiring the
iTunes.exe /regserver error dialog. So whether I wait for that
error message, or preempt it and run from an Administrative Command
Prompt... hmmm, I'll try running it from a non-admin command
prompt..... nope, no change.</p>
<p>iTunes version 9.0.2.25<br>
Windows 7</p></div>Tim Ltag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T08:16:16Z2009-11-21T08:16:16ZEA4 Installation - Updating DB Failed<div><p>Hi Tim,</p>
<p>Thanks for your feedback.<br>
Could you please delete the folder</p>
<p><code>C:\Users\AppData\Local\tagtraum industries</code></p>
<p>re-install the latest EA and try again? Does it make any
difference?<br>
If not, could you please send me your logs? They are in
<code>C:\Users\AppData\Local\tagtraum
industries\beaTunes\logs</code></p>
<p>Thanks!</p>
<p>-hendrik</p></div>hendriktag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T09:19:26Z2009-11-21T09:19:26ZEA4 Installation - Updating DB Failed<div><p>Evening,<br>
Rightio, having deleted the suggested directory at
'C:\Users\AppData\Local\tagtraum industries' Its Updating the DB
again (see screenie08)<br>
For each "reinstall" of an EA that I thought I was doing... it
didn't try and Update the Database like this, so I suppose I
screwed up letting it<br>
update the first time. (iTunes crashed last time from memory.)<br>
I expect this to take a long long while, instead of a long while.
-Timme</p>
<hr>
<p>From: "hendrik"<br>
<a>tender+de0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com</a><br>
Sent: Saturday, November 21, 2009 7:16 PM<br>
To: <a href=
"mailto:asc3nti0ni7e@gmail.com">asc3nti0ni7e@gmail.com</a><br>
Subject: Re: EA4 Installation - Updating DB Failed [Problems]</p></div>Tim Leechtag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T10:26:33Z2009-11-21T10:26:33ZEA4 Installation - Updating DB Failed<div><p>Failed again...<br>
... included are my logs.</p>
<p>I came back to my computer after say 25-30 minutes, and the same
"schema is<br>
13, not 15" error as earlier screenies show.<br>
Synch Database in-beatunes takes longer than before, but cuts
out.<br>
Painting of the screen is screwy as.<br>
The list of things I have waiting to be analysed is there from
2018,<br>
pre-EA4-reinstall, all 17,000 since I know they had been beatuned
so I'm<br>
hitting them all up for the embedded info.<br>
-Tim</p>
<hr>
<p>From: "Tim Leech" <a href=
"mailto:asc3nti0ni7e@gmail.com">asc3nti0ni7e@gmail.com</a><br>
Sent: Saturday, November 21, 2009 8:18 PM<br>
To: <a href=
"mailto:support@beatunes.com">support@beatunes.com</a><br>
Subject: Re: EA4 Installation - Updating DB Failed [Problems]</p></div>Tim Leechtag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T19:46:19Z2009-11-21T19:46:19ZEA4 Installation - Updating DB Failed<div><p>Hi Tim,</p>
<p>thanks for the logs. Unfortunately, because beaTunes was left
running for a while after the schema migration failed, the logs
only contain meaningless error messages (they are rolling logs,
meaning, old stuff gets thrown away after a while).</p>
<p>If you have a chance to delete the
'C:\Users\AppData\Local\tagtraum industries' folder again, restart
the EA version, stop it right after the migration failed and send
me the logs again, I would probably be able to see what's
wrong.</p>
<p>Thanks so much for helping improving beaTunes!</p>
<p>-hendrik</p>
<p>-hendrik</p></div>hendriktag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T22:59:01Z2009-11-21T22:59:01ZEA4 Installation - Updating DB Failed<div><p>Ahhh, i see.<br>
Well I'm only going through iTunes rating tunes today (really tough
day) so<br>
I'll give it another go.</p>
<p>Timothy Leech</p>
<pre>
<code> Protection and Control Tester
Network Services, Citipower Ltd.
35 Rooney St Burnley, 3121
Ph. (03) 9297 6523
Mob. 0417 315 827</code>
</pre>
<p>2009/11/22 hendrik <<br>
<a href=
"mailto:tender+de0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com">
tender+de0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com</a><a>tender%2Bde0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com</a><br></p></div>Timothy Leechtag:help.beatunes.com,2009-07-24:Comment/6171982009-11-21T23:59:23Z2009-11-21T23:59:23ZEA4 Installation - Updating DB Failed<div><p>Got it.<br></p>
<pre>
<code>Alright, so there is a chronology here, but the logs that I zipped while the error messages were on the screen were untainted with the thousands of errors that occurred once the main window started painting.
So "really new" install of EA4, iTunes is running still tuning away, leave the normal conditions of "run beaTunes when installer finishes" and "read readme" checkboxes checked. Then beaTunes starts, takes it sweet time, but eventually gets to the dialog stating that I have to run iTunes.exe /regserver, <logs200911221005> so I go do that from a normal-access-level command prompt.
So it starts updating the DB on the next run of EA4 after that regserver thing. so I take a log zip: <logs200911221011>
After 10 minutes, its still updating, take another log zip, the logfile doesn't seem to ahve overflowed yet, so it'll just be a bit more on the last I suppose: <logs200911221024>
My attention starts to wane at this stage, so I wander off and do something. I think I found Windows Media Centre so I started that looking for my music and movie folders. Alt-Tab out of that full-screen app and see the messages, I think, bummer, missed getting the log, but no, its' there. the logfile has the schema whinge at the end of it, so I hope it helps: <logs200911221036>
So I tried to get a zip of the logs just after I accepted the errors, there's a little bit of playlist loading there. <logs200911221039a>
Then by the next one the window had painted and I hit the close button in the top right... took a zip... the timestamp from the first to the last are like 10milliseconds in the .log file, I didn't look at the .2, .3, .4 or .5 files.</code>
</pre>
<p>Hope you see somethign interesting.</p>
<hr>
<p>From: "hendrik"
<a>tender+de0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com</a><br>
Sent: Sunday, November 22, 2009 6:46 AM<br>
To: <a href=
"mailto:asc3nti0ni7e@gmail.com">asc3nti0ni7e@gmail.com</a><br>
Subject: Re: EA4 Installation - Updating DB Failed [Problems]</p></div>Tim Leechtag:help.beatunes.com,2009-07-24:Comment/6171982009-11-22T12:33:02Z2009-11-22T12:33:02ZEA4 Installation - Updating DB Failed<div><p>Tim!</p>
<p>Thanks so much! The <code>mighthavebeentoolate</code>-log
contained the relevant error message.</p>
<p>In order to save some disk space, I'm trying to change the
database schema from fairly generous datatypes to more concise
ones. E.g. trackCount from regular integer to smallint. Now for
some reason you seem to have a value in your database that is out
of the numeric range of a smallint and that's causing the schema
update to fail. This too high (or too low) value is quite
surprising for a trackCount.</p>
<p>Could you please check in iTunes what's the highest trackCount
in your collection (just sort by Track #)? Just in case you are not
familiar with the term: trackcount is the number of tracks in an
album.</p>
<p>If there is no extraordinarily high number to be seen.. could
you please send me your <code>C:\Users\tleech\Music\iTunes\iTunes
Music Library.xml</code>-file (zipped!)?</p>
<p>Thanks,</p>
<p>-hendrik</p></div>hendriktag:help.beatunes.com,2009-07-24:Comment/6171982009-11-23T08:13:19Z2009-11-23T08:13:19ZEA4 Installation - Updating DB Failed<div><p>Hey,<br>
So there were 231 tracks with a tracknumber value of 65400 to
65535. (duplicates of some numbers) they seem all to be coded
values of volume, disk, side, track number ... something like that
anyhow. I deleted the<br>
values, and will work out what compilation they're from later
on.<br>
BUT I have a top 2000 tracks collection so there is a trackvalue of
up to two-thousand.<br>
I could move the values from the track column to the comments
fields using Jaikoz if I must, what's the maximum allowable value
under "smallint"?</p>
<p>Timothy Leech</p>
<pre>
<code> Protection and Control Tester
Network Services, Citipower Ltd.
35 Rooney St Burnley, 3121
Ph. (03) 9297 6523
Mob. 0417 315 827</code>
</pre>
<p>2009/11/22 hendrik <<br>
<a href=
"mailto:tender+de0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com">
tender+de0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com</a><a>tender%2Bde0b24f3ef781c04f75608662faedb95e6086c3a2@tenderapp.com</a><br></p></div>Timothy Leechtag:help.beatunes.com,2009-07-24:Comment/6171982009-11-23T08:30:47Z2009-11-23T08:30:47ZEA4 Installation - Updating DB Failed<div><p>Hi Tim,</p>
<p>that explains the issue.</p>
<p>Smallints are -32768 to 32767 - more than enough, I thought, to
encode valid tracknumbers and trackcounts.</p>
<p>-hendrik</p></div>hendrik