Support

Support is part of Event Gallery Extended.

Please get a subscription if you need support. Feel free to use the ticket system or the contact form for reporting defects or pre-sale questions. Make sure you're logged in in order to be able to create a new ticket.

For general information you can also jump to the manual.

Subscribe now!

#2628 Problem loading Google Photos

Posted in ‘Event Gallery - General’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by rvanlaarhoven on Sunday, 09 July 2017 11:48 UTC

rvanlaarhoven
 Hi Sven,

First of all, thank you for your work on this really great component. You saved me when Google changed from Picasa to Google Photos.

However, I have a strange problem:
I am the webmaster of a website for a local sportsclub. People can read news and watch photos of the sports events.
I upload the photos to Google Photos and try to show them on the website using your Event Gallery component. This worked fine until it was not possible to make the albums public any more.
To solve this problem, I tried to install the latest component version and use the Google Auth Token. When I make a new event I am able to select the Google Album and to save the event, but the photos are NEVER loaded and the album NEVER shows up on the frontend.
HOWEVER, I also have a test website (a subdomain of my own website), which is a mirror of the real website (using Akeeba backup). Using the test website everything works fine! The photos of new albums are loaded and show correctly. I tried many things to solve this problem on the real website, but without success.

Please can you help me solving this problem? I really would like to use Google Photos with Event Gallery on the real website, not the test website!

I hope to hear from you soon.
Best regards,
Rene

sbluege
Both sites us the same server? Did you checked the /log folder for the eventgallery log file?

rvanlaarhoven
Hi Sven,

Thank you for your quick reply.
Both sites are on different servers. The server with the test website that works correctly has PHP version 5.6.30, the server with the real website that does not work correctly has PHP version 5.4.41.

I also looked into the log files as you requested and I found the following:
- The logfile on the real website reports many times the following line:
2017-03-27T18:37:57+00:00 INFO 66.249.66.127 com_eventgallery unable to load xml content from file. File Name: /home/xxxxxxx/domains/xxxxxxxxx.nl/public_html/cache/com_eventgallery_picasa/bd61fe8800f51347262e9891ba09f5a0.xml for 104486598xxxxx1127822@640212xxxxx44574769 (I replaced some data with the character 'x' for privacy reasons)
- The XML file bd61fe8800f51347262e9891ba09f5a0.xml only contains the text 'No album found.'

This seems to be the problem.
As a test, I copied the XML file bd61fe8800f51347262e9891ba09f5a0.xml for the test website to the real website. After copying the XML file the album is shown correctly on the real website!

It appears to me that for some reason Event Gallery cannot collect the data from the requested album correctly.
I hope that with this information you can look further into solving this problem.

Best regards,
Rene

sbluege
PHP 5.4 on a production server? Crazy.

Anyways... does that server support curl? Can you connect to https://www.svenbluege.de on the command line? This is necessary to load the token for accessing the albums.

rvanlaarhoven
Both websites are hosted at a hosting provider, so I don't have control over the PHP version and I don't have access to the command line. I checked cURL support in the Joomla PHP information tab.
On both websites cURL is enabled:
Testwebsite --> PHP version 5.6.30, cURL support enabled, cURL Information 7.19.7
Real website --> PHP version 5.4.41, cURL support enabled, cURL Information 7.42.1

Best regards,
Rene

sbluege
Do you mind installing this version: https://www.svenbluege.de/downloads/pkg_eventgallery_light_3_7_1_20170318_06-18-50_295c800.zip

Please remove the files in /cache/com_eventgallery_picasa to force a reload. Having a backup copy of the site before installing that version is a good idea as well.

rvanlaarhoven
Hi Sven,

Thanks for your hard work!
I installed the new version and removed all the cache files.
I made a new event, choose for Picasa Images and picked the album from the list. The new event is generated, but is not shown on the frontend.
I investigated the logfiles again, but the problem stays the same, sorry.

Best regards,
Rene

sbluege
Are you sure there is no additional log information in the log files? The version you installed is way more talky when it comes to connection issues.

Can I check this site myself please? Please send the necessary credentials to svenbluege@gmail.com

rvanlaarhoven
Hi Sven,

Sorry, I didn't look into the correct logfiles.
This is the extra information you need:

