Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 193
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 200
Total: 200

Author Topic: Many errors...  (Read 9465 times)

0 Members and 1 Guest are viewing this topic.

Offline vkot

  • Full Member
  • ***
  • Posts: 136
    • View Profile
Many errors...
« on: May 06, 2010, 05:02:51 am »
I have many of the following errors in my SMF's error logs:

Quote
http://xxx.xxx.xxx/index.php?action=classifieds;sa=editlisting2
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 'WHERE l.ID_TAG = t.ID_TAG AND l.ID_LISTING = '15302' AND t.tag = 'Korg'' at line 2
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 7989
Quote
http://xxx.xxx.xxx/index.php?action=classifieds;sa=listingfiles;id=
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 '' at line 4
File: /xxxxxx/forum/httpdocs/Sources/Load.php(2087) : eval()'d code
Line: 2360
Quote
8: Undefined index: new
File: /xxxxxx/forum/httpdocs/cache/lang_classifieds_greek_default.php (main sub template - eval?)
Line: 250
Quote
http://xxx.xxx.xxx/index.php?action=classifieds&sa=delpic2
8: Undefined index: id
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 3528
Quote
http://xxx.xxx.xxx/index.php?action=classifieds;sa=listall;type=recent
8: Undefined variable: orderby2
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 6241
Quote
http://xxx.xxx.xxx/index.php?action=classifieds;sa=listall;type=recent
8: Undefined variable: sortby2
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 6241
Quote
http://xxx.xxx.xxx/index.php?action=classifieds;sa=memberlistings;id=14990
8: Undefined index: class_listall_type
File: /xxxxxx/forum/httpdocs/Themes/default/classifieds2.template.php (member_listings sub template - eval?)
Line: 7220

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Many errors...
« Reply #1 on: May 08, 2010, 12:14:15 am »
Fixed for 1.3.5 should be out in the next couple days
1.3.5
!Fixed possible keyword sql error on updating a listing.
!Fixed undefined error on sort change for member listings for SMF 2.0
!Added some other checking to prevent some undefined error
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 vkot

  • Full Member
  • ***
  • Posts: 136
    • View Profile
Re: Many errors...
« Reply #2 on: April 17, 2013, 12:05:17 am »
There is a problem with the apostrophes in a SQL query, it seems they are not escaped. I have a few of messages like these in my logs. All of them have an apostrophe in the query.

Quote
http://xxxxx/index.php?action=classifieds;sa=addlisting2
Σφάλμα βάσης δεδομένων: 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 'jimjj55's media' - s1207_photobucket_com_user_jimjj55_media_Fender%20New%20CS%20' at line 3
Αρχείο: /xxxxx/forum/httpdocs/Sources/classifieds2.php
Γραμμή: 9350

My SMF Classifieds version is 2.0.11
« Last Edit: April 22, 2013, 06:28:44 am by vkot »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Many errors...
« Reply #3 on: April 17, 2013, 09:47:23 am »
Is that when you add the it in the listing description?
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 vkot

  • Full Member
  • ***
  • Posts: 136
    • View Profile
Re: Many errors...
« Reply #4 on: April 21, 2013, 05:53:06 am »
The errors appeared from something that the users did. I am sorry, I could not reproduce it, I tried apostrophes in title, bodu text, image filename, and it works ok.
If I'll get more of there messages, I'll inform you.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Many errors...
« Reply #5 on: April 21, 2013, 07:55:24 am »
Ok yeah I was trying the same thing will look into some more too.
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: 16436
    • View Profile
Re: Many errors...
« Reply #6 on: April 21, 2013, 08:18:14 am »
Think I figured it out. Issue was with image name of uploaded image. Have fixed for next major 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/

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
14667 Views
Last post December 04, 2007, 09:27:54 pm
by SMFHacks
2 Errors

Started by m.ehm Support

1 Replies
2334 Views
Last post April 06, 2014, 11:01:10 pm
by SMFHacks
Errors

Started by Madirex Bugs

0 Replies
4478 Views
Last post February 18, 2016, 10:46:16 am
by Madirex
5 Replies
2525 Views
Last post March 11, 2019, 08:31:47 am
by Ken.
3 Replies
1485 Views
Last post February 05, 2021, 08:52:51 am
by SMFHacks

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

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

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

Powered by EzPortal