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: 43319
Total Topics: 7526
Most Online Today: 237
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 252
Total: 252

Author Topic: [2.5] Error search custom fields  (Read 13737 times)

0 Members and 1 Guest are viewing this topic.

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
[2.5] Error search custom fields
« on: July 05, 2009, 03:55:11 am »
 
Hello,
When I try to search in the custom field I get this error:

Code: [Select]
URL  http://digiscrap.nl/index.php?action=gallery;sa=search2
Databasefout: 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 'OR d.value LIKE '%juli09%')' at line 5
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/Load.php(1959) : eval()'d code
Regel: 2882

Errors in the log:
Code: [Select]
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 'OR d.value LIKE '%juli09%')' at line 5
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/Load.php(1959) : eval()'d code
Regel: 2882

Code: [Select]
URL  http://digiscrap.nl/index.php?action=gallery;sa=search2;key=juli09
8: Undefined index: gallery_searchcustom
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Themes/default/Gallery2.template.php (search_results sub template - eval?)
Regel: 2872

Code: [Select]
URL  http://digiscrap.nl/index.php?action=gallery;sa=search2
8: Undefined variable: searchquery
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/Gallery2.php
Regel: 3634



Thanks,
Vincent
« Last Edit: July 23, 2009, 01:53:03 am by Vincent Volmer »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16463
    • View Profile
Re: [2.5b2.1] Error search custom fields
« Reply #1 on: July 05, 2009, 08:39:27 am »
Fixed for next update
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 Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5b2.1] Error search custom fields
« Reply #2 on: July 05, 2009, 08:43:24 am »

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5b3] Error search custom fields
« Reply #3 on: July 13, 2009, 02:01:10 am »
 
Hello,

Searching custom fields still causes error 500 in v2.5b3:
When searching in custom fields together with Description, Title or keyword.

When I unselect the other ( Description, Title or keyword) and search in the custom fields only, it works fine.

Vincent
« Last Edit: July 13, 2009, 02:03:10 am by Vincent Volmer »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16463
    • View Profile
Re: [2.5b3] Error search custom fields
« Reply #4 on: July 13, 2009, 06:41:04 pm »
Tried a couple combinations and couldn't repeat this issue. What is the exact combination of search things you are searching for.
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 Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5b3] Error search custom fields
« Reply #5 on: July 14, 2009, 12:17:54 am »
Tried a couple combinations and couldn't repeat this issue. What is the exact combination of search things you are searching for.

Hmmmm.... all combinations. No matter which combination. All combinations are causing this......
Strange enough: there are no errors in the log  :-\

Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5b3] Error search custom fields
« Reply #6 on: July 15, 2009, 02:49:55 pm »
Tried a couple combinations and couldn't repeat this issue. What is the exact combination of search things you are searching for.

Custom Fields
Custom Fields+Title
Custom Fields+Keyword
Custom Fields+Discription
Custom Fields+Title+Keyword
Custom Fields+Title+Discription
Custom Fields+Keyword+Discription
Custom Fields+Title+Keyword+Discription

Title
Keyword
Discription
Title+Keyword
Title+Discription
Keyword+Discription
Title+Keyword+Discription


These are all options I tried. The green ones are fine. Red not. When I look into the database I see a couple of custom fields which are not in use anymore. Could that give the problem?

I can give you access to the database and website as admin if you need.

Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5RC1] Error search custom fields
« Reply #7 on: July 21, 2009, 09:07:04 am »
Sorry for repeating this issue...

 
Today -thankfully- the error appears in the log again:

Code: [Select]
URL  http://digiscrap.nl/index.php?action=gallery;sa=search2;key=Henrike
8: Undefined index: gallery_searchcustom
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Themes/default/Gallery2.template.php (search_results sub template - eval?)
Regel: 2992

Could you please look at this? Don't know if I'm the only one with this 'problem'....

Thanks,
Vincent
« Last Edit: July 21, 2009, 09:09:02 am by Vincent Volmer »

Offline Matth41

  • Bad Emails DO NOT EMAIL
  • Full Member
  • *
  • Posts: 108
    • View Profile
    • Furcadia Art Zone
Re: [2.5RC1] Error search custom fields
« Reply #8 on: July 21, 2009, 09:43:56 am »
Just to confirm, I'm seeing the same error in my logs.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16463
    • View Profile
Re: [2.5RC1] Error search custom fields
« Reply #9 on: July 21, 2009, 11:48:18 pm »
I believe I have both errors fixed for the final release.
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 Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5] Error search custom fields
« Reply #10 on: July 23, 2009, 01:52:43 am »
I believe I have both errors fixed for the final release.

I'm sorry, but searching the custom fields is still not working correct. Still the same error 500 issue.....

Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5] Error search custom fields
« Reply #11 on: July 29, 2009, 04:06:14 pm »
Hello mr SMFHacks,

I finally disabled searching in custom fields. It caused an crash of the website. After a minute or so, the site is up again. Thats not acceptable for me. All tough I understand that you cant reproduce this, I like to see an solution if possible.

We upgraded our forum from SMF 1.1.8 to SMF 2.0b4 -> 2.0RC1.2 (now). Could it be possible when there are some special characters in the custom fields which causes this error? Did you (maybe) made an mistake with uppercase/lowercase/underscore in the search query?

I wish I could help finding this issue. Don't know where to start. If you want, I can give you an Admin account and also database access.

Thanks in advance and I appreciate your help (and your great work on the gallery!)

Vincent Volmer
 


Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: [2.5] Error search custom fields
« Reply #12 on: July 30, 2009, 01:18:32 am »
 
Hello,

This issue appears also on my test website.

Vincent
 

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16463
    • View Profile
Re: [2.5] Error search custom fields
« Reply #13 on: July 30, 2009, 07:53:41 am »
Most likely will remove custom fields searching for the next update not sure what is causing works on my site.
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: 16463
    • View Profile
Re: [2.5] Error search custom fields
« Reply #14 on: August 16, 2009, 12:06:08 am »
Removed in 2.5.2
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
1 Replies
4653 Views
Last post November 17, 2006, 08:45:39 pm
by SMFHacks
0 Replies
3891 Views
Last post May 15, 2009, 03:14:14 am
by Darkshadow
0 Replies
3831 Views
Last post July 22, 2011, 05:02:43 am
by Xtreme4U2NV
1 Replies
2442 Views
Last post February 15, 2016, 12:10:48 pm
by SMFHacks
6 Replies
5950 Views
Last post April 12, 2016, 10:01:24 am
by bknapp

+- Recent Topics

Attachment images Upsidedown or Sideways by SMFHacks
June 18, 2024, 10:53:24 am

JSON decode error: The maximum stack depth has been exceeded by SMFHacks
June 14, 2024, 10:15:16 pm

“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

Powered by EzPortal