I am trying to:connect two custom post types (collections) and (free-resources) by one-to-many relationship, but i'm getting an error whenever i'm trying to do so.
Link to a page where the issue can be seen: hidden link
I expected to see: i expected the relationship to be created
Instead, I got:an error saying "An error when creating a relationship "Free Resources Collections": No relationship with slug "free-resource-collection" was found."
Hi,
Thank you for contacting us and I'd be happy to assist.
The Toolset post relationships feature uses custom tables. This message shows if those tables are either missing or are not accessible.
I'll recommend making sure that Toolset plugins and WordPress are updated to the latest version and that the server meets the minimum server requirements, for Toolset.
( ref: https://toolset.com/toolset-requirements/ )
In case, the issue still persists, you're welcome to share temporary admin login details, for further troubleshooting. I'll also need your permission to download the clone/snapshot of the website if it needs to be investigated on a different server.
Note: Your next reply will be private and making a complete backup copy is recommended before sharing the access details.
regards,
Waqar
i still need to confirm whether i'll be able to provide the access to you or not. But i wanted to mention that we are using microsoft SQL server database for the website. and i've been getting warnings on the relationship page in the wordpress saying it needs to update the DB version but when i try to do so, it gives me error that it's not able to do it and when i check the logs it shows that it was not able to change the associate table name.
Thank you for sharing this update and that explains it.
Your website most likely has old relationship data, that didn't use the custom database tables.
Now when Toolset tries to update the database to create those tables for the new relationship structure, it fails due to your website's database permissions/privileges.
You can consult your hosting support team to ensure that the WordPress user for the database, has full read/write access to the database, including the ability to create new tables.
If for some reason that is not possible on your website's production server, you can download your website's clone and deploy it to a different server, complete the database update process, and then migrate the updated website, back to the production server.
These are the plugins that we officially use and recommend for safely migrating websites:
https://wordpress.org/plugins/duplicator/
https://wordpress.org/plugins/all-in-one-wp-migration/
i looked into the wp-config and i picked the DB and its user info from there and then i logged into the SSMS using those credentials and i could rename and create new table using same user that is in the wp-config file, so it has the permissions to do the job
I'm afraid, it won't be possible for us to investigate the server and database configuration and permissions.
I'll recommend turning on WordPress debugging and checking server's error logs for when the relationship migration update process fails.
( ref: https://wordpress.org/documentation/article/debugging-in-wordpress/ )
This should provide more specific information about the errors.
i wanted to mention here that relationship migration has already been done successfully, its just that i'm not able to create any relationships, it errors out in the last step.
Ok, in that case, we'll need to troubleshoot this at the database level.
Do you have an update on sharing the admin access details, with us? If it is not possible to share admin access details of the website you can alternatively share the website's clone/snapshot.
( ref: https://toolset.com/faq/provide-supporters-copy-site/)
This will allow us to investigate this on a different server, without affecting the actual website.
Note: I've set your next reply as private.
