Facebook 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4282
Latest: Eric87
New This Month: 7
New This Week: 1
New Today: 1
Stats
Total Posts: 43660
Total Topics: 7574
Most Online Today: 89
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 71
Total: 71

Author Topic: Database error? Affecting Gallery Pro table.  (Read 2700 times)

0 Members and 1 Guest are viewing this topic.

Offline GSJ

  • Member
  • *
  • Posts: 5
    • View Profile
Database error? Affecting Gallery Pro table.
« on: December 28, 2010, 12:08:09 pm »
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 :D

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16617
    • View Profile
Re: Database error? Affecting Gallery Pro table.
« Reply #1 on: December 28, 2010, 12:17:06 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline GSJ

  • Member
  • *
  • Posts: 5
    • View Profile
Re: Database error? Affecting Gallery Pro table.
« Reply #2 on: December 29, 2010, 10:42:34 am »
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. :)

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16617
    • View Profile
Re: Database error? Affecting Gallery Pro table.
« Reply #3 on: December 29, 2010, 01:49:39 pm »
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
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
10 Replies
10802 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
Database Error

Started by pioneer « 1 2 » Support

22 Replies
13898 Views
Last post April 18, 2009, 11:58:55 am
by SMFHacks
5 Replies
7303 Views
Last post January 22, 2010, 11:26:48 am
by SMFHacks
10 Replies
6391 Views
Last post November 28, 2012, 03:50:59 am
by Jonas1975
7 Replies
3806 Views
Last post December 10, 2014, 10:26:08 pm
by SMFHacks

+- Recent Topics

Do you offer paid assistance with the SMFBlog mod? by Grammy
February 11, 2025, 02:58:04 pm

SMFBlog Mod by Grammy
February 10, 2025, 07:33:32 pm

[Mod]Bluesky Auto Embed by SMFHacks
January 30, 2025, 01:47:36 pm

Delete a Picture from Trash - Error by SMFHacks
January 29, 2025, 09:06:38 pm

RESOLVED: Store Not Logging Transactions or Sending Emails by SMFHacks
January 23, 2025, 06:24:27 pm

Ability to exclude categories from ezPortal SMF Gallery random image ezblock by Alistair
January 22, 2025, 08:20:13 am

How to move SMF to new server by SMFHacks
January 21, 2025, 08:45:53 pm

Figuring out settings by SMFHacks
January 12, 2025, 04:56:14 pm

Filesizes incorrect by SMFHacks
January 12, 2025, 02:02:47 pm

December 2024 Sale! by SMFHacks
December 02, 2024, 10:30:38 pm

Powered by EzPortal