2017-03-29T16:23:52+00:00 INFO 163.172.66.9 com_eventgallery curl getPicasaToken failed: http 0 51 - SSL: no alternative certificate subject name matches target host name 'www.svenbluege.de'
2017-03-29T16:23:53+00:00 INFO 163.172.66.9 com_eventgallery unable to load xml content from file. File Name: /home/xxxxxxx/domains/xxxxxxxxxxxxxx/public_html/cache/com_eventgallery_picasa/7d68928317dedb545ff282fdc2bd3ebc.xml for 104486598xxxxx1127822@640212xxxxx44574769
2017-03-29T16:24:13+00:00 INFO 157.55.39.99 com_eventgallery curl getPicasaToken failed: http 0 51 - SSL: no alternative certificate subject name matches target host name 'www.svenbluege.de'
2017-03-29T16:24:13+00:00 INFO 157.55.39.99 com_eventgallery unable to load xml content from file. File Name: /home/xxxxxxx/domains/xxxxxxxxxxxxxx/public_html/cache/com_eventgallery_picasa/7d68928317dedb545ff282fdc2bd3ebc.xml for 104486598xxxxx1127822@640212xxxxx44574769
2017-03-29T16:24:21+00:00 INFO 145.132.95.103 com_eventgallery curl getPicasaToken failed: http 0 51 - SSL: no alternative certificate subject name matches target host name 'www.svenbluege.de'
2017-03-29T16:24:21+00:00 INFO 145.132.95.103 com_eventgallery unable to load xml content from file. File Name: /home/xxxxxxx/domains/xxxxxxxxxxxxxx/public_html/cache/com_eventgallery_picasa/7d68928317dedb545ff282fdc2bd3ebc.xml for 104486598xxxxx1127822@640212xxxxx44574769

If you still need access to the site, what kind of access do you need, FTP level or Joomla login access?

Best regards,
Rene

sbluege
I think you mixed up the php and curl version above. That would actually make sense. You production server uses an old curl version which can't handle the ssl connection. Because of this it works on the other server. Please contact your hosting provider to update curl for you. For security reasons this is a very good idea anyways.

rvanlaarhoven
I also wondered myself about the versions, but I did not mix up the versions. I will send you the Joomla system information files via e-mail of both websites.

Best regards,
Rene

sbluege
Please try to contact your hosting provider.

Command line: curl https://www.svenbluege.de
Error message: curl error 51 ssl no alternative certificate subject name matches target host name

They need to fix this. Usually they answer with something like "turn off the certificate validation" but that is a stupid and lazy answer. They need to fix curl, update it or whatever. Your second host proves that this works.

by the way.. what happens if you call curl --version and curl https://www.svenbluege.de directly on your ssh command line?

rvanlaarhoven
Hi Sven,

I escalated the problem to my hosting provider. As soon as I have a reply, I will inform you.
Thank you!

rvanlaarhoven
Hi Sven,

It took a long while, but my website is now moved to a new server with PHP 7.1 active. Your extension now works great, so the problem looks solved.

However, now that I want to migrate all the Google Albums from the old extension to Event Gallery, I run into a new problem.
When I want to create a new event, I use the "Album Selector" button to choose the album I need. The albums are displayed, but not all albums. It looks like there is a limit on reading all albums from Google. There are "only" 1000 albums to choose from the list that the "Album Selector" button creates, and I have 1123 albums available on Google.
Can you tell me if this limitation is set by Google or by Event Gallery?

I hope to hear from you soon.
Thank you and best regards,
Rene

sbluege
Hi,

I'm not sure about that. I can't see a way to do paging with the Picasa API. One can specify a max-results parameter. If you add that to the picasa url you might get more results. Please grab the URL by opening the browser dev tools and reload the url https://www.svenbluege.de/picasa/v1.2/. You should find something like this:

picasaweb.google.com/data/feed/api/user/11584xxxxxxxxxxxxx086?alt=json&access=public.........

just add &max-results=10000 at the end. Does this return more elements?

rvanlaarhoven
Hi Sven,

I tried your suggestion but it doesn't work. I googled on this issue and there seems to be a hard limit on 1000 albums.
I also tried different options like start-index, start-date and end-date, but none of the options seem to work. I Always get the same information returned. I also tried to search on a filename of a photo that is in an album outside the 1000 limit. It finds the photo, but in the information returned is only the username, not the albumID.
At this moment I miss the information of 35 albums. Maybe I can upload the photos again to a new album to receive fresh information or do you have any more ideas?

Thanks for looking into this!
Best regards,
Rene

sbluege
Unfortunately I don't have more ideas here regarding Google Photos. Did you thought about moving stuff to Flickr?

rvanlaarhoven
Hi Sven,

Thank you for your help and your quick replies!
I will consider switching over to Flickr.

Best regards,
René