View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0019294mantisbtdb schemapublic2015-01-28 02:582015-02-14 05:17
Reportertherubyguy Assigned Todregad  
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionno change required 
OSUNIX 
Product Version1.2.19 
Summary0019294: Unable to Update Issues: Migration Issue
Description

So I just migrated to from 2007 Mantis to the newest version of Mantis. Of course this was a bit of a jump from legacy from current but most of the DB seems to check out for the most part.

I can submit new issues, add notes and all the views are visible as well. The only issue is once an issue is reported I can't seem to update it. New issues can be created, but not updated. I receive this issue:

"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 '
due_date=1482451200
WHERE id=1321' at line 15 for the query: UPDATE mantis_bug_table
SET project_id=?, reporter_id=?,
handler_id=?, duplicate_id=?,
priority=?, severity=?,
reproducibility=?, status=?,
resolution=?, projection=?,
category_id=?, eta=?,
os=?, os_build=?,
platform=?, version=?,
build=?, fixed_in_version=?,
target_version=?,
view_state=?,
summary=?,
sponsorship_total=?,
sticky=?,
due_date=?
WHERE id=?."

I'm assuming that the issue is related to the due_date field. I enable viewing of that field and originally all the dates in that field were set to 1 in my Database. I manually updated all of the due dates to equal 1482451200 (arbitrary date).

Tell me if there's any other config you need. I also enabled the viewing of due dates in my config just to test if I could manually force it through mantis and confirm it wasn't the issue.

Steps To Reproduce

Have unedited configured legacy mantis from 2007. Update the mantis and run the script from mantisdirectoy/admin/install.php.

Once it is confirmed to run successfully check schema. Change the due date field from 1 to
1482451200 or other arbitrary date in the DB.

Update a random issue. Will not update and throws said error.

TagsNo tags attached.
Attached Files
MantisBT.html (8,419 bytes)    
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0041)myur/bugs/bug_update.php -->
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<link rel="stylesheet" type="text/css" href="./MantisBT_files/default.css">
	<script type="text/javascript"><!--
		if(document.layers) {document.write("<style>td{padding:0px;}<\/style>")}
	// --></script>
	
	<meta http-equiv="Pragma" content="no-cache">
	<meta http-equiv="Cache-Control" content="no-cache">
	<meta http-equiv="Pragma-directive" content="no-cache">
	<meta http-equiv="Cache-Directive" content="no-cache">
	<meta http-equiv="Expires" content="Wed, 28 Jan 2015 17:04:05 GMT">
	<link rel="shortcut icon" href="myurl/bugs/images/favicon.ico" type="image/x-icon">
	<link rel="search" type="application/opensearchdescription+xml" title="MantisBT: Text Search" href="myurl/bugs/browser_search_plugin.php?type=text">	<link rel="search" type="application/opensearchdescription+xml" title="MantisBT: Issue Id" href="myurl/bugs/browser_search_plugin.php?type=id">	<title>MantisBT</title>
<script type="text/javascript" src="./MantisBT_files/common.js"></script>
<script type="text/javascript">var loading_lang = "Loading...";</script><script type="text/javascript" src="./MantisBT_files/ajax.js"></script>
<style type="text/css"></style><style id="style-1-cropbar-clipper">/* Copyright 2014 Evernote Corporation. All rights reserved. */
.en-markup-crop-options {
    top: 18px !important;
    left: 50% !important;
    margin-left: -100px !important;
    width: 200px !important;
    border: 2px rgba(255,255,255,.38) solid !important;
    border-radius: 4px !important;
}

.en-markup-crop-options div div:first-of-type {
    margin-left: 0px !important;
}
</style></head>
<body cz-shortcut-listen="true">
<div align="left"><a href="myurl/bugs/my_view_page.php"><img border="0" alt="MantisBT" src="./MantisBT_files/mantis_logo.png"></a></div><br><div align="center"><table class="width50" cellspacing="1"><tbody><tr><td class="form-title">APPLICATION ERROR #401</td></tr><tr><td><p class="center" style="color:red">Database query failed. Error received from database was #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 '<br>
						due_date=1422605160<br>
					WHERE id=1327' at line 15 for the query: UPDATE mantis_bug_table<br>
					SET project_id=?, reporter_id=?,<br>
						handler_id=?, duplicate_id=?,<br>
						priority=?, severity=?,<br>
						reproducibility=?, status=?,<br>
						resolution=?, projection=?,<br>
						category_id=?, eta=?,<br>
						os=?, os_build=?,<br>
						platform=?, version=?,<br>
						build=?, fixed_in_version=?,<br>
						target_version=?,<br>
						view_state=?,<br>
						summary=?,<br>
						sponsorship_total=?,<br>
						sticky=?,<br>
						due_date=?<br>
					WHERE id=?.</p></td></tr><tr><td><p class="center">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.</p></td></tr><tr><td>		<center>
			<table class="width75">
				<tbody><tr>
					<td>Full path: /$mantisdirectory/core/database_api.php</td>
				</tr>
				<tr>
					<td>Line: 405</td>
				</tr>
				<tr>
					<td>
						<table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>p_query</td><td>UPDATE mantis_bug_table
					SET project_id=?, reporter_id=?,
						handler_id=?, duplicate_id=?,
						priority=?, severity=?,
						reproducibility=?, status=?,
						resolution=?, projection=?,
						category_id=?, eta=?,
						os=?, os_build=?,
						platform=?, version=?,
						build=?, fixed_in_version=?,
						target_version=?,
						view_state=?,
						summary=?,
						sponsorship_total=?,
						sticky=?,
						due_date=?
					WHERE id=?</td><td>string</td></tr>
