php - Opencart Error trying to access Customers section of admin area -

-

i have opencart store setup , when try access customers page admin area receive following error code:

fatal error: uncaught exception 'errorexception' message 'error: unknown column 'cg.name' in 'field list'<br />error no: 1054<br />select *, concat(c.firstname, ' ', c.lastname) name, cg.name customer_group oc_customer c left join oc_customer_group cg on (c.customer_group_id = cg.customer_group_id) order name asc limit 0,20' in /home/canad763/public_html/testshop/system/database/mysqli.php:41 stack trace: #0 /home/canad763/public_html/testshop/system/library/db.php(20): dbmysqli->query('select *, conca...') #1 /home/canad763/public_html/testshop/admin/model/sale/customer.php(150): db->query('select *, conca...') #2 /home/canad763/public_html/testshop/admin/controller/sale/customer.php(408): modelsalecustomer->getcustomers(array) #3 /home/canad763/public_html/testshop/admin/controller/sale/customer.php(12): controllersalecustomer->getlist() #4 [internal function]: controllersalecustomer->index() #5 /home/canad763/public_html/testshop/system/engine/front.php(42): call_user_func_array(array, array) #6 /hom in /home/canad763/public_html/testshop/system/database/mysqli.php on line 41


Comments

Post a Comment

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

-
i plot number of emails in inbox on time using gmail api , i'm seeing lot of drop-outs, whatever reason i'm getting incomplete count of messages @ single time points. my plots here: https://plot.ly/~tdsmith/2 -- "drop-outs" i'm complaining trace shoots downwards , recovers previous level @ next timepoint. the code i'm using count emails here: https://github.com/tdsmith/gmail-plotly/blob/master/gmail-plotly.py#l47-l64 what can diagnose these faults?
Read more

Installing Android SQLite Asset Helper -

-
i need use ready made database. search solution on internet did not work until decided use mentioned library found here . however, found hard use library in installation procedures shallow beginners. i appreciate step step procedure on how use android studio. in struggle tried copying sources main/libs , adding line gradle did not work. use api 19 if helps. update here build.gradle // top-level build file can add configuration options common sub-projects/modules. buildscript { repositories { mavencentral() } dependencies { classpath 'com.android.tools.build:gradle:0.11.+' compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' // note: not place application dependencies here; belong // in individual module build.gradle files } } allprojects { repositories { mavencentral() } } trying compile project error error:(9, 0) no signature of method: org.gradle.api.internal.artifacts
Read more

Qt Creator - Searching files with Locator including folder -

-
one quick question qtcreator : know possible use locator open files using "ctrl-k" shortcut. however, possible search files including locations? for example, let's want locate file named "main.cpp" in folder named "myfolder" , have lots of other main.cpp files. what should type locator in order open ? just type myfolder/main.cpp in locator
Read more