Welcome to Geeklog, Anonymous Thursday, April 25 2024 @ 05:28 pm EDT

Geeklog Forums

Errors editing file information in filemgmt 1.3. Can it be done?


Status: offline

DPuett

Forum User
Newbie
Registered: 07/11/04
Posts: 3
I've have a few files uploaded and I wanted to keep the entries but edit the information like version number or update the description.

I keep getting SQL errors..

The message on the screen is "An SQL error has occured. Please see error.log for details."

I tried just editing the info but I would get this error log entry "Tue Nov 23 14:27:48 2004 - Currentfilename is:'ActiveServer_Setup.exe' and new file is:''

So I would re-upload the file.

Anyone have any ideas how to edit the entries or do I need to create new entries every time?

Here are the log entries.

Tue Nov 23 13:23:55 2004 - 1064: 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 ' title='Active Server (includes EmpInfo)', url='ActiveServer_Se. SQL in question: UPDATE gl_filemgmt_filedetail SET cid=, title='Active Server (includes EmpInfo)', url='ActiveServer_Setup.exe', homepage='http://www.activebiometrics.com/staticpages/index.php?page=20041011115414784', version='1.5', size=2479400,status=1, date=1101245035, comments=0 WHERE lid=2

Tue Nov 23 13:30:47 2004 - Currentfilename is:'ActiveServer_Setup.exe' and new file is:'ActiveServer_Setup.exe'

Tue Nov 23 13:30:47 2004 - 1064: 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 ' title='Active Server (includes EmpInfo)', url='ActiveServer_Se. SQL in question: UPDATE gl_filemgmt_filedetail SET cid=, title='Active Server (includes EmpInfo)', url='ActiveServer_Setup.exe', homepage='http://www.activebiometrics.com/staticpages/index.php?page=20041011115414784', version='1.5', size=2479400,status=1, date=1101245447, comments=0 WHERE lid=2

Tue Nov 23 13:34:27 2004 - Currentfilename is:'ActiveServer_Setup.exe' and new file is:'ActiveServer_Setup.exe'

Tue Nov 23 13:34:27 2004 - 1064: 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 ' title='Active Server includes EmpInfo', url='ActiveServer_Setu. SQL in question: UPDATE gl_filemgmt_filedetail SET cid=, title='Active Server includes EmpInfo', url='ActiveServer_Setup.exe', homepage='http://www.activebiometrics.com/staticpages/index.php?page=20041011115414784', version='1.5', size=2479400,status=1, date=1101245667, comments=0 WHERE lid=2

Tue Nov 23 14:27:48 2004 - Currentfilename is:'ActiveServer_Setup.exe' and new file is:''

Tue Nov 23 14:27:48 2004 - 1064: 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 ' title='Active Server', url='ActiveServer_Setup.exe', homepage=. SQL in question: UPDATE gl_filemgmt_filedetail SET cid=, title='Active Server', url='ActiveServer_Setup.exe', homepage='http://www.activebiometrics.com/staticpages/index.php?page=20041011115414784', version='1.5', size=2479400,status=1, date=1101248868, comments=0 WHERE lid=2

Tue Nov 23 15:18:18 2004 - Currentfilename is:'ActiveServer_Setup.exe' and new file is:'ActiveServer_Setup.exe'

Tue Nov 23 15:18:18 2004 - 1064: 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 ' title='Active Server', url='ActiveServer_Setup.exe', homepage=. SQL in question: UPDATE gl_filemgmt_filedetail SET cid=, title='Active Server', url='ActiveServer_Setup.exe', homepage='http://www.activebiometrics.com/staticpages/index.php?page=20041011115414784', version='1.5', size=2479400,status=1, date=1101251898, comments=0 WHERE lid=2
 Quote

All times are EDT. The time is now 05:28 pm.

  • 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