I looked at these: http://www.question2answer.org/qa/20758/how-to-integrate-joomla-with-q2a-single-sign-on-solved
http://www.question2answer.org/single-sign-on.php
----------
I did login with Joomla account on q2a web site. But I get an error: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/zzzz/public_html/zzz/zzz/qa-external/qa-external-users.php on line 943
while ($result=mysql_fetch_assoc($results)) // 943. line
{
$useridtopublic[$result['id']]=$result['username'];
}
-------
Notice: Undefined offset: 1 in /home/zzzz/public_html/zzzzz/zzzzz/qa-external/qa-external-users.php on line 1152
foreach ($userids as $userid) {
$publicusername=$useridtopublic[$userid]; // 1152. line
$usershtml[$userid]=htmlspecialchars($publicusername);
----
Other problem, when I ask a question with Joomla membership, I get an error. On the other hand I ask a quesiton without membership, I don't get an error.
This is my log file:
[13-Aug-2013 13:42:50 Europe/Helsinki] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/monadiza/public_html/diy/ybudav2/qa-external/qa-external-users.php on line 943
[13-Aug-2013 13:42:50 Europe/Helsinki] PHP Notice: Undefined offset: 1 in /home/monadiza/public_html/diy/ybudav2/qa-external/qa-external-users.php on line 1151
[13-Aug-2013 13:42:50 Europe/Helsinki] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/monadiza/public_html/diy/ybudav2/qa-external/qa-external-users.php on line 943
[13-Aug-2013 13:43:09 Europe/Helsinki] PHP Question2Answer MySQL query error 1452: Cannot add or update a child row: a foreign key constraint fails (`monadiza_yqa`.`qa_posts`, CONSTRAINT `qa_posts_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `qa_users` (`userid`) ON DELETE SET NULL) - Query: INSERT INTO qa_posts (categoryid, type, parentid, userid, cookieid, createip, title, content, format, tags, notify, name, created) VALUES (NULL, 'Q', NULL, '16', NULL, INET_ATON('151.250.234.35'), 'xcvxcvxcvxcvxc', 'vxcvxcvxcvxcxvxxcvcvsdas', '', '', NULL, NULL, NOW())
Joomla version: 2.5
