Project

General

Profile

Bug #158

error on cpo-import

Added by Anonymous almost 11 years ago. Updated over 9 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
-
Target version:
Start date:
18/11/2009
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal

Description

error on cpo-import:
MDB2_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => -29 [message] => MDB2 Error: null value violates not-null constraint [userinfo] => _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO chamilo_demo.repository_document (`id`, `path`, `filename`, `filesize`, `hash`) VALUES (?, ?, ?, ?, ?)] [Native code: 1048] [Native message: Column 'path' cannot be null] [backtrace] => Array ( [0] => Array ( [file] => /var/www/html/chamilo/demo/plugin/pear/MDB2.php [line] => 1009 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => MDB2 Error: null value violates not-null constraint [1] => -29 [2] => 16 [3] => Array ( [0] => DatabaseRepositoryDataManager [1] => handle_error ) [4] => _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO chamilo_demo.repository_document (`id`, `path`, `filename`, `filesize`, `hash`) VALUES (?, ?, ?, ?, ?)] [Native code: 1048] [Native message: Column 'path' cannot be null] ) ) [1] => Array ( [file] => /var/www/html/chamilo/demo/plugin/pear/PEAR.php [line] => 574 [function] => MDB2_Error [class] => MDB2_Error [object] => MDB2_Error Object RECURSION [type] => -> [args] => Array ( [0] => -29 [1] => 16 [2] => Array ( [0] => DatabaseRepositoryDataManager [1] => handle_error ) [3] => _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO chamilo_demo.repository_document (`id`, `path`, `filename`, `filesize`, `hash`) VALUES (?, ?, ?, ?, ?)] [Native code: 1048]
....

History

#1

Updated by Anonymous almost 11 years ago

The same also happens when using create to upload a zip-file

#2

Updated by Sven Vanpoucke almost 11 years ago

  • Target version set to 2

Can you give the files with which you have tested?

Thank you!

#3

Updated by Sven Vanpoucke almost 11 years ago

  • Assignee set to Sven Vanpoucke
#4

Updated by Sven Vanpoucke almost 11 years ago

  • Status changed from New to Needs testing
  • % Done changed from 0 to 100

There was some corruption in the data
This could be caused by older version
However i would like some of you to test this out by only exporting a group of documents, and then count in there package how many hashes are available in the hash folder

For those who don't know (the cpo file can be opened with any compression program like winzip / winrar)

#5

Updated by Anonymous almost 11 years ago

Problem still exists when uploading zip files (which used to work), in the repository as well as in a course

#6

Updated by Stefaan Vanbillemont almost 11 years ago

  • Status changed from Needs testing to Bug resolved
#7

Updated by Anonymous almost 11 years ago

Import into repository of a cpo file does not work, repository remains empty

#8

Updated by Sven Vanpoucke almost 11 years ago

  • Status changed from Bug resolved to Assigned

There is still a bug with the hotpsot question so if you export / import (do not export the hotspot questions)

#9

Updated by Sven Vanpoucke almost 11 years ago

  • Assignee deleted (Sven Vanpoucke)
#10

Updated by Anonymous almost 11 years ago

Error still persists:

MDB2_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => 20 [message] => MDB2 Error: insufficient data supplied [userinfo] => buildManipSQL: [Error message: Update requires table fields] [Last executed query: UPDATE repository_content_object SET `title` = ?, `description` = ?, `comment` = ?, `created` = ?, `modified` = ?, `owner_id` = ?, `parent_id` = ?, `object_number` = ?, `id` = ? WHERE `id`=28] [Native code: 0] [backtrace] => Array ( [0] => Array ( [file] => C:\wamp\www\chamilo\plugin\pear\MDB2.php [line] => 1009 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => MDB2 Error: insufficient data supplied [1] => -20 [2] => 16 [3] => Array ( [0] => DatabaseRepositoryDataManager [1] => handle_error ) [4] => buildManipSQL: [Error message: Update requires table fields] [Last executed query: UPDATE repository_content_object SET `title` = ?, `description` = ?, `comment` = ?, `created` = ?, `modified` = ?, `owner_id` = ?, `parent_id` = ?, `object_number` = ?, `id` = ? WHERE `id`=28] [Native code: 0] ) ) [1] => Array ( [file] => C:\wamp\www\chamilo\plugin\pear\PEAR.php [line] => 574 [function] => MDB2_Error [class] => MDB2_Error [object] => MDB2_Error Object RECURSION [type] => -> [args] => Array ( [0] => -20 [1] => 16 [2] => Array ( [0] => DatabaseRepositoryDataManager [1] => handle_error ) [3] => buildManipSQL: [Error message: Update requires table fields] [Last executed query: UPDATE repository_content_object SET `title` = ?, `description` = ?, `comment` = ?, `created` = ?, `modified` = ?, `owner_id` = ?, `parent_id` = ?, `object_number` = ?, `id` = ? WHERE `id`=28] [Native code: 0] ) ) [2] => Array ( [file] => C:\wamp\www\chamilo\plugin\pear\MDB2.php [line] => 1497 [function] => raiseError [class] => PEAR [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] => [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => root [password] => [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.36-community-log [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current

#11

Updated by Anonymous almost 11 years ago

Same bug persists (after re-install)

#12

Updated by Stefaan Vanbillemont almost 11 years ago

  • Status changed from Assigned to Bug resolved
#13

Updated by Stefaan Vanbillemont over 9 years ago

  • Project changed from Chamilo LCMS Connect to Repository
  • Category deleted (4)
#14

Updated by Stefaan Vanbillemont over 9 years ago

  • Target version changed from 2 to 1.0.0

Also available in: Atom PDF