error s.active_size' in 'field list'

Phoca Cart - complex e-commerce extension
akasit
Phoca Member
Phoca Member
Posts: 21
Joined: 15 Mar 2016, 17:07

error s.active_size' in 'field list'

Post 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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error s.active_size' in 'field list'

Post 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
If you find Phoca extensions useful, please support the project
akasit
Phoca Member
Phoca Member
Posts: 21
Joined: 15 Mar 2016, 17:07

Re: error s.active_size' in 'field list'

Post 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.
akasit
Phoca Member
Phoca Member
Posts: 21
Joined: 15 Mar 2016, 17:07

Re: error s.active_size' in 'field list'

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error s.active_size' in 'field list'

Post 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
If you find Phoca extensions useful, please support the project
Post Reply