Bug #649
closedRespository - Overview: can't publish anymore
0%
Description
I want to publish one or more objects. I get a MDB2 error:
MDB2_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => 18 [message] => MDB2 Error: no such table [userinfo] => doQuery: [Error message: Could not execute statement] [Last executed query: SELECT cose.* FROM `weblcms_course` AS cose JOIN `weblcms_course_user_relation` AS coon ON cose.`id` = coon.`course_id` WHERE coon.`user_id` = '2' ORDER BY cose.`title` ASC] [Native code: 1146] [Native message: Table 'chamilo.weblcms_course' doesn't exist] [backtrace] => Array ( [0] => Array ( [file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/MDB2.php [line] => 1009 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => MDB2 Error: no such table [1] => -18 [2] => 16 [3] => Array ( [0] => DatabaseRepositoryDataManager [1] => handle_error ) [4] => _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT cose.* FROM `weblcms_course` AS cose JOIN `weblcms_course_user_relation` AS coon ON cose.`id` = coon.`course_id` WHERE coon.`user_id` = '2' ORDER BY cose.`title` ASC] [Native code: 1146] [Native message: Table 'chamilo.weblcms_course' doesn't exist] ) ) [1] => Array ( [file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/PEAR.php [line] => 574 [function] => MDB2_Error [class] => MDB2_Error [type] => -> [object] => MDB2_Error Object RECURSION [args] => Array ( [0] => -18 [1] => 16 [2] => Array ( [0] => DatabaseRepositoryDataManager [1] => handle_error ) [3] => _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT cose.* FROM `weblcms_course` AS cose JOIN `weblcms_course_user_relation` AS coon ON cose.`id` = coon.`course_id` WHERE coon.`user_id` = '2' ORDER BY cose.`title` ASC] [Native code: 1146] [Native message: Table 'chamilo.weblcms_course' doesn't exist] ) ) [2] => Array ( [file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/MDB2.php [line] => 1497 [function] => raiseError [class] => PEAR [type] => -> [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => - [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => / [escape] => ) ) [server_capabilities_checked] => 1 [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => root [password] => root [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => root [password] => root [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => mysqli Object ( ) [opened_persistent] => [database_name] => chamilo [connected_database_name] => chamilo [connected_server_info] => 5.1.37 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 3 [debug_handler] => Array ( [0] => Database [1] => debug ) [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 127 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => [multi_query] => ) [wildcards] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error] => [offset] => 0 [limit] => 0 [phptype] => mysqli [dbsyntax] => mysqli [last_query] => SELECT cose.* FROM `weblcms_course` AS cose JOIN `weblcms_course_user_relation` AS coon ON cose.`id` = coon.`course_id` WHERE coon.`user_id` = '2' ORDER BY cose.`title` ASC [fetchmode] => 1 [modules] => Array ( [Datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [Extended] => MDB2_Extended Object ( [db_index] => 1 ) ) [destructor_registered] => 1 [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) [datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [loaded_version_modules] => Array ( [0] => datatype ) [extended] => MDB2_Extended Object ( [db_index] => 1 ) ) [args] => Array ( [0] => [1] => 18 [2] => [3] => [4] => doQuery: [Error message: Could not execute statement] [Last executed query: SELECT cose.* FROM `weblcms_course` AS cose JOIN `weblcms_course_user_relation` AS coon ON cose.`id` = coon.`course_id` WHERE coon.`user_id` = '2' ORDER BY cose.`title` ASC] [Native code: 1146] [Native message: Table 'chamilo.weblcms_course' doesn't exist] [5] => MDB2_Error [6] => 1 ) ) [3] => Array ( [file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/MDB2/Driver/mysqli.php [line] => 781 [function] => raiseError [class] => MDB2_Driver_Common [type] => -> [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => - [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => / [escape] => ) ) [server_capabilities_checked] => 1 [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => root [password] => root [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => root [password] => root [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => mysqli Object ( ) [opened_persistent] => [database_name] => chamilo [connected_database_name] => chamilo [connected_server_info] => 5.1.37 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 3 [debug_handler] => Array ( [0] => Database [1] => debug ) [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 127 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => [multi_query] => ) [wildcards] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error] => [offset] => 0 [limit] => 0 [phptype] => mysqli [dbsyntax] => mysqli [last_query] => SELECT cose.* FROM `weblcms_course` AS cose JOIN `weblcms_course_user_relation` AS coon ON cose.`id` = coon.`course_id` WHERE coon.`user_id` = '2' ORDER BY cose.`title` ASC [fetchmode] => 1 [modules] => Array ( [Datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [Extended] => MDB2_Extended Object ( [db_index] => 1 ) ) [destructor_registered] => 1 [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) [datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [loaded_version_modules] => Array ( [0] => datatype ) [extended] => MDB2_Extended Object ( [db_index] => 1 ) ) [args] => Array ( [0] => [1] => [2] => [3] => Could not execute statement [4] => _doQuery ) ) [4] => Array ( [file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/MDB2.php [line] => 2589 [function] => _doQuery [class] => MDB2_Driver_mysqli [type] => > [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => - [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked] => 1 [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => root [password] => root [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn]
Updated by Anonymous over 13 years ago
I cannot replicate these errors (latest code, reinstall two days ago).
Btw: it would be useful if the date of latest install was shown in platform administration.
Updated by Sven Vanpoucke over 13 years ago
- Status changed from New to Needs testing
This seems to be due to a corrupt installation, can you retest tis please
Updated by Stefaan Vanbillemont over 13 years ago
- Status changed from Needs testing to Bug resolved
Tested and fixed!
Updated by Stefaan Vanbillemont about 12 years ago
- Project changed from Chamilo LCMS Connect to Repository
- Category deleted (
4)
Updated by Stefaan Vanbillemont about 12 years ago
- Target version changed from 2 to 1.0.0