Mysqli prepare error installing on Omeka Classic 2.8

[GitByrd]

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]

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]

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