Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
09/04/2018 at 1:18 pm #471543
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?
09/05/2018 at 9:39 am #471619
- This topic was modified 3 years, 10 months ago by Eric Bunch.
Please create a temp admin login using this plugin:
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!09/05/2018 at 10:05 am #471650This reply has been marked as private.09/05/2018 at 11:22 am #471668
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.09/05/2018 at 12:04 pm #471672
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,
Eric09/05/2018 at 12:29 pm #471676
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.09/05/2018 at 1:33 pm #471684
Ok, I think it is been rebuilt and seems to be functioning correctly again. I would give your site(s) a once over.09/05/2018 at 2:01 pm #471688
Everything appears to be working properly. Thank you so much for all your help! If you have a donate link, please let me know.
Eric09/05/2018 at 7:54 pm #471716
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!09/06/2018 at 10:36 am #471780
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).
You cannot reply to this support topic. Please open your own support topic.