by Sugar-project

SugarPrint enables printing to PDF / XLS export of any: List view, Detail view and Calendar view in SuiteCRM and SugarCRM Community Edition. SugarPrint makes exporting basic or advanced Search Results to PDF or Excel a one-click process.

Includes a 30 day guarantee
Try it Now

By clicking you consent to share your profile with the developer

#603 - Error to install on Sql server

Open Installation created by aruiz Verified Purchase 10 years ago

Hi, I have error when to install in SuiteCRM (Sugar CE) with sql server, SugarPrint works on Listview and Detailview but can't see how a module and when i try to make a repair have this query error:

/* INDEXES / / Table : sugarprint / /COLUMNS/ /MISMATCH WITH DATABASE - privatereport - ROW [name] => 'privatereport' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - privatereport - ROW[required] => '' [name] => 'privatereport' [vname] => 'LBL_PRIVATEREPORT' [type] => 'bit' [massupdate] => '0' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__priva__005FFE8A ALTER TABLE sugarprint ALTER COLUMN privatereport bit NULL ; ALTER TABLE sugarprint ADD DEFAULT '0' FOR privatereport ; /MISMATCH WITH DATABASE - print_logo - ROW [name] => 'print_logo' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - print_logo - ROW[required] => '' [name] => 'print_logo' [vname] => 'LBL_PRINT_LOGO' [type] => 'bit' [massupdate] => '0' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__print__015422C3 ALTER TABLE sugarprint ALTER COLUMN print_logo bit NULL ; ALTER TABLE sugarprint ADD DEFAULT '0' FOR print_logo ; /MISMATCH WITH DATABASE - sparkline - ROW [name] => 'sparkline' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - sparkline - ROW[required] => '' [name] => 'sparkline' [vname] => 'LBL_SPARKLINE' [type] => 'bit' [massupdate] => '0' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__spark__024846FC ALTER TABLE sugarprint ALTER COLUMN sparkline bit NULL ; ALTER TABLE sugarprint ADD DEFAULT '0' FOR sparkline ; / INDEXES */

Also I have problems to create reports or export to exel when Listview have many rows, is possible to accelerate the process?

Can help me please ?

Thanks

  1. marcomm member avatar

    Sugar-project Provider Affiliate

    10 years ago

    HI can you explain better? does the problem appear only when you try to repair o when you install sugarpirnt?

    It is a standard sugarcrm module with no relations to other.

    to increase speed to calculate report with many rows you can increase page size of listview in admin settings

    marco

  2. aruiz member avatar

    aruiz Verified Purchase

    10 years ago

    Hello, When I try install Sugarprint have this error on log:

    06/12/14 16:37:16 [5888][1][FATAL] Error altering column(s) privatereport on table: sugarprint: Query Failed: ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__priva__005FFE8A ALTER TABLE sugarprint ALTER COLUMN privatereport bit NULL ALTER TABLE sugarprint ADD DEFAULT '0' FOR privatereport ::: [Microsoft][SQL Server Native Client 11.0][SQL Server]'DF__sugarprin__priva__005FFE8A' no es una restricción. [Microsoft][SQL Server Native Client 11.0][SQL Server]No se puede quitar la restricción. Consulte los errores anteriores.

    SugarPrint works on Listview and Detailview but can't see how a module and when I try to make a repair have this query error:

    /* INDEXES / / Table : sugarprint / /COLUMNS/ /MISMATCH WITH DATABASE - privatereport - ROW [name] => 'privatereport' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - privatereport - ROW[required] => '' [name] => 'privatereport' [vname] => 'LBL_PRIVATEREPORT' [type] => 'bit' [massupdate] => '0' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__priva__005FFE8A ALTER TABLE sugarprint ALTER COLUMN privatereport bit NULL ; ALTER TABLE sugarprint ADD DEFAULT '0' FOR privatereport ; /MISMATCH WITH DATABASE - print_logo - ROW [name] => 'print_logo' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - print_logo - ROW[required] => '' [name] => 'print_logo' [vname] => 'LBL_PRINT_LOGO' [type] => 'bit' [massupdate] => '0' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__print__015422C3 ALTER TABLE sugarprint ALTER COLUMN print_logo bit NULL ; ALTER TABLE sugarprint ADD DEFAULT '0' FOR print_logo ; /MISMATCH WITH DATABASE - sparkline - ROW [name] => 'sparkline' [type] => 'bit' [len] => '1' [default] => '0' / / VARDEF - sparkline - ROW[required] => '' [name] => 'sparkline' [vname] => 'LBL_SPARKLINE' [type] => 'bit' [massupdate] => '0' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '255' [size] => '20' [dbType] => 'bool' / ALTER TABLE sugarprint DROP CONSTRAINT DF__sugarprin__spark__024846FC ALTER TABLE sugarprint ALTER COLUMN sparkline bit NULL ; ALTER TABLE sugarprint ADD DEFAULT '0' FOR sparkline ; / INDEXES */

    Thank you

  3. marcomm member avatar

    Sugar-project Provider Affiliate

    10 years ago

    Hi What is your sql server version? Can you read this post in SugarCRM forum? http://forums.sugarcrm.com/f3/drop-constraint-error-custom-module-checkbox-datatype-83009/ In SugarPrint there is one checke box "privatereport" if the link doesn't help you I can help you with a small modification in SugarPrint: no more checkboxes. tell me if you can solve with Sql server management Best marco

  4. aruiz member avatar

    aruiz Verified Purchase

    10 years ago

    Hi, version sql server 2008 R2 Please help me for no more checkboxes what I need to do in sql server management ? Thanks

  5. aruiz member avatar

    aruiz Verified Purchase

    10 years ago

    [redacted]

  6. marcomm member avatar

    Sugar-project Provider Affiliate

    10 years ago

    Hi we have deleted from web login data to your system. But I have these data in email. If you want to change passeword send me email (m.marletta @ datamain.it)

    For your problem i ve replaces chechbox but I 've no uploaded in you system. Please send me spanish translation or tell me if have backup of languages files And then I can upload this new version

    best marco

  7. aruiz member avatar

    aruiz Verified Purchase

    10 years ago

    Hi Marco We have backup of lenguages files You can proceed to upload thanks

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...