Post by prasath » Wed Dec 30, 2015 3:34 pm

Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table 'nklmart_bazar.oc_news' doesn't exist<br />Error No: 1146<br />SELECT COUNT(DISTINCT n.news_id) AS total FROM oc_news n LEFT JOIN oc_news_description nd ON (n.news_id = nd.news_id) LEFT JOIN oc_news_to_store n2s ON (n.news_id = n2s.news_id) WHERE nd.language_id = '1' AND n.status = '1' AND n2s.store_id = '0'' in /home/nklmart/public_html/system/database/mysqli.php:40 Stack trace: #0 /home/nklmart/public_html/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('SELECT COUNT(DI...') #1 /home/nklmart/public_html/catalog/model/catalog/news.php(184): DB->query('SELECT COUNT(DI...') #2 /home/nklmart/public_html/catalog/controller/news/headlines.php(65): ModelCatalogNews->getTotalNews(Array) #3 [internal function]: ControllernewsHeadlines->index() #4 /home/nklmart/public_html/vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #5 /home/nklmart/public_html/vqmod/vqcache/vq2-system_engine_front.php(29): Front->execute in /home/nklmart/public_html/system/database/mysqli.php on line 40


When i click blog page this error is showing..Please help me

Newbie

Posts

Joined
Wed Dec 30, 2015 3:27 pm

Post by IP_CAM » Thu Dec 31, 2015 4:16 am

it's probably missing an OC_NEWS Table, since this is an Extension, not built-in by default, and set in the DB.
Check your Extension, if some DB CREATE_TABLE something Routine exists, anywhere around...
nklmart_bazar.oc_news
Ernie
bigmax.ch/shop/

Ernie's OpenCart v.1.5.6.5 LIGHT + OpenShop Admin v.1.75 Test Sites
http://www.ebikes.li - http://www.evelo.li - http://www.openshop.li
Image


User avatar
Guru Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by atikajay » Sat Oct 07, 2017 6:51 pm

Fatal error: Uncaught Exception: Error: Table 'redeyepa_rep.oc_affiliate' doesn't exist<br />Error No: 1146<br />SELECT COUNT(*) AS total FROM oc_affiliate WHERE approved = '0' in /home/redeyepa/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/redeyepa/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT COUNT(*)...', Array) #1 /home/redeyepa/public_html/admin/model/marketing/affiliate.php(180): DB->query('SELECT COUNT(*)...') #2 /home/redeyepa/public_html/system/storage/modification/system/engine/loader.php(178): ModelMarketingAffiliate->getTotalAffiliates(Array) #3 /home/redeyepa/public_html/system/engine/proxy.php(25): Loader->{closure}(Array, Array) #4 /home/redeyepa/public_html/admin/controller/common/header.php(109): Proxy->__call('getTotalAffilia...', Array) #5 /home/redeyepa/public_html/system/storage/modification/system/engine/action.php(51): ControllerCommonHeader->index(Array) #6 /home/redeyepa/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Obje in /home/redeyepa/public_html/system/library/db/mysqli.php on line 40


help me

Newbie

Posts

Joined
Sat Oct 07, 2017 6:48 pm

Post by atikajay » Sat Oct 07, 2017 7:11 pm

Fatal error: Uncaught Exception: Error: Table 'redeyepa_rep.oc_affiliate' doesn't exist<br />Error No: 1146<br />SELECT COUNT(*) AS total FROM oc_affiliate WHERE approved = '0' in /home/redeyepa/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/redeyepa/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT COUNT(*)...', Array) #1 /home/redeyepa/public_html/admin/model/marketing/affiliate.php(180): DB->query('SELECT COUNT(*)...') #2 /home/redeyepa/public_html/system/storage/modification/system/engine/loader.php(178): ModelMarketingAffiliate->getTotalAffiliates(Array) #3 /home/redeyepa/public_html/system/engine/proxy.php(25): Loader->{closure}(Array, Array) #4 /home/redeyepa/public_html/admin/controller/common/header.php(109): Proxy->__call('getTotalAffilia...', Array) #5 /home/redeyepa/public_html/system/storage/modification/system/engine/action.php(51): ControllerCommonHeader->index(Array) #6 /home/redeyepa/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Obje in /home/redeyepa/public_html/system/library/db/mysqli.php on line 40


help me

Newbie

Posts

Joined
Sat Oct 07, 2017 6:48 pm

Post by ADD Creative » Sat Oct 07, 2017 11:45 pm

The error message says that your database is missing the oc_affiliate table. Check your database.

ADD Creative - Web development and e-commerce development, Milton Keynes or Christchurch, UK
ADD Filtration - HVAC Panel Filters, Bag Filters and HEPA Filters


Active Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Who is online

Users browsing this forum: No registered users and 21 guests