hi

just wondering if this thread got resolved

i have this same problem

i have uninstalled all other login modules and still get a session write error when users try to login by facebook connect and have run out of options as to what might be causing a conflict

cheers

"Session Error" problem is in syncUser() at

// user couldn't store; clear facebook information to prevent locking out of retry:

sent into session_write_close from clearFacebookSession():

2010-10-01 14:42:28 - 64.102.254.33 user couldn't store in syncUser:

---

>clear facebook information to prevent locking out of retry
2010-10-01 14:42:28 - 64.102.254.33 sb.session calling this->write()

---

>
2010-10-01 14:42:28 - 64.102.254.33 start cb.session $v loop <

---

>
2010-10-01 14:42:28 - 64.102.254.33 session_id: 'dNwjTlIsYi3rAnD7kwisff6sroIqMJO8/'
2010-10-01 14:42:28 - 64.102.254.33 session_data: 'a:4:{s:17:\"cbsessions.verify\";s:32:\"jlYeBMiIZ7G8N0WQwDF6pluFvyx9akhe\";s:15:\"cbsession.agent\";s:97:\"Mozilla/5.0 (Macintosh; U; Intel Mac
OS X 10.5; en-US; rv:1.9.1.13) Gecko/20100914 Firefox/3.5.13\";s:15:\"facebook_userid\";N;s:7:\"cb_auth\";s:0:\"\";}'
2010-10-01 14:42:28 - 64.102.254.33 expiry_time: UNIX_TIMESTAMP()+43200
2010-10-01 14:42:28 - 64.102.254.33 ui: 1
2010-10-01 14:42:28 - 64.102.254.33 client_ip: '64.102.254.33'
2010-10-01 14:42:28 - 64.102.254.33 incoming_ip: '64.102.254.33'
2010-10-01 14:42:28 - 64.102.254.33 end cb.session $v loop <

---

>
2010-10-01 14:42:28 - 64.102.254.33 SQL on write in cb.session: INSERT INTO `#__comprofiler_sessions` (`session_id`,`session_data`,`expiry_time`,`ui`,`client_ip`,`incoming_ip`) VALUES('dNwjTl
IsYi3rAnD7kwisff6sroIqMJO8/','a:4:{s:17:\"cbsessions.verify\";s:32:\"jlYeBMiIZ7G8N0WQwDF6pluFvyx9akhe\";s:15:\"cbsession.agent\";s:97:\"Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1.13) Gecko/20100
914 Firefox/3.5.13\";s:15:\"facebook_userid\";N;s:7:\"cb_auth\";s:0:\"\";}',UNIX_TIMESTAMP()+43200,1,'64.102.254.33','64.102.254.33')
2010-10-01 14:42:28 - 64.102.254.33 _db->query() result in cb.session:
2010-10-01 14:42:28 - 64.102.254.33 sb.session this->write() DEAD!

---

>


While the SQL appears valid this->_db->query() is returing null causing death.

I see a new version was released (W 9/29) sorry I spent time on this one!

I don't see any attempt to remove the session from the database prior to this insert. Since the table is set for session_id to be unique I don't think this should be an insert. I has to be an update to an existing entry. That would explain a false return to the query.

Thought I am using the 1.0 release version.

/**
* Facebook CB plugin for Community Builder
* @version $Id: cb.facebookconnect.php 1089 2010-04-30 12:34:48Z kyle $
* @package Community Builder
* @subpackage Facebook CB plugin
* @author Kyle and Beat
* @copyright (C) www.joomlapolis.com and various
* @license www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU/GPL version 2

Post edited by: qrQq97y3P2yS, at: 2010/10/01 18:54

Post edited by: qrQq97y3P2yS, at: 2010/10/01 18:56