Page 1 of 1
error s.active_size' in 'field list'
Posted: 03 Jun 2017, 18:22
by akasit
hi Jan
after login checkout page is error
1054 - Unknown column 's.active_size' in 'field list'
how to fix error
phoca care 3.0.0 RC8
Thank you.
Re: error s.active_size' in 'field list'
Posted: 03 Jun 2017, 23:58
by Jan
Hi, can you enable debug mode in Joomla! configuration to see full error message?
Did you install the RC8 newly or did you make an upgrade. This seems like the active_size column is missing in your database.
Jan
Re: error s.active_size' in 'field list'
Posted: 04 Jun 2017, 09:57
by akasit
hi jan
1.i upgrade version rc7 to rc8 from component upgrade
2.ok i open debug mode homepage show info.
Unknown column 's.active_size' in 'field list'
Call stack
# Function Location
1 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681
2 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocacart/libraries/phocacart/shipping/shipping.php:68
3 PhocacartShipping->getPossibleShippingMethods() JROOT/components/com_phocacart/views/checkout/view.html.php:178
4 PhocaCartViewCheckout->display() JROOT/libraries/legacy/controller/legacy.php:671
5 JControllerLegacy->display() JROOT/components/com_phocacart/controller.php:42
6 PhocaCartController->display() JROOT/libraries/legacy/controller/legacy.php:709
7 JControllerLegacy->execute() JROOT/components/com_phocacart/phocacart.php:26
8 require_once() JROOT/libraries/cms/component/helper.php:394
9 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369
10 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
11 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230
12 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265
13 JApplicationCms->execute() JROOT/index.php:49
how to fix error
Thank you.
Re: error s.active_size' in 'field list'
Posted: 05 Jun 2017, 09:32
by akasit
hi jan
ok i uninstall and install rc8 it ok
but i use Import data
step 1. i can upload file backup
but step 2.( show "There are products ready to import: 2248") can not click Import button
how to check
thank you
akasit
Re: error s.active_size' in 'field list'
Posted: 05 Jun 2017, 15:32
by Jan
Hi,
1) what you you mean with flie backup?
2) can you paste a screenshot? What if you import data e.g. in phpMyAdmn (did you backup the database)?
Jan