Quickstart installation of my template does not work V6 but works with V5

JoomlaTema

Hello and thanks for Acymailing Extension. I am developing joomla templates and using Acymailing frequently. I create quickstart packages of templates. After Acymailing version 6+ I have begun to face an issue while installing my quickstarts. Installation corrupts with an error message like this "Error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DROP TABLE IF EXISTS #__acym_field; CREATE TABLE IF NOT EXISTS `#__acym_' at line 103
Access denied for user 'joomlate_temp'@'localhost' to database 'wtcorporate' " If I uninstall V6 and Install V5 and create quickstart again It works. Do you have an idea or any suggestion on this issue? I do not want to use previous Version on my templates. If you want to see problem I have a temporary installation on my site now (http://joomlatema.net/temporaryfolder/). I can send credentials to make temporary installation and see the issue. Thanks Regards.)
See attached image please
https://prnt.sc/s5p6mp

JoomlaTema

Any suggestion on this issue? That is really important for me. I have to use V5 instead of V6 in my Templates due to quickstart installation problem. It seems that there is something wrong with DB tables.Thanks.

jvstratum

Hi,

If I'm correct this is an issue that already has been fixed. Please download version 6.10.3 from your account on Acyba's website and see if it resolves your issue.

JoomlaTema

I have just downloaded and tested but it has not been fixed. It is the same Unfortunately.

jvstratum

Hi,

Please raise a support ticket for this via Acyba's website (https://www.acymailing.com/contact/) and include a link to this thread.

JoomlaTema

Okay thanks

JoomlaTema

Hello I have raised a support ticket and had a conversation with support team they gave me some advises but unfortunately I have no positive result. It seems that support team consider it a database export problem but absolutely it is not. I have tried all database export options (create table if not exists, drop table, insert table etc.) while preparing my quickstart packages of templates all fail with Acymailing V6 but works with V5. It seems that there is something wrong with V6's DB tables. All error codes are related with acym db tables. I am waiting for help please. I am ready to pay if pro version does not have this problem. Thanks.

jvstratum

Have you tried to run a database integrity check in Acymailing->Configuration->Security?

JoomlaTema

I have just tested seems okay

jvstratum

OK, then there's no issue with the database tables.

JoomlaTema

It seems no issue with the database tables but when created a quickstart package of any site with Acym 6 it does not work. I can not install quickstart package. It results with error codes regarding acymail db tables. 🙁(

jvstratum

Hi,

Just found that there's documentaqtion about creating a quickstart package: https://docs.acymailing.com/developers/quickstart-package-with-acymailing

JoomlaTema

Thank you very much.

JoomlaTema

Sorry for bothering again but this problem persists. I can not be able to create a working quickstart installation with acymailing V6 but V5. After raising a support ticket and having a conversation with support team they sent me a working quickstart with V6. When returned to this working quicsktart to use it on my new template quickstart package I had problems with it too and then I saw that it has been prepared by enterprise edition. I am having problems with starter edition. Please note that I have also tried the export method ( https://docs.acymailing.com/developers/quickstart-package-with-acymailing ) suggested by jvstratum in previous post but no luck. I do not want to ue V5 in my new template quickstarts and I am waiting for any solution. Thanks in advance. Best regards

jvstratum

Hi,

If you have a valid Essential or Enterprise subscription the best thing you can do is to raise a support ticket for this: https://www.acymailing.com/support/

JoomlaTema

I do not have Unfortunately. But If you sure that enterprise edition does not have this problem I can buy a subscription. Thanks

JoomlaTema

After following trial and error method line by line on database I am very happy to announce that I have resolved problem. It seems that ('uploadfolder', 'media/com_acym\upload\'), line under Dumping data for table #__acym_configuration is causing error. Changing it like this ('uploadfolder', 'media/com_acym/upload'), resolved problem for now.

jvstratum

Hi,

I'm glad you were able to resolve the issue. Enjoy your Acymailing!

JoomlaTema

Maybe your team should inspect the code above and make a permanent fix for the issue. Thanks