• Warning Unknown column 'parent_id' in 'where clause'

I am trying to update from the latest version of Enterprise ACYMailing 5 to 6. The update is failing with this error message:

Warning
Unknown column 'parent_id' in 'where clause'

Afterwards ACYmailing 6 shows in the "extensions: manage" area, but I get an error uninstalling it.

To rule out settings on my server I installed ACYmailing in a fresh Joomla site and it installs fine.

Also, I tried to install an enterprise version of ACYmailing 6 and it did install and I was able to uninstall it.

Enterprise ACYmailing 6 still failed when I tried again after

Hi,

Can you check if your v5 vesion is 5.9 or higher?

Hi,

Can you go in Acymailing to Configuration->Security and run a database integrity check?

    If you installed version 6 in the past but you didn't use it, please try to remove ALL "%acym" tables from the DB and install version 6 from the beginning

    That should work

      jvstratum I ran the DB integrity check. It did fix a couple of things, however one thing it cannot fix:

      primary key missing in #acymailing_history
      [ERROR]Could not add the primary key on the table : #      acymailing_history
      Duplicate entry '23577-1525961971' for key 'PRIMARY'...

        mihha I think you meant remove ALL "%acym_" (with the underscore at the end) tables. I still have ACY5 installed and want to upgrade, not start over.

        I did remove all the ACY6 tables, as yoru directions reminded me I had installed V6 a long time ago but did not start using it because the tags were not a feture in 6 yet.

        Removing those tables still creates the same error.

          Hi,

          That's what Mihha meant. All #acymailing tables belong to v5 and all #acym tables belong to v6. They each store their own data and settings. That's why you can run both versions on the same site and your data is still present in the v5 tables after migration.

          I see you ran the database check in v5. As for the "primary key missing" message, it seems that there is at least one duplicated row in the table #__acymailing_history that prevents the creation of the key.
          The solution in this case is either to manually check the table in phpmyadmin and remove the duplicated ones, or export the history data then empty the table if you don't need it.

            jvstratum I removed the duplicate row, but there was another one, then another one and so on. I've deleted that table, had acymailing recreate and now there are no database problems. Acymailing 6 is still giving that error. Some of the V6 tables are being populated with data from V5 but something in breaking the process. The reason I am moving to 6 now is because short tags stopped working properly in V5 for me last week. So there's probably something else that is off too - I don't know what to try next.

              Hi,

              Thie issue you've had with the v5 database also results in a migration that will be incomplete. Perhaps that has happened.

              Please delete all the #acym_ tables, which are the v6 tables, in your database and then try to install v6 again.

                jvstratum Yes, I've deleted all of those each time after fixing the database in V5.

                  Issue fixed and latest version 6 installed on your site

                  When you removed AcyMailing 6 tables from the DB in your previous attempt, you didn't realize (I am guessing this) that tables have constraints. Because of them, you can't remove them in one pass

                  I had to remove them all in three attempts to fulfil constraints properly

                    mihha All I know is I went into phpMyadmin, selected the tables and dropped them. I must have missed any messages that they weren't all being dropped successfully. I'll tuck that info away for future reference!

                    Thank you very much for the help and getting things going now - just in time for making a new template on my live stream.

                      Not a problem at all

                      2 months later

                      HELP
                      I have the same problem: 1054 Unknown column 'mail.parent_id' in 'where clause' I use Acyba every week. Nothing changed. I tried to manage the database with the FIX but still cannot access Acyba.

                      There is really no need to open two tickets using different accounts with the same issue and then also post the same issue on a random post in the forum

                      Something like this really can't speed up the resolution and you just waste everyone's time by doing that. Support staff needs to focus on your tickets (at least three of them) instead of helping other users

                      Please open just one ticket and wait for the resolution (which has been already sent btw) in the future. You will help everyone by doing that

                      Thank you for understanding!

                      2 months later

                      I have the same problem:
                      Unknown column 'parent_id' in 'where clause'
                      Acymail 6.19.3 on Joomla 3.9.23
                      Is there a public solution?
                      Thank you

                      Hi,

                      The solution is in this thread. Did you follow al steps? And did you read the suggestions mihha made?