Hi,
I just updated the subscription app to 4.1.4.
Now I get a database error (see attachment).
If I try "Update structure" it has the same result.
Best regards
Sigrid
#464 DB fix for subscription app after update
Posted in ‘Technical Support / Bugs’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by Sigrid Gramlinger on Monday, 22 September 2025 08:26 UTC
Thursday, 11 September 2025 13:42 UTC
Sigrid Gramlinger
Thursday, 11 September 2025 17:06 UTC
Olivier
Thanks for the feedback, Sigrid, I am looking at it.
In the meantime, no worries about these errors, they do not affect the subscription's functionality. The script is trying to alter the size of the column ids but can't. For some reason, the 'CAN FAIL' has no effect.
Olivier.
Growing Together
Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.
Friday, 12 September 2025 05:57 UTC
Sigrid Gramlinger
ok. thanks!
Saturday, 20 September 2025 04:05 UTC
Olivier
Hi Sigird,
I believe if you update the file plugins/j2store/app_subscriptionproduct/sql/updates/mysql/4.1.4.sql by removing the leading spaces in front of 'MODIFY', you will be able to run 'Update structure' with success.
Let me know if that works for you, thanks!
Olivier.
Growing Together
Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.
Monday, 22 September 2025 08:26 UTC
Sigrid Gramlinger
Yes, thanks!
now the error is gone!
Best regards
Sigrid
Stay Updated
Subscribe for free and be the first to know about the latest features, updates, and new additions.