View Issue Details

IDProjectCategoryView StatusLast Update
1439RackTablesdefaultpublic2015-03-21 22:51
Reportercabbiebatman Assigned Toadoom42  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformLinuxOSCentOSOS Version7
Product Version0.20.9 
Target Version0.20.11Fixed in Version0.20.11 
Summary1439: Object 'row'#'161' does not exist
DescriptionI recently upgraded from 0.20.08 to 0.20.09 and when I go into the reports section and click on the "Data Integrity" tab I get the error Object 'row'#'161' does not exist
and I am redirected back to the main screen. If I click on reports again I get the same error but it I wait 15+ minutes I can go back in to the reports section and all reports work except the "Data Integrity"
Steps To ReproduceWait ~15 minutes and go back in to reports tab and select "Data Integrity"
TagsNo tags attached.

Activities

adoom42

adoom42

2015-03-06 21:02

administrator   ~0002757

The error message you're seeing means that there is at least one row in some table that refers to Object 161, which no longer exists. The report should give you more information instead of throwing a general error, but alas it does not in the current incarnation. If I could reproduce the problem, I could polish the error handling.

As a quick fix, you could perform a mysqldump of the database and search for cases where a column's value is "161". That would at least give you a hint.
cabbiebatman

cabbiebatman

2015-03-09 16:02

reporter   ~0002761

Having problems finding it, would it if I attach a copy? it is about 695 KB
adoom42

adoom42

2015-03-09 17:27

administrator   ~0002763

The database dump probably contains sensitive data. Please send it to devteam@racktables.org instead of attaching it to this ticket.
cabbiebatman

cabbiebatman

2015-03-16 14:31

reporter   ~0002781

sent copy to devteam@racktables.org
adoom42

adoom42

2015-03-21 22:51

administrator   ~0002793

The report threw an exception which wasn't caught in time, so it defaulted to redirecting you back to the home page. I added some error handling to prevent this.

The fix will be in 0.20.11. Until then, you can manually patch interface.php: https://github.com/RackTables/racktables/commit/f2500a89df78adc011ff85331f37d0143bcd19b0

Issue History

Date Modified Username Field Change
2015-03-06 17:23 cabbiebatman New Issue
2015-03-06 21:02 adoom42 Note Added: 0002757
2015-03-09 16:02 cabbiebatman Note Added: 0002761
2015-03-09 17:27 adoom42 Note Added: 0002763
2015-03-16 14:31 cabbiebatman Note Added: 0002781
2015-03-21 22:51 adoom42 Note Added: 0002793
2015-03-21 22:51 adoom42 Assigned To => adoom42
2015-03-21 22:51 adoom42 Status new => closed
2015-03-21 22:51 adoom42 Resolution open => fixed
2015-03-21 22:51 adoom42 Fixed in Version => 0.20.11
2015-03-21 22:51 adoom42 Target Version => 0.20.11