Error on Contacts, trying to creat relationship to custom module

[tuitai]

Hello,
I have a new Hosted CRM running. Doing some custom work in studio and module builder. I have one custom module that I want to have a relationship (1 to 1) with the OOB Contacts.

I tried it and now I get an error on Contacts detail page. Even if I go back and delete the relationship, I still get MySQL errors on the Contact detail page.

If anyone from SugarCRM team can assist, I would appreciate it.
Thanks,
-T

Error message:

Error running count query for Contact List: Query Failed SELECT count(*) c FROM ttcp_contact_feedback_form LEFT JOIN users jt0 ON jt0.id= ttcp_contact_feedback_form.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= ttcp_contact_feedback_form.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN teams jt2 ON jt2.id= ttcp_contact_feedback_form.team_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN users jt3 ON jt3.id= ttcp_contact_feedback_form.assigned_user_id AND jt3.deleted=0 AND jt3.deleted=0 LEFT JOIN users jt4 ON jt4.id= ttcp_contact_feedback_form.modified_user_id AND jt4.deleted=0 AND jt4.deleted=0 INNER JOIN ttcp_contacorm_contacts ON (ttcp_contact_feedback_form.id=ttcp_contacorm_cont acts.ttcp_contact_feedback_form_ida AND ttcp_contacorm_contacts.contacts_idb= '93f62eb2-495c-9e12-27a8-48af41a01561') where ( ttcp_contacorm_contacts.deleted=0 AND ttcp_contact_feedback_form.deleted=0) AND ttcp_contact_feedback_form.deleted=0 )::MySQL error 1146: Table 'tuitai2.ttcp_contact_feedback_form' doesn't exist

[andopes]

Hi tuitai

It seems the table ttcp_contact_feedback_form had not been created.

Try to run the Quick Repair and Rebuild and make sure you will be prompt to exec some database modification "CREATE TABLE .....".

Cheers

[tuitai]

Hi Andre,
Thanks for the help. I ran the quick repair and it prompted to execute create table. After hitting execute, I get this error

Executing repair query: Query Failed:CREATE TABLE ttcp_contact_feedback_form (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,team_id char(36) NULL ,assigned_user_id char(36) NULL ,ttcp_contact_feedback_form_number int(11) NOT NULL auto_increment,type varchar(255) NULL ,status varchar(25) NULL ,priority varchar(25) NULL ,resolution varchar(255) NULL ,system_id int NULL ,work_log text NULL ,q1_promises float(18,) DEFAULT '10' NULL ,q2_staff float(18,) DEFAULT '10' NULL ,q3_cabin float(18,) DEFAULT '10' NULL ,q4_meals float(18,) DEFAULT '10' NULL ,q5_diving float(18,) DEFAULT '10' NULL ,q6_safe float(18,) DEFAULT '10' NULL ,q7_recommend varchar(100) DEFAULT 'Yes' NULL ,q8_favorite_activities varchar(250) NULL , PRIMARY KEY (id), UNIQUE ttcp_contact_feedback_formnumk (ttcp_contact_feedback_form_number)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 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 ') DEFAULT '10' NULL ,q2_staff float(18,) DEFAULT '10' NULL ,q3_cabin float(18,' at line 1

[andopes]

Hi Tuitai

The problem is the fields:
q1_promises float( 18, ) DEFAULT '10' NULL ,
q2_staff float( 18, ) DEFAULT '10' NULL ,
q3_cabin float( 18, ) DEFAULT '10' NULL ,
q4_meals float( 18, ) DEFAULT '10' NULL ,
q5_diving float( 18, ) DEFAULT '10' NULL ,
q6_safe float( 18, ) DEFAULT '10' NULL ,

All are float type fields and they have an issue in the 'len' attribute in the vardefs.

This is an example of the correct definition of a float type field:

   'subtotal' => 
  array (
    'name' => 'subtotal',
    'vname' => 'LBL_SUBTOTAL',
    'dbType' => 'decimal',
    'type' => 'currency',
    'len' => '26,6',
  ), 
  

Edit the vardefs of the modules and set the second value of the 'len' attribute.

Cheers