[Owncloud] thumbnails in gallery app

Sat Jan 14 19:00:06 UTC 2012

Hi Bartek

As it works on your end, I digged a bit into the issue. It appears (according to apache2/error.log) that /var/www/owncloud/apps/gallery/ajax/scanForAlbums.php is called, but this file does not exist. (why? I am on git master branch with a clean working directory).

Nevertheless, to answer your direct questions and although the above issue is most likely the cause:

The sqlite3 .schema of owncloud.db:
CREATE TABLE "oc_appconfig" ("appid" VARCHAR(255) DEFAULT ' ' NOT NULL, "configkey" VARCHAR(255) DEFAULT ' ' NOT NULL, "configvalue" VARCHAR(255) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_authtoken" ("token" VARCHAR(40) DEFAULT ' ' NOT NULL, "appUrl" VARCHAR(128) DEFAULT ' ' NOT NULL, "user" VARCHAR(64) DEFAULT ' ' NOT NULL, "category" VARCHAR(64) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "url" VARCHAR(4096) DEFAULT ' ' NOT NULL, "title" VARCHAR(140) DEFAULT ' ' NOT NULL, "user_id" VARCHAR(64) DEFAULT ' ' NOT NULL, "public" SMALLINT DEFAULT 0, "added" INTEGER UNSIGNED DEFAULT NULL, "lastmodified" INTEGER UNSIGNED DEFAULT NULL, "clickcount" INTEGER UNSIGNED DEFAULT 0 NOT NULL);
CREATE TABLE "oc_bookmarks_tags" ("bookmark_id" BIGINT DEFAULT 0, "tag" VARCHAR(255) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_calendar_calendars" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "userid" VARCHAR(255), "displayname" VARCHAR(100), "uri" VARCHAR(100), "active" INTEGER DEFAULT 1 NOT NULL, "ctag" INTEGER UNSIGNED DEFAULT 0 NOT NULL, "calendarorder" INTEGER UNSIGNED DEFAULT 0 NOT NULL, "calendarcolor" VARCHAR(10), "timezone" LONGTEXT, "components" VARCHAR(100));
CREATE TABLE "oc_calendar_objects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "calendarid" INTEGER UNSIGNED DEFAULT 0 NOT NULL, "objecttype" VARCHAR(40) DEFAULT ' ' NOT NULL, "startdate" DATETIME DEFAULT '0000-00-00 00:00:00', "enddate" DATETIME DEFAULT '0000-00-00 00:00:00', "repeating" INTEGER DEFAULT NULL, "summary" VARCHAR(255), "calendardata" LONGTEXT, "uri" VARCHAR(100), "lastmodified" INTEGER DEFAULT NULL);
CREATE TABLE "oc_contacts_addressbooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "userid" VARCHAR(255) DEFAULT ' ' NOT NULL, "displayname" VARCHAR(255), "uri" VARCHAR(100), "description" LONGTEXT, "ctag" INTEGER UNSIGNED DEFAULT 1 NOT NULL);
CREATE TABLE "oc_contacts_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "addressbookid" INTEGER UNSIGNED DEFAULT 0 NOT NULL, "fullname" VARCHAR(255), "carddata" LONGTEXT, "uri" VARCHAR(100), "lastmodified" INTEGER UNSIGNED DEFAULT NULL);
CREATE TABLE "oc_foldersize" ("path" VARCHAR(512) DEFAULT ' ' NOT NULL, "size" INTEGER DEFAULT 0 NOT NULL);
CREATE TABLE "oc_gallery_albums" ("album_id" INTEGER PRIMARY KEY AUTOINCREMENT, "uid_owner" VARCHAR(64) DEFAULT ' ' NOT NULL, "album_name" VARCHAR(100) DEFAULT ' ' NOT NULL, "album_path" VARCHAR(100) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_gallery_photos" ("photo_id" INTEGER PRIMARY KEY AUTOINCREMENT, "album_id" INTEGER DEFAULT 0 NOT NULL, "file_path" VARCHAR(100) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_group_user" ("gid" VARCHAR(64) DEFAULT ' ' NOT NULL, "uid" VARCHAR(64) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_groups" ("gid" VARCHAR(64) DEFAULT ' ' NOT NULL, PRIMARY KEY (gid));
CREATE TABLE "oc_locks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "userid" VARCHAR(200), "owner" VARCHAR(100), "timeout" INTEGER UNSIGNED DEFAULT NULL, "created" INTEGER DEFAULT NULL, "token" VARCHAR(100), "scope" SMALLINT DEFAULT NULL, "depth" SMALLINT DEFAULT NULL, "uri" LONGTEXT);
CREATE TABLE "oc_log" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "moment" DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, "appid" VARCHAR(255) DEFAULT ' ' NOT NULL, "user" VARCHAR(255) DEFAULT ' ' NOT NULL, "action" VARCHAR(255) DEFAULT ' ' NOT NULL, "info" LONGTEXT NOT NULL);
CREATE TABLE "oc_media_albums" ("album_id" INTEGER PRIMARY KEY AUTOINCREMENT, "album_name" VARCHAR(200) DEFAULT ' ' NOT NULL, "album_artist" INTEGER DEFAULT 0 NOT NULL, "album_art" VARCHAR(200) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_media_artists" ("artist_id" INTEGER PRIMARY KEY AUTOINCREMENT, "artist_name" VARCHAR(200) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_media_sessions" ("session_id" INTEGER PRIMARY KEY AUTOINCREMENT, "token" VARCHAR(64) DEFAULT ' ' NOT NULL, "user_id" VARCHAR(64) DEFAULT ' ' NOT NULL, "start" DATETIME DEFAULT '1970-01-01 00:00:00' NOT NULL);
CREATE TABLE "oc_media_songs" ("song_id" INTEGER PRIMARY KEY AUTOINCREMENT, "song_name" VARCHAR(200) DEFAULT ' ' NOT NULL, "song_artist" INTEGER DEFAULT 0 NOT NULL, "song_album" INTEGER DEFAULT 0 NOT NULL, "song_path" VARCHAR(200) DEFAULT ' ' NOT NULL, "song_user" VARCHAR(64) DEFAULT '0' NOT NULL, "song_length" INTEGER DEFAULT 0 NOT NULL, "song_track" INTEGER DEFAULT 0 NOT NULL, "song_size" INTEGER DEFAULT 0 NOT NULL, "song_playcount" INTEGER DEFAULT 0 NOT NULL, "song_lastplayed" INTEGER DEFAULT 0 NOT NULL);
CREATE TABLE "oc_media_users" ("user_id" VARCHAR(64) DEFAULT '0' NOT NULL, "user_password_sha256" VARCHAR(64) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_preferences" ("userid" VARCHAR(255) DEFAULT ' ' NOT NULL, "appid" VARCHAR(255) DEFAULT ' ' NOT NULL, "configkey" VARCHAR(255) DEFAULT ' ' NOT NULL, "configvalue" VARCHAR(255) DEFAULT ' ' NOT NULL);
CREATE TABLE "oc_principalgroups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "principal_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL, "member_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL);
CREATE TABLE "oc_principals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT, "uri" VARCHAR(255), "displayname" VARCHAR(255));
CREATE TABLE "oc_properties" ("userid" VARCHAR(200) DEFAULT ' ' NOT NULL, "propertypath" VARCHAR(255) DEFAULT ' ' NOT NULL, "propertyname" VARCHAR(255) DEFAULT ' ' NOT NULL, "propertyvalue" LONGTEXT NOT NULL);
CREATE TABLE "oc_sharing" ("uid_owner" VARCHAR(64) DEFAULT ' ' NOT NULL, "uid_shared_with" VARCHAR(64) DEFAULT ' ' NOT NULL, "source" VARCHAR(128) DEFAULT ' ' NOT NULL, "target" VARCHAR(128) DEFAULT ' ' NOT NULL, "permissions" SMALLINT DEFAULT 0 NOT NULL);
CREATE TABLE "oc_users" ("uid" VARCHAR(64) DEFAULT ' ' NOT NULL, "password" VARCHAR(255) DEFAULT ' ' NOT NULL, PRIMARY KEY (uid));
CREATE UNIQUE INDEX a_app_remotestorage_user ON "oc_authtoken" (user ASC, token ASC);
CREATE UNIQUE INDEX artist_name ON "oc_media_artists" (artist_name ASC);
CREATE UNIQUE INDEX bookmark_tag ON "oc_bookmarks_tags" (bookmark_id ASC, tag ASC);
CREATE UNIQUE INDEX id ON "oc_bookmarks" (id DESC);
CREATE INDEX path_index ON "oc_foldersize" (path ASC);
CREATE UNIQUE INDEX principals_members_index ON "oc_principalgroups" (principal_id ASC, member_id ASC);
CREATE UNIQUE INDEX uri ON "oc_principals" (uri ASC);

oc_gallery_photos and oc_gallery_albums are empty and remain empty when hitting rescan.

No notification appears when hitting rescan.

Best

Al_

-------- Original-Nachricht --------
> Datum: Sat, 14 Jan 2012 17:46:47 +0100
> Von: Bartek Przybylski <bart.p.pl at gmail.com>
> An: Software at quantentunnel.de
> CC: owncloud at kde.org
> Betreff: Re: [Owncloud] thumbnails in gallery app

> when you press rescan on top of the screen notification should appear
> (Creating thumbnails)?
> Also please provide your sqlite db scheme (for gallery) becasue there
> is possibility that scheme was not updated to latest version
> critical error logs might be stored in php logs, owncloud error log
> are stored in data/owncloud.log
> 
> bartek
> 
> 2012/1/14  <Software at quantentunnel.de>:
> > Sure.
> >
> > The server (actually an old computer used as media server with a 2 TB
> disk for /home and small disk for everything else):
> > Linux 2.6.32-37-generic-pae #81-Ubuntu
> > owncloud current master, commit 34a4784...
> > pictures all on /var/www/owncloud/... (i.e., no symbolic link to my 2 TB
> disk).
> >
> > The client (less interesting): I trigger the rescan from Linux Ubuntu
> Natty, Firefox 9.0.1
> >
> > I manually deleteed the records, but not the tables, in owncloud.db
> (using sqlite3) and rm all pre-rendered thumbnails.
> > Then logged in from the client machine into my account, confirmed that
> all pictures exist (as files), then switched to the gallery app and hit
> rescan; no visible response.
> >
> > Are there any logs? I've seen that logging is forseen, but it seems not
> to be widely used. I diverted the logs to /var/log/owncloud.log, and I have
> set the logging level to debug.
> >
> > Best
> >
> > Al_
> >
> >
> >
> > -------- Original-Nachricht --------
> >> Datum: Sat, 14 Jan 2012 17:21:41 +0100
> >> Von: Bartek Przybylski <bart.p.pl at gmail.com>
> >> An: Software at quantentunnel.de
> >> CC: owncloud at kde.org
> >> Betreff: Re: [Owncloud] thumbnails in gallery app
> >
> >> Could you provide reproduction steps and setup environment because
> >> rescanning works for me
-- 
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!		
Jetzt informieren: http://www.gmx.net/de/go/freephone