letest images doubled

mironb

Hi I have zenphoto 1.26. I opened statistics in admin options and now my letest images in index page are doubled. Please see on "nowe zdjecia":
http://fotostacja.pl/galeria/
What is wrong ?

regards

acrylian

The gallery backend stats and the image_album_statsitics are not related in 1.2.6 and if if they were they do not alter anything.

It must be something different by looking at the doube entries I fond slightly different urls:
`
/galeria/./Fotografia_Latawcowa/023_wrak.jpg.php
/galeria/Fotografia_Latawcowa/023_wrak.jpg.php
`
See the point? I suggest to check the albums folder on the filesystem and do a database refresh.

mironb

In admin options I had 1 unpublished album "."
In phpmyadmin I deleted it from zp_albums table and now I don't have it in admin overview page but I still have doubled images
Database refresh doesn't help clear cache also
That database is very old and have been may times updated.

acrylian

Did you create that album named "."? Have you checked if there is actually also a folder of that name on the filesystem via FTP? Names starting with "." can be problematic because normally a suffix starts with that.

mironb

I have never created album named "." There is no such folder in filesystem

acrylian

Then I have no idea where that could come from. Maybe sbillard has an idea later.

kagutsuchi

Are you absolutely sure the directory doesn't exist? Normally, a directory with "." as its name resolves to the current directory. It could be that whichever program you're using for FTP could be not showing the directory.

kagutsuchi

Actually, naming conventions should prevent creation of a "." directory. It might be a problem with your theme. I'm not sure what else could be causing such a problem.

mironb

I have enabled viewing of hidden files so there is no folder "." I change my theme and the problem is still visible. Few months ago my page was hacked. It was zenphoto 1.1.6 I have deleted hacked files from album folder but maybe there is something in mysql base ?

I also have same error messages in my admin page when I open statistics:

`
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/galeria/zp-core/js/jqueryui/i18n/ui.datepicker-en-US.js) is not within the allowed path(s): (/tmp:/home:/var/www/html) in /home/fotografia/domains/fotostacja.pl/public_html/galeria/zp-core/admin-functions.php on line 156

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/galeria/zp-core/js/jqueryui/i18n/ui.datepicker-en.js) is not within the allowed path(s): (/tmp:/home:/var/www/html) in /home/fotografia/domains/fotostacja.pl/public_html/galeria/zp-core/admin-functions.php on line 158
`

acrylian

That error looks like a permissions issue.

sbillard

There is always a '.' and a '..' folder in each folder. But these should be ignored. Unfortunately, the database refresh will not clean out any albums which have this dot in their names as the algorithm is to see if the folder still exists. It will. You will have to remove these folder entries manually from the database and then do another database refresh.

mironb

The mistake is in the mysql base in albums_table but I don't know where exactly. I have created new zenphoto instalation and new mysql base for that gallery. When I go in statistics everything works good. But when I copied my zp_albums table from my fotostacja.pl to this new installation photos started doubling. Deleting each doubled photo from zp_images does't help becouse when I go to statistics they doubled again. What I have to delete in zen_albums table to solve this problem ? Where I Have to look ?

acrylian

You would have to look for a wrong album entry.

mironb

Thanks for help !!!! I deleted in phpmyadmin all albums and photos with "." and now everything is working.