search

djjudas21 / photodb-perl

App to manage a collection of film cameras & lenses
https://metacpan.org/pod/App::PhotoDB
GNU General Public License v2.0
1 stars 2 forks source link

Collation mismatch #159

Closed djjudas21 closed 5 years ago

djjudas21 commented 5 years ago 
[jonathan@xps photography-database]$ ./photodb archive list
List the contents of an archive. Continue? (boolean) [yes]: 
    1   Film Archive Vol. I
    2   Film Archive Vol. II
    3   Film Archive Vol. III
    4   Film Archive Vol. IV
    5   Large Print Archive
    6   Print Archive Vol. I
    7   Print Archive Vol. II
    8   Print Archive Vol. III
    9   Print Archive Vol. IV
    10  Unframed 10x8" prints for sale
Please select a archive from the list (text) []: 1
Now showing items in archive Film Archive Vol. I
DBD::mysql::st execute failed: Illegal mix of collations for operation 'UNION' at /home/jonathan/git/photography-database/lib/funcs.pm line 393, <STDIN> line 2.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /home/jonathan/git/photography-database/lib/funcs.pm line 405, <STDIN> line 2.
djjudas21 commented 5 years ago

This probably warrants a wider audit of all collations because they seem to be all over the place, both table and column