Bug #13161 | Cannot See the Created Issue | ||
---|---|---|---|
Submitted: | 14 Sep 2005 5:30 | Modified: | 4 Nov 2005 4:04 |
Reporter: | Gourav Sinha | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Eventum | Severity: | S2 (Serious) |
Version: | 1.6.1 | OS: | Windows (XP and IE) |
Assigned to: | Bryan Alsdorf | CPU Architecture: | Any |
[14 Sep 2005 5:30]
Gourav Sinha
[14 Sep 2005 5:32]
Gourav Sinha
The log file after the bug.
Attachment: errors.log (application/octet-stream, text), 9.67 KiB.
[14 Sep 2005 14:28]
Bryan Alsdorf
Hi, Please send me the output of the following commands: DESC tbl_issue; DESC tbl_group;
[14 Sep 2005 15:26]
Gourav Sinha
hi, I am attaching the out of the commands that you asked for. The problem is solved if you swap the name of the tables in the natural join. like FROM eventum.eventum_issue, eventum.eventum_user TO FROM eventum.eventum_user, eventum.eventum_issue But then are a lot of queries with the same problem. I am attaching the latest log file as well with the latest errors with other tables.
[14 Sep 2005 15:27]
Gourav Sinha
The Output of DESC Tbl_group
Attachment: _group.htm (text/plain), 1.81 KiB.
[14 Sep 2005 15:27]
Gourav Sinha
The Output of DESC Tbl_issue
Attachment: _issue.htm (text/plain), 10.82 KiB.
[14 Sep 2005 15:28]
Gourav Sinha
The latest log file.
Attachment: Errors.log (application/octet-stream, text), 196.61 KiB.
[23 Sep 2005 21:57]
Costin Bereveanu
Hey, The guy that suggested the table name switch was correct. You may either do that, in class.issue.php, or enclose the two comma separated table names in paranthesis (without switching the names) - that seems to work too. Warning: the same bug exists for more than one function, so keep enclosing (swapping) :)
[23 Sep 2005 21:59]
Costin Bereveanu
By the way, I'm using PHP 5.0.5 and the latest MySQL 5 beta. Windows XP...
[23 Sep 2005 23:08]
Bryan Alsdorf
I have confirmed this is a bug and will work on resolving it.
[4 Nov 2005 4:04]
Bryan Alsdorf
Hi, this issue is now fixed and will be in our next release.
[16 Dec 2005 18:09]
milan shah
I have the same problem and am not sure what to change in which file so could you please send me the edited phps and I can replace the ones I have. or put detailed info of WHAT to change where as I'm not a techi. I understand what you are saying but don't know where to make the changes. Thanks