Tickets :: Comment on [#11261] Assigning Property to Category throws Error

* Your Email Address
* Spam protection	Enter the letters below: . ..___ __.\ /.__ \|\ \|[__ (__ >< [__) \| \\|[___.__)/ \\| \
Comment	> 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] => >
Attachment
Watch this ticket

Saved Queries