09311: Error on DB upgrade:: CMysqlTableSchema and its behaviors do not have a method or closure named "getTable"

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

09311	Bug reports	Other	public	2014-10-17 22:25	2014-10-21 00:36

Reporter	mfaber	Assigned To	c_schmitz
Priority	normal	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	2.06+

Summary	09311: 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'
Tags	No tags attached.

Bug heat	6
Complete LimeSurvey version number (& build)	141017
I will donate to the project if issue is resolved	No
Browser	FF
Database type & version	MySQL 5.0.10
Server OS (if known)	Win7
Webserver software & version (if known)	Apache 2.4.7
PHP Version	PhP 5.4.19

User List	There are no users monitoring this issue.

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 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 2014-10-21 00:36 administrator ~30842	Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14586

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

LimeSurvey: 2.06 72efcaa5 2014-10-21 00:36 c_schmitz Details Diff	Fixed issue 09311: Error on DB upgrade		Affected Issues 09311
	mod - application/helpers/update/updatedb_helper.php		Diff File

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History