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

#603 - Error to install on Sql server

Open Installation created by aruiz Verified Purchase 5 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

    5 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

    5 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

    5 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

    5 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

    5 years ago

    [redacted]

  6. marcomm member avatar

    Sugar-project Provider Affiliate

    5 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

    5 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...

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.