Existing fields throw "does not exist" error

[cpx3]

Hi all,

I copied my database from one site to the other and everything seems to work fine. But I have an issue with some fields that are editable in the backend but as soon I try to save the page give me the error message:

FieldtypePage: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_p624065_1.field_select_hidden_categories' doesn't exist.

I tried to delete and readd them to the page but with no success. (This happens at least with two fields). What am I doing wrong?

[da²]

Hi,

So, does the table usr_p624065_1.field_select_hidden_categories exist? 😁

[cpx3]

For whatever reason not in the database but in the fieldlist and in the template. I can edit it but when I save it, it produces an error.

[da²]

So there's a mistake related to the database. Or you are accessing the wrong one (check site/config.php), or the DB copy is wrong.

[cpx3]

I suppose that there is a mistake in the database. But where does PW get the information from that this field exists?

[da²]

Looks like a part of database has been copied? If I'm not wrong, fields are also referenced in fieldgroups_fields table that are referenced in templates table. So a template knows what field to display.

But the main question is: why is not the database copied properly? What method do you use?

[cpx3]

Oh, that is an unexpected explication, I did not know this!

I copied the database via PHPMyAdmin dumb, what usually works perfectly...