[mludwig]

Hi,

First of all let me say thank you for the com_connector component and the vBulletin SQL module. I have been looking for a bridge between Joomla and vBulletin for ages.

I have managed to get the login integration working with Joomla's standard login module. However, since the client asked for Community Builder to be installed too, I have been writing a CB plugin for forwarding CB user events to com_connector. During development I have accidentally entered a non existing username in the login form and I got the following DB error:

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=UPDATE jos_users SET connector_cookies = 'a:0:{}' WHERE id =
SQL =

UPDATE jos_users
 SET connector_cookies = 'a:0:{}'
 WHERE id =

Then I got the same error for the standard Joomla login module.
I think the source of the error might lay in the following code:

                       $query = "UPDATE #__users"
                                . "\n SET connector_cookies = '".serialize($cookies)."'"
                                . "\n WHERE id = $row->id"
                                ;
                                $this->_db->setQuery($query);
                                if (!$this->_db->query()) {
                                        die($this->_db->stderr(true));
                                }

Since this snippet is outside of the

if ($this->_db->loadObject( $row )){..}
else {..}

structure $row might remain null, hence no value for $row->id, which in turn breaks the SQL query.

Please let me know, if I am on the wrong track here.

I am using Joomla 1.0.10, com_connector 1.0.0 and the Joomla mods from the .zip downloaded yesterday from here.