Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+3 votes
619 views
in Q2A Core by
edited

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

Please log in or register to answer this question.

...