Forums

Help! Can't uninstall addons. (in v. 5.6.3.3) WorkflowTypes table is gone from database.

Permalink
Not sure how this happened, but...

ALL listed add-ons on a 5.6.3.3 site give the following error when I Click EDIT on the Dashboard ADD FUNCTIONALITY page (so I can't remove anything)

An unexpected error occurred.
mysqlt error: [1146: Table 'myaccount_mydatabase.WorkflowTypes' doesn't exist] in EXECUTE("select wftID from WorkflowTypes where pkgID = '21' order by wftID asc")

Of course the pkgID = '21' changes depending on the add-on.

I checked in phpMyAdmin, and the WorkflowTypes table is gone (I compared to a previous version testsite and of course it's there).

I'm not sure what happened, but before I try a backup, I'm wondering if any SQL guru's can help.

Thanks.
OKDnet
 
OKDnet replied on at Permalink Reply
OKDnet
Problem Fixed.
Apparently this table only changes if you install packages with Workflows. There's only one default workflow type in it, so I just put that in with the 2nd query.

I did this.

CREATE TABLE `WorkflowTypes` (
`wftID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`wftHandle` varchar(64) NOT NULL,
`wftName` varchar(128) NOT NULL,
`pkgID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`wftID`)
)
and then ran this to insert the record:

INSERT INTO `WorkflowTypes` (`wftID`, `wftHandle`, `wftName`, `pkgID`)
VALUES
(1, 'basic', 'Basic Workflow', 0);

The bigger mystery is why that table would just disappear!

A Big thanks to my buddy Ryan in Australia!
hutman replied on at Permalink Reply
hutman
Another way to do this is to go into the Dashboard -> System & Settings -> Database XML and do a Database Refresh.
OKDnet replied on at Permalink Reply
OKDnet
No kidding! This is good to know.
Wow... learning something new every day.

Thanks!