https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20644

Adolfo Rodríguez Taboada <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #92 from Adolfo Rodríguez Taboada <[email protected]> ---
Is the IF NOT EXISTS really necessary in the file
installer/data/mysql/db_revs/250600010.pl? 

It's already being checked before applying the SQL with !column_exists(
'itemtypes', 'checkprevcheckout' ) and it returns an error with versions of
MySQL such as Ver 15.1 Distrib 10.1.48-MariaDB and Ver 8.0.31


Error message:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'IF
NOT EXISTS checkprevcheckout enum('yes', 'no', 'inherit') NOT NULL DEFAULT' at
line 1

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to