SugarPrint

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

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

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

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

[redacted]

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

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