View Issue Details

IDProjectCategoryView StatusLast Update
0012880mantisbtsecuritypublic2016-11-07 17:25
Reportermklimek Assigned Todregad  
PriorityurgentSeveritycrashReproducibilityalways
Status closedResolutionunable to reproduce 
PlatformLinuxOSCentOSOS Version5.5
Summary0012880: #<long number> in summary/description cause crash
Description

Typing #<very long number> or ~<very long number> in task description crashes view.php. Same with ~<very long number>. Same for notes.

What worse, typing this into task summary cause view_all_bug_page crash - project view.

Error:

APPLICATION ERROR 0000401
Database query failed. Error received from database was #-1: ERROR: value "2342341242345123432" is out of range for type integer for the query: SELECT *
FROM mantis_bug_table
WHERE id=?.

Or:

APPLICATION ERROR 0000401
Database query failed. Error received from database was #-1: ERROR: value "423412423423423" is out of range for type integer for the query: SELECT COUNT(*)
FROM mantis_bugnote_table
WHERE id=?.

Additional Information

Used database: Postgresql
MantisBT version: 1.2.3

TagsNo tags attached.

Relationships

duplicate of 0014014 closeddregad Search with number > 2147483647 fails on 64-bit systems with PostgreSQL 
related to 0021802 closedcproensa Attempting to auto-link very long numbers can cause database errors 

Activities

macarbiter

macarbiter

2011-05-12 06:13

reporter   ~0028774

We've also just run into this problem.

A temporary fix is to change the type of the id column in the mantis_bugnote_table table to a bigint so that at least the query works.

Is there any timeline on when this will be fixed?

dregad

dregad

2012-02-08 03:38

developer   ~0031191

I was unable to reproduce the crash as described.
Tried on mysql and pgsql, with both 1.2.3 release and latest trunk.

If problem persists, please reopen and provide additional information that may help reproducing it.