WordPress.org

Forums

ProgressFly Not Creating Table (2 posts)

  1. Orin
    Member
    Posted 7 years ago #

    I've installed the most recent version of the ProgressFly plugin, but it seems that the table isn't being created properly. I'm logged in as the administrator, and this is the error message I receive when trying to create a table for the first time:

    WordPress database error: [Table 'mytablename.wp_progressfly' doesn't exist]

    I could create this table manually, but I don't know how many fields should be in that particular table. Any hints?

  2. Mel
    Member
    Posted 7 years ago #

    This worked for me.... You will have to add in the backticks (quotes) since this forum takes them out.

    --
    -- Table structure for table wp_progressfly
    --

    CREATE TABLE IF NOT EXISTS wp_progressfly (
    wipid int(11) NOT NULL auto_increment,
    title varchar(50) NOT NULL,
    titlelink varchar(200) default NULL,
    target double NOT NULL,
    progress double NOT NULL,
    units varchar(50) default NULL,
    pfcategory varchar(200) NOT NULL,
    h3style varchar(500) NOT NULL,
    meterwidth int(11) NOT NULL,
    meterheight int(11) NOT NULL,
    intmargin int(11) NOT NULL,
    bgcolor varchar(10) NOT NULL,
    targstyle varchar(500) NOT NULL,
    pcolor varchar(10) NOT NULL,
    progstyle varchar(500) NOT NULL,
    bordercolor varchar(10) NOT NULL,
    borderwidth tinyint(4) NOT NULL,
    textstyle varchar(500) NOT NULL,
    intextstyle varchar(500) NOT NULL,
    complete varchar(3) NOT NULL,
    visible varchar(3) NOT NULL,
    borderstyle varchar(500) NOT NULL,
    PRIMARY KEY (wipid)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

Topic Closed

This topic has been closed to new replies.

About this Topic