Author Topic: Admin Side, Edit Email Templates, all templates are page not found  (Read 698 times)

Offline Huijun Sun

  • Newbie
  • *
  • Posts: 9
  • Karma: +2/-0
    • View Profile
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!!


« Last Edit: June 29, 2021, 12:12:59 AM by Huijun Sun »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1966
  • Karma: +300/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Huijun Sun

  • Newbie
  • *
  • Posts: 9
  • Karma: +2/-0
    • View Profile
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #2 on: June 29, 2021, 03:19:01 PM »
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
« Last Edit: June 29, 2021, 06:03:21 PM by Huijun Sun »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1966
  • Karma: +300/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #3 on: June 30, 2021, 02:47:17 AM »
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
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1966
  • Karma: +300/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #4 on: June 30, 2021, 02:56:40 AM »
btw, what php version do you use? try latest
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Huijun Sun

  • Newbie
  • *
  • Posts: 9
  • Karma: +2/-0
    • View Profile
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #5 on: June 30, 2021, 11:20:46 AM »
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.


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1966
  • Karma: +300/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #6 on: June 30, 2021, 11:25:58 AM »
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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1966
  • Karma: +300/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #7 on: June 30, 2021, 11:49:45 AM »
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.

“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Huijun Sun

  • Newbie
  • *
  • Posts: 9
  • Karma: +2/-0
    • View Profile
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #8 on: June 30, 2021, 11:59:43 AM »
Hi Abolabo,

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

Thanks again.

Offline Huijun Sun

  • Newbie
  • *
  • Posts: 9
  • Karma: +2/-0
    • View Profile
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #9 on: June 30, 2021, 12:39:46 PM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1966
  • Karma: +300/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #10 on: July 02, 2021, 07:02:31 AM »
To solve an issue needs to replace file  public_html/core/lib/config.php
with this
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Huijun Sun

  • Newbie
  • *
  • Posts: 9
  • Karma: +2/-0
    • View Profile
Re: Admin Side, Edit Email Templates, all templates are page not found
« Reply #11 on: July 02, 2021, 09:09:03 AM »
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.

 :-* :-* :-*

 

Powered by SMFPacks Social Login Mod