Results 1 to 2 of 2

Thread: Help! Problem with Repair Database

  1. 2009-09-23, 06:31 PM #1
    jivko81
    jivko81 is offline Junior Member
    Join Date
    Sep 2009
    Posts
    1

    Default Help! Problem with Repair Database

    Hello,
    i have some problem with Sugar.
    When i start Repair Database the error appears:L
    /* Table : contracts */
    /*COLUMNS*/
    /* INDEXES */
    /*MISSING INDEX IN DATABASE - idx_CONTRACT_name -index ROW */
    ALTER TABLE contracts ADD INDEX idx_CONTRACT_name (name);
    /* Table : quotes */
    /*COLUMNS*/
    /* INDEXES */
    /*MISSING INDEX IN DATABASE - idx_QUOTE_name -index ROW */
    ALTER TABLE quotes ADD INDEX idx_QUOTE_name (name);
    /* Table : oqc_externalcontract */
    /*COLUMNS*/
    /*MISMATCH WITH DATABASE - finalcosts - ROW [name] => 'finalcosts' [type] => 'decimal' [len] => '26,6' */
    /* VARDEF - finalcosts - ROW[required] => '' [name] => 'finalcosts' [vname] => 'LBL_FINALCOSTS' [type] => 'decimal' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '255' [dbType] => 'currency' */
    /*MISMATCH WITH DATABASE - currency_id - ROW [name] => 'currency_id' [type] => 'char' [len] => '36' */
    /* VARDEF - currency_id - ROW[required] => '' [name] => 'currency_id' [vname] => 'LBL_CURRENCY' [type] => 'char' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [studio] => 'visible' [function] => 'Array' [dbType] => 'id' */
    /* INDEXES */
    ALTER TABLE oqc_externalcontract modify column finalcosts decimal(26,6) NULL , modify column currency_id char(36) NULL ;
    /* Table : oqc_externalcontractcosts */
    /*COLUMNS*/
    /*MISMATCH WITH DATABASE - price - ROW [name] => 'price' [type] => 'decimal' [len] => '26,6' */
    /* VARDEF - price - ROW[required] => '' [name] => 'price' [vname] => 'LBL_PRICE' [type] => 'decimal' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '255' [dbType] => 'currency' */
    /*MISMATCH WITH DATABASE - currency_id - ROW [name] => 'currency_id' [type] => 'char' [len] => '36' */
    /* VARDEF - currency_id - ROW[required] => '' [name] => 'currency_id' [vname] => 'LBL_CURRENCY' [type] => 'char' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [studio] => 'visible' [function] => 'Array' [dbType] => 'id' */
    /* INDEXES */
    ALTER TABLE oqc_externalcontractcosts modify column price decimal(26,6) NULL , modify column currency_id char(36) NULL ;
    /* Table : oqc_externalcontractdetailedcosts */
    /*COLUMNS*/
    /*MISMATCH WITH DATABASE - price - ROW [name] => 'price' [type] => 'decimal' [len] => '26,6' */
    /* VARDEF - price - ROW[required] => '' [name] => 'price' [vname] => 'LBL_PRICE' [type] => 'decimal' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '255' [dbType] => 'currency' */
    /*MISMATCH WITH DATABASE - currency_id - ROW [name] => 'currency_id' [type] => 'char' [len] => '36' */
    /* VARDEF - currency_id - ROW[required] => '' [name] => 'currency_id' [vname] => 'LBL_CURRENCY' [type] => 'char' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [studio] => 'visible' [function] => 'Array' [dbType] => 'id' */
    /* INDEXES */
    ALTER TABLE oqc_externalcontractdetailedcosts modify column price decimal(26,6) NULL , modify column currency_id char(36) NULL ;
    /* Table : oqc_externalcontractpositions */
    /*COLUMNS*/
    /*MISMATCH WITH DATABASE - price - ROW [name] => 'price' [type] => 'decimal' [len] => '26,6' */
    /* VARDEF - price - ROW[required] => '' [name] => 'price' [vname] => 'LBL_PRICE' [type] => 'decimal' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '255' [dbType] => 'currency' */
    /*MISMATCH WITH DATABASE - currency_id - ROW [name] => 'currency_id' [type] => 'char' [len] => '36' */
    /* VARDEF - currency_id - ROW[required] => '' [name] => 'currency_id' [vname] => 'LBL_CURRENCY' [type] => 'char' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [studio] => 'visible' [function] => 'Array' [dbType] => 'id' */
    /* INDEXES */
    ALTER TABLE oqc_externalcontractpositions modify column price decimal(26,6) NULL , modify column currency_id char(36) NULL ;


    Executing repair query: Query Failed:ALTER TABLE contracts ADD INDEX idx_CONTRACT_name (name)::MySQL error 1061: Duplicate key name 'idx_CONTRACT_name'

    Please help me!
    I attach export file.
    Reply With Quote Reply With Quote
  2. 2010-03-26, 01:33 PM #2
    iancomtek
    iancomtek is offline Member
    Join Date
    Oct 2009
    Posts
    5

    Default Re: Help! Problem with Repair Database

    I don't know if it helps but I'm getting similar problems:

    Code:
    /* Table : quotes */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - modified_user_id -  ROW [name] => 'modified_user_id'  [type] => 'varchar'  [len] => '36'  [required] => 'true'  */
