I have a tabel sysstatus that has links to two other tables, project and payment. In the sandbox it is working fine. But when i download and install the component the gridview on payment has a SQL error.

In the gridview of payment i have a filter field on sysstatus->statuscode and on project->reference.
When i disable the Project > Reference filter the view is working:
//$model_project_id = JModel::getInstance('project', 'Mw1crowdfundingModel');
//$this->filters = new stdClass();
//$this->filters->list = $model_project_id->getItems();
//$this->filters->value = $model->getState("filter.project_id");


Is there a difference between the download and the sandbox?

The project name is mw1 crowdfunding. (I have changed the status fields in project and payment in enumeration fields because i have to finish a project for this component)

JDatabaseMySQLi::query: 1054 - Unknown column '_project_status_.statuscode' in 'order clause' SQL=SELECT a.id,a.access,a.checked_out,a.created_by,a.* FROM r7fc2_mw1crowdfunding_project AS a ORDER BY _project_status_.statuscode asc
Call stack
# Function Location
1 JAdministrator->dispatch() JROOT/administrator/index.php:46
2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
5 JController->execute() JROOT/administrator/components/com_mw1crowdfunding/mw1crowdfunding.php:71
6 Mw1crowdfundingController->display() JROOT/libraries/joomla/application/component/controller.php:761
7 JController->display() JROOT/administrator/components/com_mw1crowdfunding/controller.php:59
8 Mw1crowdfundingViewPayments->display() JROOT/libraries/joomla/application/component/controller.php:722
9 Mw1crowdfundingViewPayments->displayDefault() JROOT/administrator/components/com_mw1crowdfunding/views/payments/view.html.php:56
10 Mw1crowdfundingModelProject->getItems() JROOT/administrator/components/com_mw1crowdfunding/views/payments/view.html.php:107
11 Mw1crowdfundingModelList->getItems() JROOT/administrator/components/com_mw1crowdfunding/models/project.php:112
12 JModelList->getItems() JROOT/administrator/components/com_mw1crowdfunding/classes/jmodel.list.php:403
13 JModelList->getStart() JROOT/libraries/joomla/application/component/modellist.php:128
14 JModelList->getTotal() JROOT/libraries/joomla/application/component/modellist.php:265
15 JModel->_getListCount() JROOT/libraries/joomla/application/component/modellist.php:231
16 JDatabaseMySQLi->execute() JROOT/libraries/joomla/application/component/model.php:318
17 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
18 JError::raise() JROOT/libraries/joomla/error/error.php:251

I'm making the assumption that you've modified the fields in the table after installing it on your test server?

The tables on your server are not modified when you install over an old installation so you'll need to either modify the table yourself, or uninstall and reinstall the component.

Dave

Yes i removed the whole component and a new install afterwards.

Thank you.

good to know on the reinstall ... I'm no expert so I'm puzzled by why the builder is generating code that references a field (statuscode) that doesn't exist in the table (project)

Is this a field that you removed from the project? if so, did you remove it from any filters and groupings?

just some ideas ...

Dave