Started process on 17/05/2014-15:00
Inizilizzazione conclusa!
Started daily post process on 17/05/2014-15:00
Now connecting to the DB...
Properly connected to the DB...
Session DB: agorkcom
Query per flag da resettare: UPDATE rockdayz.events SET FbPubStatus='0' WHERE (substring(DataEvento,5,4)<>'0517' AND FbPubStatus<>'0')
Processing all users now...
Query per eventi da pubblicate: SELECT eve.ID as ID, eve.DataCreazione as DataCreazione, eve.UserIDAutore as UserIDAutore, eve.DataEvento as DataEvento, eve.TipoData as TipoData, eve.DescrizioneEvento as DescrizioneEvento, eve.UrlEvento as UrlEvento, eve.UrlImmagine as UrlImmagine, eve.GenereID as GenereID, lkt.LikesCount as LikesCount, gen.Descrizione as NomeGenere, ana.Cognome as Cognome, ana.Nome as Nome, ana.NomeAvatar as NomeAvatar, comm.NomeInChiaro as NomeInChiaro FROM rockdayz.events as eve LEFT JOIN (SELECT ID as LikeID, Count(*) as LikesCount FROM rockdayz.likes as lks GROUP BY lks.ID) as lkt ON lkt.LikeID=eve.ID LEFT JOIN genre as gen ON eve.GenereID=gen.ID LEFT JOIN agorkcom.anagrafica as ana ON (eve.UserIDAutore=ana.UserID AND ana.CodiceCommunity='Hr05qsI35R') LEFT JOIN agorkcom.community as comm ON (comm.CodiceCommunity='Hr05qsI35R') WHERE ( substring(eve.DataEvento,5,4)='0517' AND eve.Cancellato='N' AND eve.TipoData='1' AND eve.FbPubStatus='0' AND eve.Convalidato = '1') ORDER BY eve.DataEvento DESC LIMIT 0,1
Eventi trovati: 1
Query per recuperare configurazione: SELECT * FROM rockdayz.facebook_daily LIMIT 0,1
Data configurazione: 20140516
Data attuale: 20140517
Query per aggiornare configurazione: UPDATE rockdayz.facebook_daily SET DataPassaggio='20140517', NumeroPassaggio='1' WHERE ID='0'
Query per flag da resettare: UPDATE rockdayz.events SET FbPubStatus='0' WHERE (substring(DataEvento,5,4)='0517' AND FbPubStatus<>'0')
Item:
array(30) { [0]=> string(4) "1087" ["ID"]=> string(4) "1087" [1]=> string(8) "20120517" ["DataCreazione"]=> string(8) "20120517" [2]=> string(12) "RockdayzBoss" ["UserIDAutore"]=> string(12) "RockdayzBoss" [3]=> string(8) "20120517" ["DataEvento"]=> string(8) "20120517" [4]=> string(1) "1" ["TipoData"]=> string(1) "1" [5]=> string(219) "Trent Reznor was born on May 17, 1965 in Mercer, USA. He is vocalist and a multi-instrumentalist of Nine Inch Nails. In 2010 he and his wife, Mariqueen Maandig, founded the post-industrial band How to Destroy Angels. " ["DescrizioneEvento"]=> string(219) "Trent Reznor was born on May 17, 1965 in Mercer, USA. He is vocalist and a multi-instrumentalist of Nine Inch Nails. In 2010 he and his wife, Mariqueen Maandig, founded the post-industrial band How to Destroy Angels. " [6]=> string(41) "http://en.wikipedia.org/wiki/Trent_Reznor" ["UrlEvento"]=> string(41) "http://en.wikipedia.org/wiki/Trent_Reznor" [7]=> string(132) "http://upload.wikimedia.org/wikipedia/commons/thumb/4/45/Trent_Reznor_Lollapalooza_1991.jpg/190px-Trent_Reznor_Lollapalooza_1991.jpg" ["UrlImmagine"]=> string(132) "http://upload.wikimedia.org/wikipedia/commons/thumb/4/45/Trent_Reznor_Lollapalooza_1991.jpg/190px-Trent_Reznor_Lollapalooza_1991.jpg" [8]=> string(2) "41" ["GenereID"]=> string(2) "41" [9]=> NULL ["LikesCount"]=> NULL [10]=> string(16) "Alternative Rock" ["NomeGenere"]=> string(16) "Alternative Rock" [11]=> NULL ["Cognome"]=> NULL [12]=> NULL ["Nome"]=> NULL [13]=> NULL ["NomeAvatar"]=> NULL [14]=> NULL ["NomeInChiaro"]=> NULL } Facebook Post:
array(3) { ["message"]=> string(19) "On 17th of May 2012" ["link"]=> string(88) "http://www.rockdayz.com/agork/sites/rockdayz/presentation/p100a/rd_showevent.php?id=1087" ["from"]=> array(1) { [0]=> array(4) { ["name"]=> string(8) "Rockdayz" ["canvas_name"]=> string(8) "rockdayz" ["namespace"]=> string(8) "rockdayz" ["id"]=> string(15) "125189544252601" } } } Facebook configuration:array(3) { ["appId"]=> NULL ["secret"]=> NULL ["cookie"]=> bool(true) }
Getting access token:
This is me at 17-05-2014 03:May :Errore posting per applicazione: CurlException: 60: error setting certificate verify locations: CAfile: /var/www/html/agork/externals/fb-php-sdk/fb_ca_chain_bundle.crt CApath: none
Query per flag da settare pubblicato: UPDATE rockdayz.events SET FbPubStatus='1' WHERE ID='1087'
Print processing completed!