CiviCRM Community Forums (archive)

Hi,
I am using CiviCRM version 4.3.3 with the Webform CiviCRM Integration module 6.x-2.3 (Drupal 6.29) . All contact fields are shown except for the website field.
I get this (DB-error) in my Civicrm log:
Jul 02 10:34:36  [info] $backTrace = #0 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\CRM\Core\Error.php(751): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT * \n FROM civicrm_website \n \n WHERE (  civicrm_website.contact_id = ...")
#4 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT * \n FROM civicrm_website \n \n WHERE (  civicrm_website.contact_id = ...")
#5 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB\common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT * \n FROM civicrm_website \n \n WHERE (  civicrm_website.contact_id = ...", "DB_Error", TRUE)
#6 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'is_primary' in 'order clause'")
#7 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("SELECT * \n FROM civicrm_website \n \n WHERE (  civicrm_website.contact_id = ...")
#9 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB\DataObject.php(2421): DB_common->query("SELECT * \n FROM civicrm_website \n \n WHERE (  civicrm_website.contact_id = ...")
#10 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\packages\DB\DataObject.php(441): DB_DataObject->_query("SELECT * \n FROM civicrm_website \n \n WHERE (  civicrm_website.contact_id = ...")
#11 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\api\v3\utils.php(745): DB_DataObject->find()
#12 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\api\v3\utils.php(941): _civicrm_api3_dao_to_array(Object(CRM_Core_BAO_Website), (Array:4), FALSE, "")
#13 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\api\v3\Website.php(115): _civicrm_api3_basic_get("CRM_Core_BAO_Website", (Array:4))
#14 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\api\api.php(75): civicrm_api3_website_get((Array:4))
#15 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\webform_civicrm\webform_civicrm_utils.inc(1658): civicrm_api("website", "get", (Array:4))
#16 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\webform_civicrm\webform_civicrm_forms.inc(1172): webform_civicrm_api("website", "get", (Array:2))
#17 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\webform_civicrm\webform_civicrm.module(68): _webform_civicrm_webform_frontend_form_alter((Array:27), (Array:4))
#18 [internal function](): webform_civicrm_form_alter((Array:27), (Array:4), "webform_client_form_1112")
#19 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\includes\common.inc(2949): call_user_func_array("webform_civicrm_form_alter", (Array:3))
#20 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\includes\form.inc(556): drupal_alter("form", (Array:27), "webform_client_form_1112")
#21 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\includes\form.inc(106): drupal_prepare_form("webform_client_form_1112", (Array:27), (Array:4))
#22 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\webform\webform.module(1412): drupal_get_form("webform_client_form_1112", Object(stdClass), (Array:0), FALSE)
#23 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\webform\webform.module(986): webform_node_view(Object(stdClass), FALSE, TRUE)
#24 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\modules\node\node.module(685): webform_nodeapi(Object(stdClass), "view", FALSE, TRUE)
#25 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\modules\node\node.module(1102): node_invoke_nodeapi(Object(stdClass), "view", FALSE, TRUE)
#26 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\modules\node\node.module(1019): node_build_content(Object(stdClass), FALSE, TRUE)
#27 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\modules\node\node.module(1114): node_view(Object(stdClass), FALSE, TRUE)
#28 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\modules\node\node.module(1810): node_show(Object(stdClass), NULL)
#29 [internal function](): node_page_view(Object(stdClass))
#30 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\includes\menu.inc(350): call_user_func_array("node_page_view", (Array:1))
#31 C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\index.php(17): menu_execute_active_handler()
#32 {main}
However, the field exists in CiviCRM (and in the database). Any ideas what to do, or do you need more/specific information?
thanks in advance, Bas.

Just upgraded CiviCRM to version 4.3.8, but that doesn't seem to help. In my contact view I don't see a "primary"option in case you have more than 1 website. Is that the problem? Maybe added to a 4.4 version..?

I also get this error:
The CiviCRM "website get" API function returned the error: "DB Error: no such field" when called by line 276 of C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\webform_civicrm\webform_civicrm_forms.inc with the following parameters: "Array ( [contact_id] => 140 [options] => Array ( [sort] => is_primary DESC ) [check_permissions] => [version] => 3 ) "
The same problem I think, so that's why I also tried upgrading my webform_civicrm module to version 2.7, but that did'nt help either. (and by the way introduced another problem: only the standard civicrm-table/records are updated when saving a webform, and not the civicrm-table/records we made ourselves. However, the correct values from the previously saved records are shown in the webform, so that looks like a one-way link... (I'll place this issue in the webform_civicrm forum).

The civicrm update produced two errors (more than once) in my watchdog:
Invalid argument supplied for foreach() in C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\menu_item_container\menu_item_container.module op regel 102.
Invalid argument supplied for foreach() in C:\Program Files\BitNami Drupal 6 Stack\apps\drupal\htdocs\sites\all\modules\civicrm\CRM\Case\XMLProcessor\Process.php op regel 148.

Should I resolve those before upgrading my production site?