/* VARDEF - modified_user_id -  ROW[name] => 'modified_user_id'  [rname] => 'user_name'  [id_name] => 'modified_user_id'  [vname] => 'LBL_MODIFIED'  [type] => 'varchar'  [table] => 'modified_user_id_users'  [isnull] => 'false'  [dbType] => 'varchar'  [len] => '36'  [reportable] => '1'  [comment] => 'User who last modified record'  */
/*MISMATCH WITH DATABASE - name -  ROW [name] => 'name'  [type] => 'varchar'  [len] => '255'  [required] => 'true'  */
/* VARDEF - name -  ROW[name] => 'name'  [vname] => 'LBL_NAME'  [type] => 'varchar'  [dbType] => 'varchar'  [len] => '255'  [audited] => '1'  [unified_search] => '1'  [comment] => 'The short description of the QUOTE'  [merge_filter] => 'selected'  */
/*MISMATCH WITH DATABASE - billing_account -  ROW [name] => 'billing_account'  [type] => 'varchar'  [len] => '50'  [required] => 'true'  */
/* VARDEF - billing_account -  ROW[name] => 'billing_account'  [vname] => 'LBL_BILLING_ACCOUNT'  [type] => 'varchar'  [len] => '50'  [audited] => ''  [options] => ''  [dbType] => 'varchar'  */
/*MISMATCH WITH DATABASE - expiration -  ROW [name] => 'expiration'  [type] => 'date'  [required] => 'true'  */
/* VARDEF - expiration -  ROW[name] => 'expiration'  [vname] => 'LBL_EXPIRATION'  [type] => 'date'  [audited] => ''  [massupdate] => '1'  [options] => ''  [dbType] => 'date'  [len] => ''  */
/*MISMATCH WITH DATABASE - stage -  ROW [name] => 'stage'  [type] => 'varchar'  [len] => '255'  [required] => 'true'  */
/* VARDEF - stage -  ROW[name] => 'stage'  [vname] => 'LBL_STAGE'  [type] => 'varchar'  [audited] => ''  [massupdate] => '1'  [options] => 'quote_stage_options'  [dbType] => 'enum'  [len] => '255'  */
/* INDEXES */
/*MISSING INDEX IN DATABASE - idx_QUOTE_name -index  ROW */
ALTER TABLE quotes   modify column modified_user_id varchar(36)  NULL ,  modify column name varchar(255)  NULL ,  modify column billing_account varchar(50)  NULL ,  modify column expiration date  NULL ,  modify column stage varchar(255)  NULL ,  ADD  INDEX idx_QUOTE_name (name);
/* Table : products_quotes */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - product_name -  ROW [name] => 'product_name'  [type] => 'varchar'  [len] => '50'  [required] => 'true'  */
/* VARDEF - product_name -  ROW[name] => 'product_name'  [vname] => ''  [type] => 'varchar'  [len] => '50'  [dbType] => 'varchar'  */
/*MISMATCH WITH DATABASE - product_qty -  ROW [name] => 'product_qty'  [type] => 'int'  [len] => '11'  [required] => 'true'  */
/* VARDEF - product_qty -  ROW[name] => 'product_qty'  [vname] => ''  [type] => 'int'  [dbType] => 'int'  [len] => '11'  */
/*MISSING IN DATABASE - product_cost_price -  ROW*/
/*MISMATCH WITH DATABASE - product_list_price -  ROW [name] => 'product_list_price'  [type] => 'decimal'  [len] => '8,2'  [required] => 'true'  */
/* VARDEF - product_list_price -  ROW[name] => 'product_list_price'  [vname] => ''  [dbType] => 'decimal'  [type] => 'decimal'  [len] => '16,2'  */
/*MISMATCH WITH DATABASE - product_unit_price -  ROW [name] => 'product_unit_price'  [type] => 'decimal'  [len] => '8,2'  [required] => 'true'  */
/* VARDEF - product_unit_price -  ROW[name] => 'product_unit_price'  [vname] => ''  [dbType] => 'decimal'  [type] => 'decimal'  [len] => '16,2'  */
/*MISMATCH WITH DATABASE - product_total_price -  ROW [name] => 'product_total_price'  [type] => 'decimal'  [len] => '16,2'  [required] => 'true'  */
/* VARDEF - product_total_price -  ROW[name] => 'product_total_price'  [vname] => ''  [dbType] => 'decimal'  [type] => 'decimal'  [len] => '16,2'  */
/* INDEXES */
ALTER TABLE products_quotes   modify column product_name varchar(50)  NULL ,  modify column product_qty int(11)  NULL ,  add column product_cost_price decimal(16,2)  NULL ,  modify column product_list_price decimal(16,2)  NULL ,  modify column product_unit_price decimal(16,2)  NULL ,  modify column product_total_price decimal(16,2)  NULL ;
/* Table : products */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - modified_user_id -  ROW [name] => 'modified_user_id'  [type] => 'varchar'  [len] => '36'  [required] => 'true'  */
/* VARDEF - modified_user_id -  ROW[name] => 'modified_user_id'  [rname] => 'user_name'  [id_name] => 'modified_user_id'  [vname] => 'LBL_MODIFIED'  [type] => 'varchar'  [table] => 'modified_user_id_users'  [isnull] => 'false'  [dbType] => 'varchar'  [len] => '36'  [reportable] => '1'  [massupdate] => ''  [comment] => 'User who last modified record'  */
/*MISMATCH WITH DATABASE - name -  ROW [name] => 'name'  [type] => 'varchar'  [len] => '255'  [required] => 'true'  */
/* VARDEF - name -  ROW[name] => 'name'  [vname] => 'LBL_NAME'  [type] => 'varchar'  [dbType] => 'varchar'  [len] => '255'  [audited] => '1'  [unified_search] => '1'  [comment] => 'The short description of the PRODUCT'  [merge_filter] => 'selected'  */
/*MISMATCH WITH DATABASE - cost -  ROW [name] => 'cost'  [type] => 'decimal'  [len] => '8,2'  [required] => 'true'  */
/* VARDEF - cost -  ROW[name] => 'cost'  [vname] => 'LBL_COST'  [dbType] => 'decimal'  [type] => 'decimal'  [len] => '16,2'  [audited] => ''  [options] => ''  */
/*MISMATCH WITH DATABASE - price -  ROW [name] => 'price'  [type] => 'decimal'  [len] => '8,2'  [required] => 'true'  */
/* VARDEF - price -  ROW[name] => 'price'  [vname] => 'LBL_PRICE'  [dbType] => 'decimal'  [type] => 'decimal'  [len] => '16,2'  [audited] => ''  [options] => ''  */
/* INDEXES */
/*MISSING INDEX IN DATABASE - idx_PRODUCT_name -index  ROW */
ALTER TABLE products   modify column modified_user_id varchar(36)  NULL ,  modify column name varchar(255)  NULL ,  modify column cost decimal(16,2)  NULL ,  modify column price decimal(16,2)  NULL ,  ADD  INDEX idx_PRODUCT_name (name);
/* Table : contracts */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - modified_user_id -  ROW [name] => 'modified_user_id'  [type] => 'varchar'  [len] => '36'  [required] => 'true'  */
/* VARDEF - modified_user_id -  ROW[name] => 'modified_user_id'  [rname] => 'user_name'  [id_name] => 'modified_user_id'  [vname] => 'LBL_MODIFIED'  [type] => 'varchar'  [table] => 'modified_user_id_users'  [isnull] => 'false'  [dbType] => 'varchar'  [len] => '36'  [reportable] => '1'  [comment] => 'User who last modified record'  */
/*MISMATCH WITH DATABASE - name -  ROW [name] => 'name'  [type] => 'varchar'  [len] => '255'  [required] => 'true'  */
/* VARDEF - name -  ROW[name] => 'name'  [vname] => 'LBL_NAME'  [type] => 'varchar'  [dbType] => 'varchar'  [len] => '255'  [audited] => '1'  [unified_search] => '1'  [comment] => 'The short description of the CONTRACT'  [merge_filter] => 'selected'  */
/*MISMATCH WITH DATABASE - account -  ROW [name] => 'account'  [type] => 'varchar'  [len] => '50'  [required] => 'true'  */
/* VARDEF - account -  ROW[name] => 'account'  [vname] => 'LBL_ACCOUNT'  [type] => 'varchar'  [len] => '50'  [audited] => ''  [options] => ''  [dbType] => 'varchar'  */
/*MISMATCH WITH DATABASE - account_id -  ROW [name] => 'account_id'  [type] => 'char'  [len] => '36'  [required] => 'true'  */
/* VARDEF - account_id -  ROW[name] => 'account_id'  [vname] => 'LBL_ACCOUNT_ID'  [type] => 'char'  [reportable] => ''  [comment] => 'Contact unique identifier'  [dbType] => 'id'  [len] => '36'  */
/*MISSING IN DATABASE - opportunity -  ROW*/
/*MISSING IN DATABASE - opportunity_id -  ROW*/
/*MISMATCH WITH DATABASE - status -  ROW [name] => 'status'  [type] => 'varchar'  [len] => '255'  [required] => 'true'  */
/* VARDEF - status -  ROW[name] => 'status'  [vname] => 'LBL_STATUS'  [type] => 'varchar'  [audited] => ''  [options] => 'contract_status_options'  [dbType] => 'enum'  [len] => '255'  */
/* INDEXES */
/*MISSING INDEX IN DATABASE - idx_CONTRACT_name -index  ROW */
ALTER TABLE contracts   modify column modified_user_id varchar(36)  NULL ,  modify column name varchar(255)  NULL ,  modify column account varchar(50)  NULL ,  modify column account_id char(36)  NULL ,  add column opportunity varchar(50)  NULL ,  add column opportunity_id char(36)  NULL ,  modify column status varchar(255)  NULL ,  ADD  INDEX idx_CONTRACT_name (name);
    Then pressing the Execute button:
    Code:
    Executing repair query: Query Failed:ALTER TABLE quotes modify column modified_user_id varchar(36) NULL , modify column name varchar(255) NULL , modify column billing_account varchar(50) NULL , modify column expiration date NULL , modify column stage varchar(255) NULL , ADD INDEX idx_QUOTE_name (name)::MySQL error 1061: Duplicate key name 'idx_QUOTE_name'
    We have the 'Open Sales' modules installed but strangely two of the modules previous versions are still there. See: Name: delme.jpeg Views: 364 Size: 48.3 KB

    Attempting to uninstall the previous module versions errors:
    Code:
    Error: PCLZIP_ERR_MISSING_FILE (-4) : Missing archive file 'UNINSTALLABLE'
    which may be related?

    We want to run the repair wizard since when we add contracts we are getting logentries:
    Code:
    Query:INSERT into contracts set id='efd42f8a-1a9e-25a2-1266-4bacb06fe011', date_entered='2010-03-26 13:02:03', date_modified='2010-03-26 13:02:03', modified_user_id='38E95422-74E0-DA11-A366-000AE400C805', assigned_user_id='38E95422-74E0-DA11-A366-000AE400C805', deleted='0', name='Test', description=null, created_by='38E95422-74E0-DA11-A366-000AE400C805', billing_date=null, company_signed_date=null, contact=null, contact_id=null, account='Comtek', account_id='D3C1C489-34CF-DC11-BE19-000AE400C805', opportunity=null, opportunity_id=null, customer_signed_date=null, expiration_notice=null, expiry_date=null, start_date='2010-12-01', status='Active', type=null, amount='04000'

MySQL error 1054: Unknown column 'opportunity' in 'field list'
    The contracts table is in fact missing those two opportunity columns.

    Ian
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database error on repair
    By jim.thornton in forum Developer Help
    Replies: 4
    Last Post: 2009-03-14, 04:54 AM
  2. Getting Error while repair database
    By akkimca in forum Developer Help
    Replies: 4
    Last Post: 2009-01-19, 03:23 AM
  3. email folders 1.1/repair database problem
    By mattdanner in forum Help
    Replies: 0
    Last Post: 2007-11-15, 10:34 PM
  4. Repair Database does not
    By mmakowski in forum Help
    Replies: 1
    Last Post: 2007-01-03, 04:58 AM
  5. Repair Database Problem?
    By bands in forum Developer Help
    Replies: 0
    Last Post: 2006-09-08, 11:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules