Admin Side, Edit Email Templates, all templates are page not found

[Huijun Sun]

Hi,

My AbanteCart version is 1.3.0.
I tried to edit order confirmation email templates by Design ==> email Templates ==> "storefront_order_confirm"==> Edit.
Then it shows "THE PAGE YOU REQUESTED CANNOT BE FOUND!"

So I tried to edit all templates, all with the same result.

The error message in the error log:
2021-06-29 3:26:02 - database error: AbanteCart core v.1.3.0 SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error No: 1064
SQL: SELECT * FROM ac_email_templates WHERE text_id='admin_order_status_notify' AND language_id=1 AND store_id=
PHP call stack:
#0 /home/lelk0ldjzkfk/public_html/core/lib/db.php:102
#1 /home/lelk0ldjzkfk/public_html/core/engine/extensions.php:1151
#2 /home/lelk0ldjzkfk/public_html/core/engine/extensions.php:372
#3 /home/lelk0ldjzkfk/public_html/core/lib/db.php:68
#4 /home/lelk0ldjzkfk/public_html/admin/model/design/email_template.php:145
#5 /home/lelk0ldjzkfk/public_html/admin/controller/pages/design/email_templates.php:214
#6 /home/lelk0ldjzkfk/public_html/admin/controller/pages/design/email_templates.php:184
#7 /home/lelk0ldjzkfk/public_html/core/engine/dispatcher.php:287
#8 /home/lelk0ldjzkfk/public_html/core/engine/dispatcher.php:322
#9 /home/lelk0ldjzkfk/public_html/core/engine/page.php:108
#10 /home/lelk0ldjzkfk/public_html/core/engine/router.php:193
#11 /home/lelk0ldjzkfk/public_html/core/engine/router.php:86
#12 /home/lelk0ldjzkfk/public_html/index.php:97
in <b>/home/lelk0ldjzkfk/public_html/core/database/amysqli.php</b> on line <b>119</b>

I reuploaded all files in this error message but still get the same result.
Please help!!
Thanks!!

[abolabo]

To solve please replace your file with this
https://github.com/abantecart/abantecart-src/blob/dd57c53ece4ad68b38d053f65f9af8bef02b96b8/public_html/admin/model/design/email_template.php
and let us know about result.

[Huijun Sun]

Hi Abolabo


I got another error message on the webpage, no error message in the error log.

Error message:
This page isn't working
Redirected you too many times.
Try clearing your cookies.
ERR_TOO_MANY_REDIRECTS

I cleaned all my cookies but still not work.
Please advise.


Huijun

[abolabo]

Hi Abolabo


I got another error message on the webpage, no error message in the error log.

Error message:
This page isn't working
Redirected you too many times.
Try clearing your cookies.
ERR_TOO_MANY_REDIRECTS

I cleaned all my cookies but still not work.
Please advise.


Huijun

This error not related to Model-file changes.
Try to disable some of 3d-party extensions and check. Usually redirect loop becomes from their

[abolabo]

btw, what php version do you use? try latest

[Huijun Sun]

Hi Abolabo,

My PHP version is 8.0. And please check the picture, that all the extensions I have installed right now.

BTW, I tried to disable all extensions and still get the same error.
Please help. Thanks.

[abolabo]

do you have .htaccess file inside public_html folder?

You can try to rename it and recheck.
If still fail - send me PM with url of your admin side and credentials.

[abolabo]

Please note, you have a store in .ca domain zone.
But if you open email templates grid all links goes to www.yourcart.ca/.ca/index.php (why additional .ca as subfolder ?)
i guess problem is in the redirect settings of your hosting provider CPanel.
Try to ask techsupport about that redirects. Probably it's symlinks issue on host etc.

[Huijun Sun]

Hi Abolabo,

Thanks for your support.
I will contact the hosting provider to solve this.

Thanks again.

[Huijun Sun]

Hi Abolabo,

I contacted the tech support from the hosting company, they checked and said no redirection and symlinks issue on the host.
What I should do next?
Is it possible that I did something wrong during the installation process?
Please advise.

Truly thanks for your help.

Hui

[abolabo]

To solve an issue needs to replace file  public_html/core/lib/config.php
with this

[Huijun Sun]

Hi Abolabo,

Woo, that's amazing. It works.
The additional .ca is removed and the Email Templates are all accessible now.
Thanks for your supports.