After upgrading to Tiki 4 tiki-galleries.php does not work anymore

• Error
• Usability
• Support request

I have the following problem:

we wanted to upgrade our old tiki 2.2 to the new tiki 4.0 but there are some problems.

after using tiki-install.php to upgrade the old tiki to the new one the image galleries doesn't work anymore, even though it is activiated in the features menu.

the problem is the following:
every time i want to go to tiki-galleries.php i get the following error:

The following error message was returned:

The query was:
select `sortorder`,`sortdirection` from `tiki_galleries` where `galleryId`=?

Values:

1. 13
2. o

The built query was likely:
select `sortorder`,`sortdirection` from `tiki_galleries` where `galleryId`='13'

the problem is as you see there is no error message only the query is displayed.

i tried to install a vanilla 4.0 and created two galleries where each of it has one image in it and it works fine

i compared the database tables tiki_images, tiki_images_data and tiki_galleries and they seem to have the same structure

i tried to copy the tables mentioned above from the upgraded tiki into a clean install and still get the error above

possible problem seems to be with the tiki_image table as it works fine without the images in the image tables - but the error appears only after i copy the image tables into the database

it would be nice if someone could help me / fix this problem as it would take some time to reupload all the images (then probably into the file galleries)

and besides that is there a tool that moves the images from the image gallery to the file gallery for future use?

edit: all the other php files work like tiki-list_gallery.php and tiki-browse_gallery.php

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org