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