Error executing query
Unknown column 'categories_pos.position' in 'order clause'
SQL
:SELECT categories_pos_id as 'id',categories_pos_fk as 'categories_pos_fk',categories_pos.description as 'description' FROM categories_pos WHERE categories_pos_fk = 0 AND 1=1 ORDER BY categories_pos.position DESC Array ( [0] => Array ( [file] => /home/broarg/public_html/lib/class.database.php [line] => 85 [function] => execute [class] => Database [type] => -> [object] => Database Object ( [connection] => mysqli Object ( ) [host] => localhost [user] => broarg_vbroarg [name] => broarg_vbrother [pass] => ;jsd*cs1p~%. ) [args] => Array ( [0] => SELECT categories_pos_id as 'id',categories_pos_fk as 'categories_pos_fk',categories_pos.description as 'description' FROM categories_pos WHERE categories_pos_fk = 0 AND 1=1 ORDER BY categories_pos.position DESC ) ) [1] => Array ( [file] => /home/broarg/public_html/lib/class.generic.php [line] => 191 [function] => buildArray [class] => Database [type] => -> [object] => Database Object ( [connection] => mysqli Object ( ) [host] => localhost [user] => broarg_vbroarg [name] => broarg_vbrother [pass] => ;jsd*cs1p~%. ) [args] => Array ( [0] => SELECT categories_pos_id as 'id',categories_pos_fk as 'categories_pos_fk',categories_pos.description as 'description' FROM categories_pos WHERE categories_pos_fk = 0 AND 1=1 ORDER BY categories_pos.position DESC ) ) [2] => Array ( [file] => /home/broarg/public_html/lib/class.generic.php [line] => 217 [function] => execute [class] => Generic [type] => -> [object] => categories_pos Object ( [sortable] => Array ( [enabled] => 1 [show_field] => description [filter_fields] => Array ( [0] => categories_pos_fk ) [force_filter] => 1 ) [columns] => Array ( [0] => categories_pos_fk [1] => description ) [datafields] => Array ( [categories_pos_fk] => Array ( [type] => select [label] => Categoria Padre [validation] => [value] => [extra] => Array ( [field] => description ) ) [description] => Array ( [type] => text [label] => Descripción [validation] => required [value] => ) ) [invisible] => [add] => 1 [edit] => 1 [delete] => 1 [items] => Array ( ) [where:private] => Array ( [0] => categories_pos_fk = 0 [1] => 1=1 ) [fields:private] => Array ( [0] => categories_pos_id as 'id' [1] => categories_pos_fk as 'categories_pos_fk' [2] => categories_pos.description as 'description' ) [limit:private] => [order:private] => ORDER BY categories_pos.position DESC [tables:private] => Array ( [0] => categories_pos ) [values:private] => Array ( ) [total] => 15 [files:private] => Array ( ) [multiple:private] => Array ( ) [merge:private] => Array ( [0] => categories_pos_fk ) [id] => 0 [table_id] => categories_pos_id [table] => categories_pos [titles] => Array ( [section] => Categorias de PDV [collection] => Listado [add] => Agregar [edit] => Editar [delete] => Borrar [back] => Volver a Listado [sort] => Ordenar ) [messages] => Array ( [success] => Agregado! [error] => Error! [update] => Editado! [delete] => Borrado! ) ) [args] => Array ( [0] => SELECT {fields} FROM {tables} WHERE {where} {order} {limit} [1] => collection ) ) [3] => Array ( [file] => /home/broarg/public_html/classes/categories_pos.php [line] => 50 [function] => collection [class] => Generic [type] => -> [object] => categories_pos Object ( [sortable] => Array ( [enabled] => 1 [show_field] => description [filter_fields] => Array ( [0] => categories_pos_fk ) [force_filter] => 1 ) [columns] => Array ( [0] => categories_pos_fk [1] => description ) [datafields] => Array ( [categories_pos_fk] => Array ( [type] => select [label] => Categoria Padre [validation] => [value] => [extra] => Array ( [field] => description ) ) [description] => Array ( [type] => text [label] => Descripción [validation] => required [value] => ) ) [invisible] => [add] => 1 [edit] => 1 [delete] => 1 [items] => Array ( ) [where:private] => Array ( [0] => categories_pos_fk = 0 [1] => 1=1 ) [fields:private] => Array ( [0] => categories_pos_id as 'id' [1] => categories_pos_fk as 'categories_pos_fk' [2] => categories_pos.description as 'description' ) [limit:private] => [order:private] => ORDER BY categories_pos.position DESC [tables:private] => Array ( [0] => categories_pos ) [values:private] => Array ( ) [total] => 15 [files:private] => Array ( ) [multiple:private] => Array ( ) [merge:private] => Array ( [0] => categories_pos_fk ) [id] => 0 [table_id] => categories_pos_id [table] => categories_pos [titles] => Array ( [section] => Categorias de PDV [collection] => Listado [add] => Agregar [edit] => Editar [delete] => Borrar [back] => Volver a Listado [sort] => Ordenar ) [messages] => Array ( [success] => Agregado! [error] => Error! [update] => Editado! [delete] => Borrado! ) ) [args] => Array ( ) ) [4] => Array ( [file] => /home/broarg/public_html/classes/categories_pos.php [line] => 40 [function] => collection [class] => categories_pos [type] => -> [object] => categories_pos Object ( [sortable] => Array ( [enabled] => 1 [show_field] => description [filter_fields] => Array ( [0] => categories_pos_fk ) [force_filter] => 1 ) [columns] => Array ( [0] => categories_pos_fk [1] => description ) [datafields] => Array ( [categories_pos_fk] => Array ( [type] => select [label] => Categoria Padre [validation] => [value] => [extra] => Array ( [field] => description ) ) [description] => Array ( [type] => text [label] => Descripción [validation] => required [value] => ) ) [invisible] => [add] => 1 [edit] => 1 [delete] => 1 [items] => Array ( ) [where:private] => Array ( [0] => categories_pos_fk = 0 [1] => 1=1 ) [fields:private] => Array ( [0] => categories_pos_id as 'id' [1] => categories_pos_fk as 'categories_pos_fk' [2] => categories_pos.description as 'description' ) [limit:private] => [order:private] => ORDER BY categories_pos.position DESC [tables:private] => Array ( [0] => categories_pos ) [values:private] => Array ( ) [total] => 15 [files:private] => Array ( ) [multiple:private] => Array ( ) [merge:private] => Array ( [0] => categories_pos_fk ) [id] => 0 [table_id] => categories_pos_id [table] => categories_pos [titles] => Array ( [section] => Categorias de PDV [collection] => Listado [add] => Agregar [edit] => Editar [delete] => Borrar [back] => Volver a Listado [sort] => Ordenar ) [messages] => Array ( [success] => Agregado! [error] => Error! [update] => Editado! [delete] => Borrado! ) ) [args] => Array ( ) ) [5] => Array ( [file] => /home/broarg/public_html/sitemap.php [line] => 44 [function] => getRoots [class] => categories_pos [type] => -> [object] => categories_pos Object ( [sortable] => Array ( [enabled] => 1 [show_field] => description [filter_fields] => Array ( [0] => categories_pos_fk ) [force_filter] => 1 ) [columns] => Array ( [0] => categories_pos_fk [1] => description ) [datafields] => Array ( [categories_pos_fk] => Array ( [type] => select [label] => Categoria Padre [validation] => [value] => [extra] => Array ( [field] => description ) ) [description] => Array ( [type] => text [label] => Descripción [validation] => required [value] => ) ) [invisible] => [add] => 1 [edit] => 1 [delete] => 1 [items] => Array ( ) [where:private] => Array ( [0] => categories_pos_fk = 0 [1] => 1=1 ) [fields:private] => Array ( [0] => categories_pos_id as 'id' [1] => categories_pos_fk as 'categories_pos_fk' [2] => categories_pos.description as 'description' ) [limit:private] => [order:private] => ORDER BY categories_pos.position DESC [tables:private] => Array ( [0] => categories_pos ) [values:private] => Array ( ) [total] => 15 [files:private] => Array ( ) [multiple:private] => Array ( ) [merge:private] => Array ( [0] => categories_pos_fk ) [id] => 0 [table_id] => categories_pos_id [table] => categories_pos [titles] => Array ( [section] => Categorias de PDV [collection] => Listado [add] => Agregar [edit] => Editar [delete] => Borrar [back] => Volver a Listado [sort] => Ordenar ) [messages] => Array ( [success] => Agregado! [error] => Error! [update] => Editado! [delete] => Borrado! ) ) [args] => Array ( ) ) )