Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11809
Latest: Rheingauner
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 41640
Total Topics: 7280
Most Online Today: 54
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 39
Total: 39

Author Topic: Database Error: You have an error in your SQL syntax?  (Read 9726 times)

0 Members and 1 Guest are viewing this topic.

Offline ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
Database Error: You have an error in your SQL syntax?
« on: February 09, 2008, 10:26:22 pm »
Not sure what is going on with this error.

Here is what is shows in the error log.

Quote

 Guest                                            Today at 05:59:32 PM 
 99.238.77.127                              b6b3c1ed72d122452b7f9d4425b846d3 

 http://appliancejunk.com/forums/index.php?action=gallery;sa=prev;id=421
 
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 USER_ID_CAT = AND approved = 1 AND ID_PICTURE > 421 LIMIT 1' at line 1
File: /home/content/a/p/p/appliancejunk/html/forums/Sources/Gallery.php
Line: 4763

 

So I go to my forums/Sources/Gallery.php and look at line 4763 and see this.

Code: [Select]
$dbresult = db_query("SELECT ID_PICTURE FROM {$db_prefix}gallery_pic WHERE ID_CAT = $ID_CAT AND USER_ID_CAT =
Here is a little larger section of that code.

Code: [Select]
//Get previous image
$dbresult = db_query("SELECT ID_PICTURE FROM {$db_prefix}gallery_pic WHERE ID_CAT = $ID_CAT AND USER_ID_CAT = $USER_ID_CAT AND approved = 1 AND ID_PICTURE > $id  LIMIT 1", __FILE__, __LINE__);
if(db_affected_rows() != 0)
{
$row = mysql_fetch_assoc($dbresult);
$ID_PICTURE = $row['ID_PICTURE'];
}
else
$ID_PICTURE = $id;

mysql_free_result($dbresult);

redirectexit('action=gallery;sa=view;id=' . $ID_PICTURE);
}
function NextImage()
{
global $db_prefix, $txt, $scripturl;

$id = (int) $_REQUEST['id'];
if(empty($id))
fatal_error($txt['gallery_error_no_pic_selected']);

So it seems to be something that happens when a guest clicks to Get previous image, correct?

Not sure what I need to do or look at to correct this.

Any help would be appreciated.

Thank you,
 AJ



Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15765
    • View Profile
Re: Database Error: You have an error in your SQL syntax?
« Reply #1 on: February 09, 2008, 10:42:04 pm »
Figured it out appears that image was deleted.
http://appliancejunk.com/forums/index.php?action=gallery;sa=view;id=421

And the user/bot was following an old link.
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 ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
Re: Database Error: You have an error in your SQL syntax?
« Reply #2 on: February 09, 2008, 11:31:17 pm »
Figured it out appears that image was deleted.
http://appliancejunk.com/forums/index.php?action=gallery;sa=view;id=421

And the user/bot was following an old link.

ok, I was kind of wondering if it was something like that as it started to happen after I removed half a dozen photos from the gallery and a couple of the "guest" were goggle when I checked on there IP's.

So there is nothing I should have to repair or change, correct?


Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15765
    • View Profile
Re: Database Error: You have an error in your SQL syntax?
« Reply #3 on: February 09, 2008, 11:34:26 pm »
Not really. I can add a check to that function just to stay that picture no longer exists if it becomes an issue.
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 ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
Re: Database Error: You have an error in your SQL syntax?
« Reply #4 on: February 09, 2008, 11:44:03 pm »
Not really. I can add a check to that function just to stay that picture no longer exists if it becomes an issue.

Ok, I don't think it will become a issue for me.

Thanks for your fast replies.


 

Related Topics

  Subject / Started by Replies Last post
4 Replies
5964 Views
Last post September 02, 2008, 08:06:08 pm
by SMFHacks
2 Replies
6573 Views
Last post January 24, 2009, 09:28:41 am
by cepsi
1 Replies
2931 Views
Last post April 02, 2009, 09:06:46 pm
by SMFHacks
4 Replies
4550 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
16 Replies
6682 Views
Last post October 03, 2017, 08:49:37 pm
by drewactual

+- Recent Topics

Logo and Category? by tank_fv101
January 10, 2022, 08:03:11 am

Questions about SMF Gallery Pro Folders and Gallery URL by scso1502
January 05, 2022, 03:48:27 pm

$subcats_linktree by mickjav
January 05, 2022, 03:08:29 pm

New Photos Won't Upload - Gallery Pro 8.0 or 9.0b - Old Photos Still Visible by scso1502
January 05, 2022, 02:23:16 pm

Additional Recommendations for SMF Store by SMFHacks
January 03, 2022, 02:37:10 pm

Seasons Greetings by SMFHacks
December 24, 2021, 10:02:42 pm

Problems with the contact mod by SMFHacks
December 22, 2021, 09:16:24 am

Gallery Pro v8.0 and PHP 7.4 by SMFHacks
December 16, 2021, 01:34:03 pm

Thanks mod SMF 2.1 by Monocero
November 27, 2021, 01:13:01 pm

How to change the font on a photo in SMF Gallery Pro? by SMFHacks
November 18, 2021, 09:28:11 am

Powered by EzPortal