Hello everyone,

I am very new to ERPAL and wanted to first thank you guys very much for such an amazing product!

I ran in an issue that I believe is a bug: I am unable to relate a Contact Type of Person to a Contact Type of Company but it will not save and is giving me an error which I've inserted further below.

This occurred many times and I spent hours trying to figure it out but I decided to not make ANY configurational changes and right after install, I added the Contact. It doesn't matter how or in what order you add the relation type. The system will still give an error.

My installation is on a Godaddy cPanel with 3GBs RAM, using 5.5.41 MySQL Community Server (GPL).

Please keep in mind that I did not discover ERPAL until a couple days ago but I watched the videos and it's fairly simple to grasp the logic and flow but I do not do any coding or scripting.

I keep getting the error below:

Error
Error messagePDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_endpoints0.endpoints_r_index' in 'where clause': SELECT DISTINCT field_data_endpoints_delta_0.entity_type AS entity_type, field_data_endpoints_delta_0.entity_id AS entity_id, field_data_endpoints_delta_0.revision_id AS revision_id, field_data_endpoints_delta_0.bundle AS bundle FROM {field_data_endpoints} field_data_endpoints_delta_0 INNER JOIN {field_data_endpoints} field_data_endpoints_delta_1 ON field_data_endpoints_delta_1.entity_type = field_data_endpoints_delta_0.entity_type AND field_data_endpoints_delta_1.entity_id = field_data_endpoints_delta_0.entity_id INNER JOIN {relation} relation ON relation.rid = field_data_endpoints_delta_0.entity_id WHERE (field_data_endpoints_delta_0.endpoints_entity_type = :db_condition_placeholder_0) AND (field_data_endpoints_delta_0.endpoints_entity_id = :db_condition_placeholder_1) AND (field_data_endpoints_delta_0.delta = field_data_endpoints_delta_0.delta) AND (field_data_endpoints_delta_1.endpoints_entity_type = :db_condition_placeholder_2) AND (field_data_endpoints_delta_1.endpoints_entity_id = :db_condition_placeholder_3) AND (field_data_endpoints_delta_1.delta = field_data_endpoints_delta_1.delta) AND (field_data_endpoints_delta_0.deleted = :db_condition_placeholder_4) AND (relation.relation_type = :db_condition_placeholder_5) AND (relation.arity = :db_condition_placeholder_6) AND (field_data_endpoints_delta_0.entity_type = :db_condition_placeholder_7) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints2.endpoints_r_index) ; Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => 11 [:db_condition_placeholder_2] => node [:db_condition_placeholder_3] => 10 [:db_condition_placeholder_4] => 0 [:db_condition_placeholder_5] => works_at [:db_condition_placeholder_6] => 2 [:db_condition_placeholder_7] => relation ) in field_sql_storage_field_storage_query() (line 632 of /home/onli/public_html/solengize.net/erpal/modules/field/modules/field_sql_storage/field_sql_storage.module).
The website encountered an unexpected error. Please try again later.
powered by Drupal
supported and maintained by Bright Solutions GmbH