Need to set up a numbering system to track your records? Define and add a unique ID identifier field to any SugarCRM record. Many options to define any alphanumeric format you need. Start tracking your Quote, Cases, Accounts and any other module today..
#2021 - Can't create a sequence for Contact: Database error
I just installed CM & Sugar Sequencing Add-on
I get the error: 'Database failure. Please refer to suitecrm.log for details.'
SUITECRM VERSION
Log file:
Your IP Address is 209.33.217.210
Thu Mar 17 15:53:52 2016 [13105][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:53:53 2016 [2749][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:05 2016 [13109][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:06 2016 [4876][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:17 2016 [15941][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:19 2016 [6148][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:22 2016 [4876][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:23 2016 [2748][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:31 2016 [6148][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:31 2016 [6148][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:31 2016 [6148][1][FATAL] Query Failed: SELECT sequences.id , sequences.name , sequences.type , sequences.parent_type , sequences.code_field , sequences.date_entered , sequences.assigned_user_id FROM sequences where ((sequences.parent_type in ('Contacts'))) AND sequences.deleted=0 ORDER BY sequences.date_entered DESC LIMIT 0,41: MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:31 2016 [6148][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:33 2016 [13107][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:44 2016 [6148][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:44 2016 [6148][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:44 2016 [6148][1][FATAL] Query Failed: SELECT sequences.id , sequences.name , sequences.type , sequences.parent_type , sequences.code_field , sequences.date_entered , sequences.assigned_user_id FROM sequences where sequences.deleted=0 ORDER BY sequences.date_entered DESC LIMIT 0,41: MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:44 2016 [6148][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:46 2016 [13109][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:50 2016 [13105][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:50 2016 [13105][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:50 2016 [13105][1][FATAL] Query Failed: SELECT sequences.id , sequences.name , sequences.type , sequences.parent_type , sequences.code_field , sequences.date_entered , sequences.assigned_user_id FROM sequences where sequences.deleted=0 ORDER BY sequences.date_entered DESC LIMIT 0,41: MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:50 2016 [13105][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:52 2016 [15941][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:52 2016 [13109][1][FATAL] error with select of stored informations for build the DRAW Query Failed: SELECT code_prefix, code_suffix, code_seperator, sequence_add_date,
sequence_date_format, zero_padding, next_num, first_num, sequence_ordering
FROM sequences
WHERE id = '': MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:54:53 2016 [13109][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:54:54 2016 [4876][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:55:01 2016 [2749][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:56:48 2016 [2751][1][FATAL] Error inserting into table: sequences: Query Failed: INSERT INTO sequences (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,assigned_user_id,code_prefix,code_suffix,code_seperator,code_field,sequence_add_date,sequence_readonly,sequence_date_format,zero_padding,type,first_num,next_num,parent_type,sequence_ordering)
VALUES ('af201894-3249-89b8-8a99-56eb36bf80d5','Customer Number','2016-03-17 22:56:48','2016-03-17 22:56:48','1','1',0,'1','L','','','last_name',0,1,'',8,1,1,1,'Contacts','code_prefix|first_num|sequence_date_format|code_suffix'): MySQL error 1146: Table 'bitnami_suitecrm.sequences' doesn't exist
Thu Mar 17 15:56:58 2016 [15941][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:57:00 2016 [15941][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:57:04 2016 [13107][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:57:05 2016 [2749][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:57:07 2016 [2751][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 15:57:08 2016 [2752][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 16:00:53 2016 [13105][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
Thu Mar 17 16:00:55 2016 [13109][1][ERROR] Unable to load custom logic file: custom/include/social/hooks.php
8 years ago
8 years ago
8 years ago