DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: http://bugs.horde.org/ticket/11261
------------------------------------------------------------------------------
Ticket | 11261
Created By | Twilek at gmx.de
Summary | Assigning Property to Category throws Error
Queue | Sesha
Version | 1.0.0alpha1
Type | Bug
State | Unconfirmed
Priority | 1. Low
Milestone |
Patch |
Owners |
------------------------------------------------------------------------------
Twilek at gmx.de (2012-07-10 16:51) wrote:
I have installed sesha to a test installation of Horde 5. When I try
to assign an property to a category sesha throws an error. The Admin
screen says the db schema is up to date (I installed to database from
there). I suspect somehow the database setup is not complete
The Error:
A fatal error has occurred
QUERY FAILED: Unknown column 'sesha_categories.properties' in 'where
clause' SELECT sesha_categories.category_id,
sesha_categories.category, sesha_categories.description,
sesha_categories.priority FROM sesha_categories WHERE
sesha_categories.`category_id` = 6 AND sesha_categories.`category` =
'Test' AND sesha_categories.`description` = '' AND
sesha_categories.`priority` = 0 AND sesha_categories.`properties` = ''
AND sesha_categories.`stock` = '' LIMIT 1
1. Sesha_Driver_Rdo->setPropertiesForCategory()
/var/www/horde5/sesha/admin.php:55
2. Horde_Rdo_Mapper->findOne() /var/www/horde5/sesha/lib/Driver/Rdo.php:337
3. Horde_Rdo_List->current() /usr/share/php/Horde/Rdo/Mapper.php:674
4. Horde_Rdo_List->rewind() /usr/share/php/Horde/Rdo/List.php:146
5. Horde_Rdo_List->next() /usr/share/php/Horde/Rdo/List.php:135
6. Horde_Db_Adapter_Mysqli_Result->fetch()
/usr/share/php/Horde/Rdo/List.php:177
7. Horde_Db_Adapter_Mysqli_Result->valid()
/usr/share/php/Horde/Db/Adapter/Mysqli/Result.php:183
8. Horde_Db_Adapter_Mysqli_Result->rewind()
/usr/share/php/Horde/Db/Adapter/Mysqli/Result.php:200
9. Horde_Db_Adapter_Mysqli->execute()
/usr/share/php/Horde/Db/Adapter/Mysqli/Result.php:112
Details
The full error message is logged in Horde's log file, and is shown
below only to administrators. Non-administrative users will not see
error details.
Horde_Db_Exception Object
(
[details] =>
[logged] => 1
[_logLevel:protected] => 0
[message:protected] => QUERY FAILED: Unknown column
'sesha_categories.properties' in 'where clause'
SELECT sesha_categories.category_id, sesha_categories.category,
sesha_categories.description, sesha_categories.priority FROM
sesha_categories WHERE sesha_categories.`category_id` = 6 AND
sesha_categories.`category` = 'Test' AND
sesha_categories.`description` = '' AND sesha_categories.`priority` =
0 AND sesha_categories.`properties` = '' AND sesha_categories.`stock`
= '' LIMIT 1
[string:Exception:private] =>
[code:protected] => 1054
[file:protected] => /usr/share/php/Horde/Db/Adapter/Mysqli.php
[line:protected] => 315
[trace:Exception:private] => Array
(
[0] => Array
(
[file] =>
/usr/share/php/Horde/Db/Adapter/Mysqli/Result.php
[line] => 112
[function] => execute
[class] => Horde_Db_Adapter_Mysqli
[type] => ->
[args] => Array
(
[0] => SELECT
sesha_categories.category_id, sesha_categories.category,
sesha_categories.description, sesha_categories.priority FROM
sesha_categories WHERE sesha_categories.`category_id` = ? AND
sesha_categories.`category` = ? AND sesha_categories.`description` = ?
AND sesha_categories.`priority` = ? AND sesha_categories.`properties`
= ? AND sesha_categories.`stock` = ? LIMIT 1
[1] => Array
(
[0] => 6
[1] => Test
[2] =>
[3] => 0
[4] => Horde_Rdo_List Object
(
[_query:protected] =>
Horde_Rdo_Query Object
(
[mapper] =>
Sesha_Entity_PropertyMapper Object
(
[_table:protected] => sesha_properties
[_lazyRelationships:protected] => Array
(
[categories] => Array
(
[type] => 4
[mapper] => Sesha_Entity_CategoryMapper
[through] => sesha_relations
)
[values] => Array
(
[type] => 2
[mapper] => Sesha_Entity_ValueMapper
[foreignKey] => property_id
)
)
[_setTimestamps:protected] => 1
[_classname:protected] => Sesha_Entity_Property
[_tableDefinition:protected] =>
[_lazyFields:protected] => Array
(
)
[_relationships:protected] => Array
(
)
[_defaultSort:protected] =>
[_factory:protected] => Horde_Rdo_Factory Object
(
[_mappers:protected] => Array
(
[Sesha_Entity_PropertyMapper] => Sesha_Entity_PropertyMapper
Object
*RECURSION*
[Sesha_Entity_CategoryMapper] => Sesha_Entity_CategoryMapper
Object
(
[_table:protected] => sesha_categories
[_lazyRelationships:protected] => Array
(
[properties] => Array
(
[type] => 4
[mapper] => Sesha_Entity_PropertyMapper
[through] => sesha_relations
)
[stock] => Array
(
[type] => 4
[mapper] => Sesha_Entity_StockMapper
[through] => sesha_inventory_categories
)
)
[_setTimestamps:protected] => 1
[_classname:protected] => Sesha_Entity_Category
[_tableDefinition:protected] =>
[_lazyFields:protected] => Array
(
)
[_relationships:protected] => Array
(
)
[_defaultSort:protected] =>
[_factory:protected] => Horde_Rdo_Factory Object
*RECURSION*
[adapter] => Horde_Db_Adapter_Mysqli Object
(
[_connection:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.5.24
[client_version] => 50524
[connect_errno] => 0
[connect_error] =>
[errno] => 1054
[error] => Unknown column
'sesha_categories.properties' in 'where clause'
[error_list] => Array
(
[0] => Array
(
[errno] => 1054
[sqlstate] => 42S22
[error] => Unknown
column 'sesha_categories.properties' in 'where clause'
)
)
[field_count] => 13
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 6
[server_info] => 5.5.24-4
[server_version] => 50524
[stat] => Uptime: 3145 Threads: 1
Questions: 2208 Slow queries: 0 Opens: 421 Flush tables: 1 Open
tables: 104 Queries per second avg: 0.702
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 252
[warning_count] => 0
)
[_insertId:protected] => 6
[_schemaClass:protected] =>
Horde_Db_Adapter_Mysql_Schema
[_hasMysqliFetchAll:protected] =>
[_config:protected] => Array
(
[username] => root
[password] => babylon5
[protocol] => unix
[charset] => utf-8
[ssl] =>
[splitread] =>
[phptype] => mysqli
[adapter] => mysqli
[dbname] => horde
)
[_transactionStarted:protected] =>
[_lastQuery:protected] => SELECT
sesha_categories.category_id, sesha_categories.category,
sesha_categories.description, sesha_categories.priority FROM
sesha_categories WHERE sesha_categories.`category_id` = 6 AND
sesha_categories.`category` = 'Test' AND
sesha_categories.`description` = '' AND sesha_categories.`priority` =
0 AND sesha_categories.`properties` = '' AND sesha_categories.`stock`
= '' LIMIT 1
[_rowCount:protected] => 1
[_runtime:protected] => 0
[_active:protected] => 1
[_cache:protected] => Horde_Cache Object
(
[_params:protected] => Array
(
[compress] =>
[lifetime] => 86400
[sub] => 0
[umask] => 63
)
[_logger:protected] =>
Horde_Core_Log_Logger Object
(
[_levels:Horde_Log_Logger:private] => Array
(
[0] => EMERG
[1] => ALERT
[2] => CRIT
[3] => ERR
[4] => WARN
[5] => NOTICE
[6] => INFO
[7] => DEBUG
)
[_handlers:Horde_Log_Logger:private] => Array
(
[0] =>
Horde_Log_Handler_Stream Object
(
[_formatter:protected] => Horde_Log_Formatter_Simple Object
(
[_format:protected] => %timestamp% %levelName%: %message%
)
[_stream:protected] => Resource id #35
[_mode:protected] => a+
[_streamOrUrl:protected] => /tmp/horde.log
[_options:protected] => Array
(
[ident]
=> HORDE
)
[_filters:protected] => Array
(
[0] =>
Horde_Log_Filter_Level Object
(
[_level:protected] => 6
)
)
)
)
[_filters:Horde_Log_Logger:private] => Array
(
)
)
[_storage:protected] =>
Horde_Cache_Storage_File Object
(
[_dir:protected] => /tmp
[_file:protected] => Array
(
[tables/columns/sesha_properties] =>
/tmp/cache_c88efd0cc2c62c11550154e6ea2b75de
[tables/indexes/sesha_properties] =>
/tmp/cache_efdb86f856410ab85e56f051c51ad297
[tables/columns/sesha_categories] =>
/tmp/cache_e7baec7002b7ea53b7cfb82525d6543c
[tables/indexes/sesha_categories] =>
/tmp/cache_66c49d59844ca13581c65eb67f868462
[tables/columns/sesha_inventory] =>
/tmp/cache_395a4eac74da67b0369d11add64c02c5
[tables/indexes/sesha_inventory] =>
/tmp/cache_40409320402f7642f63d5db53c53b08a
)
[_logger:protected] =>
Horde_Core_Log_Logger Object
(
[_levels:Horde_Log_Logger:private] => Array
(
[0] => EMERG
[1] => ALERT
[2] => CRIT
[3] => ERR
[4] => WARN
[5] => NOTICE
[6] => INFO
[7] => DEBUG
)
[_handlers:Horde_Log_Logger:private] => Array
(
[0] =>
Horde_Log_Handler_Stream Object
(
[_formatter:protected] => Horde_Log_Formatter_Simple Object
(
[_format:protected] => %timestamp% %levelName%: %message%
)
[_stream:protected] => Resource id #35
[_mode:protected] => a+
[_streamOrUrl:protected] => /tmp/horde.log
[_options:protected] => Array
(
[ident] => HORDE
)
[_filters:protected] => Array
(
[0] => Horde_Log_Filter_Level Object
(
[_level:protected] => 6
)
)
)
)
[_filters:Horde_Log_Logger:private] => Array
(
)
)
[_params:protected] => Array
(
[prefix] => cache_
[sub] => 0
[umask] => 63
[lifetime] => 86400
[compress] => 1
[logger] =>
Horde_Core_Log_Logger Object
(
[_levels:Horde_Log_Logger:private] => Array
(
[0] =>
EMERG
[1] =>
ALERT
[2] =>
CRIT
[3] =>
ERR
[4] =>
WARN
[5] =>
NOTICE
[6] =>
INFO
[7] =>
DEBUG
)
[_handlers:Horde_Log_Logger:private] => Array
(
[0] =>
Horde_Log_Handler_Stream Object
(
[_formatter:protected] => Horde_Log_Formatter_Simple Object
(
[_format:protected] => %timestamp% %levelName%: %message%
)
[_stream:protected] => Resource id #35
[_mode:protected] => a+
[_streamOrUrl:protected] => /tmp/horde.log
[_options:protected] => Array
(
[ident] => HORDE
)
[_filters:protected] => Array
(
[0] => Horde_Log_Filter_Level Object
(
[_level:protected] => 6
)
)
)
)
[_filters:Horde_Log_Logger:private] => Array
(
)
)
)
)
)
[_logger:protected] => Horde_Core_Log_Logger
Object
(
[_levels:Horde_Log_Logger:private] =>
Array
(
[0] => EMERG
[1] => ALERT
[2] => CRIT
[3] => ERR
[4] => WARN
[5] => NOTICE
[6] => INFO
[7] => DEBUG
)
[_handlers:Horde_Log_Logger:private] =>
Array
(
[0] => Horde_Log_Handler_Stream
Object
(
[_formatter:protected]
=> Horde_Log_Formatter_Simple Object
(
[_format:protected] => %timestamp% %levelName%: %message%
)
[_stream:protected] =>
Resource id #35
[_mode:protected] => a+
[_streamOrUrl:protected] => /tmp/horde.log
[_options:protected] =>
Array
(
[ident] => HORDE
)
[_filters:protected] =>
Array
(
[0] =>
Horde_Log_Filter_Level Object
(
[_level:protected] => 6
)
)
)
)
[_filters:Horde_Log_Logger:private] =>
Array
(
)
)
[_schema:protected] =>
Horde_Db_Adapter_Mysql_Schema Object
(
[_adapter:protected] =>
Horde_Db_Adapter_Mysqli Object
*RECURSION*
[_adapterMethods:protected] => Array
(
[adapterName] => 0
[supportsMigrations] => 1
[connect] => 2
[disconnect] => 3
[isActive] => 4
[quoteString] => 5
[select] => 6
[selectAll] => 7
[selectOne] => 8
[selectValue] => 9
[selectValues] => 10
[execute] => 11
[insert] => 12
[beginDbTransaction] => 13
[commitDbTransaction] => 14
[rollbackDbTransaction] => 15
[__construct] => 16
[__destruct] => 17
[__sleep] => 18
[__wakeup] => 19
[getOption] => 20
[setCache] => 21
[getCache] => 22
[setLogger] => 23
[getLogger] => 24
[__call] => 25
[supportsCountDistinct] => 26
[prefetchPrimaryKey] => 27
[getLastQuery] => 28
[resetRuntime] => 29
[reconnect] => 30
[rawConnection] => 31
[selectAssoc] => 32
[update] => 33
[delete] => 34
[transactionStarted] => 35
[addLimitOffset] => 36
[sanitizeLimit] => 37
[addLock] => 38
[insertFixture] => 39
[emptyInsertStatement] => 40
)
)
[_schemaMethods:protected] => Array
(
[makeColumn] => 0
[quoteColumnName] => 1
[quoteTableName] => 2
[quoteTrue] => 3
[quoteFalse] => 4
[nativeDatabaseTypes] => 5
[tables] => 6
[primaryKey] => 7
[indexes] => 8
[columns] => 9
[endTable] => 10
[renameTable] => 11
[changeColumn] => 12
[changeColumnDefault] => 13
[renameColumn] => 14
[removePrimaryKey] => 15
[indexName] => 16
[createDatabase] => 17
[dropDatabase] => 18
[currentDatabase] => 19
[typeToSql] => 20
[addColumnOptions] => 21
[buildClause] => 22
[getCharset] => 23
[setCharset] => 24
[_mysqlCharsetName] => 25
[getCollation] => 26
[showVariable] => 27
[caseSensitiveEqualityOperator] => 28
[limitedUpdateConditions] => 29
[__construct] => 30
[setAdapter] => 31
[makeColumnDefinition] => 32
[makeIndex] => 33
[makeTable] => 34
[makeTableDefinition] => 35
[__call] => 36
[__get] => 37
[quote] => 38
[quoteString] => 39
[quoteDate] => 40
[quoteBinary] => 41
[tableAliasLength] => 42
[tableAliasFor] => 43
[table] => 44
[createTable] => 45
[dropTable] => 46
[addColumn] => 47
[removeColumn] => 48
[addPrimaryKey] => 49
[addIndex] => 50
[removeIndex] => 51
[recreateDatabase] => 52
[distinct] => 53
[addOrderByForAssocLimiting] => 54
[interval] => 55
[modifyDate] => 56
)
)
[table] => sesha_categories
[tableDefinition] => Horde_Db_Adapter_Base_Table Object
(
[_name:protected] => sesha_categories
[_primaryKey:protected] =>
Horde_Db_Adapter_Base_Index Object
(
[table] => sesha_categories
[name] => PRIMARY
[unique] => 1
[primary] => 1
[columns] => Array
(
[0] => category_id
)
)
[_columns:protected] => Array
(
[category_id] =>
Horde_Db_Adapter_Mysql_Column Object
(
[_originalDefault:protected] =>
[_name:protected] => category_id
[_type:protected] => integer
[_null:protected] =>
[_limit:protected] => 10
[_precision:protected] =>
[_scale:protected] =>
[_unsigned:protected] => 1
[_default:protected] =>
[_sqlType:protected] => int(10)
unsigned
[_isText:protected] =>
[_isNumber:protected] => 1
)
[category] =>
Horde_Db_Adapter_Mysql_Column Object
(
[_originalDefault:protected] =>
[_name:protected] => category
[_type:protected] => string
[_null:protected] => 1
[_limit:protected] => 255
[_precision:protected] =>
[_scale:protected] =>
[_unsigned:protected] =>
[_default:protected] =>
[_sqlType:protected] =>
varchar(255)
[_isText:protected] => 1
[_isNumber:protected] =>
)
[description] =>
Horde_Db_Adapter_Mysql_Column Object
(
[_originalDefault:protected] =>
[_name:protected] => description
[_type:protected] => text
[_null:protected] => 1
[_limit:protected] =>
[_precision:protected] =>
[_scale:protected] =>
[_unsigned:protected] =>