ERROR MARIADB

[nerio]

I had to relocate my site. Backed up everything and restored (including the database).
A search form not linked to a table (plugin 'redirect' to a table) gives me an error in MariaDB (attached sql_error.jpg). There are joins (databasejoins) to tables to capture the search values and it seems to me that these are the ones that give me problems. Yet the tables are there and I checked the links.
When I enter the menu item, the search mask appears for a moment, then disappears and only the button remains, which returns an error to me (attached cerca_error.jpg).
Can anyone help me?

 

[troester]

I had to relocate my site. Backed up everything and restored (including the database).

Did you open and re-save the Fabrik connection?
If you copy your site the Fabrik connection is still pointing to the old database.

 

[nerio]

Yes, I have reconnected the new database in the connection.
I specify that before the site migration everything worked perfectly.

 

[troester]

Obviously there's a table name missing in the JOIN...ON part.

How did you copy/restore the database?
All tables there?
Do you have MySQL views?
Correct DB user and DB access?

 

[nerio]

Obviously there's a table name missing in the JOIN ... ON part.
See Attachment

How did you copy / restore the database?
Ackeeba kickstart.php

All tables there?
Yes
Do you have MySQL views?
Yes. Phpmyadmin

Correct DB user and DB access?
Yes

 

[troester]

Akeeba won't restore views it's creating tables (at least as I did it some time ago).

Obviously there's a table name missing in the JOIN ... ON part.
See Attachment

A databasejoin won't create a list join. Check your list settings [Data][Joins]

 

[nerio]

Sorry but it worked before. Maybe I should point out that the form contains a redirect plugin as you can see from the attachment.

 

[troester]

it worked before.

Where? In the original site or in the copy?
Anyway: Check your list settings [Data][Joins]

 

[nerio]

In the original site

 

[troester]

So Check your list settings [Data][Joins] (in the copy)