Database Error?

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
   Badge Awards
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   Buy Website Traffic
   Site Showcase
   Email Marketing Software

Advanced search

[ApplianceJunk]

A few times though out the day I get errors like this in the error log.

I just started checking the IP address that go with them and they always seem to be from a search engine, such as google or yahoo.

http://appliancejunk.com/forums/index.php?action=gallery;sa=view;id=446
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 'ORDER BY c.id_comment DESC' at line
5File: /home/applianc/public_html/forums/Sources/Gallery2.php
Line: 579

What are these errors from and should I do anything to try and fix them?

Thanks,

[SMFHacks]

Try to get the real line number run this sql query

Code:

REPLACE INTO smf_settings VALUES ('disableTemplateEval', 1);

[ApplianceJunk]

How do I run a sql query?

[SMFHacks]

If you have phpmyadmin you can run it that way using the forum's database if not there is also a mod on the SMF modsite too.

[ApplianceJunk]

Is this what your looking for?

1 row(s) affected. ( Query took 0.0004 sec )
REPLACE INTO smf_settings
VALUES (
'disableTemplateEval', 1
);

[SMFHacks]

Yes now click http://appliancejunk.com/forums/index.php?action=gallery;sa=view;id=446 and check your db error log

[ApplianceJunk]

http://appliancejunk.com/forums/index.php?action=gallery;sa=view;id=446
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 'ORDER BY c.id_comment DESC' at line 5
File: /home/applianc/public_html/forums/Sources/Gallery2.php
Line: 579

[SMFHacks]

Hmm can you attach that file don't see that area in my file.

[ApplianceJunk]

Thanks,

[SMFHacks]

Don't remember the version number in there.  Looks like you maybe a couple versions back download the latest beta/release at
http://www.smfhacks.com/index.php/topic,5930.0.html

[ApplianceJunk]

The link gives me a ...

The topic or board you are looking for appears to be either missing or off limits to you.

[SMFHacks]

Try this file.

[ApplianceJunk]

Ok, uploaded the new file and now when I click on http://appliancejunk.com/forums/index.php?action=gallery;sa=view;id=446 I'm just taken to a page that says ...

An Error Has Occurred!
No picture selected.

and I take it that is not really a error and is what it should show me, because I then check my error log and it's empty.

Is that how it should be working now then?

I don't know how I would have got a old version as I recall I purchased SMF Gallery Pro just a few days ago and downloaded it from the link it gave me after purchasing it.

[SMFHacks]

Make sure you enter your license key to gain the latest version.

yeah that's how it should be. The error occurred since the picture was deleted but was still indexed by search engines.

[ApplianceJunk]

In admin it shows I'm running, SMF Gallery Lite    3.1.1

I was running the free SMG Gallery on SMF 1.1.14 and then after the upgrade to SMF 2.0 I had to reinstall mods and I'm sure I installed the SMF Gallery Pro that I purchased.

Anyway, should I uninstall what I'm running now (Gallery lite?) and then try to re install the latest?

thanks for the help,

Help Support the SMFHacks.com mod making.