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
Hi there! I'm hopping in here quick until CM & Sugar can follow up. It's a simple fix for this. Go to Admin and then Repair. Then select Quick Repair & Rebuild. When the page finishes loading go to the bottom and click on "Execute SQL". This should create the missing table.
Hope this helps! Jason Eggers SugarOutfitters
8 years ago
Hello,
first: thanks to Jason for answering in time. As he mentioned already, the sequences table is missing. Once you did Jason's steps, it should work fine. Please let me know, if your issue got fixed.
However, I am surprised, you got that error. If possible, please let me know, how your installed that plug-in. Actually there should be an auto creation of any new installed plug-in.
Thanks, Roger
8 years ago
I assume, everything worked well. Thus I will close that ticket.