Database error? Affecting Gallery Pro table.

[GSJ]

Hi recently I paid for the Gallery Pro edition for my website. On installation everything was fine, no errors. Adding pictures, categories everything remains fine. Then today for some reason a database error showed up. Saying this:

Invalid use of group function
File: /home/animeins/public_html/Sources/Gallery.php
Line: 9507

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.12, while your database is at version 1.1.11. The above error might possibly go away if you execute the latest version of upgrade.php.

I tried to repair the database with Cpanel that didn't work and when I tried to upload the SMF 1.1.12 upgrade (as advised in the error) But it says error this file is either invalid or corrupted.

At current I have the SMF 1.1.12 version I don't understand why it says it's 1.1.11 nor why suddenly there is an error in the first place. It actually stops all the categories/boards showing up when you go into the gallery. Newest image, most recent commented etc is still there and you 'can' still get to the boards in the go around(just not from the main gallery menu)and there's just an ugly error and confusion  for my members.

Here's the source for /home/animeins/public_html/Sources/Gallery.php

Would really really appreciate someone having a look at this for me.

Thanks again!

Gold

[SMFHacks]

First try this. Go into your Admin -> Gallery Configuration -> Settings -> Layout
And disable Show tag cloud on index and see if that makes the error disappear. Then i will look at it from there.

[GSJ]

I did what you said and now all the boards show up again. So it is the tag cloud that conflicted somehow. I have no idea how to fix that problem at all. Am relieved the gallery boards are back however.

[SMFHacks]

I will need to do some testing on that one. First time I seen that happen with the tag cloud.

Under Admin -> Support and Help can you post what your MySQL Version is