SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.extends_model' in 'where clause'

Discuss the webshop here.

Moderator: Developers

User avatar
lonesomewalker
Posts: 320
Joined: Wed Sep 15, 2004 9:15 am
Location: everywhere
Contact:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.extends_model' in 'where clause'

Postby lonesomewalker » Fri Apr 07, 2017 4:50 pm

Any chances to know which column?

Code: Select all

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.extends_model' in 'where clause' Full SQL Query: SELECT `t`.`id`, `t`.`category_id`, `t`.`name`, `t`.`datatype`, `t`.`sort_index`, `t`.`function`, `t`.`required`, `t`.`validation_regex`, `t`.`helptext`, `t`.`multiselect`, `t`.`max`, `t`.`nesting_level`, `t`.`treemaster_field_id`, `t`.`exclude_from_grid`, `t`.`height`, `t`.`number_decimals`, `t`.`unique_values`, `t`.`max_length`, `t`.`addressbook_ids`, `t`.`prefix`, `t`.`suffix` FROM `cf_fields` t WHERE 1 AND `category`.`extends_model` = :go11 ORDER BY `category`.`sort_index` ASC ,`t`.`sort_index` ASC Bind params: array ( ':go11' => array ( 0 => 'GO\\Projects2\\Model\\Project', 1 => 2, ), )


Code: Select all

#0 /usr/share/groupoffice/go/base/db/ActiveRecord.php(1625): PDOStatement->execute()
#1 /usr/share/groupoffice/go/base/controller/AbstractJsonController.php(444): GO\Base\Db\ActiveRecord->find(Object(GO\Base\Db\FindParams))
#2 /usr/share/groupoffice/go/base/controller/AbstractJsonController.php(113): GO\Base\Controller\AbstractJsonController->_processCustomFieldsDisplay(Object(GO\Projects2\Model\Project), Array)
#3 /usr/share/groupoffice/modules/projects2/controller/ProjectController.php(687): GO\Base\Controller\AbstractJsonController->renderDisplay()
#4 /usr/share/groupoffice/modules/professional/controller/AbstractJsonController.php(45): GO\Projects2\Controller\ProjectController->actionDisplay()
#5 /usr/share/groupoffice/go/base/controller/AbstractController.php(452): GO\Professional\Controller\AbstractJsonController->callActionMethod('actiondisplay', Array)
#6 /usr/share/groupoffice/go/base/controller/AbstractJsonController.php(296): GO\Base\Controller\AbstractController->run('display', Array, true, true)
#7 /usr/share/groupoffice/go/base/Router.php(159): GO\Base\Controller\AbstractJsonController->run('display', Array)
#8 /usr/share/groupoffice/index.php(82): GO\Base\Router->runController()
#9 {main}
User avatar
lonesomewalker
Posts: 320
Joined: Wed Sep 15, 2004 9:15 am
Location: everywhere
Contact:

Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.extends_model' in 'where clause'

Postby lonesomewalker » Sat Apr 08, 2017 10:50 am

When debugging "professional" modules, it is extremely annoying, that there is no chance of getting proper output.

For example:
AND `category`.`extends_model` = :go11
-> have a look in database for the model id -> there is no 11.

So, yes, there must be a wrong reference to this somewhere...

Bind params: array (
':go11' =>
array (
0 => 'GO\\Projects2\\Model\\Project',
1 => 2,
),
)

Seems valid.

Return to “Webshop products”

Who is online

Users browsing this forum: No registered users and 1 guest