hi, even without the field required the group doesnt get auto joined - basically autojoining of groups using groupjive is crucial to this project working - what sort of turnaround times do these 'bugs' normally take?

sorry to be a pain - but was hoping to be up and running with this project this week.

thanks for your help.

Ben.

i've just found this error if this helps?

500 - JDatabaseMySQL::query: 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 '!IN '1' ) ORDER BY a.`ordering` ASC' at line 4 SQL=SELECT a.* FROM `jos_groupjive_categories` AS a LEFT JOIN `jos_users` AS b ON b.`id` = a.`user_id` WHERE ( a.`id` !IN '1' ) ORDER BY a.`ordering` ASC

---

JDatabaseMySQL::query: 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 '!IN '1' ) ORDER BY a.`ordering` ASC' at line 4 SQL=SELECT a.* FROM `jos_groupjive_categories` AS a LEFT JOIN `jos_users` AS b ON b.`id` = a.`user_id` WHERE ( a.`id` !IN '1' ) ORDER BY a.`ordering` ASC

Call stack
# Function Location
1 JSite->dispatch() /home/sites/iaasuk.com/public_html/index.php:68
2 JComponentHelper->renderComponent() /home/sites/iaasuk.com/public_html/includes/application.php:124
3 require_once() /home/sites/iaasuk.com/public_html/libraries/joomla/application/component/helper.php:162
4 registerForm() /home/sites/iaasuk.com/public_html/components/com_comprofiler/comprofiler.php:128
5 HTML_comprofiler::registerForm() /home/sites/iaasuk.com/public_html/components/com_comprofiler/comprofiler.php:972
6 cbTabs->getEditTabs() /home/sites/iaasuk.com/public_html/components/com_comprofiler/comprofiler.html.php:1166
7 cbTabs->_getEditTabContents() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/comprofiler.class.php:3604
8 cbTabs->_getFieldsContents() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/comprofiler.class.php:3923
9 cbTabs->_getSingleFieldContent() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/comprofiler.class.php:4075
10 cbPluginHandler->callField() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/comprofiler.class.php:4137
11 cbPluginHandler->call() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/plugin.class.php:374
12 call_user_func_array() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/plugin.class.php:582
13 cbgjautoField->getFieldRow()
14 cbFieldHandler->getFieldRow() /home/sites/iaasuk.com/public_html/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveauto/cbgroupjiveauto.php:52
15 cbgjautoField->getField() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/plugin.class.php:814
16 cbgjData->getCategories() /home/sites/iaasuk.com/public_html/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveauto/cbgroupjiveauto.php:101
17 CBdatabase->loadObjectList() /home/sites/iaasuk.com/public_html/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:59
18 CBdatabase->query() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/library/cb/cb.database.php:861
19 JDatabaseMySQL->query() /home/sites/iaasuk.com/public_html/administrator/components/com_comprofiler/library/cb/cb.database.php:695
20 JError->raiseError() /home/sites/iaasuk.com/public_html/libraries/joomla/database/database/mysql.php:231
21 JError->raise() /home/sites/iaasuk.com/public_html/libraries/joomla/error/error.php:171
22 JException->__construct() /home/sites/iaasuk.com/public_html/libraries/joomla/error/error.php:136

Hi, update: i've installed this on an Amazon s2 server and the error still happens:

iaasuk.bitnamiapp.com/joomla/index.php?option=com_comprofiler&task=registers&Itemid=473


is there anyway of getting a quick fix to this please? or a workaround until the bug removed?

thanks.

Ben.

and using Joomla 1.7.3 as well on an amazon server i get the following error report:

Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3302 Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3303 Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3304 Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3305 Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3312 Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3317 Strict Standards: Only variables should be assigned by reference in /opt/bitnami/apps/joomla/htdocs/administrator/components/com_comprofiler/plugin.foundation.php on line 3325 Strict Standards: Accessing static property JCache::$_handler as non static in /opt/bitnami/apps/joomla/htdocs/libraries/joomla/cache/cache.php on line 422 Strict Standards: Accessing static property JCache::$_handler as non static in /opt/bitnami/apps/joomla/htdocs/libraries/joomla/cache/cache.php on line 422 Strict Standards: Accessing static property JCache::$_handler as non static in /opt/bitnami/apps/joomla/htdocs/libraries/joomla/cache/cache.php on line 422 Strict Standards: Accessing static property JCache::$_handler as non static in /opt/bitnami/apps/joomla/htdocs/libraries/joomla/cache/cache.php on line 422
work place : This field is required!