#603 - Error to install on Sql server
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
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
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
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
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
10 years ago
[redacted]
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
10 years ago
Hi Marco We have backup of lenguages files You can proceed to upload thanks