Author Topic: Problem adding CiviCRM 3.4.8 to an existing Joomla 1.5 site (Read 1108 times)

Erich · January 29, 2012, 07:26:43 pm

The installation itself seemed to go uneventfully.

I was able to define some custom fields, and import some data which populated those fields.

I was then able to generate search queries and reports which displayed the contents of those fields.

But... when I click on one of the returned records to view its details, I get:

"Sorry. A non-recoverable error has occurred."
"DB Error: no such field"

but no indication of what field it's looking for.

Here's the backtrace (but I don't see anything that looks like the name of a field):

[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 159, handle,
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2424
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1610
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 152
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 879
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomGroup.php, executeQuery, 520
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Contact/Page/View/Summary.php, getTree, 71
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Contact/Page/View/Summary.php, preProcess, 94
[SITE_HOME]/html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 223
[SITE_HOME]/html/administrator/components/com_civicrm/admin.civicrm.php, invoke, 85
[SITE_HOME]/html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
[SITE_HOME]/html/libraries/joomla/application/component/helper.php, require_once, 162
[SITE_HOME]/html/administrator/includes/application.php, renderComponent, 136
[SITE_HOME]/html/administrator/index.php, dispatch, 67
[SITE_HOME]/html/administrator/index2.php, include, 14

Any ideas?

Erich · January 31, 2012, 09:43:32 pm

Below the "DB Error: no such field" line was the following (in a dark grey box that was nearly as wide as the browser window itself):

> Error Details

i.e. it looks like it is supposed to be clickable, but it isn't.

Out of curiosity, I viewed the html source for the error page, and saw:

Database Error Code: Unknown column 'civicrm_value_voter_info_1.neighborhoolock_4' in 'field list', 1054

Well, now I am getting somewhere... "Voter Info" is the name of the custom data set that I created, and "Neighborhood / Block" is the name of one of the field labels I created.

Looking at the CiviCRM database via phpMyAdmin, I saw that civicrm_value_voter_info_1 is the name of one of the tables, but the internal name of the field (judging from the column heading) is neighborhood__block_4 and not neighborhoolock_4.

Not sure how the name got truncated, but I tried going into the civicrm_custom_field table and manually editing the column name there, and that seems to have fixed my problem.

CiviCRM Community Forums (archive)

News:

Author Topic: Problem adding CiviCRM 3.4.8 to an existing Joomla 1.5 site (Read 1108 times)

Erich

Problem adding CiviCRM 3.4.8 to an existing Joomla 1.5 site

Erich

Re: Problem adding CiviCRM 3.4.8 to an existing Joomla 1.5 site