https://www.icyphoenix.com/viewtopic.php?f=35&t=8852&p=57803#p57803
-----------------------------------
TheSteffen
Fri 14 Dec, 2012 15:41

Re: Blank Paged After Update To 2.0
-----------------------------------
[quote user="Rene" post="57799"]Entry in IP_album column pic_filename = 2/2/2/IMG_0045.JPG[/quote]
The pfad is wrong:

Should be  2/IMG_0045.JPG
The 2 is the User-ID from the user how upload the pic.
So if you have other users than you, you have check this too.

My fix would be:
[list=1][*]Make a backup of your DB or at least for ip_album
[*]run the script for renaming all pfads (see below)
[/list]

[code linenumbers=false]UPDATE ip_album
SET pic_filename = REPLACE(pic_filename, '2/2/2/', '2/')
WHERE pic_filename LIKE '%2/2/2/%'[/code]

That should work  :mricy:


