starred/SuiteCRM-SuiteCRM

mirror of https://github.com/SuiteCRM/SuiteCRM.git synced 2026-03-02 19:16:58 -05:00

[7.1beta2] Contact table not created properly on install #12

New issue

Closed

opened 2026-02-20 14:13:49 -05:00 by deekerman · 1 comment

deekerman commented

2026-02-20 14:13:49 -05:00

Owner

Originally created by @gunnicom on GitHub (Mar 24, 2014).

After install, database table for contacts was not created correct. Creating a contact resulted in an error. Quick repair does repair it:

/* Table : cases /
/COLUMNS/
/MISSING IN DATABASE - state - ROW/
/ INDEXES /
ALTER TABLE cases add COLUMN state varchar(100) DEFAULT 'Open' NULL ;
/ Table : contacts /
/COLUMNS/
/MISSING IN DATABASE - joomla_account_id - ROW/
/MISSING IN DATABASE - portal_account_disabled - ROW/
/MISSING IN DATABASE - portal_user_type - ROW/
/ INDEXES */
ALTER TABLE contacts add COLUMN joomla_account_id varchar(255) NULL , add COLUMN portal_account_disabled bool DEFAULT '0' NULL , add COLUMN portal_user_type varchar(100) DEFAULT 'Single' NULL ;

Originally created by @gunnicom on GitHub (Mar 24, 2014). After install, database table for contacts was not created correct. Creating a contact resulted in an error. Quick repair does repair it: /\* Table : cases _/ /_COLUMNS_/ /_MISSING IN DATABASE - state - ROW_/ /_ INDEXES _/ ALTER TABLE cases add COLUMN state varchar(100) DEFAULT 'Open' NULL ; /_ Table : contacts _/ /_COLUMNS_/ /_MISSING IN DATABASE - joomla_account_id - ROW_/ /_MISSING IN DATABASE - portal_account_disabled - ROW_/ /_MISSING IN DATABASE - portal_user_type - ROW_/ /_ INDEXES */ ALTER TABLE contacts add COLUMN joomla_account_id varchar(255) NULL , add COLUMN portal_account_disabled bool DEFAULT '0' NULL , add COLUMN portal_user_type varchar(100) DEFAULT 'Single' NULL ;

deekerman closed this issue

2026-02-20 14:13:49 -05:00

deekerman commented

2026-02-20 14:13:51 -05:00

Author

Owner

@mattlorimer commented on GitHub (Jul 7, 2014):

Fixed

@mattlorimer commented on GitHub (Jul 7, 2014): Fixed

deekerman referenced this issue

2026-02-20 16:03:32 -05:00

MySQL error 1054: Unknown column 'date_start' in 'order clause' #3299

deekerman referenced this issue

2026-02-20 16:03:32 -05:00

MySQL error 1054: Unknown column 'date_start' in 'order clause' #3299

deekerman referenced this issue

2026-02-20 16:04:03 -05:00

Database Failure when creating a Meeting #3337

deekerman referenced this issue

2026-02-20 16:04:20 -05:00

Accounts view broken on 7.10.9 #3358

deekerman referenced this issue

2026-02-20 16:04:47 -05:00

Lead detail view fails when has scheduled call #3391

deekerman referenced this issue

2026-02-20 16:10:06 -05:00

DB error in Activities subpannel #3805

deekerman referenced this issue

2026-02-20 16:28:29 -05:00

500 error when saving record when audit enabled on numeric field #5038

Sign in to join this conversation.

No labels

Area: Campaigns

Area: Clean Up: Performance

Area: Databases

Area: Developer Tools

Area: Elasticsearch

Area: Elasticsearch

Area: Emails:Campaigns

Area: Emails:Cases

Area: Emails:Compose

Area: Emails:Config

Area: Emails:Templates

Area: Environment

Area: Installation

Area: Upgrading

Area:Activity Stream

Good First Issue

PR:Community Contribution

PR:Type:Enhancement

Priority:Critical

Priority:Important

Priority:Moderate

Severity: Major

Severity: Minor

Severity: Moderate

Status: Requires Code Review

Status: Requires Updates

Status: Team Investigating

Status:Assessed

Status:Fix Proposed

Status:Needs Assessed

Status:Requires Automated Tests

Type:Deprecated

Type:Discussion

Type:Suggestion

Type:Suggestion

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/SuiteCRM-SuiteCRM#12

No description provided.