View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
09311Bug reportsOtherpublic2014-10-21 00:36
Reportermfaber Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.06+ 
Summary09311: Error on DB upgrade:: CMysqlTableSchema and its behaviors do not have a method or closure named "getTable"
Description

Upgraded to the latest 2.06 git version.
After clicking on yes for the db upgrade, there's an error (see trace in additional info).

The LimeSurvey database is being upgraded (2014-10-17 22:23:14) .
Please be patient...

An non-recoverable error happened during the update. Error details:
CMysqlTableSchema and its behaviors do not have a method or closure named "getTable".

Please fix this error in your database and try again

Additional Information

LimeSurvey@GIT
The LimeSurvey database is being upgraded (2014-10-17 22:23:14) .

Please be patient...

An non-recoverable error happened during the update. Error details:

CMysqlTableSchema and its behaviors do not have a method or closure named "getTable".

Please fix this error in your database and try again
LimeSurvey - Online Manual
Support this project - Donate to LimeSurvey
LimeSurvey
Application Log
Timestamp Level Category Message
22:23:13.065149 trace system.CModule

Loading "log" application component

22:23:13.065149 trace system.CModule

Loading "request" application component

22:23:13.080749 trace system.CModule

Loading "assetManager" application component

22:23:13.096349 trace system.db.ar.CActiveRecord

Plugin.findAllByAttributes()

22:23:13.096349 trace system.CModule

Loading "db" application component

22:23:13.096349 trace system.db.CDbConnection

Opening DB connection

22:23:14.141551 trace system.CModule

Loading "cache" application component

22:23:14.157150 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_plugins

22:23:14.157150 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_plugins

22:23:14.157150 trace system.db.CDbCommand

Querying SQL: SELECT * FROM lime_plugins t WHERE t.active=:yp0

22:23:14.172750 trace system.CModule

Loading "urlManager" application component

22:23:14.188350 trace system.CModule

Loading "session" application component

22:23:14.203950 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_settings_global

22:23:14.203950 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_settings_global

22:23:14.219551 trace system.db.ar.CActiveRecord

SettingGlobal.findAll()

22:23:14.219551 trace system.db.CDbCommand

Querying SQL: SELECT * FROM lime_settings_global t

22:23:14.281950 trace system.CModule

Loading "bootstrap" application component

22:23:14.281950 trace system.CModule

Loading "clientScript" application component

22:23:14.281950 trace system.CModule

Loading "messages" application component

22:23:14.281950 trace system.CModule

Loading "user" application component

22:23:14.281950 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_surveys

22:23:14.281950 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_surveys

22:23:14.297550 trace system.CModule

Loading "widgetFactory" application component

22:23:14.313152 trace system.db.CDbConnection

Starting transaction

22:23:14.313152 trace system.db.CDbCommand

Querying SQL: SHOW TABLES LIKE 'lime_tokens%'

22:23:14.313152 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_tokens_593622

22:23:14.313152 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_tokens_593622

22:23:14.313152 trace system.db.CDbCommand

Executing SQL: UPDATE lime_tokens_593622 set email=substring(email,0,254)

22:23:14.313152 trace system.db.CDbCommand

Executing SQL: ALTER TABLE lime_tokens_593622 CHANGE email email
varchar(254)

22:23:14.313152 trace system.db.CDbCommand

Executing SQL: ALTER TABLE lime_tokens_593622 CHANGE firstname
firstname varchar(150)

22:23:14.313152 trace system.db.CDbCommand

Executing SQL: ALTER TABLE lime_tokens_593622 CHANGE lastname
lastname varchar(150)

22:23:14.328752 trace system.CModule

Loading "coreMessages" application component

22:23:14.328752 trace system.db.CDbTransaction

Rolling back transaction

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW TABLES

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_answers

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_answers

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_assessments

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_assessments

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_conditions

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_conditions

22:23:14.328752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_defaultvalues

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_defaultvalues

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_encrypt_responses

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_encrypt_responses

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_expression_errors

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_expression_errors

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_failed_login_attempts

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_failed_login_attempts

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_groups

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_groups

22:23:14.344352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_labels

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_labels

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_labelsets

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_labelsets

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_survey_225819_20140309230238

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_survey_225819_20140309230238

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_survey_384944_20131218222342

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_survey_384944_20131218222342

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_survey_593622_20140331233219

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_survey_593622_20140331233219

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_survey_593622_20140331235146

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_survey_593622_20140331235146

22:23:14.359951 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_survey_619922_20140317205924

22:23:14.375551 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_survey_619922_20140317205924

22:23:14.375551 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_survey_875115_20140301220943

22:23:14.375551 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_survey_875115_20140301220943

22:23:14.375551 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_tokens_593622_20140331233206

22:23:14.375551 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_tokens_593622_20140331233206

22:23:14.375551 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_old_tokens_718325_20131220205244

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_old_tokens_718325_20131220205244

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_participant_attribute

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_participant_attribute

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_participant_attribute_names

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_participant_attribute_names

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM
lime_participant_attribute_names_lang

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_participant_attribute_names_lang

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_participant_attribute_values

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_participant_attribute_values

