[Eric Bunch]

Hi Steven,

After searching the forum, I found a support ticket that is very similar to our problem: https://connections-pro.com/support/topic/error-entry-could-not-be-updatedadded/page/2/#post-450141

The problem we’re having is when I try to delete a record, I see this error: “The link you followed has expired.” When I try to update a record, I see this error: “ERROR: Entry could not be updated.”

This is a sub-site in a multisite environment. We built it on a DEV server. Due to some issues, the sub-site was manually migrated to the production server via phpMyAdmin.

After some investigation, we now believe that Connections was updated on DEV, but not on the live site. So when we migrated, a disconnect occurred in the database.

I read in the above thread that you were given access to the website control panel, where you “manually triggered the proper db upgrade processes.” You mentioned that “it’s a simple fix but would be hard to walk someone through.”

I’m wondering if you might be able to provide some assistance?

Sincerely,

Eric

• This topic was modified 5 years ago by Eric Bunch.

[Steven Zahm]

@ Eric

Please create a temp admin login using this plugin:

https://wordpress.org/plugins/temporary-login-without-password/

Since this is multisite, make sure the account has the ability to edit plugins.

Reply back, as a private reply, with the login link.

Thanks!

[Eric Bunch]

This reply has been marked as private.

[Steven Zahm]

@ Eric

I took a look and what I found is not good… The primary table is missing its primary index key. And several of the support tables such as addresses and phone numbers have not structure at all, but seem to exist. honestly, I’m a little surprised it able to run at all.

My guess is when you migrated from the dev server the tables were not properly migrated. Are the tables intact on the dev server? If they are, I would suggest migrating them again. IMPORTANT, only migrate the Connections tables for this subsite only. The others may be fine, at least one other I checked seems to have the correct structure.

If you would like to compare… navigate to the Connections : Tools admin page on both the subsite you are having an issue with and the healthmanagement.com subsite which seems to be working fine. Click the System Info tab for both. Scroll down to the Table Structure.

If your dev tables are not usable either, I suppose I could force Connections to rebuild it’s table structure and import the existing entries. But there is a good chance those are lost.

[Eric Bunch]

Hi Steven,

This doesn’t surprise me. I was certain that the migration wasn’t done properly. But it happened so long ago, that the DEV site wouldn’t match up anymore.

Luckily the subsite has only 6 records and they are backed up. I could easily recreate them if needed.

If you forced Connections to rebuild it’s table structure, would it have any impact on the main site? The main site works properly and has over 300 records — so I wouldn’t want to jeopardize that in the process.

I’ve just made a backup of the database as a precaution. If you feel that rebuilding the table would fix the problems on the subsite and not impact the main site, then please proceed.

Thanks for helping,
Eric

[Steven Zahm]

@ Eric

Well, in theory the rebuild should not impact any other site. It is the same code that creates the tables initially on the subsite and that code uses core code which only adds missing structure. It should not remove structure or delete data.

Since you do have a backup and this should be safe. I’ll trigger the rebuild.

[Steven Zahm]

@ Eric

Ok, I think it is been rebuilt and seems to be functioning correctly again. I would give your site(s) a once over.

[Eric Bunch]

Steven,

Everything appears to be working properly. Thank you so much for all your help! If you have a donate link, please let me know.

Thanks,
Eric

[Steven Zahm]

@ Eric

I do not have a donate link. If you would like to send something the best way would be may to renew an existing license or make another purchase.

Thanks!

[Steven Zahm]

@ Eric

Here, important… on the subsite which was broken, try adding an entry with details for every section (address/phone/email, so on).

Edit that entry, was the data saved? Can you make changes and are they saved?

Do the same with adding a category.

It occurred to me that perhaps those tables might be broken (well the ones that I did not rebuild, yesterday that is).

[Author]

Posts