Image Gallery fails with Unknown column 'g.parentgallery' in 'on clause'

• Error
• Usability

I am running Tiki 1.9.7 with MySQL on Linux.

I have gone through the tiki_mysql.sql file and have found no reference to the column listed in the error message:

Context:
File tiki-galleries.php
Url tiki-galleries.php
Query:
select g.*, a.`name` as parentgalleryName from `tiki_galleries` g left join `tiki_galleries` a on g.`parentgallery` = a.`galleryId` order by `name` desc
Values:
Message:
Error Message Unknown column 'g.parentgallery' in 'on clause'

This appears as soon as I click on "Image Galleries" folder from the Menu module, or "Galleries".

I also get the same error message when I try and click on "Upload Image":

Context:
File tiki-upload_image.php
Url tiki-upload_image.php
Query:
select g.*, a.`name` as parentgalleryName from `tiki_galleries` g left join `tiki_galleries` a on g.`parentgallery` = a.`galleryId` order by `lastModif` desc
Values:
Message:
Error Message Unknown column 'g.parentgallery' in 'on clause'

Apparently this column needs to exist, but I have no idea what the column settings should be. This is preventing me from even using the image gallery feature.

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org