MYSQL error when publishing changes

Permalink
Hi,

I transfered my site from a testing environment:http://grafomantestsite1.be/
To the live environment:http://www.bikingronse.be/

Now whenever i try to publish / change something on bikingronse.be i get the following error:
An exception occurred while executing 'insert into WorkflowRequestObjects (wrObject) values (?)' with params [""]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bikingronse_be.WorkflowRequestObjects' doesn't exist


Also see screenshot.

I copied the databases from grafomantestsite1.be to bikingronse.be. Changed the config file in the application folder. (like i always do).

Updated to the latest version of concrete 5.7.5.4

Hosting at one.com.

Any ideas?

1 Attachment

 
grafoman replied on at Permalink Best Answer Reply
I managed to solve this one on my own.
For people getting the same error:

When i check the database of my testsite, i can see there are 2 pages of tables. I simply forgot to also export the tables on the second page.

As the error says. There was a table missing. So just import those tables in the database of your new site. And you should be good.