If new columns are added to a table, it seems you have to remove and then re-add the table for the new columns to be visible to TW. An option to add new columns when analyzing a table would be helpful.

As an aside, I had no problems after removing and re-adding a table.

Thanks for this great module!

Comments

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Category: feature » bug
Status: Active » Postponed (maintainer needs more info)

If going to the analysis page and clicking Reanalyze does not add the new columns to the analysis page, that would be a bug in Table Wizard. Can you give any more information - anything unusual about the table or the new columns (e.g. do the column names contain anything other than alphanumerics and underscores)?

Thanks.

awolfey’s picture

awolfey commented

The only unusual thing might be that I added the columns to the db manually while also updating the install file. I didn't reinstall the module. So perhaps the schema did not match the db exactly. But, I think there were a few columns I did the same with before using TW, and those were picked up. The table has about 70 columns.

awolfey’s picture

awolfey commented

Now that I'm thinking about it, maybe I clicked the analyze button, but did click reanalyze once the table details were opened.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)