Project

General

Profile

Bug #1979

survey mdb2 error

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

Status:
Bug resolved
Priority:
Normal
Target version:
Start date:
10/09/2010
Due date:
% Done:

80%

Estimated time:
Complexity:
Normal

Description

survey mdb2 error on selecting survey application
compare to 1963

MDB2_Error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -19
[message] => MDB2 Error: no such field
[userinfo] => _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT alias_sp.* FROM chamilo_test.survey_publication AS alias_sp JOIN chamilo_test.repository_content_object AS alias_rco ON alias_sp.`content_object_id` = alias_rco.`id` WHERE (alias_sp.`type` = 1) ORDER BY alias_rco.`title` ASC LIMIT 0, 20]
[Native code: 1054]
[Native message: Unknown column 'alias_sp.type' in 'where clause']

History

#1

Updated by Sven Vanpoucke over 9 years ago

  • Assignee set to Sven Vanpoucke
#2

Updated by Sven Vanpoucke over 9 years ago

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

Survey requires reinstall. For the online icl server i have changed the database manually so a reinstall is not necessary

#3

Updated by Anonymous over 9 years ago

first page now ok, but when selecting publish: blank page

#4

Updated by Anonymous over 9 years ago

still something wrong (with an existing survey):
Fatal error: require_once() [function.require]: Failed opening required 'C:\wamp\www\chamilogoogle\repository\lib\content_object\survey\context_data_manager/../template//.class.php' (include_path='C:\wamp\www\chamilogoogle\plugin\pear;C:\wamp\www\chamilogoogle\plugin\google\library') in C:\wamp\www\chamilogoogle\repository\lib\content_object\survey\context_data_manager\database_context_data_manager.class.php on line 342

#5

Updated by Anonymous over 9 years ago

  • % Done changed from 100 to 80
#6

Updated by Stefaan Vanbillemont almost 9 years ago

  • Status changed from Needs testing to Bug resolved
#7

Updated by Anonymous almost 9 years ago

  • Status changed from Bug resolved to Needs more info

Now another error when opening a newly created survey:
Fatal error: Call to a member function get_id() on a non-object in C:\wamp\www\chamilogoogle\repository\content_object\survey\php\display\component\viewer\survey_viewer_form.class.php on line 58

Furthermore: complex builder icon is missing

#8

Updated by Stefaan Vanbillemont almost 9 years ago

  • Target version changed from 18 to 21
#9

Updated by Stefaan Vanbillemont almost 9 years ago

  • Status changed from Needs more info to Bug resolved

retested and no problem anymore!

#10

Updated by Stefaan Vanbillemont almost 9 years ago

  • Project changed from Chamilo LCMS Connect to Common
#11

Updated by Stefaan Vanbillemont almost 9 years ago

  • Target version changed from 21 to 2.1.0

Also available in: Atom PDF