by christianknoll

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

  1. christianknoll member avatar

    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.

  2. providerpower member avatar

    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 '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
    

    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

  3. christianknoll member avatar

    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

  4. christianknoll member avatar

    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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Dors this theme support drag and drop on iPad/safari ? If yes I will purchase it." - chradja

    Read More Reviews