| Anonymous | Login | Signup for a new account | 2010-09-08 12:11 CEST |  |
| Main | My View | View Issues | Roadmap | Repositories | Search |
| View Issue Details [ Jump to Notes ] | [ Print ] | |||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0000197 | Fusion Ticket | Back-office (admin) | public | 2010-06-12 21:48 | 2010-06-14 03:47 | |||||||
| Reporter | chris | |||||||||||
| Priority | normal | Severity | major | Reproducibility | always | |||||||
| Status | resolved | Resolution | fixed | |||||||||
| Product Version | BETA6 | |||||||||||
| Target Version | BETA6.2 | Fixed in Version | BETA6.2 | |||||||||
| Summary | 0000197: Cant see Cancelled orders in Admin Bad SQL! | |||||||||||
| Description | The join should be that it doenst require seats to assigned to the Order! Currently it does. view.order.php in admin. | |||||||||||
| Steps To Reproduce | Try and look at cancelled orders in admin. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0000154) chris (administrator) 2010-06-12 21:54 |
NEW SQL NEEDS TO BE: SELECT SQL_CALC_FOUND_ROWS distinct seat_order_id, `Order`.* FROM Seat RIGHT JOIN `Order` on seat_order_id=order_id WHERE $where ORDER BY order_date DESC LIMIT {$limit['start']},{$limit['end']} Other wise the cancelled seats will never show cancelled orders as cancelled orders dont have seats! |
|
(0000156) chris (administrator) 2010-06-14 03:47 |
Changed SQL, works now |
|
Notes |
| MantisBT 1.2.1[^] Copyright © 2000 - 2010 MantisBT Group |
 |