Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4260
Latest: Verrick
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43307
Total Topics: 7525
Most Online Today: 310
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 194
Total: 195

Author Topic: Database error? Affecting Gallery Pro table.  (Read 2628 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: 16457
    • 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: 16457
    • 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
10613 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
Database Error

Started by pioneer « 1 2 » Support

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

+- Recent Topics

Attachment images Upsidedown or Sideways by donk
Today at 12:57:32 am

“Insert from Gallery” by donk
June 10, 2024, 01:26:57 pm

Pretty Urls extras by SMFHacks
May 13, 2024, 10:28:54 am

Mod question by Verrick
May 11, 2024, 02:42:50 pm

i have paid but cant download ad pro. by SMFHacks
May 02, 2024, 11:29:38 pm

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

Powered by EzPortal