Skip Navigation

[Closed] i'm not able to use relationships in my post-types

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Karachi (GMT+05:00)

This topic contains 8 replies, has 2 voices.

Last updated by Waqar 2 months, 2 weeks ago.

Assisted by: Waqar.

Author
Posts
#2696022
Image20240506094202.png

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."

#2696029

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

#2696123

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.

#2696130

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/

#2696131

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

#2696204

any updates on this?

#2696206

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.

#2696285

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.

#2696456

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.

The topic ‘[Closed] i'm not able to use relationships in my post-types’ is closed to new replies.