Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No datascribe_project table. #84

Open
hawkpf opened this issue May 27, 2021 · 6 comments
Open

No datascribe_project table. #84

hawkpf opened this issue May 27, 2021 · 6 comments

Comments

@hawkpf
Copy link

hawkpf commented May 27, 2021

After I install this module on omeka s 3.0.2 and I go to the Datascribe tab (dashboard) I get the following error.
Doctrine\DBAL\Exception\TableNotFoundException
An exception occurred while executing 'SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.is_public AS is_public_5, d0_.owner_id AS owner_id_6, d0_.created_by_id AS created_by_id_7, d0_.modified_by_id AS modified_by_id_8 FROM datascribe_project d0_ LEFT JOIN user u1_ ON d0_.owner_id = u1_.id LEFT JOIN datascribe_user d2_ ON d0_.id = d2_.project_id WHERE u1_.id = ? OR d2_.user_id = ? GROUP BY d0_.id ORDER BY d0_.name ASC, d0_.id ASC' with params [1, 1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'omeka_emkons.datascribe_project' doesn't exist

@mebrett
Copy link
Collaborator

mebrett commented May 27, 2021

Just to double check - the install ran fine? It's only when you're trying to navigate to the DataScribe dashboard?

Did you have DataScribe installed before? This forum thread has a very similar error.

@hawkpf
Copy link
Author

hawkpf commented May 27, 2021

Correct,
If I uninstall, the database has zero tables for Datascribe. Once I
reinstall the following tables exist:
datascribe_field
datascribe_item
datascribe_record
datascribe_user
datascribe_value

Then if I click on the Datascribe in the bottom left under modules I get
that error because the table datascribe_project does not exist.

@mebrett
Copy link
Collaborator

mebrett commented May 27, 2021

It may be an environment error (based on the forum thread linked about and this extensive issue on a different module.

Is this an install of Omeka S that you upgraded? Or fresh of 3.0.2? Are any other modules not working on your install?

@hawkpf
Copy link
Author

hawkpf commented May 27, 2021

I upgraded the site from Omeka-S 2 to 3. All other modules are installed and working that are meant for version 3.

@mebrett
Copy link
Collaborator

mebrett commented May 27, 2021

Are you able to make a fresh install of Omeka S on the same server, to see if the error also happens when you add DataScribe to that install?

When you re-installed, did you grab a fresh version of the module? Or use the same that you'd tried before?

@hawkpf
Copy link
Author

hawkpf commented Jun 1, 2021

I have a VM that I use to test deployments and I did a full install of Omeka-S 3.0.2 using their release-3.0 branch. I downloaded the Datascribe zip file and unzipped the contents, installed the module and I still get the error. I also did a git clone with your master branch and the error still persists.

My VM is centos 7 using mariadb.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants