Symphony.

Essentially, I had a section I created but the client wasn’t using. Instead of forcing them to do it the way I’d envisioned I noticed that one section was simply unnecessary so I deleted it.

Then I remembered I hadn’t deleted the datasources. Oops. I tried to delete them but I got an error. I tried just deleting the files and that appeared to remove them from Symphony as well but when I tried to create a new datasource I get the error again.

Big problem. Site is due to launch tomorrow. It won’t be, for client-related reasons but I still need to have my end of up and running.

How do I fix this and please, please, please don’t say I have to reinstall and reenter all that data for the other sections.

I’ve attached the error page.

I tried to delete them but I got an error.

Error didn’t come through on the post. I doubt you’ll have to rebuild…

Lovely. Take two…

Attachments:

Symphony Fatal Database Error.pdf

Maybe you have another of your sections with a select box pointing to the section you deleted?

Nope. The section I deleted was for kinds of donations. The only section that referenced it was the donations section where the client would input new donations to show on the site. I removed it just fine.

Yeah, what alpacaaa said. Looks like somewhere you have a select box whose options are being dynamically loaded by a missing field:

/home/samaritan_admin/samaritanccphila.org/symphony/lib/toolkit/fields/field.select.php:83] fieldSelect- >findAndAddDynamicOptions();

OK, I managed to fix it. I’m not sure what’s trying to pull in that data but I was able to fix it by creating a new section that was a duplicate of the one I had just deleted and then copying it to sym_entries_data_27.

It’s annoying but I’m just going to leave that table in there rather than go digging and looking for trouble.

Open your database up and look in both sym_fields_selectboxlink and sym_sectionsassociation. Does 27 appear in any of the columns in either table? If so, you should be able to work backwards and see where the orphaned relationship is.

Thanks, Nick! I’ll give it a shot and see what comes up.