1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    Dismiss Notice

ERROR MARIADB

Discussion in 'Community' started by nerio, Aug 2, 2022.

  1. nerio

    nerio Member

    Level: Community
    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?
     

    Attached Files:

  2. troester

    troester Well-Known Member Staff Member

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

    nerio Member

    Level: Community
    Yes, I have reconnected the new database in the connection.
    I specify that before the site migration everything worked perfectly.
     
  4. troester

    troester Well-Known Member Staff Member

    Level: Community
    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?
     
  5. nerio

    nerio Member

    Level: Community
    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
     

    Attached Files:

  6. troester

    troester Well-Known Member Staff Member

    Level: Community
    Akeeba won't restore views it's creating tables (at least as I did it some time ago).
    A databasejoin won't create a list join. Check your list settings [Data][Joins]
     
  7. nerio

    nerio Member

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

    Attached Files:

  8. troester

    troester Well-Known Member Staff Member

    Level: Community
    Where? In the original site or in the copy?
    Anyway: Check your list settings [Data][Joins]
     
  9. nerio

    nerio Member

    Level: Community
    In the original site
     
  10. troester

    troester Well-Known Member Staff Member

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

Share This Page