Google Style SugarTheme

Striking Features. A Completely Rethought UI. Give your users a familiar user interface that makes them more efficient and effective with SugarCRM CE. Powerful features abound such as favorites, quick reminders, subpanels as tabs, and unlimited dashboards. On top of the click reducing interface, these feature make it a must-have tool for any organization looking to improve their bottom line.

Includes a 30 day guarantee

Try it Now

By clicking you consent to share your profile with the developer

#54 - Install and display issues with SugarCRM 6.5

Closed Bug? created by michaelalanstuart Verified Purchase 11 years ago

The favorites and reminders don't work

Looking at the SQL insert you can see why:

Query Failed:INSERT INTO trfavorites SET beanid=N'ba8cdcd2-2300-ba50-34ab-508fb30df72d', user_id='1', bean=N'Accounts', date_entered=curdate()::: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'SET'.

The Admin Skin configuration doesn't work examples: Error: Module TRHomePages does not exist. Notice: Undefined index: save in \crm\modules\TRThemeController\TRThemeConfig.php on line 4

The menu dropdown for last viewed and favorites doesn't work just doesn't show up

Other similar issues of invalid SQL statements and missing modules - this skin needs lots of work TBD

christianknoll Provider
11 years ago

apologies for the MSSQL related issues. I have sent you an updated package the fixes those issues mentioned via email. Please provide feedback if that fixes it. I was able to reporduce those issues on MSSQL as you mentioned but with the changes that has been fixed. I will also releaser that update then here at SugarOutfitters.

reply
michaelalanstuart Verified Purchase
11 years ago
we are still getting many errors with new module and the extended features do not work. after we Loaded we still see the following errors...

Notice: Use of undefined constant URL - assumed 'URL' in E:\WEBSITES\crm\modules\TRThemeController\TRSideBarWidgets\TRSideBarWidgetShortcuts.php on line 30

Notice: Use of undefined constant URL - assumed 'URL' in E:\WEBSITES\crm\modules\TRThemeController\TRSideBarWidgets\TRSideBarWidgetShortcuts.php on line 30

Notice: Use of undefined constant URL - assumed 'URL' in E:\WEBSITES\crm\modules\TRThemeController\TRSideBarWidgets\TRSideBarWidgetShortcuts.php on line 30

Notice: Undefined variable: jsIncludes in E:\WEBSITES\crm\modules\TRThemeController\TRThemeSideBarManager.php on line 32

On every page

Notice: Use of undefined constant URL - assumed 'URL' in E:\WEBSITES\crm\modules\TRThemeController\TRSideBarWidgets\TRSideBarWidgetShortcuts.pp on line 30
```
Notice: Use of undefined constant URL - assumed &#039;URL&#039; in E:\WEBSITES\crm\modules\TRThemeController\TRSideBarWidgets\TRSideBarWidgetShortcuts.php on line 30

Notice: Use of undefined constant URL - assumed &#039;URL&#039; in E:\WEBSITES\crm\modules\TRThemeController\TRSideBarWidgets\TRSideBarWidgetShortcuts.php on line 30

Notice: Undefined variable: jsIncludes in E:\WEBSITES\crm\modules\TRThemeController\TRThemeSideBarManager.php on line 32
```
Error on rebuild….

/* Table : dash_dashboardbackups / /COLUMNS/ /MISMATCH WITH DATABASE - user_default - ROW [name] => 'user_default' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - user_default - ROW[required] => '' [name] => 'user_default' [vname] => 'LBL_USER_DEFAULT' [type] => 'bit' [massupdate] => '0' [default] => '0' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [calculated] => '' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE dash_dashboardbackups DROP CONSTRAINT DF__dash_dash__user___76EBA2E9 ALTER TABLE dash_dashboardbackups ALTER COLUMN user_default bit NULL ; ALTER TABLE dash_dashboardbackups ADD DEFAULT '0' FOR user_default ; / INDEXES / / Table : trfavorites / /COLUMNS/ / INDEXES / /INDEX MISMATCH WITH DATABASE - tfr_idx - ROW tfr_idx index [0] => 'beanid' [1] => 'user_id' / / VARDEF - tfr_idx - ROW tfr_idx unique [0] => 'beanid' [1] => 'user_id' */ ALTER TABLE trfavorites DROP CONSTRAINT tfr_idx;; ALTER TABLE trfavorites ADD CONSTRAINT tfr_idx UNIQUE (beanid,user_id);;

/* Table : trreminders / /COLUMNS/ / INDEXES / /INDEX MISMATCH WITH DATABASE - tsr_idx - ROW tsr_idx index [0] => 'user_id' [1] => 'bean_id' / / VARDEF - tsr_idx - ROW tsr_idx unique [0] => 'user_id' [1] => 'bean_id' */ ALTER TABLE trreminders DROP CONSTRAINT tsr_idx;; ALTER TABLE trreminders ADD CONSTRAINT tsr_idx UNIQUE (user_id,bean_id);;

mike To: mstuart@providerpower.com Subject: AW: Installing Sugar Theme

P
reply
christianknoll Provider
11 years ago

Mike,

(1) the first thing are notices and not errors. YOu can disregard that. If you see them on the page you should turn off error display in yopur php ini. (2) dash_dashboardbackups is another module (3) if you repair the indexes is this not working? I cannot get these messages on the instance I have running with MSSQL 2012. What versaion of MSSQL do you have (4) Which extended features are not working?

christian

reply
christianknoll Provider
11 years ago

as per your feedback after applying the latest version and setting erro display properly everything works properly now. Closing the Support Case

reply