Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4252
Latest: Jwatson_785
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43228
Total Topics: 7514
Most Online Today: 77
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 108
Total: 108

Author Topic: SMF Gallery Pro Database Error  (Read 3508 times)

0 Members and 1 Guest are viewing this topic.

Offline access control forum

  • Member
  • *
  • Posts: 31
    • View Profile
    • accesscontrolforum.com
SMF Gallery Pro Database Error
« on: December 10, 2014, 03:43:41 pm »
I was working on my gallery for the first time, attempted to delete a file and got this.

I cant find anything on updating just the "Sources" file. Is this possible or do I need to reinstall SMF and all my mods?

Database Error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND approved = 1' at line 1
File: /home5/accessd3/public_html/forum/Sources/Gallery2.php
Line: 7884

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


Here is what my Detailed Version Check looks like:

SMF File                  Your Version    Current Version
SMF Package    SMF 2.0.9    SMF 2.0.9
Sources                    2.0.8    2.0.9
Default Templates    2.0.9    2.0.9
Language Files    2.0.8    2.0.8

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16422
    • View Profile
Re: SMF Gallery Pro Database Error
« Reply #1 on: December 10, 2014, 03:56:54 pm »
I will take a look at this issue for you do not uninstall or change anything on it.
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 SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16422
    • View Profile
Re: SMF Gallery Pro Database Error
« Reply #2 on: December 10, 2014, 05:48:44 pm »
Try copying this updated file to your Sources folder for your forum.
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 access control forum

  • Member
  • *
  • Posts: 31
    • View Profile
    • accesscontrolforum.com
Re: SMF Gallery Pro Database Error
« Reply #3 on: December 10, 2014, 10:11:52 pm »
Now my website redirects to exactly what I wanted thanks!!!!!!!!!!!!!!

I already had a file with the same name so I copied over it, OK? When I went to look at my gallery the file I was trying to delete was gone. I tried to delete an existing image and it worked fine.

Thanks!
« Last Edit: December 10, 2014, 10:22:57 pm by access control forum »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16422
    • View Profile
Re: SMF Gallery Pro Database Error
« Reply #4 on: December 10, 2014, 10:14:42 pm »
Glad that it helps changing that link though hahah don't want that in links to
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 access control forum

  • Member
  • *
  • Posts: 31
    • View Profile
    • accesscontrolforum.com
Re: SMF Gallery Pro Database Error
« Reply #5 on: December 10, 2014, 10:22:18 pm »
When I realized it hyperlinked it I changed it too.... You literally changed as soon as I did... I am taking the line out anyway. sorry!

Offline access control forum

  • Member
  • *
  • Posts: 31
    • View Profile
    • accesscontrolforum.com
Re: SMF Gallery Pro Database Error
« Reply #6 on: December 10, 2014, 10:24:53 pm »
I'll never make that mistake again!!!! thanks! sorry again!

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16422
    • View Profile
Re: SMF Gallery Pro Database Error
« Reply #7 on: December 10, 2014, 10:26:08 pm »
Its ok np
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
4 Replies
11443 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
10 Replies
10371 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
3 Replies
2587 Views
Last post December 29, 2010, 01:49:39 pm
by SMFHacks
4 Replies
6127 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
10 Replies
6128 Views
Last post November 28, 2012, 03:50:59 am
by Jonas1975

+- Recent Topics

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Request for admin notification by davejo
February 06, 2024, 09:02:12 am

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

User Gallery Feature: move / bulk move images by SMFHacks
January 30, 2024, 05:48:25 pm

In the future it may be for smf 2.1.x? by smithloo
January 30, 2024, 12:55:34 am

Clipboard image support for the editor by SMFHacks
January 29, 2024, 11:22:17 am

Release date? by SMFHacks
January 26, 2024, 02:00:45 pm

Powered by EzPortal