Posted on: 04/25/03 10:16pm
By: Anonymous (bedek)
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
Filemgmt - update problem - SQL
Posted on: 04/26/03 11:34am
By: Blaine
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.
Re:Filemgmt - update problem - SQL
Posted on: 07/20/03 06:41am
By: Agent X20
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).