XF 2.0 XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatem

[DoogiePC]

I try to rebuild an addon or even just installing an addon and I get this error:



It also seems to happen for other things like creating a node

 

[Deleted member 136029]

I get the same error, all i did was upgraded my forum version from 1.5 to 2.1.0. Any fix found ?

 

[DoogiePC]

I generated a fresh separate install of the 2.1.0 website and then copied broken sql databases to my old website

 

[Deleted member 136029]

I generated a fresh separate install of the 2.1.0 website and then copied broken sql databases to my old website

So this way you were able to solve the SQL error, importing had no issues?

 

[DoogiePC]

Yes

 

[Deleted member 136029]

I did a fresh install and restored the backup still it was same. Then i ran this sql query

CREATE TABLE `xf_template_phrase` (`template_id` int(10) UNSIGNED NOT NULL, `phrase_title` varbinary(100) NOT NULL, PRIMARY KEY (`template_id`,`phrase_title`), KEY `phrase_title` (`phrase_title`)) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

Finally it fixed it. I am happy now

 

[DoogiePC]

No create a separate fresh install of the website then copy some database files from the new fresh install to the website you transferred that are broken

 

[Deleted member 136029]

Ah i did the opposite, the site works now. If i face any issues i will follow your steps.