Post by niman » Fri Sep 13, 2019 12:18 am

I can't edit category. When I click on action button, It shows the below error. Anyone can help me? Thanks in advance.

OC version: 3.0.2.0

Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'lang' in 'where clause'<br />Error No: 1054<br />SELECT * FROM oc_seo_url WHERE query = 'category_id=75' AND lang = '1'' in /home/bengpapj/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/bengpapj/opencart3/modification/system/library/db.php(52): DB\MySQLi->query('SELECT * FROM o...') #1 /home/bengpapj/opencart3/modification/admin/model/catalog/category.php(562): DB->query('SELECT * FROM o...') #2 [internal function]: ModelCatalogCategory->getCategorySeoUrls('75') #3 /home/bengpapj/opencart3/modification/system/engine/loader.php(253): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /home/bengpapj/public_html/system/engine/proxy.php(47): call_user_func_array(Object(Closure), Array) #6 /home/bengpapj/opencart3/modification/admin/controller/catalog/category.php(487): Proxy->__call('getCategorySeoU...', Array) #7 /home/bengpapj/opencart3/modification/admin/controller/catalog/category in /home/bengpapj/public_html/system/library/db/mysqli.php on line 40

Newbie

Posts

Joined
Thu Nov 22, 2018 2:21 am

Post by xxvirusxx » Fri Sep 13, 2019 12:53 am

What language you use?

Active Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - RO

Post by niman » Fri Sep 13, 2019 1:16 am

xxvirusxx wrote:
Fri Sep 13, 2019 12:53 am
What language you use?
English and Bengoli

Newbie

Posts

Joined
Thu Nov 22, 2018 2:21 am

Post by grgr » Sat Sep 14, 2019 8:54 pm

On the basis that "lang" is not a field on the seo_url table, it is unsurprsing that it does not work! The field is language_id.

I would presume an extension altering getCategorySeoUrls() function.

Image Image Image Image Image Image Image Image


User avatar
Active Member

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK
Who is online

Users browsing this forum: No registered users and 3 guests