Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - browncoat125

Pages: [1]
1
ThumbsPlus Suggestions / Move TNs to file - issue
« on: 2019-05-09 16:23:26 »
I executed the procedure under FAQ "Database is full error/ I can't create new thumbnails" to move thumbnails to files. The database is old... created under TP7 iirc, upgraded over time, keeps bumping into the 2TB limit. After the procedure and TP restart, all TNs showed up as black squares. Re-creating TNs caused them to go into the DB (evidenced by DB growing), not the file system. I tried a new DB with "TNs in files" from creation time, and that worked AOK. I tried a new DB with TNs in the DB, created a hundred or so TNs, ran the "move TNs fo files" option, and same result as with the old DB - black square TNs.

Comparing the DBs, I noticed that the "converted" ones did not have the row "thumbnail_files,1" in table ThumbsPlusDatabase. To be more accurate, the old DB was missing that row altogether, the newer converted DB had it set to 0. After fixing that, both the smaller new test DB and the large old DB are working fine, and accessing the TNs in the file system.

TP 10 sp2[4013]

Pages: [1]