Application Error #401 Mssql
- LinkedCustomFields Plugin - MachineAD Plugin - MantisTouchRedirect Plugin - RecurrCall Plugin - RelatedIssuesExport Plugin - Reminder Plugin - Tasks Plugin - Time Tracking 2016-09-30 18:47 EDT My View View Issues Change Log Roadmap Wiki Repositories View Issue Details[Jump to Notes] [Wiki] [Issue History] [Print] IDProjectCategoryView StatusDate SubmittedLast Update0005904mantisbtdb mssqlpublic2005-07-08 06:212014-05-16 15:00Reporterdavide73italyAssigned TograngewayPrioritynormalSeveritymajorReproducibilityalwaysStatusclosedResolutionno change requiredProduct Versiongit trunkTarget VersionFixed in VersionSummary0005904: Application error 0000401 only when using MSSQLDescriptionI use MSSQL SP4; when I log in, Mantis gives me this error: APPLICATION ERROR 0000401 Database query failed. Error received from database was #0: for the query: UPDATE mantis_user_table SET login_count=login_count+1 WHERE id='1' 1) This query is correct; I have tried this query with Microsoft Query Analyzer and it's ok: no error! 2) The field login_count is increased; probably the mistake is in the return value of some function. TagsNo tags attached.Attached Files Relationships has duplicate0005905closedthraxispApplication error 0000401 only when using MSSQL Relationships Notes ~0010691 davide73italy (reporter) 2005-07-08 06:29 Sorry this is a SQL issue, not webpage Please, update it Thank you ~0010695 NicoleC (reporter) 2005-07-08 12:35 I had this error but resolved it with a change to the table. If I recall correctly, I had to switch the field login_count to type int. ~0010705 davide73italy (reporter) 2005-07-10 21:21 login_count in mantis_user_table is already an int ~0010720 grangeway (reporter) 2005-07-11 17:51 David, i assume it's you that emailed me.. I'm trying to think as I think i've seen this before - what adodb d
5 hours Powered by phpBB Forum Software © phpBB Group
Version1.0.0rc1Target VersionFixed in Version1.1.0a4Summary0006063: APPLICATION ERROR /bugs/view.php?id=401 on MSSQL while uploading filesDescriptionDatabase query failed. Error received from database was 0000206: Operand type clash: text is incompatible with image for the query: INSERT INTO mantis_bug_file_table (bug_id, title, description, https://www.mantisbt.org/bugs/print_bug_page.php?bug_id=6063 diskfile, filename, folder, filesize, file_type, date_added, content) VALUES (208, '', '', 'F:\wwwroot\Mantis\Uploads\TestProject\b994e1a4136c05dbde9527e042aa8e81', 'nt4cmd.txt', 'F:\wwwroot\Mantis\Uploads\TestProject\', 14285, 'text/plain', '2005-08-01 02:14:50PM', 'Q:\LOAD\nt4D\I386... etc etc rest of file.Additional InformationTried uploading attached file to DB and recieved above error. This file is just reference for commands on NT4 installations. Mantis Reads the application error internal of the file and errors with this. Using Windows 2003, php4.3, MSSQL 2000 SP3. This is relevant to the same issue I had before only this time I am getting a different error message TagsNo tags attached.Relationshipshas duplicate0007297closedvboctorError in database when trying to attach a filerelated to0008867closedryandesignAPPLICATION application error #401 ERROR 0000401 while uploading files into MySQLAttached Filesnt4cmd.txt (14,285) 2005-08-01 17:21https://www.mantisbt.org/bugs/file_download.php?file_id=815&type=bug Notes (0011043) griddly 2005-08-01 17:23 This same issue occurs with ZIP files with VBS inside them. not sure if there is a setting that can be changed. am willing to look if anyone has suggestions though. (0011044) griddly 2005-08-01 17:41 changed setting in config_defaults from disk to database and got this..... Database query failed. Error received from database was 0000206: Operand type clash: text is incompatible with image for the query: INSERT INTO mantis_bug_file_table (bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content) VALUES (208, '', '', ' f61746954a195cfb7553f9822f4f0836', 'nt4cmd.txt', ' ', 14285, 'text/plain', '2005-08-01 02:38:03PM', 'Q:\LOAD\nt4D\I386\winnt32.exe /s:Q:\LOAD\nt4D\I386 /u:B:\unattend.txt (0011062) griddly 2005-08-02 14:59 (Last edited: 2005-08-11 17:29) Ok, been doing a little research, created duplicate table mantis_bug_file_table and changed 'Content' column from Image to Text. this resolved the upload issu