Module builder white screen after create record

[EcoHomes]

Hi,

I’m having some issues. I cannot create a record in a module I just created, I just get a white screen after entering the details and clicking save for the new record.

I think it may have to do with me deleting a package I created the wrong way. I created a package earlier and deleted it. In that module I was able to create a record without this white screen. Now whenever I create a new module I cannot create any records.

Here is what it says in the suitecrm.log:

Query Failed: SELECT test_test_suppliers.id , test_test_suppliers.assigned_user_id , test_test_suppliers.name , test_test_suppliers.billing_address_city , test_test_suppliers.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, test_test_suppliers.created_by FROM test_test_suppliers LEFT JOIN users jt0 ON test_test_suppliers.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where test_test_suppliers.deleted=0 ORDER BY test_test_suppliers.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘suitecrm.test_test_suppliers’ doesn’t exist
Mon Nov 13 15:34:59 2017 [2080][1][FATAL] Error inserting into table: test_test_suppliers: Query Failed: INSERT INTO test_test_suppliers (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,test_test_suppliers_type,industry,annual_revenue,phone_fax,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,rating,phone_office,phone_alternate,website,ownership,employees,ticker_symbol,shipping_address_street,shipping_address_city,shipping_address_state,shipping_address_postalcode,shipping_address_country)
VALUES (‘4d7ea71b-f13c-9d05-20e3-5a09bb5617aa’,‘TDP’,‘2017-11-13 15:34:59’,‘2017-11-13 15:34:59’,‘1’,‘1’,’’,0,‘1’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,‘http://’,’’,’’,’’,’’,’’,’’,’’,’’): MySQL error 1146: Table ‘suitecrm.test_test_suppliers’ doesn’t exist
Mon Nov 13 15:34:59 2017 [2080][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

[pgr]

Try a Quick Repair and Rebuild, and when it ends scroll down to the bottom to see if there is a button to “sync vardefs with database”.

If that doesn’t help, try looking for left-overs of your old module on the custom directory, and in the database.

Don’t forget to check the table fields_meta_data.

EDIT: here is a more complete explanation:

http://www.jsmackin.co.uk/suitecrm/suitecrm-missing-field-definitions/

[EcoHomes]

Thanks! That solved it. I did do that but I didn’t notice the execute button at the button, sorry I’m a bit new to SuiteCRM.

What happens if I create a module with the same name of a deleted module? I see in the MySQL database that the tables have not actually been deleted. Would that cause issues or would it just reuse that same table and reactivate it?

Thanks again!

[pgr]

I don’t know the answer, just make a good backup and try it