WordPress.org

Ready to get started?Download WordPress

Forums

ABASE
List showing incorrect primary key field (1 post)

  1. cswaim
    Member
    Posted 7 months ago #

    I have 2 tables Programs and Campaigns.
    Programs:
    id int
    program char
    desc vchar

    Campaigns
    id int
    program char
    campaign char
    date date

    foreign key on campaigns.program

    See below for exact definition of tables and foreign keys.

    When listing the programs table for maint all is well.
    When listing the campaigns table for maint, the id of the campaign table is the id from the programs.

    short codes are:

    [abase table="wp_qqxcx8_brc_campaigns" rlink="id"]
    
    [abase form="1,update" table="wp_qqxcx8_brc_campaigns" elements="id,program,campaign,dt_start,dt_end,total_mailed,rsp_cnt" fields="id,program,campaign,dt_start,dt_end,total_mailed,rsp_cnt$Update Campaign" ack="brown" style="width:100%;"]

    When you select the id (rlink), the following error message is displayed.

    #1. [abase table="wp_qqxcx8_brc_campaigns" rlink="id"]
    Fatal Error (1376)
    Column 'id' in where clause is ambiguous
    Check to make sure the upper and lower case spelling of your table and column names are all exactly correct. Valid table names in haag_sfcg: wp_qqxcx8_brc_campaign_details, wp_qqxcx8_brc_campaigns, wp_qqxcx8_brc_programs, wp_qqxcx8_commentmeta, wp_qqxcx8_comments, wp_qqxcx8_links, wp_qqxcx8_options, wp_qqxcx8_postmeta, wp_qqxcx8_posts, wp_qqxcx8_rg_form, wp_qqxcx8_rg_form_meta, wp_qqxcx8_rg_form_view, wp_qqxcx8_rg_lead, wp_qqxcx8_rg_lead_detail, wp_qqxcx8_rg_lead_detail_long, wp_qqxcx8_rg_lead_meta, wp_qqxcx8_rg_lead_notes, wp_qqxcx8_term_relationships, wp_qqxcx8_term_taxonomy, wp_qqxcx8_terms, wp_qqxcx8_usermeta, wp_qqxcx8_users.
    
    SELECT * FROM wp_qqxcx8_brc_campaigns LEFT JOIN <code>wp_qqxcx8_brc_programs</code> AS <code>wp_qqxcx8_brc_campaigns$program$wp_qqxcx8_brc_programs</code> ON <code>wp_qqxcx8_brc_campaigns</code>.program=<code>wp_qqxcx8_brc_campaigns$program$wp_qqxcx8_brc_programs</code>.program WHERE <code>id</code>='1' table_error = '' cols_in = '' fields_in = '' columns_in = '*' form = ''

    here is the sql for the table and constraints:
    CREATE TABLE IF NOT EXISTSwp_qqxcx8_brc_campaigns` (
    id int(11) NOT NULL AUTO_INCREMENT,
    program char(8) NOT NULL,
    campaign char(12) NOT NULL,
    dt_start date DEFAULT NULL,
    dt_end date DEFAULT NULL,
    total_mailed int(11) NOT NULL DEFAULT '0',
    rsp_cnt int(11) NOT NULL DEFAULT '0',
    created datetime DEFAULT NULL,
    modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    UNIQUE KEY pgm_campaign (program,campaign)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='brc campaigns' AUTO_INCREMENT=23 ;

    --
    -- Constraints for table wp_qqxcx8_brc_campaigns
    --
    ALTER TABLE wp_qqxcx8_brc_campaigns
    ADD CONSTRAINT wp_qqxcx8_brc_campaigns_ibfk_1 FOREIGN KEY (program) REFERENCES wp_qqxcx8_brc_programs (program) ON DELETE CASCADE ON UPDATE CASCADE;`

    Am I entering the shortcodes incorrectly, missing a parm or is there a bug?

    http://wordpress.org/plugins/abase/

Reply

You must log in to post.

About this Plugin

About this Topic