Tuesday, April 30, 2013

authorize.net SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL (Solve)

Error with Transaction:
SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed


sloutation for php :

add to function in where curl is call

 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);

 curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);

Saturday, April 27, 2013

comma separate mysql join query between two table

SELECT a.*,b.album_name FROM #__simplephotogallery_images a inner join #__simplephotogallery_album b on b.id = a.album_id WHERE FIND_IN_SET('11', `a.album_id`) order by title asc LIMIT 0,20