photo

Justin Hawker

shared this problem
4 years ago

Employees Involved

photo

PIV Support

Admin

Statistics

1
Comments
379
Views

Relates to

Share

1
votes

Issue in "listingimages" table

I was troubleshooting another issue looking at my DB and looking at the "listingsimages" table and came across what I believe is a bug. It appears userdb_id is getting populated with the listing id rather than the user id. Looking through my DB, the last listing I created that correctly assigned user_id was 4/19/2011. The next listing I created was on 4/23/2011 and that and anything after it is assigning the user_id as the listing_id. I'm guessing I upgraded my site around then to the lastest OR version and that was when the bug was introduced.

Add Comment

Comments (1)

photo Employee
1

Nice catch. I have confirmed this is still a bug in v3.2.7, and a bug report has been filed.

If you upgraded back in 4/2011 you would have likely upgraded to v3.1.13 or .14 as those were released around that time. If so, that would mean this bug has been present for a while.

I am unsure what functionality implications this has (if any) on existing features, but I suspect it's not breaking anything. However, anyone who pulls data out of that table for any other reason would probably appreciate it if the userdb_id column actually contains user ID#s in case that matters to their purposes.

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 20M