View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0008865mantisbtdb mysqlpublic2008-02-07 19:172008-04-19 04:10
Reporteropi Assigned Tojreese  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version1.2.0a1 
Summary0008865: Wrong format for insert into Database
Description

I use the lastest SVN.
If i try to upload a File i get folow errormessage:
APPLICATION ERROR 0000401

Database query failed. Error received from database was 0001064: 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 '15:55:06, '')' at line 4 for the query: INSERT INTO mantis_bug_file_table
(bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content)
VALUES
(41, '', '', '../uploads/b995b47223fb01231181968491d8e585', 'index.html.ori', '../uploads/', 1147, 'text/plain', 2008-02-07 15:55:06, '')

The cuse seems to be that here the ' are missed around the Fileupload Date/Time.

I hope you can fix that ASAP
TIA
Frank (Opi) Weber

Steps To Reproduce

Try to upload a File...

TagsNo tags attached.

Activities

jreese

jreese

2008-02-07 22:22

reporter   ~0016975

Committed fix to trunk svn r4969.

Related Changesets

MantisBT: master 3d0be3f9

2008-02-07 22:20

jreese


Details Diff		 Fix bug 0008865: unquoted db_now() in SQL query.

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@4969 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9		 Affected Issues
0008865
mod - core/file_api.php Diff File