Post by fegdeed » Sat Jan 19, 2019 10:37 am

Hello, I am using Opencart 3.0.2 and after a successful order, the customer order email notification shows text_subject instead of Order #...
What do I need to do to fix that? Thank you.

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by straightlight » Mon Jan 21, 2019 12:34 am

Language definition issues with either the language association from the database or from a third party language package you might be using.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by fegdeed » Mon Jan 21, 2019 5:04 pm

Thanks @straightlight, am guessing it could probably be from the first one, because I am not using a third party language package. Is there a way to fix it if its a language definition issue with the language association from the database?

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by paulfeakins » Mon Jan 21, 2019 7:35 pm

Check that text_subject is defined in the relevant language file.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by fegdeed » Tue Jan 22, 2019 12:34 am

Thanks @paulfeakins, in catalog > language > en-gb > mail > order_add.php , I have $_['text_subject'] = '%s - Order %s';

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by straightlight » Wed Jan 23, 2019 4:12 am

Looks like a language ID or language code entity issue which your OC admin is currently handling. Ensure that the selected language is relative to an existing language ID. As for the language code, ensure to not have used a custom name from the admin localisation languages page where the default language is being used. Otherwise, this can also affect your orders information.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by fegdeed » Wed Jan 23, 2019 11:33 am

Thanks @Straightlight, I will check the localization in the admin as you said...

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by fegdeed » Fri Jan 25, 2019 12:45 am

I have Language name : English (Default), Code : en-gb, Locale : en-US,en_US.UTF-8,en_US,en-gb,english, Status : Enabled, and Sort order : 1....
I'm still getting text_subject....

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by straightlight » Fri Jan 25, 2019 7:16 pm

Language ID relationship issues on your database. Ensure your language and setting tables do use the same language ID between the language_id and the config_language_id fields.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by fegdeed » Sat Jan 26, 2019 12:44 am

Thanks @Straightlight, I did check, it looks like the settings side has no language_id, it only shows config_language and not config_language_id...I have attached screenshots, which code do I have to inject into the database to create and set the config_language_id to 1 like in the language? or is there another way to fix this?

Attachments

setting.png

setting.png (28.15 KiB) Viewed 1349 times

language.png

language.png (13.28 KiB) Viewed 1349 times


Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by straightlight » Sat Jan 26, 2019 6:30 am

The config_language corresponds with your browser language code, your from the language table and your setting table. Ensure both language codes do match between your language table and your setting table on the database in order for the config_language_id to be properly initialized once found from the browser.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by fegdeed » Sat Jan 26, 2019 6:50 pm

Thanks @Straightlight, so in the setting table, I only have config_language which has a value of en-gb, and in the language table, I have a language_id of 1 which uses the code en-gb...
which key should i be looking for in the setting table?

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by straightlight » Sat Jan 26, 2019 11:28 pm


Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by fegdeed » Mon Jan 28, 2019 11:55 am

Thanks @Straightlight, I did change all the language codes to en-gb, cleared cache, and did a test order and I'm still getting text_subject...However, the order update email shows the right subject (eg. Order Update #)

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am
Who is online

Users browsing this forum: Adminas99999 and 139 guests