22:23:14.391151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_participant_shares

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_participant_shares

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_participants

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_participants

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_permissions

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_permissions

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_plugin_settings

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_plugin_settings

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_plugins

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_plugins

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_question_attributes

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_question_attributes

22:23:14.406752 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_questions

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_questions

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_quota

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_quota

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_quota_languagesettings

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_quota_languagesettings

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_quota_members

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_quota_members

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_saved_control

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_saved_control

22:23:14.422352 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_sessions

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_sessions

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_settings_global

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_settings_global

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_233777

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_233777

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_382964

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_382964

22:23:14.437952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_419536

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_419536

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_515576

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_515576

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_593622

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_593622

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_718325

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_718325

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_718325_timings

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_718325_timings

22:23:14.453552 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_787769

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_787769

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_814679

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_814679

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_834429

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_834429

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_875115

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_875115

22:23:14.469151 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_975791

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_975791

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_975791_timings

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_975791_timings

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_984639

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_984639

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_links

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_links

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_survey_url_parameters

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_survey_url_parameters

22:23:14.484751 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_surveys

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_surveys

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_surveys_languagesettings

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_surveys_languagesettings

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_templates

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_templates

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_templates_rights

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_templates_rights

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_tokens_975791

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_tokens_975791

22:23:14.500351 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_tokens_984639

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_tokens_984639

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_user_groups

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_user_groups

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_user_in_groups

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_user_in_groups

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW FULL COLUMNS FROM lime_users

22:23:14.515952 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE lime_users

22:23:14.671952 trace system.db.ar.CActiveRecord

SettingGlobal.findByPk()

22:23:14.671952 trace system.db.CDbCommand

Querying SQL: SELECT * FROM lime_settings_global t WHERE
t.stg_name='updateversions' LIMIT 1

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.update()

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.updateByPk()

22:23:14.687551 trace system.db.CDbCommand

Executing SQL: UPDATE lime_settings_global SET stg_name=:yp0,
stg_value=:yp1 WHERE lime_settings_global.stg_name='updateversions'

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.findByPk()

22:23:14.687551 trace system.db.CDbCommand

Querying SQL: SELECT * FROM lime_settings_global t WHERE
t.stg_name='updateavailable' LIMIT 1

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.update()

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.updateByPk()

22:23:14.687551 trace system.db.CDbCommand

Executing SQL: UPDATE lime_settings_global SET stg_name=:yp0,
stg_value=:yp1 WHERE lime_settings_global.stg_name='updateavailable'

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.findByPk()

22:23:14.687551 trace system.db.CDbCommand

Querying SQL: SELECT * FROM lime_settings_global t WHERE
t.stg_name='updatelastcheck' LIMIT 1

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.update()

22:23:14.687551 trace system.db.ar.CActiveRecord

SettingGlobal.updateByPk()

22:23:14.687551 trace system.db.CDbCommand

Executing SQL: UPDATE lime_settings_global SET stg_name=:yp0,
stg_value=:yp1 WHERE lime_settings_global.stg_name='updatelastcheck'

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)141017
I will donate to the project if issue is resolvedNo
BrowserFF
Database type & versionMySQL 5.0.10
Server OS (if known)Win7
Webserver software & version (if known)Apache 2.4.7
PHP VersionPhP 5.4.19

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2014-10-18 11:41

developer   ~30814

Hi mfaber, not for this bug. But when i have a php error, i save the HTML file (only the HTML) to uplaod this filehere.

I think it's more clear to see the error line :)

mfaber

mfaber

2014-10-21 00:00

reporter   ~30841

Sorry to reopen this but this does not seem to be fixed. I still get the same error when I start up 2.06 and do the DB update.

c_schmitz

c_schmitz

2014-10-21 00:36

administrator   ~30842

Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14586

Related Changesets

LimeSurvey: 2.06 72efcaa5

2014-10-20 22:36:13

c_schmitz

Details Diff
Fixed issue 09311: Error on DB upgrade Affected Issues
09311
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-10-17 22:25 mfaber New Issue
2014-10-17 22:25 mfaber Issue generated from: 09310
2014-10-18 11:41 DenisChenu Note Added: 30814
2014-10-19 11:49 c_schmitz Status new => closed
2014-10-19 11:49 c_schmitz Assigned To => c_schmitz
2014-10-19 11:49 c_schmitz Resolution open => fixed
2014-10-21 00:00 mfaber Note Added: 30841
2014-10-21 00:00 mfaber Status closed => feedback
2014-10-21 00:00 mfaber Resolution fixed => reopened
2014-10-21 00:36 c_schmitz Changeset attached => LimeSurvey 2.06 72efcaa5
2014-10-21 00:36 c_schmitz Note Added: 30842
2014-10-21 00:36 c_schmitz Status feedback => closed
2014-10-21 00:36 c_schmitz Resolution reopened => fixed