Application Error #401 Database Query Failed
Post a reply 13 posts • Page 1 of 1 Reply with quote Application Error #401 by fredckp » Jun 01, 2005 12:56 am Hi, Need some help here.. I just installed 1.0.0a3 on a RedHat server. I managed to login to administrator account, with an error prompt stated below. I got the same error when accessing My View, View Issues, Manage Custom Views. Please kindly advise. Thanks. Cheers, Fred APPLICATION ERROR #401 Database query failed. Error received from database was #1064: You have an error in your SQL syntax near 'on cft.id = cfpt.field_id JOIN mantis_project_table as pt on' at line 3 for the query: SELECT distinct cft.id as id, cft.name as name FROM mantis_custom_field_table as cft JOIN mantis_custom_field_project_table as cfpt on cft.id = cfpt.field_id JOIN mantis_project_table as pt on cfpt.project_id = pt.id LEFT JOIN mantis_project_user_list_table as pult on cfpt.project_id = pult.project_id and pult.user_id = 2 JOIN mantis_user_table as ut on ut.id = 2 WHERE pt.view_state = 10 OR ( pt.view_state = 50 and pult.user_id = 2 ) OR ( pult.user_id is null and ut.access_level >= 90 ) ORDER BY name ASC Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section. fredckp Posts: 4Joined: Jun 01, 2005 12:50 am Top Reply with quote Same problem here by mivaca » Jun 01, 2005 6:21 pm Hello: I have just finished an Upgrade from 0.19 to 1.0.0a3 on a Fedora Core 3 system, executed ALL the upgrade scripts WITHOUT getting errors. The moment I log on with any account that was previously working, I get the following error message every time I try to "view issues" or acces "my view" or "manage custom views". Any help will be greatly appreciated. Thanks. Marco V. APPLICATION ERROR #401 Database query failed. Error received from database was #1064: You have an error in your SQL
- LinkedCustomFields Plugin - MachineAD Plugin - MantisTouchRedirect Plugin - RecurrCall Plugin - RelatedIssuesExport Plugin - Reminder Plugin - Tasks Plugin - Time Tracking 2016-09-30 18:45 EDT My View View Issues Change Log Roadmap Wiki Repositories View Issue Details[Jump to Notes] [Wiki] [Issue History] [Print] IDProjectCategoryView StatusDate SubmittedLast Update0007064mantisbtlocalizationpublic2006-05-09 04:372009-06-23 15:28ReporterqyhAssigned TosiebrandPrioritynormalSeveritymajorReproducibilityalwaysStatusclosedResolutionfixedProduct Version1.0.3Target VersionFixed in Version1.2.0rc1Summary0007064: [zh_TW] APPLICATION ERROR 0000401 Database query failed. Error received from database was #1406:DescriptionEvery time http://www.mantisbt.org/forums/viewtopic.php?t=379 when I set language to chinese in Account Preferences, I can not report issue with chinese content. I will met an information like this : "APPLICATION ERROR 0000401 Êý¾Ý¿â²éѯʧ°Ü¡£Êý¾Ý¿â·µ»ØµÄ´íÎóÐÅÏ¢ÊÇ£º#1406: Data too long for column 'description' at row 1 ²éѯ£ºINSERT INTO mantis_bug_text_table ( description, steps_to_reproduce, additional_information ) VALUES ( 'ºó', '', '×óÓÒ' https://www.mantisbt.org/bugs/view.php?id=7064 ) ÇëÔÚÄãµÄä¯ÀÀÆ÷ÖÐʹÓá°ºóÍË¡±°´Å¥À´·µ»Øµ½ÉÏÒ»Ò³Ã棬ÕâÑùÄú¿ÉÒÔÕÒµ½·¢ÉúÁËʲôÎÊÌâ»òÕß½øÐбðµÄ²Ù×÷£»Äú»¹¿ÉÒÔµã»÷µ¼º½À¸ÖеÄÑ¡ÏîÖ±½ÓÌøתµ½Ò»¸öеÄÇø¶Î¡£" The important thing is that I set values to ( description, steps_to_reproduce, additional_information ) as ( 'Ç°', 'ºó','×óÓÒ' ). It feedback as ( 'ºó', '', '×óÓÒ' ). Only one time after I set language to english in Account Preferences, I recieve an error information as "Database query failed. Error received from database was #1406: Data too long for column 'description' at row 1 for the query: INSERT INTO mantis_bug_text_table ( description, steps_to_reproduce, additional_information ) VALUES ( 'åŽ', '', '塤¦å³' )" , with the same input. Additional InformationThe configuration of my server is : windows XP, IIS5.1, MySQL 5.0.20, php5.1.2. I insert and select some chinese word of gb2312 in my MySQL 5.0.20.It works correctly.TagsNo tags attached.Attached Files Relationships Relationships Notes ~0012802 qyh (reporter) 2006-05-09 23:34 I made a mistake in the sentence"The important thing is that I set values to ( description, steps_to_reproduce, additional_information ) as ( 'Ç°', 'ºó','×óÓÒ'
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/9095328/mantis-installing-error-on-mysql of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges https://forum.kde.org/viewtopic.php?f=265&t=119368 Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: application error Sign up Mantis Installing Error on Mysql up vote 1 down vote favorite I tried to install the latest version of Mantis, but i keep getting this error: APPLICATION ERROR #401 Database query failed. Error received from database was #1146: Table 'user_mantis.mantis_user_table' doesn't exist for the query: SELECT * FROM mantis_user_table WHERE username=?. Please use the "Back" button in your web browser to application error #401 return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section. Im sure about the database credentials, i cant figure out what else would it be. Appreciate your help! mysql installation mantis share|improve this question asked Feb 1 '12 at 11:53 Waleed Asender 565621 Can you add some more information like operating system, MySQL version, PHP version and your config_inc.php file? –Robert Munteanu Feb 1 '12 at 12:45 2 Check manually in the database, if you have a user_mantis.mantis_user_table? –Nishant Feb 1 '12 at 12:46 To add to that, I'd make sure that mantis_user_table does indeed belong to the user_mantis schema. That table may exist but on another schema. –Ben English Feb 1 '12 at 20:01 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted You can find the solution at the below mentioned link http://www.mantisbt.org/forums/viewtopic.php?t=19060&p=43806 Let me know if this works for you. share|improve this answer answer
search Information The requested topic does not exist. Board index New Topic Find a Solution KDE Links Top Top The team • Delete all board cookies Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group © Copyright 2012 KDE Community Forum Team. All rights reserved.KDE Community Forums has no liability for any content or post. All messages belong to and are the opinion of their respective authors.KDE and K Desktop Environment are trademarks of KDE e.V. • For more details, contact the Forum Administrators.