Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 02:10 am EDT

Geeklog Forums

Filemgmt - update problem - SQL


bedek

Anonymous
I'cant update file name, version etc in file wich i've uploaded earlier. I get error on the site: 1064: You have an error in your SQL syntax near ' title='Próba 23 kw.', url='zupki.jpg', homepage='bedek.ods.org', version='1', s' at line 1 and error in error.log 1064: You have an error in your SQL syntax near ' title='Próba 23 kw.', url='zupki.jpg', homepage='bedek.ods.org', version='1' , s' at line 1 SQL in question: UPDATE gl_filemgmt_filedetail SET cid=, title='Próba 23 kw.', url='zupki.jpg', homepage='bedek.ods.org', version='1', size=782675, logourl='zupki.jpg', status=1, date=1051323291, comments= WHERE lid=9
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
You are only seeing part of the error message on the screen. The complete SQL error message is in the geeklog error.log file. It would appear to be a quote issue - where a non escaped quote is in the data.
Geeklog components by PortalParts -- www.portalparts.com
 Quote

Status: offline

Agent X20

Forum User
Junior
Registered: 06/11/03
Posts: 27
I\'ve seen the same problem. Basically the filemgmt plugin allows apostrophes in the file\'s title and then tries to use this in various SQL calls with the obvious results. I\'ve posted a comment about this over at the author\'s site but have had no response to date (after a week or so). Also, the code required to properly hack in the filemgmt comments into comment.php has also changed as of 1.3.8 so I\'m hoping there\'ll be an updated release soon (otherwise I\'m gonna have to hack things about myself which I\'m not so keen on).
 Quote

All times are EDT. The time is now 02:10 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content