<tr><td>p_limit</td><td>-1</td><td>integer</td></tr>
<tr><td>p_offset</td><td>-1</td><td>integer</td></tr>
<tr><td>g_db_log_queries</td><td></td><td>boolean</td></tr>
<tr><td>g_db_param_count</td><td>42</td><td>integer</td></tr>
<tr><td>t_db_type</td><td>mysql</td><td>string</td></tr>
<tr><td>s_check_params</td><td></td><td>boolean</td></tr>
<tr><td>t_result</td><td></td><td>boolean</td></tr>
<tr><td colspan="3" align="left"><br><strong>arr_parms</strong></td></tr><tr><td colspan="3"><table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td>8</td><td>integer</td></tr>
<tr><td>1</td><td>44</td><td>integer</td></tr>
<tr><td>2</td><td>44</td><td>integer</td></tr>
<tr><td>3</td><td>0</td><td>integer</td></tr>
<tr><td>4</td><td>30</td><td>integer</td></tr>
<tr><td>5</td><td>60</td><td>integer</td></tr>
<tr><td>6</td><td>10</td><td>integer</td></tr>
<tr><td>7</td><td>40</td><td>integer</td></tr>
<tr><td>8</td><td>10</td><td>integer</td></tr>
<tr><td>9</td><td>10</td><td>integer</td></tr>
<tr><td>10</td><td>16</td><td>integer</td></tr>
<tr><td>11</td><td>10</td><td>integer</td></tr>
<tr><td>12</td><td></td><td>string</td></tr>
<tr><td>13</td><td></td><td>string</td></tr>
<tr><td>14</td><td></td><td>string</td></tr>
<tr><td>15</td><td></td><td>string</td></tr>
<tr><td>16</td><td></td><td>string</td></tr>
<tr><td>17</td><td></td><td>string</td></tr>
<tr><td>18</td><td></td><td>string</td></tr>
<tr><td>19</td><td>10</td><td>integer</td></tr>
<tr><td>20</td><td>Unable to Update Issues</td><td>string</td></tr>
<tr><td>21</td><td>0</td><td>string</td></tr>
<tr><td>22</td><td></td><td>boolean</td></tr>
<tr><td>23</td><td>1422605160</td><td>integer</td></tr>
<tr><td>24</td><td>1327</td><td>integer</td></tr>
</tbody></table></td></tr><tr><td colspan="3" align="left"><br><strong>g_queries_array</strong></td></tr><tr><td colspan="3"><table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td>1</td><td>integer</td></tr>
<tr><td>1</td><td>1</td><td>integer</td></tr>
<tr><td>2</td><td>1</td><td>integer</td></tr>
<tr><td>3</td><td>1</td><td>integer</td></tr>
<tr><td>4</td><td>1</td><td>integer</td></tr>
<tr><td>5</td><td>1</td><td>integer</td></tr>
<tr><td>6</td><td>1</td><td>integer</td></tr>
<tr><td>7</td><td>1</td><td>integer</td></tr>
<tr><td>8</td><td>1</td><td>integer</td></tr>
<tr><td>9</td><td>1</td><td>integer</td></tr>
<tr><td>10</td><td>1</td><td>integer</td></tr>
<tr><td>11</td><td>1</td><td>integer</td></tr>
<tr><td>12</td><td>1</td><td>integer</td></tr>
<tr><td>13</td><td>1</td><td>integer</td></tr>
<tr><td>14</td><td>1</td><td>integer</td></tr>
</tbody></table></td></tr></tbody></table>					</td>
				</tr>
			</tbody></table>
		</center>
