search

CellProfiler / CellProfiler-Analyst

Open-source software for exploring and analyzing large, high-dimensional image-derived data.
http://cellprofileranalyst.org
Other
145 stars 72 forks source link

Table ‘_link_tables_’ already exists error #240

Open jhung0 opened 8 years ago

jhung0 commented 8 years ago

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:

image

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

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 commented 8 years ago

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 commented 8 years ago

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?

image

jhung0 commented 8 years ago

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

imoutsatsos commented 7 years ago

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

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 commented 7 years ago

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

jhung0 commented 7 years ago

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 commented 7 years ago

Update: nightly should be building again

EsbenSv commented 6 years ago

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