Table ‘_link_tables_’ already exists error

[jhung0]

From http://forum.cellprofiler.org/t/table--link-tables--already-exists-error/4126 Greetings to all;

Using CPA v2.2.1 with MySQL, I'm experiencing the following series of errors.

Before link tables are created I can use the:

1. Histogram
2. Box Plot and
3. Table Viewer tools

The first time use of these tools appears to create the link tables. After the link tables are created and while trying to use any of the CPA tools (except Table Viewer that always works) I get the following error:

Trying to use te 'Advanced'-> 'Clear table linking information' tool also fails

However, if I manually drop the link tables then the tools work as indicated above (for first time use) and then fail again with the errors above.

I've checked for 'dbconnect' in the properties file an I don't find it anywhere. Any ideas as to what I should try next.

Thanks and best regards Ioannis

[jhung0]

I think this is an issue with the table names being capitalized. I tried to fix it, so try it with the nightly build made after this. https://github.com/CellProfiler/CellProfiler-Analyst/commit/eb5202a9d928365b31f1f995d6c49851d8b39b63

[imoutsatsos]

I have downloaded the nightly build from here: http://d1zymp9ayga15t.cloudfront.net/CellProfiler-Analyst-nightly.exe

However, I see the same errors. I also don't see a different version reported by the software. Is that OK? I still see version 2.2.1. I also do not see a recent date for the binary. Are you sure this is nightly build?

[jhung0]

Oh sorry, you should get it from the cellprofiler.org site http://cellprofiler.org/releases/#CPA

[imoutsatsos]

I think this is the same link. After re-installing the executable still appears as before.

Can you confirm that this should be the date appearing in the nightly build. I would think not but just in case...

Thanks and best regards Ioannis

[imoutsatsos]

Do I have to build it from source? I would think that the nightly build executable should be all I need?

[jhung0]

Ok, it seems like the night builds aren't working at the moment, so you can try building from source https://github.com/CellProfiler/CellProfiler-Analyst/wiki/Cellprofiler-analyst-developer's-version-installation-for-pc. (The directions may seem a bit long, and I'm trying to get them shorter.)

[jhung0]

Update: nightly should be building again

[EsbenSv]

@imoutsatsos Did you find a solution to this issue? I have same same issue in CPA2.2.1 and CPA2.0