</td></tr><tr><td><center><table class="width75"><tbody><tr><th>Filename</th><th>Line</th><th></th><th></th><th>Function</th><th>Args</th></tr><tr class="row-1"><td>/$mantisdirectory/core/database_api.php</td><td>405</td><td>-</td><td>-</td><td>trigger_error</td><td>( &lt;string&gt;'401', &lt;integer&gt;256 )</td></tr><tr class="row-2"><td>/$mantisdirectory/core/bug_api.php</td><td>453</td><td>-</td><td>-</td><td>db_query_bound</td><td>( &lt;string&gt;'UPDATE mantis_bug_table
					SET project_id=?, reporter_id=?,
						handler_id=?, duplicate_id=?,
						priority=?, severity=?,
						reproducibility=?, status=?,
						resolution=?, projection=?,
						category_id=?, eta=?,
						os=?, os_build=?,
						platform=?, version=?,
						build=?, fixed_in_version=?,
						target_version=?,
						view_state=?,
						summary=?,
						sponsorship_total=?,
						sticky=?,
						due_date=?
					WHERE id=?', &lt;Array&gt; { [0] =&gt; 8, [1] =&gt; 44, [2] =&gt; 44, [3] =&gt; 0, [4] =&gt; 30, [5] =&gt; 60, [6] =&gt; 10, [7] =&gt; 40, [8] =&gt; 10, [9] =&gt; 10, [10] =&gt; 16, [11] =&gt; 10, [12] =&gt; '', [13] =&gt; '', [14] =&gt; '', [15] =&gt; '', [16] =&gt; '', [17] =&gt; '', [18] =&gt; '', [19] =&gt; 10, [20] =&gt; 'Unable to Update Issues', [21] =&gt; '0', [22] =&gt; false, [23] =&gt; 1422605160, [24] =&gt; 1327 } )</td></tr><tr class="row-1"><td>/$mantisdirectory/bug_update.php</td><td>230</td><td>BugData</td><td>-&gt;</td><td>update</td><td>( &lt;boolean&gt;true, &lt;boolean&gt;false )</td></tr></tbody></table></center></td></tr></tbody></table></div>

</body></html>
MantisBT.html (8,419 bytes)   
due_date.csv (19,857 bytes)    
id,due_date
1,1482451200
112,1482451200
3,1482451200
4,1482451200
5,1482451200
6,1482451200
7,1482451200
8,1482451200
9,1482451200
111,1482451200
11,1482451200
12,1482451200
13,1482451200
14,1482451200
15,1482451200
16,1482451200
17,1482451200
18,1482451200
19,1482451200
20,1482451200
110,1482451200
22,1482451200
23,1482451200
24,1482451200
25,1482451200
26,1482451200
27,1482451200
28,1482451200
29,1482451200
30,1482451200
31,1482451200
32,1482451200
33,1482451200
34,1482451200
35,1482451200
36,1482451200
37,1482451200
38,1482451200
41,1482451200
40,1482451200
42,1482451200
43,1482451200
44,1482451200
45,1482451200
46,1482451200
47,1482451200
48,1482451200
49,1482451200
50,1482451200
51,1482451200
52,1482451200
53,1482451200
54,1482451200
55,1482451200
56,1482451200
57,1482451200
58,1482451200
59,1482451200
60,1482451200
61,1482451200
62,1482451200
63,1482451200
64,1482451200
65,1482451200
66,1482451200
67,1482451200
68,1482451200
69,1482451200
70,1482451200
71,1482451200
72,1482451200
73,1482451200
74,1482451200
75,1482451200
76,1482451200
77,1482451200
78,1482451200
79,1482451200
189,1482451200
80,1482451200
81,1482451200
82,1482451200
83,1482451200
84,1482451200
85,1482451200
86,1482451200
87,1482451200
88,1482451200
89,1482451200
90,1482451200
91,1482451200
92,1482451200
93,1482451200
94,1482451200
95,1482451200
96,1482451200
98,1482451200
99,1482451200
100,1482451200
102,1482451200
103,1482451200
104,1482451200
105,1482451200
106,1482451200
107,1482451200
109,1482451200
191,1482451200
113,1482451200
114,1482451200
115,1482451200
116,1482451200
117,1482451200
118,1482451200
119,1482451200
120,1482451200
121,1482451200
122,1482451200
123,1482451200
124,1482451200
125,1482451200
126,1482451200
127,1482451200
128,1482451200
129,1482451200
130,1482451200
131,1482451200
132,1482451200
133,1482451200
134,1482451200
135,1482451200
136,1482451200
137,1482451200
138,1482451200
139,1482451200
140,1482451200
141,1482451200
142,1482451200
143,1482451200
144,1482451200
145,1482451200
146,1482451200
147,1482451200
148,1482451200
149,1482451200
150,1482451200
151,1482451200
152,1482451200
153,1482451200
154,1482451200
155,1482451200
156,1482451200
157,1482451200
158,1482451200
159,1482451200
160,1482451200
161,1482451200
162,1482451200
163,1482451200
164,1482451200
165,1482451200
166,1482451200
167,1482451200
168,1482451200
169,1482451200
170,1482451200
171,1482451200
172,1482451200
173,1482451200
174,1482451200
175,1482451200
176,1482451200
190,1482451200
177,1482451200
178,1482451200
179,1482451200
180,1482451200
181,1482451200
182,1482451200
183,1482451200
184,1482451200
185,1482451200
186,1482451200
187,1482451200
188,1482451200
192,1482451200
193,1482451200
194,1482451200
195,1482451200
196,1482451200
197,1482451200
198,1482451200
199,1482451200
200,1482451200
201,1482451200
202,1482451200
203,1482451200
204,1482451200
205,1482451200
206,1482451200
207,1482451200
208,1482451200
209,1482451200
210,1482451200
211,1482451200
212,1482451200
213,1482451200
214,1482451200
215,1482451200
216,1482451200
217,1482451200
218,1482451200
219,1482451200
220,1482451200
221,1482451200
222,1482451200
223,1482451200
224,1482451200
225,1482451200
226,1482451200
227,1482451200
228,1482451200
229,1482451200
230,1482451200
231,1482451200
232,1482451200
233,1482451200
234,1482451200
235,1482451200
236,1482451200
237,1482451200
238,1482451200
239,1482451200
240,1482451200
241,1482451200
242,1482451200
243,1482451200
244,1482451200
245,1482451200
246,1482451200
247,1482451200
248,1482451200
249,1482451200
250,1482451200
251,1482451200
254,1482451200
255,1482451200
256,1482451200
257,1482451200
258,1482451200
259,1482451200
260,1482451200
261,1482451200
262,1482451200
263,1482451200
272,1482451200
264,1482451200
265,1482451200
266,1482451200
267,1482451200
268,1482451200
269,1482451200
270,1482451200
271,1482451200
273,1482451200
274,1482451200
275,1482451200
276,1482451200
277,1482451200
278,1482451200
390,1482451200
279,1482451200
280,1482451200
281,1482451200
282,1482451200
283,1482451200
284,1482451200
285,1482451200
286,1482451200
287,1482451200
288,1482451200
289,1482451200
290,1482451200
291,1482451200
292,1482451200
293,1482451200
294,1482451200
295,1482451200
296,1482451200
297,1482451200
298,1482451200
301,1482451200
300,1482451200
302,1482451200
303,1482451200
304,1482451200
305,1482451200
306,1482451200
307,1482451200
308,1482451200
309,1482451200
310,1482451200
311,1482451200
312,1482451200
313,1482451200
314,1482451200
315,1482451200
316,1482451200
317,1482451200
318,1482451200
319,1482451200
320,1482451200
321,1482451200
342,1482451200
322,1482451200
323,1482451200
324,1482451200
325,1482451200
326,1482451200
327,1482451200
328,1482451200
329,1482451200
330,1482451200
331,1482451200
332,1482451200
333,1482451200
334,1482451200
335,1482451200
336,1482451200
337,1482451200
338,1482451200
339,1482451200
340,1482451200
341,1482451200
343,1482451200
344,1482451200
345,1482451200
346,1482451200
347,1482451200
348,1482451200
349,1482451200
350,1482451200
351,1482451200
352,1482451200
353,1482451200
354,1482451200
355,1482451200
356,1482451200
357,1482451200
358,1482451200
359,1482451200
360,1482451200
361,1482451200
362,1482451200
363,1482451200
364,1482451200
365,1482451200
366,1482451200
367,1482451200
368,1482451200
369,1482451200
370,1482451200
371,1482451200
372,1482451200
373,1482451200
374,1482451200
375,1482451200
376,1482451200
377,1482451200
378,1482451200
379,1482451200
380,1482451200
381,1482451200
382,1482451200
383,1482451200
384,1482451200
385,1482451200
386,1482451200
387,1482451200
388,1482451200
389,1482451200
391,1482451200
392,1482451200
393,1482451200
394,1482451200
395,1482451200
409,1482451200
396,1482451200
397,1482451200
398,1482451200
399,1482451200
400,1482451200
401,1482451200
402,1482451200
403,1482451200
404,1482451200
405,1482451200
406,1482451200
407,1482451200
408,1482451200
410,1482451200
411,1482451200
412,1482451200
413,1482451200
414,1482451200
415,1482451200
416,1482451200
417,1482451200
418,1482451200
419,1482451200
420,1482451200
421,1482451200
422,1482451200
423,1482451200
424,1482451200
425,1482451200
426,1482451200
427,1482451200
428,1482451200
429,1482451200
430,1482451200
431,1482451200
432,1482451200
433,1482451200
434,1482451200
435,1482451200
436,1482451200
437,1482451200
438,1482451200
439,1482451200
440,1482451200
441,1482451200
442,1482451200
443,1482451200
444,1482451200
445,1482451200
446,1482451200
447,1482451200
448,1482451200
449,1482451200
450,1482451200
451,1482451200
452,1482451200
453,1482451200
454,1482451200
455,1482451200
458,1482451200
456,1482451200
457,1482451200
459,1482451200
460,1482451200
461,1482451200
462,1482451200
463,1482451200
464,1482451200
465,1482451200
466,1482451200
467,1482451200
489,1482451200
468,1482451200
469,1482451200
470,1482451200
471,1482451200
472,1482451200
473,1482451200
474,1482451200
475,1482451200
497,1482451200
476,1482451200
477,1482451200
478,1482451200
479,1482451200
480,1482451200
496,1482451200
482,1482451200
483,1482451200
484,1482451200
485,1482451200
486,1482451200
487,1482451200
488,1482451200
490,1482451200
491,1482451200
492,1482451200
493,1482451200
494,1482451200
495,1482451200
498,1482451200
499,1482451200
500,1482451200
501,1482451200
502,1482451200
503,1482451200
504,1482451200
505,1482451200
506,1482451200
507,1482451200
508,1482451200
509,1482451200
510,1482451200
530,1482451200
511,1482451200
512,1482451200
513,1482451200
514,1482451200
515,1482451200
516,1482451200
576,1482451200
517,1482451200
518,1482451200
519,1482451200
564,1482451200
521,1482451200
522,1482451200
523,1482451200
524,1482451200
525,1482451200
526,1482451200
527,1482451200
528,1482451200
529,1482451200
531,1482451200
532,1482451200
533,1482451200
534,1482451200
535,1482451200
536,1482451200
537,1482451200
538,1482451200
539,1482451200
540,1482451200
541,1482451200
544,1482451200
545,1482451200
546,1482451200
547,1482451200
548,1482451200
549,1482451200
550,1482451200
551,1482451200
552,1482451200
553,1482451200
554,1482451200
555,1482451200
556,1482451200
572,1482451200
558,1482451200
559,1482451200
560,1482451200
561,1482451200
562,1482451200
563,1482451200
565,1482451200
566,1482451200
567,1482451200
568,1482451200
569,1482451200
570,1482451200
571,1482451200
573,1482451200
574,1482451200
575,1482451200
577,1482451200
578,1482451200
579,1482451200
581,1482451200
582,1482451200
583,1482451200
584,1482451200
585,1482451200
586,1482451200
587,1482451200
588,1482451200
589,1482451200
590,1482451200
591,1482451200
592,1482451200
593,1482451200
594,1482451200
595,1482451200
596,1482451200
597,1482451200
598,1482451200
599,1482451200
600,1482451200
660,1482451200
604,1482451200
602,1482451200
603,1482451200
605,1482451200
606,1482451200
607,1482451200
608,1482451200
609,1482451200
610,1482451200
796,1482451200
611,1482451200
612,1482451200
613,1482451200
616,1482451200
614,1482451200
615,1482451200
630,1482451200
617,1482451200
618,1482451200
619,1482451200
620,1482451200
629,1482451200
621,1482451200
622,1482451200
623,1482451200
624,1482451200
625,1482451200
626,1482451200
627,1482451200
628,1482451200
645,1482451200
631,1482451200
632,1482451200
633,1482451200
634,1482451200
635,1482451200
636,1482451200
637,1482451200
638,1482451200
639,1482451200
640,1482451200
641,1482451200
642,1482451200
643,1482451200
644,1482451200
646,1482451200
647,1482451200
648,1482451200
649,1482451200
650,1482451200
651,1482451200
652,1482451200
653,1482451200
693,1482451200
654,1482451200
655,1482451200
656,1482451200
657,1482451200
658,1482451200
659,1482451200
695,1482451200
685,1482451200
661,1482451200
662,1482451200
663,1482451200
664,1482451200
665,1482451200
666,1482451200
667,1482451200
668,1482451200
669,1482451200
670,1482451200
671,1482451200
672,1482451200
673,1482451200
674,1482451200
675,1482451200
676,1482451200
677,1482451200
678,1482451200
679,1482451200
680,1482451200
681,1482451200
682,1482451200
683,1482451200
684,1482451200
686,1482451200
687,1482451200
688,1482451200
689,1482451200
690,1482451200
691,1482451200
692,1482451200
694,1482451200
696,1482451200
697,1482451200
698,1482451200
699,1482451200
700,1482451200
701,1482451200
702,1482451200
703,1482451200
704,1482451200
705,1482451200
706,1482451200
707,1482451200
708,1482451200
709,1482451200
710,1482451200
711,1482451200
712,1482451200
743,1482451200
713,1482451200
714,1482451200
715,1482451200
716,1482451200
717,1482451200
718,1482451200
719,1482451200
720,1482451200
721,1482451200
722,1482451200
723,1482451200
724,1482451200
725,1482451200
726,1482451200
727,1482451200
728,1482451200
729,1482451200
730,1482451200
731,1482451200
732,1482451200
733,1482451200
734,1482451200
735,1482451200
736,1482451200
737,1482451200
738,1482451200
739,1482451200
740,1482451200
741,1482451200
742,1482451200
744,1482451200
745,1482451200
746,1482451200
747,1482451200
748,1482451200
749,1482451200
750,1482451200
751,1482451200
752,1482451200
753,1482451200
754,1482451200
755,1482451200
756,1482451200
757,1482451200
758,1482451200
759,1482451200
760,1482451200
761,1482451200
762,1482451200
763,1482451200
764,1482451200
765,1482451200
766,1482451200
767,1482451200
768,1482451200
769,1482451200
770,1482451200
771,1482451200
772,1482451200
773,1482451200
774,1482451200
775,1482451200
776,1482451200
777,1482451200
778,1482451200
779,1482451200
780,1482451200
781,1482451200
782,1482451200
783,1482451200
784,1482451200
785,1482451200
786,1482451200
787,1482451200
788,1482451200
789,1482451200
790,1482451200
791,1482451200
792,1482451200
793,1482451200
794,1482451200
795,1482451200
797,1482451200
798,1482451200
799,1482451200
800,1482451200
801,1482451200
802,1482451200
805,1482451200
803,1482451200
804,1482451200
806,1482451200
807,1482451200
808,1482451200
811,1482451200
809,1482451200
810,1482451200
812,1482451200
813,1482451200
814,1482451200
815,1482451200
816,1482451200
817,1482451200
818,1482451200
819,1482451200
820,1482451200
821,1482451200
822,1482451200
823,1482451200
824,1482451200
825,1482451200
826,1482451200
827,1482451200
828,1482451200
829,1482451200
830,1482451200
831,1482451200
832,1482451200
844,1482451200
833,1482451200
834,1482451200
835,1482451200
836,1482451200
837,1482451200
838,1482451200
839,1482451200
840,1482451200
841,1482451200
842,1482451200
843,1482451200
845,1482451200
846,1482451200
847,1482451200
848,1482451200
849,1482451200
850,1482451200
851,1482451200
852,1482451200
853,1482451200
854,1482451200
855,1482451200
856,1482451200
857,1482451200
858,1482451200
859,1482451200
860,1482451200
861,1482451200
862,1482451200
863,1482451200
864,1482451200
865,1482451200
866,1482451200
867,1482451200
868,1482451200
869,1482451200
870,1482451200
871,1482451200
872,1482451200
873,1482451200
874,1482451200
875,1482451200
876,1482451200
877,1482451200
878,1482451200
879,1482451200
880,1482451200
881,1482451200
882,1482451200
883,1482451200
884,1482451200
885,1482451200
886,1482451200
887,1482451200
888,1482451200
889,1482451200
890,1482451200
891,1482451200
892,1482451200
893,1482451200
894,1482451200
895,1482451200
896,1482451200
897,1482451200
898,1482451200
899,1482451200
900,1482451200
901,1482451200
902,1482451200
903,1482451200
904,1482451200
905,1482451200
906,1482451200
907,1482451200
908,1482451200
909,1482451200
910,1482451200
911,1482451200
912,1482451200
913,1482451200
914,1482451200
915,1482451200
916,1482451200
917,1482451200
918,1482451200
919,1482451200
920,1482451200
921,1482451200
922,1482451200
923,1482451200
924,1482451200
925,1482451200
926,1482451200
927,1482451200
928,1482451200
930,1482451200
931,1482451200
932,1482451200
933,1482451200
934,1482451200
935,1482451200
936,1482451200
937,1482451200
938,1482451200
939,1482451200
940,1482451200
941,1482451200
942,1482451200
943,1482451200
944,1482451200
945,1482451200
946,1482451200
947,1482451200
948,1482451200
949,1482451200
950,1482451200
951,1482451200
952,1482451200
970,1482451200
953,1482451200
954,1482451200
955,1482451200
956,1482451200
957,1482451200
958,1482451200
959,1482451200
960,1482451200
961,1482451200
962,1482451200
963,1482451200
964,1482451200
965,1482451200
966,1482451200
967,1482451200
968,1482451200
969,1482451200
971,1482451200
972,1482451200
973,1482451200
974,1482451200
975,1482451200
976,1482451200
977,1482451200
978,1482451200
979,1482451200
980,1482451200
981,1482451200
982,1482451200
983,1482451200
984,1482451200
985,1482451200
986,1482451200
987,1482451200
988,1482451200
989,1482451200
990,1482451200
991,1482451200
992,1482451200
993,1482451200
994,1482451200
995,1482451200
996,1482451200
997,1482451200
998,1482451200
999,1482451200
1000,1482451200
1001,1482451200
1002,1482451200
1003,1482451200
1004,1482451200
1005,1482451200
1006,1482451200
1007,1482451200
1008,1482451200
1009,1482451200
1010,1482451200
1011,1482451200
1012,1482451200
1013,1482451200
1014,1482451200
1015,1482451200
1016,1482451200
1017,1482451200
1018,1482451200
1019,1482451200
1020,1482451200
1021,1482451200
1022,1482451200
1023,1482451200
1024,1482451200
1025,1482451200
1026,1482451200
1027,1482451200
1028,1482451200
1029,1482451200
1030,1482451200
1031,1482451200
1032,1482451200
1033,1482451200
1034,1482451200
1035,1482451200
1036,1482451200
1037,1482451200
1038,1482451200
1039,1482451200
1040,1482451200
1041,1482451200
1042,1482451200
1043,1482451200
1044,1482451200
1045,1482451200
1046,1482451200
1047,1482451200
1057,1482451200
1048,1482451200
1049,1482451200
1050,1482451200
1051,1482451200
1052,1482451200
1053,1482451200
1054,1482451200
1055,1482451200
1056,1482451200
1058,1482451200
1059,1482451200
1063,1482451200
1060,1482451200
1061,1482451200
1062,1482451200
1064,1482451200
1065,1482451200
1066,1482451200
1067,1482451200
1068,1482451200
1069,1482451200
1070,1482451200
1071,1482451200
1072,1482451200
1073,1482451200
1074,1482451200
1075,1482451200
1076,1482451200
1077,1482451200
1078,1482451200
1079,1482451200
1080,1482451200
1081,1482451200
1082,1482451200
1083,1482451200
1084,1482451200
1085,1482451200
1086,1482451200
1087,1482451200
1088,1482451200
1089,1482451200
1090,1482451200
1091,1482451200
1092,1482451200
1093,1482451200
1094,1482451200
1095,1482451200
1096,1482451200
1097,1482451200
1098,1482451200
1099,1482451200
1100,1482451200
1101,1482451200
1102,1482451200
1103,1482451200
1104,1482451200
1105,1482451200
1106,1482451200
1107,1482451200
1108,1482451200
1109,1482451200
1110,1482451200
1111,1482451200
1112,1482451200
1113,1482451200
1114,1482451200
1115,1482451200
1116,1482451200
1117,1482451200
1118,1482451200
1119,1482451200
1120,1482451200
1121,1482451200
1122,1482451200
1123,1482451200
1171,1482451200
1124,1482451200
1125,1482451200
1126,1482451200
1127,1482451200
1128,1482451200
1129,1482451200
1130,1482451200
1131,1482451200
1132,1482451200
1133,1482451200
1134,1482451200
1135,1482451200
1146,1482451200
1136,1482451200
1137,1482451200
1138,1482451200
1139,1482451200
1140,1482451200
1141,1482451200
1142,1482451200
1143,1482451200
1144,1482451200
1145,1482451200
1147,1482451200
1148,1482451200
1149,1482451200
1150,1482451200
1151,1482451200
1152,1482451200
1153,1482451200
1154,1482451200
1162,1482451200
1155,1482451200
1156,1482451200
1157,1482451200
1158,1482451200
1159,1482451200
1160,1482451200
1161,1482451200
1163,1482451200
1164,1482451200
1165,1482451200
1166,1482451200
1167,1482451200
1168,1482451200
1169,1482451200
1170,1482451200
1172,1482451200
1173,1482451200
1174,1482451200
1175,1482451200
1176,1482451200
1177,1482451200
1178,1482451200
1179,1482451200
1180,1482451200
1181,1482451200
1182,1482451200
1183,1482451200
1184,1482451200
1185,1482451200
1186,1482451200
1187,1482451200
1188,1482451200
1189,1482451200
1190,1482451200
1191,1482451200
1192,1482451200
1193,1482451200
1194,1482451200
1195,1482451200
1196,1482451200
1211,1482451200
1197,1482451200
1198,1482451200
1199,1482451200
1200,1482451200
1201,1482451200
1202,1482451200
1203,1482451200
1204,1482451200
1205,1482451200
1206,1482451200
1207,1482451200
1208,1482451200
1209,1482451200
1210,1482451200
1212,1482451200
1213,1482451200
1214,1482451200
1215,1482451200
1216,1482451200
1217,1482451200
1218,1482451200
1219,1482451200
1220,1482451200
1221,1482451200
1222,1482451200
1223,1482451200
1224,1482451200
1225,1482451200
1226,1482451200
1227,1482451200
1228,1482451200
1229,1482451200
1230,1482451200
1231,1482451200
1232,1482451200
1233,1482451200
1234,1482451200
1237,1482451200
1235,1482451200
1236,1482451200
1238,1482451200
1239,1482451200
1240,1482451200
1241,1482451200
1242,1482451200
1243,1482451200
1244,1482451200
1245,1482451200
1250,1482451200
1246,1482451200
1247,1482451200
1248,1482451200
1249,1482451200
1251,1482451200
1252,1482451200
1253,1482451200
1254,1482451200
1255,1482451200
1256,1482451200
1257,1482451200
1258,1482451200
1259,1482451200
1260,1482451200
1261,1482451200
1262,1482451200
1263,1482451200
1264,1482451200
1265,1482451200
1266,1482451200
1267,1482451200
1268,1482451200
1269,1482451200
1270,1482451200
1276,1482451200
1271,1482451200
1272,1482451200
1273,1482451200
1274,1482451200
1275,1482451200
1277,1482451200
1278,1482451200
1279,1482451200
1280,1482451200
1281,1482451200
1282,1482451200
1283,1482451200
1284,1482451200
1285,1482451200
1286,1482451200
1287,1482451200
1288,1482451200
1289,1482451200
1290,1482451200
1291,1482451200
1292,1482451200
1293,1482451200
1294,1482451200
1295,1482451200
1296,1482451200
1297,1482451200
1298,1482451200
1299,1482451200
1300,1482451200
1301,1482451200
1302,1482451200
1303,1482451200
1304,1482451200
1305,1482451200
1306,1482451200
1307,1482451200
1308,1482451200
1309,1482451200
1310,1482451200
1311,1482451200
1312,1482451200
1313,1482451200
1314,1482451200
1315,1482451200
1316,1482451200
1317,1482451200
1318,1482451200
1319,1482451200
1320,1482451200
1321,1482451200
1322,1482451200
1323,1482451200
1324,1482451200
1326,1422517020
1327,1422605160
due_date.csv (19,857 bytes)   
desc_bug_table.csv (990 bytes)    
Field,Type,Null,Key,Default,Extra
id,"int(10) unsigned",NO,PRI,NULL,auto_increment
project_id,"int(10) unsigned",NO,MUL,0,
reporter_id,"int(10) unsigned",NO,,0,
handler_id,"int(10) unsigned",NO,,0,
duplicate_id,"int(10) unsigned",NO,,0,
priority,smallint(6),NO,,30,
severity,smallint(6),NO,,50,
reproducibility,smallint(6),NO,,10,
status,smallint(6),NO,MUL,10,
resolution,smallint(6),NO,,10,
projection,smallint(6),NO,,10,
eta,smallint(6),NO,,10,
bug_text_id,"int(10) unsigned",NO,,0,
os,varchar(32),NO,,,
os_build,varchar(32),NO,,,
platform,varchar(32),NO,,,
version,varchar(64),NO,,,
fixed_in_version,varchar(64),NO,MUL,,
build,varchar(32),NO,,,
profile_id,"int(10) unsigned",NO,,0,
view_state,smallint(6),NO,,10,
summary,varchar(128),NO,,,
sponsorship_total,int(11),NO,MUL,0,
sticky,tinyint(4),NO,,0,
target_version,varchar(64),NO,,,
category_id,"int(10) unsigned",NO,,1,
date_submitted,"int(10) unsigned",NO,,1,
due_date,"int(10) unsigned",NO,,1,
last_updated,"int(10) unsigned",NO,,1,
desc_bug_table.csv (990 bytes)   

Activities

dregad

dregad

2015-01-28 04:06

developer   ~0048718

mantis from 2007

What version number is that exactly ?

Change the due date field from 1 to 1482451200 or other arbitrary date in the DB.

Can you explain why you made that change, and how you effected it ?
Note: 1 is the default value for due_date column

Additional information may be useful:

  1. temporarily configure your system as follows:

$g_show_detailed_errors = ON;

WARNING - SECURITY RISK: the 'show_detailed_errors' config can cause MantisBT to display sensitive information about your system. We recommend to restrict its activation to a Test environment, only for as long as necessary. If possible, do not turn it ON globally, instead limit it for specific user(s) using the Manage Configuration page.

  1. Reproduce the error
  2. save the output of the error screen, preferably as an HTML page
  3. be careful to remove/mask any confidential information if needed
  4. upload the results here

An SQL dump of the offending row from the bug table may also be helpful.
therubyguy

therubyguy

2015-01-28 12:11

reporter   ~0048722

The original version number was 1.08. Upgrade script ran with no issues though.

I changed the due_date from default just to debug and see if that was the issue since thats where there was the issue said it was originating from. I configured that on and attached the page.

Will send the dump in a second
therubyguy

therubyguy

2015-01-28 12:25

reporter   ~0048723

I attached both the dump and the HTML page. I replaced the sensitive URL paths with either $mantisdirectory or /myurl/. Tell me if you need any more fields, I can dump any non-sensitive fields if needed.

Also, just to clarify I can't update any issues at all, not just a specific one. Tell me if you need anything else.
dregad

dregad

2015-01-28 19:50

developer   ~0048726

Any errors during upgrade ?
What's the Mantis schema version (go to Manage menu)
Can you DESC mantis_bug_table ?
therubyguy

therubyguy

2015-01-29 11:57

reporter   ~0048735

No errors after doing a second install. Was one the first time about Binding a Timestamp, but not sure the exact error.

Schema version: 183

And will attach the desc of the table
therubyguy

therubyguy

2015-01-29 11:58

reporter   ~0048736

Attached the desc of the table. Tell me if you need anything else
therubyguy

therubyguy

2015-02-02 19:21

reporter   ~0048771

Just wanted to add another not, still need help with this issue if possible
therubyguy

therubyguy

2015-02-03 18:09

reporter   ~0048782

Did a clean install and manually ported the DB again. Issue was resolved
dregad

dregad

2015-02-03 18:34

developer   ~0048783

I'm glad to hear it. Sorry for not getting back to you earlier, got busy.