(All of the below is from a format and install of Leopard. This isn't
an upgrade or archive.)
1-Mail.app keeps generating cryptic folders named like "Database
11-43-45-547" in my Trash and in there is always a file called
Database.sqlite3. I don't mind mail doing file/temp file management
like that, but even once Mail is quit, I can't empty the trash because
the files remain in use. It generates one of those folders containing
one of those files every single day I don't reboot my Mac. (part of
early a.m. maintenance? I don't know.)
Anybody experiencing this?
The content of that sqlite file is:
---
SQLite format 3 @
!
'#
Á
#
˚
ˆ
Ò
Ï
Á
" ' % &
$
∆
Ê
∆
-com.apple.Safari A™°∏≤Ó )com.apple.mail Á…
Ù ˙Ù
ÿ ÿÌ
-com.apple.Safari)com.apple.mail
ÿ ÿÌ
-com.apple.Safari)com.apple.mail
Á
ä
«
ß
ä
M
ˇ Ó∫‡ Ä
u
Ó∫‡ Ä
u
Ó∫‡ Ä ˇ Ä
Ó ˙ÓÙ
Ë ¯Ë
‡ ı·
ˇ
å
å
r ] ] e325a0853ffca5a54c4ad6c584f4f67deebfc2fc http://ps3.4thdimension.info/backend.php
˙ ˙
” ”
,]e325a0853ffca5a54c4ad6c584f4f67deebfc2fc
” ”
,]http://ps3.4thdimension.info/backend.php
” ”
,]e325a0853ffca5a54c4ad6c584f4f67deebfc2fc
” ”
,]http://ps3.4thdimension.info/backend.php
˚ ˚
/ /^çÍ
\
Ω
-
A indexsqlite_autoindex_Entries_1Entries-
A
indexsqlite_autoindex_Entries_2Entries
[1yindexEntries_identifierEntriesCREATE INDEX
Entries_identifier ON
Entries(identifier)p3Å indexEntries_unreadcountEntriesCREATE
INDEX Entries_unreadcount ON Entries(feed, read,
localDateCreated)_)ÅindexEntries_tosyncEntriesCREATE INDEX
Entries_tosync ON Entries(localDateFlagsUpdated)Ç@!!
ÑKtableEnclosuresEnclosuresCREATE TABLE Enclosures (rowID integer not
null unique primary key,entry integer references Entries(rowID) ,url
text not null ,mimeType text ,length integer ,downloadAuditStatus
integer ,downloadState integer ,downloadedPath
text ,downloadErrorDomain integer ,downloadErrorCode integer )
! ¿ %Z¥=—
v
¿
E
Å
ÅWtableSyncInfoSyncInfo
CREATE TABLE SyncInfo (context text primary key,lastSyncDate
number,messageQueueState blob)/
C
indexsqlite_autoindex_SyncInfo_1SyncInfo!
x
ÅCtableContentsContents
CREATE TABLE Contents (rowID integer
not null unique primary key,data blob ,mimeType text )/
C
indexsqlite_autoindex_Contents_1Contents 3G!
indexsqlite_autoindex_Enclosures_1EnclosuresX-!
qindexEnclosures_entryEnclosuresCREATE INDEX Enclosures_entry ON
Enclosures(entry)Å=!
Å;indexEnclosures_autodownloadsEnclosuresCREATE INDEX
Enclosures_autodownloads ON Enclosures(downloadState,
downloadAuditStatus)ÅÅytableAuthorsAuthors
CREATE TABLE
Authors (rowID integer not null unique primary key,name text ,email
text ,url text ,addressBookUid text )-
A indexsqlite_autoindex_Authors_1Authors
a
a
ˇ
.
]
∑
G
Ç
ÅÇ
tableClientsClientsCREATE TABLE Clients (rowID integer not null
unique primary key,signature text unique not null ,private
integer ,dateUsed real )-
A indexsqlite_autoindex_Clients_1Clients-
A indexsqlite_autoindex_Clients_2ClientsX/
uindexClients_signatureClientsCREATE INDEX Clients_signature ON
Clients(signature)É
''ÖYtableSubscriptionsSubscriptionsCREATE TABLE Subscriptions
(rowID integer not null unique primary key,client integer references
Clients(rowID) not null ,feed integer references
Feeds(rowID) ,refreshInterval real ,expirationInterval
real ,expirationDate real ,refreshesInBackground
integer ,downloadsEnclosures integer ,maxEnclosureSize
real ,enclosureTypesString text ,unreadCount
integer
)9M' indexsqlite_autoindex_Subscriptions_1Subscriptions|
C'ÅindexSubscriptions_feedandclientSubscriptions CREATE INDEX
Subscriptions_feedandclient ON Subscriptions(feed, client)
Ç Ç≠ÿXò )
= indexsqlite_autoindex_Feeds_1Feeds )
= indexsqlite_autoindex_Feeds_2Feeds
) = indexsqlite_autoindex_Feeds_3FeedsS
-qindexFeeds_identifierFeedsCREATE INDEX Feeds_identifier ON
Feeds(identifier)> UindexFeeds_urlFeedsCREATE INDEX Feeds_url ON
Feeds(url)f9Å indexFeeds_localDateUpdatedFeedsCREATE INDEX
Feeds_localDateUpdated ON Feeds(localDateUpdated)
™
™
K
Å
C'Å_indexSubscriptions_nonbackgroundSubscriptions
CREATE INDEX Subscriptions_nonbackground ON Subscriptions(client,
refreshesInBackground, refreshInterval)Ö2 äCtableFeedsFeeds
CREATE TABLE Feeds (rowID integer not null unique primary
key,identifier text unique ,id text ,title text ,subtitle text ,rights
text ,minUpdateInterval real default 0.0 ,dateUpdated
real ,timeZoneUpdated blob ,url text unique not null ,alternateUrl
text ,iconUrl text ,logoUrl text ,lastErrorDomain
integer ,lastErrorCode integer ,redirectedUrl text ,localDateUpdated
real ,refreshLocalDate real ,refreshHttpDate text ,refreshEtag
text ,refreshDataHash text ,login text ,publishingProtocol
integer ,rebuildXml integer ,feedFormat integer ,bonjourGuid
text ,recoverOldEntries integer default 0 ,foafUrl text ,uploadUrl
text ,publishedEntryCount integer ,monkey blob )
≈
≈
Ü8åGtableEntriesEntriesCREATE
TABLE Entries (rowID integer not null unique primary key,identifier
text unique ,id text ,title text ,rights text ,content integer
references Contents(rowID) ,contentHash text ,summary integer
references Contents(rowID) ,summaryHash text ,xmlRepresentation
integer references Contents(rowID) ,xmlRepresentationHash
text ,dateUpdated real ,timeZoneUpdated blob ,datePublished
real ,timeZonePublished blob ,dateCreated real ,timeZoneCreated
blob ,baseUrl text ,alternateUrl text ,author integer references
Authors(rowID) ,feed integer references Feeds(rowID) ,current
integer ,tombstone integer ,read integer ,flagged
integer ,localDateCreated real ,localDateUpdated
real ,localDateXmlChanged real ,localDateFlagsUpdated real ,editUrl
text ,edited integer ,draft integer ,rebuildXml integer )
---
The urls in the earlier part of the file are links to RSS feeds. I
currently don't have any RSS feeds being managed by Mail.app.
2-I fixed my external HD permissions problem that started once I got
into Leopard-land. I had to go to command line and type a recursive
CHOWN command for my user account. Permissions finally survive
reboots! Yay! Before they would always revert to user "_unknown". I
kept deleting that, and putting my own account with read/write access
using the Get-Info pane, but after a reboot my changes would revert.
Weirdest thing.
3-Leopard doesn't like my 20" brushed metal Apple Cinema Display. If I
plug it in while the MacBook is running, it activates fine and
switches to mirror-view. But then when I try to close the MacBook lid
to get the native resolution of the monitor going and have the MacBook
display turned off, the MacBook gets stuck in a sleep-wake loop.
First, it won't wake up using my external Apple keyboard and mouse. So
I have to open the lid to get it wake up. But then it switches back to
mirror-view. So I close the lid, and it goes back to sleep. Rinse and
repeat. I can only get the external monitor to be the sole monitor if
I shut down the MacBook, press its power button, and close its lid
quickly before it starts analyzing for lid closure. Fun eh? Tiger
never did this.
4-The left pane of Finder windows, where devices are listed, doesn't
always update or displays duplicates. Sometimes when I plug in my
external hard drives, the same drive will appear multiple times, or
not appear at all. When it doesn't appear there, it almost always
appears on the Desktop though. And in any scenario, Disk Utlity
*always* sees the drives and indicates that their mounted.
5-I sometimes can't eject external drives from the Finder. I highlight
and click the eject gadget, or highlight and hit CMD+E, and nothing
happens. Same from the Desktop. I've even dried dragging the devices
to the trash from the Desktop, and nothing. The trash icon changes to
the eject symbol and everything, but then the device stays mounted. I
have to launch disk utility and do it from there to have any success.
6-Quickview fails to report the proper song length of Logic Express 8
generated MP3s. And it only plays the incorrect length that Quickview
states. Same mp3s play/report just fine in iTunes, Quicktime app and
iPod Classic however.
7-Airport on my MacBook has become useless when trying to work with my
Apple router. The MacBook no longer processes bandwidth. What I mean
is that I can connect to my Apple router and get an IP address and
everything, but the bandwidth is the pits. I'll get around 0.4k/s for
an hour, then it will go back to normal for 30 seconds, and then die
again for hours again. I've tried resetting the router, my DSL modem
that it gets its feed from and everything, and same behavior. I've
shut off airport, turned it back on etc. All my other wireless wifi
devices (PS3, PSP, NintendoDS) that use the Apple router work just
fine wirelessly. It's just the MacBook that's acting up. If I plug an
ethernet cable from the Apple router to the MacBook it works fine.
Switch Airport back on and unplug the ethernet cable back in, and I'm
dead in the water. This problem began with the 10.5.1 update.