-
Notifications
You must be signed in to change notification settings - Fork 19
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
DBI Error when using Postgres 14 on last_insert_id #51
Comments
Did you run the same version of Taranis on an older version of Postgresql without issues? Did you reinstall DBD::Pg after the upgrade to P14, or do both come natively in your OS? I haven't tried P14 yet: I am on P12. |
I can login etc - currently only "last_inserted_id" seems to be a problem. |
Well i will retry with a fresh install (in docker). But that won't happen before next year... |
Okay, so please try "cpan -i DBD::Pg" as well. I cannot find last_insert_id as official P14 change, maybe accidental? |
while trying to install DBD::Pg i got an error |
Why did i had to reinstall DBD::Pg? |
Pg.h is part of DBD::Pg. It wants to load "libpq-fe.h", which is part of Postgresql. When you have cd ~/.cpan/build/DBD-Pg*
vi Makefile.PL # change LIB
perl Makefile.PL
make install |
Following error is thrown when using postgres 14 (trying to run collector):
DBD::Pg::db last_insert_id failed: No suitable column found for last_insert_id of table "statistics_collector" at /home/taranis/taranis-3.5.1/perl5/Taranis/Database.pm line 355
.Could this be a problem between DBI and postgres 14?
The text was updated successfully, but these errors were encountered: