Hi! Your db scheme is correct, so no err here ;) but scanForAlbum.php was removed, and most gallery related operations were moved to galleryOp.php and it is like this on master ;) looks like your browser holds old javascript's because newone are updated, please clear you cache and let me know how it went :)
bartek 2012/1/14 <[email protected]>: > 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 <[email protected]> >> An: [email protected] >> CC: [email protected] >> 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 <[email protected]>: >> > 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 <[email protected]> >> >> An: [email protected] >> >> CC: [email protected] >> >> 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 _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
