https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36993 --- Comment #17 from Emmi Takkinen <emmi.takkinen@koha-suomi.fi> --- (In reply to Matthew Charlesworth from comment #16)
Hi Emmi,
(In reply to Emmi Takkinen from comment #15)
Matthew: could it be that you have values in aqbudgets.budget_period_id column that don't exist on aqbudgetperiods.budget_period_id?
To be honest I'm not sure. If I do this, does this tell you?
MariaDB [...]> select budget_period_id from aqbudgets; +------------------+ | budget_period_id | +------------------+ | 1 | +------------------+ 1 row in set (0.001 sec)
MariaDB [...]> select budget_period_id from aqbudgetperiods; +------------------+ | budget_period_id | +------------------+ | 1 | +------------------+ 1 row in set (0.000 sec)
It looks like they're the same.
M.
Hmm, they are indeed. This should also return empty: SELECT COUNT(*) FROM aqbudgets WHERE budget_period_id IS NULL OR budget_period_id NOT IN(SELECT budget_period_id FROM aqbudgetperiods); -- You are receiving this mail because: You are watching all bug changes.