search

City-of-Bloomington / master_address

Web application for handling city addressing
https://bloomington.in.gov/master_address
GNU Affero General Public License v3.0
0 stars 1 forks source link

Error when adding new street #119

Closed laurahaley closed 4 years ago

laurahaley commented 4 years ago

I added two new street names, W Thornbury DR and N Westbury Village DR. I get a "Get Sorry there is already an active transaction" error when trying to create new streets with these names.

inghamn commented 4 years ago

The transaction I added to fix #118 is causing this error. Street::Add calls Street::AddDesignation. Since they both are database transactions, the effect is to attempt to nest the Designation transaction inside of the Add transaction, which is not possible.

I need to modify the database code so that the AddDesignation queries are seperate from the transaction controls.