Skip Navigation

[Resolved] Update database precondition error question

This support ticket is created 4 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

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/Hong_Kong (GMT+08:00)

Tagged: 

This topic contains 4 replies, has 2 voices.

Last updated by ernestL 4 years, 9 months ago.

Assisted by: Luo Yang.

Author
Posts
#1852985

Hi Support
It looks like our account and plugin on the website shows that we are updated to the latest version of Toolset Types which is 3.4.2. But on the dashboard there is a not that says "Toolset needs to update the database. This will take a few minutes to complete."

When we click the button, we only get to this point...as indicated below.

> The upgrade process is starting...
> Precondition "correct database layer mode"... OK
> Precondition "toolset_associations table exists"... OK
> Precondition "toolset_associations_old table is not yet present (indicates manual database manipulation)"... OK
> Precondition "toolset_associations_new table is not yet present (indicates interrupted upgrade process)"... OK
> Precondition "toolset_connected_elements table is not yet present"... OK
> Precondition "able to create a new database table"... OK
> Precondition "able to delete a database table"... ERR

We are just concerned about the update so want to make sure it goes ok.

Are these issues that are of a concern?
> Precondition "toolset_associations_old table is not yet present (indicates manual database manipulation)"... OK
> Precondition "toolset_associations_new table is not yet present (indicates interrupted upgrade process)"... OK

Is this possibly a user permissions issue? If so, I would need to check with our tech team.
> Precondition "able to delete a database table"... ERR

Thanks
Ernie

#1853089

Hello,

Please check these:
1) Make sure the Mysql user of your website can "DROP" database table:
hidden link

2) Follow our document to get the PHP debug logs from your website:
https://toolset.com/documentation/programmer-reference/debugging-sites-built-with-toolset/

#1853237

Just to confirm...once we set the "Drop" ability for the user...we can and should be able to proceed with the update...correct?

#1853241

Yes, you are right.

#1856045

The update worked. Thanks for all your help and quick responses.
Mick