[SUPPORT] Photoview - CorneliousJD Repo


55 posts in this topic Last Reply

Recommended Posts

Hi.

 

I have an issue that the log is growing too large. My docker container file is growing too large, and it's the log size of photoview that is the cause.

 

Got a tip from their discord that I could add this, to prevent the log from growing too large:

 

logging:
            driver: "json-file"
            options:
                max-size: "50m"

 

How do I add this to the docker template in Unraid?

Link to post
  • 1 month later...
  • Replies 54
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

I had this problem I changed the domain to Unraid ip and port in order to show the images   PHOTOVIEW_PUBLIC_ENDPOINT: http://IP:8694/  

CorneliousJD, I got Photoview running, and it was quite a bit of trying different things. So initially I couldn't get Photoview to load no matter what. Looking through the logs it seemed like it was

It's case sensitive, try /photos in the container, no capital. 

Posted Images

I could install the app, the tables in the database got created and filled up with image information.

On the disk, there are a lot of thumbnail folders with correct thumbs.

 

grafik.thumb.png.6744a3e7ca776bcf2c7ea70f22881c62.png

 

But i can't see any images on the photos page.
 

grafik.thumb.png.1e4d4fbcfe96d8ea87fb7acdd11e1246.png

 

The Album page returns a sql error

 

SQL Log Errors:


 

Quote

 

2021/07/12 07:36:00 /app/graphql/models/album.go:53 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'recursive sub_albums AS (

today at 07:36:00 SELECT * FROM albums AS root WHERE id IN (?,?,?,?)

today at 07:36:00 ' at line 1

today at 07:36:00 [0.097ms] [rows:0]

today at 07:36:00 WITH recursive sub_albums AS (

today at 07:36:00 SELECT * FROM albums AS root WHERE id IN (1,2,3,4)

today at 07:36:00 UNION ALL

today at 07:36:00 SELECT child.* FROM albums AS child JOIN sub_albums ON child.parent_album_id = sub_albums.id

today at 07:36:00 )

today at 07:36:00 2021/07/12 07:36:00 WARN: error authenticating photo: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'recursive sub_albums AS (

today at 07:36:00 SELECT * FROM albums AS root WHERE id IN (?,?,?,?)

today at 07:36:00 ' at line 1

today at 07:36:00

today at 07:36:00 SELECT * FROM `sub_albums` WHERE id = 2

 

 

grafik.thumb.png.1a93b0422e4aeb2d7a9fa02e823e9312.png

 

People get recognized, but the images are not shown

 

grafik.thumb.png.e6fc06cc6e517fa72efcb30f50e369b0.png

 

any tipps?

Edited by corgan
Link to post
On 6/8/2021 at 7:27 PM, Bitbass said:

Can someone write up the MariaDB process for creating the user and DB? I've tried and I think I have it set up correctly, but I'm getting an access denied. Can't tell if I need to open something up on MariaDB or if I created or assigned the user incorrectly. This is all docker on Unraid and it's all new install.

A bit old now, but for anyone else, to set up a mariadb container I referred back to @SpaceInvaderOne tutorial on setting up Nextcloud Here Very quick and simple.

 

After reading through a Reddit debate on multiple databases per install, I went with a separate mariadb designated for Photoview.

 

I've been looking for a good photo gallery for me and sharing with family/friends. I wish I could get rid of the Info sidebar (supposedly coming) and I wish it had some internal photo management stuff (moving/tagging) but so far not too bad.

Edited by Loch
Link to post

Do I need MariaDB or MySQL, or would a Postgres DB work?

 

Edit: apparently it won't work, so I created a MariaDB. 

 

Does anyone know if you can merge multiple people to the same "Person"?  I see a bunch of the same people as separate.

 

Also, I don't think the Public Endpoint thing is working - when I create a public link, it still shows my internal IP address.

Edited by Coolsaber57
Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.