Hi all!
Can anybody help me with the trouble:
I was make two modules in module builder and install them with module loader.
Installation process was finished successfully without any warnings.
When i trying to use it the first module works correctly, but when i try to create a new object in second module that error returns:Database failure. Please refer to suitecrm.log for details.
Sutecrm.log contains:
Mon Oct 14 11:13:47 2019 [7844][1][FATAL] Mysqli_query failed.
Mon Oct 14 11:13:47 2019 [7844][1][FATAL] Query Failed: SELECT units_uni_comp.id , units_uni_comp.assigned_user_id , units_uni_comp.name , units_uni_comp.billing_address_city , units_uni_comp.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, units_uni_comp.created_by FROM units_uni_comp LEFT JOIN users jt0 ON units_uni_comp.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 where units_uni_comp.deleted=0 ORDER BY units_uni_comp.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘suitecrm.units_uni_comp’ doesn’t exist
Mon Oct 14 11:13:57 2019 [6531][1][FATAL] Mysqli_query failed.
Mon Oct 14 11:13:57 2019 [6531][1][FATAL] Error inserting into table: units_uni_comp: Query Failed: INSERT INTO units_uni_comp (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,units_uni_comp_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 (‘ece70249-5ac5-9f48-0177-5da4585c51d6’,‘qqq’,‘2019-10-14 11:13:57’,‘2019-10-14 11:13:57’,‘1’,‘1’,’’,0,‘1’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,‘http://’,’’,’’,’’,’’,’’,’’,’’,’’): MySQL error 1146: Table ‘suitecrm.units_uni_comp’ doesn’t exist
Mon Oct 14 11:13:57 2019 [6531][1][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:400
Mon Oct 14 11:13:57 2019 [6531][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
In fact that table doesn’t exist in database. I was trying to record MariaDB query log and i can’t find query contains “create table…” when module installing.
What’s wrong?
My system:
Version 7.11.8 | Sugar Version 6.5.25 (Build 344)
Debian Linux 10
PHP 7.3.9-1
10.3.17-MariaDB-0+deb10u1
Thanks for your help.