Problem in Module Builder!

Hi,

I have just discovered an issue with the Module Builder function.

VERSION INFO:
Version 7.8.3
Sugar Version 6.5.24 (Build 509)

Here it is step by step what I have done:

  1. start Module Builder -> Cretae new package, add name: KEF_package and the key:kef -> click on save

  2. click on New Module -> choose type: SALE, add package module name: KEF_palyazatok, add Label: KEF Pályázatok -> click on save

  3. go back to KEF_package main screen and click on DEPLOY

  4. go to ADMIN - > Configure Module Menu Filters and click on ADD FILTER -> add a new menu and then drag and drop the new package into the new menu, so it appears on the top menu list

  5. click on the new menu item on the top menu list, so the new module start screen appears with an empty list of table

  6. click on CREATE and fill in the required fields with some test data -> click on save
    1st ERROR I got a blank white screen here without any error message…

  7. go to ADMIN -> REPAIR, then click on Quick Repair and Rebuild

2nd ERROR appears in the list below:
/* Table : kef_kef_palyazatok /
/
MISSING TABLE: kef_kef_palyazatok */
CREATE TABLE kef_kef_palyazatok (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 ,assigned_user_id char(36) NULL ,kef_kef_palyazatok_type varchar(100) NULL ,lead_source varchar(50) NULL ,amount double NULL ,amount_usdollar double NULL ,currency_id char(36) NULL ,date_closed date NULL ,next_step varchar(100) NULL ,sales_stage varchar(100) NULL ,probability double NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;

  1. click on EXECUTE, then a message comes up: “Database tables are synced with vardefs”
  2. click on the new menu item on the top menu list, so the new module start screen appears with an empty list of table
  3. click on CREATE and fill in the required fields with some test data -> click on save
  4. the new page comes in where the newly added item is shown
  5. click on list view on the left side menu
    3rd ERROR nothing appears in the menu, the newly added item is missing! However it still can be seen from the left side nemu under “Recently Viewed”

Can you help?

I would focus on your step 6 which is where the process failed for the first time.

If you got a white screen you probably had a PHP fatal error.

Can you find anything in your logs at that exact time? That would be helpful. Thanks.

here is the log from today:

Wed May 31 00:00:01 2017 [7904][1][FATAL] Query Failed: SELECT b.id FROM kef_kef_module b LEFT JOIN aod_indexevent ie ON (ie.record_id = b.id AND ie.record_module = ‘kef_KEF_module’) WHERE b.deleted = 0 AND (ie.id IS NULL OR ie.date_modified < b.date_modified) ORDER BY b.date_modified ASC LIMIT 0,500: MySQL error 1267: Illegal mix of collations (utf8_hungarian_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
Wed May 31 09:06:13 2017 [10827][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Query Failed: SELECT kef_kef_palyazatok.id , kef_kef_palyazatok.assigned_user_id , kef_kef_palyazatok.name , kef_kef_palyazatok.sales_stage , kef_kef_palyazatok.amount_usdollar , kef_kef_palyazatok.currency_id , kef_kef_palyazatok.date_closed , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, kef_kef_palyazatok.amount , kef_kef_palyazatok.created_by FROM kef_kef_palyazatok LEFT JOIN users jt0 ON kef_kef_palyazatok.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where kef_kef_palyazatok.deleted=0 ORDER BY kef_kef_palyazatok.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:11:16 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘336d0b62-4dd0-8b07-c4e1-592e6c7eb05d’,‘test’,‘2017-05-31 07:11:15’,‘2017-05-31 07:11:15’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-05-31’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:11:16 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:11:22 2017 [10820][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘3da3f342-a4fb-b44a-ec83-592e6ce7eec8’,‘test’,‘2017-05-31 07:11:22’,‘2017-05-31 07:11:22’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-05-31’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:11:22 2017 [10820][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:11:24 2017 [11638][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘bf5dac3a-e19b-b1f0-0988-592e6cf7a3de’,‘test’,‘2017-05-31 07:11:24’,‘2017-05-31 07:11:24’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-05-31’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:11:24 2017 [11638][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:11:27 2017 [10825][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘4f1fd831-fee0-a562-cb42-592e6cd239dd’,‘test’,‘2017-05-31 07:11:27’,‘2017-05-31 07:11:27’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-05-31’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:11:27 2017 [10825][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:11:31 2017 [10829][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘413f63f3-e596-4ad2-4e71-592e6ce09747’,‘test’,‘2017-05-31 07:11:31’,‘2017-05-31 07:11:31’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-05-31’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:11:31 2017 [10829][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:12:26 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘dc7ca505-e7a0-9200-96e2-592e6ca1a60b’,‘test’,‘2017-05-31 07:12:26’,‘2017-05-31 07:12:26’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-06-15’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:12:26 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:12:29 2017 [10820][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Error inserting into table: kef_kef_palyazatok: Query Failed: INSERT INTO kef_kef_palyazatok (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,kef_kef_palyazatok_type,lead_source,amount,amount_usdollar,currency_id,date_closed,next_step,sales_stage,probability)
VALUES (‘7162c405-711b-5380-e837-592e6c00b458’,‘test’,‘2017-05-31 07:12:29’,‘2017-05-31 07:12:29’,‘b2d4f42c-5480-1759-1162-592569a5d782’,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,0,‘b2d4f42c-5480-1759-1162-592569a5d782’,’’,’’,234234,234234,’-99’,‘2017-06-15’,’’,‘Prospecting’,0): MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:12:29 2017 [10820][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Wed May 31 09:12:36 2017 [10825][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Query Failed: SELECT kef_kef_palyazatok.id , kef_kef_palyazatok.assigned_user_id , kef_kef_palyazatok.name , kef_kef_palyazatok.sales_stage , kef_kef_palyazatok.amount_usdollar , kef_kef_palyazatok.currency_id , kef_kef_palyazatok.date_closed , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, kef_kef_palyazatok.amount , kef_kef_palyazatok.created_by FROM kef_kef_palyazatok LEFT JOIN users jt0 ON kef_kef_palyazatok.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where kef_kef_palyazatok.deleted=0 ORDER BY kef_kef_palyazatok.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘suitecrm.kef_kef_palyazatok’ doesn’t exist
Wed May 31 09:13:45 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteR/modules is not a file or a dir.
Wed May 31 09:13:45 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] ERROR: rmdir_recursive(): argument cache/themes/Suite7/modules is not a file or a dir.
Wed May 31 09:15:37 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Query Failed: SELECT kef_kef_palyazatok.id , kef_kef_palyazatok.assigned_user_id , kef_kef_palyazatok.name , kef_kef_palyazatok.sales_stage , kef_kef_palyazatok.amount_usdollar , kef_kef_palyazatok.currency_id , kef_kef_palyazatok.date_closed , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, kef_kef_palyazatok.amount , kef_kef_palyazatok.created_by FROM kef_kef_palyazatok LEFT JOIN users jt0 ON kef_kef_palyazatok.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where kef_kef_palyazatok.deleted=0 ORDER BY kef_kef_palyazatok.date_entered DESC LIMIT 0,21: MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_hungarian_ci,IMPLICIT) for operation ‘=’
Wed May 31 09:16:52 2017 [11262][b2d4f42c-5480-1759-1162-592569a5d782][FATAL] Query Failed: SELECT kef_kef_palyazatok.id , kef_kef_palyazatok.assigned_user_id , kef_kef_palyazatok.name , kef_kef_palyazatok.sales_stage , kef_kef_palyazatok.amount_usdollar , kef_kef_palyazatok.currency_id , kef_kef_palyazatok.date_closed , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, kef_kef_palyazatok.amount , kef_kef_palyazatok.created_by FROM kef_kef_palyazatok LEFT JOIN users jt0 ON kef_kef_palyazatok.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where kef_kef_palyazatok.deleted=0 ORDER BY kef_kef_palyazatok.date_entered DESC LIMIT 0,21: MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_hungarian_ci,IMPLICIT) for operation ‘=’

php_errors.log:

[31-May-2017 08:56:16 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:56:17 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:56:17 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:56:17 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:56:17 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:56:17 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:56:45 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:56:45 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:56:45 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:56:46 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:56:46 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:56:46 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:57:00 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:57:00 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:57:00 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:57:02 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:57:02 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:57:02 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:57:36 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 08:57:36 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 08:58:38 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:58:39 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:58:39 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 08:58:39 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 08:58:39 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 08:58:39 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:02:14 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:02:14 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:02:33 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:02:33 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:03:05 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:03:05 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:03:06 Europe/Berlin] PHP Warning: Declaration of ListViewPackages::setup($data, $file, $where, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’) should be compatible with ListViewDisplay::setup($seed, $file, $where, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’, $id = NULL) in /var/www/html/ModuleInstall/PackageManager/ListViewPackages.php on line 42
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined index: inline_edit in /var/www/html/modules/ModuleBuilder/MB/MBModule.php on line 461
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined index: LBL_SEARCH in /var/www/html/modules/ModuleBuilder/MB/MBLanguage.php on line 184
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:03:06 Europe/Berlin] PHP Notice: Undefined variable: md5_string in /var/www/html/ModuleInstall/ModuleScanner.php on line 665
[31-May-2017 09:05:12 Europe/Berlin] PHP Notice: Undefined index: LBL_REBUILD_JAVASCRIPT_LANG_DESC in /var/www/html/modules/Administration/RebuildJSLang.php on line 44
[31-May-2017 09:12:31 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:12:31 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:12:31 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:12:32 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:12:32 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:12:32 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:21:46 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:21:46 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:21:46 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:21:47 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:21:47 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:21:47 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:22:15 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:22:15 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:22:15 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:22:15 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:22:15 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:22:15 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:22:23 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:22:23 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:22:23 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:22:24 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:22:24 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:22:24 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:22:50 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:22:50 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:22:50 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:22:51 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:22:51 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:22:51 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:23:51 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:23:51 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:23:51 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 09:23:52 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 09:23:52 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 09:23:52 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 10:05:21 Europe/Berlin] PHP Warning: Declaration of MyCallsDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Calls/Dashlets/MyCallsDashlet/MyCallsDashlet.php on line 47
[31-May-2017 10:05:21 Europe/Berlin] PHP Warning: Declaration of MyMeetingsDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Meetings/Dashlets/MyMeetingsDashlet/MyMeetingsDashlet.php on line 0
[31-May-2017 10:05:21 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 0
[31-May-2017 10:05:21 Europe/Berlin] PHP Warning: Declaration of MyAccountsDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Accounts/Dashlets/MyAccountsDashlet/MyAccountsDashlet.php on line 0
[31-May-2017 10:05:21 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 10:05:22 Europe/Berlin] PHP Warning: Declaration of MyCallsDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Calls/Dashlets/MyCallsDashlet/MyCallsDashlet.php on line 47
[31-May-2017 10:05:22 Europe/Berlin] PHP Warning: Declaration of MyMeetingsDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Meetings/Dashlets/MyMeetingsDashlet/MyMeetingsDashlet.php on line 0
[31-May-2017 10:05:22 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 0
[31-May-2017 10:05:22 Europe/Berlin] PHP Warning: Declaration of MyAccountsDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Accounts/Dashlets/MyAccountsDashlet/MyAccountsDashlet.php on line 0
[31-May-2017 10:05:22 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 10:12:51 Europe/Berlin] PHP Warning: Declaration of PopupSmarty::setup($seed, $file = NULL, $where = NULL, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’) should be compatible with ListViewDisplay::setup($seed, $file, $where, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’, $id = NULL) in /var/www/html/include/Popups/PopupSmarty.php on line 46
[31-May-2017 10:54:36 Europe/Berlin] PHP Warning: Declaration of PopupSmarty::setup($seed, $file = NULL, $where = NULL, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’) should be compatible with ListViewDisplay::setup($seed, $file, $where, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’, $id = NULL) in /var/www/html/include/Popups/PopupSmarty.php on line 46
[31-May-2017 11:06:10 Europe/Berlin] PHP Warning: Declaration of PopupSmarty::setup($seed, $file = NULL, $where = NULL, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’) should be compatible with ListViewDisplay::setup($seed, $file, $where, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’, $id = NULL) in /var/www/html/include/Popups/PopupSmarty.php on line 46
[31-May-2017 13:35:22 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 13:35:22 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 13:35:22 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 13:35:23 Europe/Berlin] PHP Warning: Declaration of MyOpportunitiesDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 48
[31-May-2017 13:35:23 Europe/Berlin] PHP Warning: Creating default object from empty value in /var/www/html/modules/Calendar/Dashlets/CalendarDashlet/CalendarDashlet.php on line 66
[31-May-2017 13:35:23 Europe/Berlin] PHP Warning: Declaration of SugarFeedDashlet::process($lvsParams = Array) should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /var/www/html/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 0
[31-May-2017 13:55:29 Europe/Berlin] PHP Warning: Declaration of PopupSmarty::setup($seed, $file = NULL, $where = NULL, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’) should be compatible with ListViewDisplay::setup($seed, $file, $where, $params = Array, $offset = 0, $limit = -1, $filter_fields = Array, $id_field = ‘id’, $id = NULL) in /var/www/html/include/Popups/PopupSmarty.php on line 46

I think the key problem is this

MySQL error 1267: Illegal mix of collations 

It is solved with MySQL configurations, you can Google it and you will find several things explaining how.

It is a problem in relation to language encodings (in the database, not in SuiteCRM), and you solve it by altering a property of the affected table.

See the last post in this thread for an example:
https://suitecrm.com/forum/suitecrm-7-0-discussion/13045-can-t-login-to-gui-of-suitecrm-7-7-after-adding-custom-field-to-users-module-in-studio

… but you might have to apply it to a different table, in your case.

It can case problem in other places also, not just

We have changed the language settings in all of the tables and now it seems to be OK, but then another issue comes up:

  1. I would like to add documents for this new module so I go ADMIN -> STUDIO, choose the new module from the tree menu
  2. click on Relationship -> ADD RELATIONSHIP
  3. Choose documents, everything is on default click on SAVE & DEPLOY
  4. go to top menu, click on this new function to start it.
  5. now we can see the list of items previously added and click on one of them

ERROR: isted of having the detail view of the item, we got a popup message in a separate window wher the header writes: “An error has occured” and there are some details of the item but it looks like a badly loaded page… the same looks with different borowser

the bottom of this new windows says:
“If this error persists, please have your administrator disable Ajax for this module”

Any idea? The aim is to create a new module where I can add files to items and activities to items, that is all I need.
By the way if I add activities to the module that is working fine!

Thanks

Hi again

you have to check your logs to see what the error was exactly.

I fear there might be some problems with your installation, resulting from previous errors in MySQL. We don’t know which queries failed during setup, during Quick Repair and Rebuilds, etc…

If you don’t have any data yet, I would seriously consider restarting with a fresh install, if I were you…

I’ve found enabling display_errors in your php.ini is quite useful to see what the exact error is and where it’s occurring.

display_errors = On

Yes, it can be practical, but not everything will show there. Those are non-fatal PHP errors that are thrown onto the screen, but there are others, and then there is all the SuiteCRM logging in suitecrm.log.