Error when upgrading to either 6 or 7

phil91

Hi,
Am currently using the starter 5 version and wanted to upgrade to either 6 or 7.
I use Joomla 3.9.23 with no update issue and yet, when I try to upgrade, I get a "Unknown column 'parent_id' in 'where clause'" error at install. Database is up-to-date, so I don't understand what goes wrong with this install...
I also tried to uninstall version 5 and wipe all tables with no more luck.
Also, turning Errors on before install doesn't help more to see where it can come from, most likely from an sql install file...
Any idea would be welcome...
Thanks

Philippe

jvstratum

Hi,

Have you updated v5 to the latest version?

phil91

jvstratum Yes, I did...

groovesplit

It seems to be that the V7 update for the plugin may be causing some issues ( i'm using the latest version of WordPress ). I've had a couple of further crashes on my site after saving some changes in Acymailing's configuration tab. After checking Acymailing's forum page I found out that multiple users seem to be having a similar issue as well. My only way of resolving this issue so far is by deleting the plugin via my hosts FTP service and reinstalling it again. I reinstalled the V6 Version of Acymailing which I have backed up on my PC and this worked perfectly. So... the issue has to be the recent plugin update right?

webjo

Hello Groovesplit,
I reinstalled an old database and reloaded an old FTP. I am therefore in V6 and I have no more errors.
Unfortunately, the support tells me that it comes from my theme ... but too many of us have the site crashed after installing V7 for the problem to come from our theme.

phil91

webjo I fully agree....It can't come from the theme.
I just fully uninstall everything, deleted the v5 tables again and have still the same message....

groovesplit

Hey webjo. thanks for the quick answer. I honestly believe it's the Acymailing V7 update that's having issues with WordPress. Hope they'll fix this soon..

phil91

Also, FWIW, the latest "authorized" Acymailing version showing up in Joomla extensions management menu is v5.10.18....
Interesting, isn't it?

sparkktv

This is why I always test things in localhost before updating the live site. I will probably wait til the next version before updating on my Joomla site until I know the bugs are fixed.

Alexandre

Hi @phil91 , @groovesplit

Could you please share with me the issue you have with AcyMailing 7?
Is it the issue mentioned in the first message (SQL issue)?

Also please send us a summary of the issue + a backend + FTP access via our contact form.
We will have a look at it.

phil91

Alexandre
Hi Alexandre,
Yep, it is the SQL issue from my original message I'm referring to: "Unknown column 'parent_id' in 'where clause".
Summary of the issue is very simple. To make a long story short:

Have been using AcyMailing 5 for a long while on one of my Joomla websites.
Received once a message in the left bar of Acymailing stating that it was no longer supported and that I had to upgrade to 6.
Downloaded Starter v6 and tried to upgrade: got this SQL message so I uninstalled v6 and removed tables and went back to v5.
When v7 came out, tried to jump direct to v7 and received the same error message. Uninstalled and removed tables and went back to v5 again...
When going to the Extensions/Install from Web menu on Joomla backend, the latest "accepted" version of AcyMailing is v5 so, either there is a problem upgrading beyound v5 or you did not update the extensions library informations or....

Should I send you login details just via contact form or PM message anywhere?

Thanks

Philippe

webjo

Good morning all,
IMPORTANT INFORMATION:
Disregard my messages questioning the support: they are very responsive and do everything to help us. I just, like all of us here, panicked when I saw these errors on my site after the update.
Know that they are doing everything to help us.
Acymailing support: we love you!

Alexandre

@phil91 We've received it and we will reply tomorrow 🙂

Alexandre

In the meantime, for all people having issues with v7, we've spent the whole day on it and finally found the problem!
A new version has been released, please update and everything will be ok 😄

Thanks for reporting the problem!

cskmanagement

Seems I have the same issue. Using Acy Enterprise version. Can't upgrade from 5.10.19 (currently latest version), using Joomla 3.9.24 (also latest version), working on Windows 10 (with all the updates and patches). Joomla database is fixed.
The result: Error: Error installing component, Warning. Unknown column 'parent_id' in 'where clause'

Any idea?
P.S. Still not sure what the benefit of an upgrade could be (except from being compatible with Joomla 4 and getting new developments, as I understand that Acy 5 will not be developed further).

jvstratum

cskmanagement

Did you run the database integrity check in Acymailing->Configuration->Security? You'll find the buttom on the bottom of the page. If not, run it and try to install v7 again.

cskmanagement

Ah, no, I didn't. Thanks for the quick reply. Will try tomorrow first thing!

mihha

@cskmanagement

I am afraid that you won't be able to update your version in one pass because you need to update it gradually from your current version to the latest version

Please open a support ticket with us and send us super admin login details so we can do this for you

cskmanagement

ok, thanks. Yes, will do so, shortly.
(you are right, it didn't work)