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

Mysqli prepare error installing on Omeka Classic 2.8 #500

Open
GitByrd opened this issue Aug 11, 2021 · 2 comments
Open

Mysqli prepare error installing on Omeka Classic 2.8 #500

GitByrd opened this issue Aug 11, 2021 · 2 comments
Assignees
Labels

Comments

@GitByrd
Copy link

GitByrd commented Aug 11, 2021

Hi there,

I downloaded the Neatline plugin for Omeka (version 2.6.4) and it seemed to install successfully in Omeka, but when I go to click on the plugin in the left column, it brings up an error page with the following message:

Zend_Db_Statement_Mysqli_Exception
Mysqli prepare error: Unknown column 'neatline_exhibits.id' in 'on clause'

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'neatline_exhibits.id' in 'on clause' in /home/schaffer/jennifer.schafferlibrarycollections.org/cms/application/libraries/Zend/Db/Statement/Mysqli.php:77

It actually threw an error before that one, saying that a certain table didn't exist in the database (I think it was om_neatline_exhibits), but then I just manually created it in MyPhpAdmin....and then I got the above error.
I haven't changed anything in the plugin's files so I'm not sure what is going on. If you could please advise, I would greatly appreciate it. Thanks!

@rondauva
Copy link
Contributor

Hi GitByrd,

Apologies for the delay in our response. All our developers are out of the office until next week, and I'm not qualified to troubleshoot this.

To help them out when they're back, can you give us some more information on your operating system, MySQL version, and any other parameter info that might be relevant, such a proxy set ups, etc.? Thank you so much!

All the best,
Ronda

@GitByrd
Copy link
Author

GitByrd commented Aug 16, 2021

Ok, thank you! I'm working on a Mac High Sierra 10.13.6. When I'm logged into myPHPadmin to view the database, the database server info says Localhost via UNIX socket, server version 10.3.27-MariaDB - MariaDB Server. The web server says Database client version: libmysql - 5.6.43, PHP version: 7.3.28. I hope some of this information helps!
Thanks so much

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

No branches or pull requests

3 participants